Skip to main content

Purchases and Direct Cost Applied Accounts in Microsoft Dynamics NAV

Purchases and Direct Cost Applied Accounts in Microsoft Dynamics NAV

When working on new Dynamics NAV implementations (and for that matter, existing NAV solutions), we get a lot of questions about the Purchases and Direct Cost Applied Accounts—namely, what are they used for?
We were trained in accounting that, when an inventory purchase receipt is invoiced (vouchered), we would debit the Inventory Account and credit the Accounts Payable Account and be done with it. Dynamics NAV doesn’t handle it that way.
When we look at the General Posting Setup in Dynamics NAV 2013 (see below), we see that there is a column for the Purchases Account and the Direct Cost Applied Account.
General Posting Setup in Dynamics NAV 2013
Figure 1 - General Posting Setup in Dynamics NAV 2013
When a purchase receipt is invoiced (vouchered) in NAV, we get the following General Ledger entries:
  • Dr Purchases Account for the Actual Invoice Amount
    • Cr Accounts Payable Account for the Actual Invoice Amount
  • Dr Inventory Account for the Actual Invoice Amount (or Standard Cost if using Standard cost Method)
    • Cr Direct Cost Applied Account for the Actual Invoice Amount
The Purchases and Direct Cost Applied accounts should net to zero.
The net effect of these postings is that the Inventory and Accounts Payable Accounts are debited for the actual amount.
The first thing to do is to understand how this works in Dynamics NAV and set up your Posting Groups appropriately. Then we are still left with the question, “Why?”
We are still left with no satisfactory answer. One explanation that was given to us is that some companies budget for inventory purchases. With the purchases account, it is then easy to compare actual to budget. Another explanation is more technical in that, depending on your setup, you can just get the General Ledger Postings for the A/P side of the transaction, then later with the Adjust Cost-Item Entries Program get the Inventory side of the transaction.
Do you have questions about other functionality in Dynamics NAV? Contact Okello Dan +256775120005; we’ll be happy to help you find the answers.

Comments

Popular posts from this blog

The Difference Between Microsoft Dynamics NAV and AX

The Difference Between Microsoft Dynamics NAV and AX Microsoft Dynamics offers a variety of ERP solutions. You might say there is a solution for every purpose and every industry. Two of the offerings,  Dynamics NAV  and  Dynamics AX (now part of  Dynamics 365 ) share some of the same features so you might wonder: ‘what are the differences and which is right for my organization?’ Both ERP solutions are highly customizable, available in and adaptable to many languages and currencies used around the world. The two solutions can also be employed in a central location or across diverse satellite locations and are designed to grow as a business grows. Their industry-specific functionality can assure compliance with local and regional requirements. In short, both solutions could rightly be described as comprehensive and well equipped to manage complex requirements of supply chain and inventory. So, what is the difference? Is one better than the other for your...

RUNREQUESTPAGE, EXECUTE, PRINT, SAVEAS in NAV

RUNREQUESTPAGE, EXECUTE, PRINT, SAVEAS in NAV …nice reporting functions are available from NAV 2015:  EX: RUNREQUESTPAGE, EXECUTE, PRINT, SAVEAS MY BEST FUCTION IS:  “RUNREQUESTPAGE” -> “ This function lets you run a request page for a report, without actually running the report. When the user clicks OK, the function simply returns a text value , which is an XML document describing the user’s selection and filters of the request page.”; you can use this function also to schedule a report on Job Queue (OnDemand report schedule) ex: a reports launcher page, scope of this page is run selected reports and generate PDF files after reports printing (or after preview mode report printing) The system use fiunction REPORT.RUNREQUESTPAGE to read and retrieve reports parameters RUNREQUESTPAGE XmlParameters:= REPORT.RUNREQUESTPAGE(intIDReport); … after you get the following XML document as a result: EXECUTE Now is time to run report with EXECUTE f...