Accounts Payable to General Ledger Reconciliation in Microsoft Dynamics NAV
Are you Running the Microsoft Dynamics NAV Accounts Payable to General Ledger Reconciliation Report?
It is vital that you keep up with Invoicing (Vouchering) in Microsoft Dynamics NAV if you want your system to show the accurate value of inventory and calculate the correct Cost of Goods Sold.
From time to time, we find clients that are not keeping up with their Purchase Receipt invoicing. We can tell this by running the A/P to G/L Reconciliation Report. This report can be found under the Financial Management/Payables menu.
When you run the report, select “Item”.
Figure 1 – Running the Accounts Payable to General Ledger Reconciliation Report
When you run this report, it gives you a list of all of the Purchase Receipts that have not been invoiced.
Figure 2 – The Accounts Payable to General Ledger Reconciliation Report shows a list of Purchase Receipts that have not been invoiced
If you find very old Purchase Receipts on the list and you know that the vendor has been paid, your only option is to invoice the receipt and then issue a Dynamics NAV Credit Memo to get the Payable off the Vendor Aging.
For more information on this or any other Dynamics NAV costing topic, please contact ArcherPoint.
Read more "How To" blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV.