Error message when you try to print the Period Sensitive Aged AP report in Accounts Payable in Microsoft Dynamics SL: "Crystal Report Engine Error 723"

Applies to: Dynamics SL 2011Accounts Payable

Symptoms


Consider the following scenario in Microsoft Dynamics SL. In Accounts Payable, you use a check to pay a prepayment. You void the check, and then use a new check to pay the same prepayment. Then, you void the second check. In this scenario, when you click Print or Print Preview in the Period Sensitive Aged AP (03.681.00) screen, you receive the following error message:
Crystal Report Engine Error 723 - Failed to open a rowset

Workaround


To workaround this issue in Microsoft Dynamics SL 7.0 Service Pack 1 (SP1), in Microsoft Dynamics SL 7.0 Service Pack 2 (SP2), and in Microsoft Dynamics SL 7.0 Feature Pack 1 (FP1), and Microsoft Dynamics SL 2011, run the following SQL script against the Microsoft Dynamics SL application databse to modify the vr_03681_docs view.

The following file is available for download from the Microsoft Dynamics File Exchange Server:


Release Date: 18-Jan 2010




Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

This problem has been reported as issue 18769.