Receiving Crystal Reports error Vendor Code 512 - failed to retrieve data from database on canned AP Period Sensitive Aging. I have tried saving the canned report as a custom report in the USR Reports folder and updated datasource location.
No there were no modifications. I was able to determine (from Microsoft) that this is a bug (#18769). They provided me with a script to update the stored procedure.
Could there have been a modification to the underlying queries to customize another report recently? This error can be caused by an underlying SQL problem. If you can or you have IT available, try to capture a profiler trace for clues as to what could be happening.
Do you have an example of the scenario that bug describes - Voiding the same prepayment twice? Or could it have been cause by something else?
The view pulls information from another view, vr_03681_docs. Within that vr_03681_docs view, there is a subquery that could return more than one value if a prepayment is paid with a check, that check is voided, and then the prepayment is paid with a second check.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics