Monday, May 14, 2012

Dynamics GP 2010 - SSRS Payables Historical Aged Trial Balance

The default SSRS Payables Historical Aged Trial Balance that gets deployed from GP has different parameters from the original GP report.
When you initially run the report straight out of the box with a value selected for the 
"Select Transactions for Report Using:" you would expect it to return all of the records.
This does not happen.

You also notice a bunch of weird characters 
ÿÿÿÿÿÿÿÿ
In the "To:" parameters.

You will also notice that NONE of the fields have any sort of drop down selection menu.
  1. To get the report to work, you must fill in ALL "to:" parameters with something useful (like "ZZZZZ")
  2. Fill in the "To: Document Number" parameter with something useful (like "9999999")
  3. Leave the "from:" parameters blank
Now if you try to run the report it will return data properly.

No comments:

Post a Comment