Skip to content

Accounts Payable to General Ledger Reconciliation in Microsoft Dynamics NAV

ArcherPoint How-To Blog: Step-by-step instructions on how to perform specific tasks 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”.

Running the Accounts Payable to General Ledger Reconciliation Report

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.

Results of he Accounts Payable to General Ledger Reconciliation Report

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.

Blog Tags: 
Read ArcherPoint's Blog Follow us on Twitter Follow us on Facebook Follow us on LinkedIn Link to our RSS feed Join us on Google+ Watch us on YouTube
Get Help Now