This error appeared when running the Top / Bottom Product Code by Date report.
Error: 39
Module: DATAENVIROMENT.BEFOREOPENTABLES
Line#: 47
Message: Numeric overflow. Data was lost
Solution
To resolve, do a Customer Sales analysis report for the same date range but use
Sort Order 1: Product Code
Sort Order 2: Invoice
Do this for the same date range but, do not apply the same parameters that were selected in the report that experienced the error.
The Top / Bottom Product Code by Date report looks at all products first then applies the filters. So the product causing the issue may not be located with the filters added.
Then repair the product as necessary, in the example this was seen on, it had an excessive cost price.
Comments
0 comments
Please sign in to leave a comment.