Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
Reconciling Purchased orders received but not invoiced with general ledger. We need a report that identifies all PO's received, but not invoiced and the $ value. That $ value would then be balanced to the general ledger account for purchases clearing that represents the liability for those receipts that have not yet been invoiced.
If your Legal Entity is in the US or Canada, you can use the Accrued purchases report:
If you're elsewhere and you have access to AX developers, you could remove the US/CA restriction on the report. When we did this on R1, I recall installing a hotfix related to the report, removing the Country restriction and altering the report's dialogue box to accept dates that were in a non-US format.
Alternatively, it is possible to extract information about Received but not Invoiced purchase order lines using the following Inquiry:
My client is using Accrued purchases report for this purpose. You can have your developer remove the US, Canada country restrictions and then you would be able to use this report as Guy mentioned in his comments.
In addition to this, there are some hotfixes released by Microsoft to fix different issues in this report, so if you are on AX 2012 FP or AX 2012 R2, search in LCS for Accrued purchases report and install those hotfixes before you can start looking at this report. Without installing hotfix, the report may be slow or some of the data in the report may not be correct.
Please let me know if you have further queries.
Fortunately, the Legal Entity is in the US! This is exactly what we were looking for.
Business Applications communities