One additional question. Is there any way to run the ledger activity with either the vendor name, or purchase order number? I am trying to use the physical voucher to match the accrued purchases report to my ledger transaction listing. I have several lines that were not matched on the ledger, possibly due to multiple receipts on the PO? I believe these multiple receipts would create their own voucher number which would cause them to not match.Any help you can give is appreciated.
Hey,I am using D365 and I'm trying to reconcile received PO against dedicated GL account. I tried the report "Accrued purchases excluding sales tax report".The report is good but we have ~10% difference between the report amount and the GL closing balance. Is there any ideas what might cause the difference or any other tricks how to solve the difference?Couple of ideas for the difference:- Timing: all the transactions are not updated / recorded at the same time. For this I tried historical dates for example last day of April both for this report and trial balance. Still approx. the same difference.- Faulty debit or credit transactions towards the GL account. The difference is not fixed, it variates based on the date so I assume there shouldn't be faulty transactions..Best regards,
If you've found this thread useful, dive deeper into User Group community content by role