You’re offline. This is a read only version of the page.
We are operating in Dynamics SL 7.0. I am having a recurring issue when reconciling the unvouchered receipts report. It does not happen all the time, and therefore has been difficult to determine what the root cause is. Example: We receive 15 items on a po line item. We need to return 12 of them. The return is created for 12, but on the unvouchered receipts report the receipt dollar amount is for the full 15. The return detail on the report, however, shows that we returned 12 and has a corresponding dollar amount equivalent to the 12. The PO receipt detail also shows 12 were returned. The discrepancy is posting to our AP account and causing our report and g/l to be out of balance. Does anyone know if this is a setup issue, processing issue, or a glitch in the system? I am getting better at locating the discrepancy, but would prefer to fix the problem. Any guidance would be appreciated.
*This post is locked for comments
I have the same question (0)
One thing you might want to check is the amounts in the POTran, and POReceipt tables in SQL. In the tables there are "Cury" fields and regular fields. In a base currency transaction they should always be the same. However, we randomly see that the fields go out of balance when processing receipts or returns.
For example the POTran.CuryTranAmt = $100.00 and the POTran.TranAmt = $250.00. This can cause problems in the reporting as well as GL, AP and Inventory if it is being used.
There has been a bug written to address one potential cause of this but there could be others. The Bug has not been corrected but if you find that this is what you are getting then there is a Trigger that can be added to the database to keep the Cury fields in sync with the regular fields if you only deal with 1 currency. The Bug ID is 7788 and you would need to open a support case to get the trigger.
I hope this helps!
Share
Report
All responses (
Answers (
