Monday, June 16, 2014

Dynamics GP - Historical Stock Status - Divide by zero error

There are corrupted item transaction records for that date range.
Solution here

http://support.microsoft.com/kb/855945


In my case, there was a single record for 0 qty and no value in the TRXSORCE column.
There were some transactions with no UofM, but these were all cost adjustments, and had no impact on the report.


I deleted the single blank record from the iv30300, and the issue was resolved.

No comments:

Post a Comment