• Home
  • About Me
  • Contact Me
  • Downloads
  • White Papers
  • Web Sites
  • Post List
  • Articles
  • FAQ

Olof Simren - Microsoft Dynamics 365 Business Central Blog

  • Home
  • About Me
  • Contact Me
  • Downloads
  • White Papers
  • Web Sites
  • Post List
  • Articles
  • FAQ

Discrepancy Between Purchase and Direct Cost Applied

May 8, 2014 Posted by Olof Simren Finance, Inventory, Purchase 13 Comments

In school we where told that when you invoice (voucher) received inventory you get a debit transaction against the inventory account and a credit transaction against the accounts payable. Well, in Microsoft Dynamics NAV you also get two transactions in the P&L, a debit against the purchase account and a credit against the direct cost applied account. What are those used for? Wouldn’t they always be the same and net each-other out?

Not necessarily. There is a special case to consider where the two transactions in the P&L are not the same and therefore a discrepancy between the two accounts will occur.

The special case is purchase credit memos for products that are returned where the vendor only credits you for parts of the inventory cost. If an item is in inventory at $100 and you return it to the vendor which only credits you $60, then you will have a $40 discrepancy on those accounts (since the credit on your inventory account will always be according to your inventory value). The g/l transactions will then look like below.

PurchaseCreditMemoTransactions

Note that the $40 adjustments will be created when the cost adjustment batch job is run (one of the reasons why you need to run it 🙂 ). Also note that the purchase credit memo account does not have to be the same as the purchase account, you can define them to be two different accounts in the general posting setup table. Although this does not change the fact that you have a discrepancy when you trying to reconcile.

This is useful to know when you evaluate any discrepancy between the purchase and direct cost applied accounts.

Share this:

  • Share on Facebook (Opens in new window) Facebook
  • Share on X (Opens in new window) X

Related


Discover more from Olof Simren - Microsoft Dynamics 365 Business Central Blog

Subscribe to get the latest posts sent to your email.

Tags: CostsFinanceInventory
13 Comments
Share
9

About Olof Simren

I am a Microsoft Dynamics NAV and 365 Business Central Expert, I started implementing Microsoft Dynamics NAV in 2002, back then it was called Navision Attain. Throughout the years there has been many exciting implementations in different parts of the world, all of them with different challenges but with one common theme; manufacturing. As a consultant, I bring over 20 years of experience in implementing Microsoft Dynamics NAV and 365 Business Central within manufacturing and distribution companies. The services I offer includes project management, consultation, development and training. Feel free to contact me if you need help with anything related to Microsoft Dynamics NAV or 365 Business Central. I work through my company Naviona where I team up with other skilled Microsoft Dynamics NAV and 365 Business Central Experts.

You also might be interested in

Production Order Posting to General Ledger

May 20, 2014

How Microsoft Dynamics NAV posts into the general ledger from[...]

Multiple Item Unit of Measures

Apr 11, 2014

Items in Microsoft Dynamics NAV can have multiple units of[...]

The Low-Level Code

Jun 4, 2014

Do you know what the low-level code in Microsoft Dynamics[...]

13 Comments

Leave your reply.
  • Michael Opatrny
    · Reply

    May 9, 2014 at 9:58 AM

    Thanks Olof – you could also experience the same situation when posting a Purchase Credit Memo where the inventory is not applied-to the original inbound Item Ledger Entry record.

    • Olof Simren
      · Reply

      Author
      May 9, 2014 at 1:26 PM

      Hi Mike, good point!
      Especially when you are on FIFO you need to select the inbound entry, otherwise you might return something that has a different cost.
      Thanks for the comment!

  • Devinder
    · Reply

    March 5, 2015 at 7:35 AM

    Hi Olof Simren,

    Another scenario is when you are on Standard and Purchase Price was different from the standard.

    Devinder

    • Peter
      · Reply

      February 15, 2016 at 12:09 PM

      Interesting thread. How do we balance the accounts then? Do we square the accounts up with a journal to the P&L or do we just live with the ‘imbalance’ and reconcile it each month by running a report of posted credit memos? Thanks, Peter

      • Olof Simren
        · Reply

        Author
        February 15, 2016 at 1:15 PM

        Those accounts should already be in the P&L.

        /Olof

  • Dejan
    · Reply

    March 29, 2016 at 8:45 AM

    HI OLOF,

    I am not conviced that i really need Purchase and direct cost at all. And its just confusing. When i buy goods, i will make it inventory debit, and payable credit (if we have no VAT etc..). Lets say i bought something for 100$. So my debit/credit relations looks like inventory 100$/vendor 100$.

    If i return that goods, and vendor says:Ok but i will accept only 60$.

    Then i make:
    Debit Credit
    Vendor -60$
    Inventory 100$ – i need to credit 100$, it doesnt metter which cost method do we use
    REAL COST 40$ – G/L account that we create as real cost (income statement)

    So difference betwen inventory and vendor is my real cost. Or if vendor is really great company and they will pay lets say 110$ of refund 🙂 then its ravenue …

    I dont really see the point to have 2 more G/L ACC

    • Shafeeque
      · Reply

      March 26, 2018 at 4:13 AM

      As per accounting principle, inventory is an asset.

      however, Some retailers view the goods purchased as part of the expense known as the cost of goods sold. Other retailers view the goods purchased as part of the asset inventory.

      To appreciate both views, let’s assume that a retailer begins the year with inventory having a cost of $800. It ends the year with inventory having a cost of $900. During the year the retailer purchased goods having a cost of $7,000. Let’s also assume that the cost per unit did not change during the year.

      Retailer X may view the $7,000 of purchases as an expense (cost of goods sold) except for $100, which was the cost of the goods added to its inventory ($900 vs. $800). Retailer X’s income statement reports its cost of goods sold as: purchases of $7,000 minus the $100 increase in inventory = $6,900.

      Retailer Y may view the $7,000 of purchases as an increase to its asset inventory and will report its cost of goods sold as: beginning inventory of $800 + purchases of $7,000 = cost of goods available of $7,800 minus the ending inventory of $900 = $6,900.

      Regardless of whether the goods purchased are initially recorded in an inventory account or in a cost of goods sold account, the amounts reported on the financial statements must be the same: the expense (reported as the cost of goods sold on the income statement for the year) is $6,900 and the asset inventory (reported on the balance sheet as of the end of the year) is $900.

      So, NAV is facilitating both way of doing it by opening two contra accounts.

      Thanks/

      • Olof Simren
        · Reply

        Author
        April 10, 2018 at 9:49 PM

        Hi Shafeeque,
        Nice, many thanks for your reply!

        Cheers!

        /Olof

  • Arão Benjamin
    · Reply

    January 11, 2018 at 6:15 PM

    Hi Olof,

    I’m just in the process of installation of the Dynamics 365, Business Edition and I just got surprised with these 2 more entries in the G/L.

    As you said in the article, this is not what’s expected. So, do you have any explanation of what’s the purpose of it?

    I can’t help thinking that it’s some kind of bad setup of the software, and I can’t find in the docs what’s the meaning of it.

    Do you have any light?

    • Olof Simren
      · Reply

      Author
      February 3, 2018 at 8:43 AM

      Hi Arão,
      Thanks for your comment, I don’t think it is a ‘bad setup of the software’, it is more the mechanics of how the posting routine was designed.
      You can point the two transactions to the same account, but I prefer to do a setup where it is separated I think it is just easier to follow then, especially if you do purchase returns (described in this blog post) or if you have any type of product dimensions on your purchase transactions (which will then show up in the P&L).

      Hope this helps, good luck with your Dynamics 365 installation!

      /Olof

      • Arao Benjamin
        · Reply

        February 5, 2018 at 5:33 PM

        Thanks Olof, you’re right, I just never had worked with these 2 sets of entries.
        Congratulations for the blog.

    • Shafeeque
      · Reply

      March 26, 2018 at 4:16 AM

      You may read my view above on this.

      • Arão Benjamin
        · Reply

        April 11, 2018 at 2:37 PM

        Shafeeque, I understand the accommodation you made to justify that particular behavior of the system.
        But, as a configurable software, I understand both Microsoft NAV and Microsoft Dynamics have several parameters configurations to accommodate several ways of accounting.
        So, for this flexibility of the system, it’s not necessary to have both double-entries at the same time.
        I still don’t see, except perhaps for help in constructing a cash flow report, how this can help.

Leave a Reply

Your email is safe with us.
Cancel Reply

Subscribe to My Blog via Email

Check Out Our Apps in AppSource

My Dynamics NAV Partner

Naviona, LLC

Categories

  • Assembly (3)
  • Development (35)
  • Finance (14)
  • General (28)
  • Inventory (24)
  • Manufacturing (36)
  • Miscellaneous (27)
  • Purchase (9)
  • Sales (11)
  • Warehouse (7)

Tags

.net Add-in AI AppSource Assembly Assembly BOM Business Central CAL Capacity Consumption Contact Copilot Costs Customer Development Dimensions Excel Finance Flushing General Ledger Inventory Item Item Tracking Low-Level Code MRP NAV 2015 NAV 2016 Output Planning Production Production BOM Production Orders Purchase Orders Receipts Reporting Reports Routing Sales Sales Order Stockkeeping Unit Subcontracting Task List Warehouse Warehouse Shipment Work Center

Recent Posts

  • Business Central Configuration Audit using Vibe Coding
  • Copilot in Planning Parameter Worksheet
  • Copilot in Planning Worksheet
  • Copilot Inventory Queries
  • Record Deletion Tool for Business Central in AppSource
  • Reopen Finished Production Orders
  • XML Buffer and CSV Buffer Tables
  • Functionality Improvements in NAV 2017
  • Reversing Production Output and Consumption
  • Return Merchandise Authorization (RMA)

Categories

  • Assembly
  • Development
  • Finance
  • General
  • Inventory
  • Manufacturing
  • Miscellaneous
  • Purchase
  • Sales
  • Warehouse

Contact Us

We're currently offline. Send us an email and we'll get back to you, asap.

Send Message

Categories

  • Assembly (3)
  • Development (35)
  • Finance (14)
  • General (28)
  • Inventory (24)
  • Manufacturing (36)
  • Miscellaneous (27)
  • Purchase (9)
  • Sales (11)
  • Warehouse (7)

Tags

.net Add-in AI AppSource Assembly Assembly BOM Business Central CAL Capacity Consumption Contact Copilot Costs Customer Development Dimensions Excel Finance Flushing General Ledger Inventory Item Item Tracking Low-Level Code MRP NAV 2015 NAV 2016 Output Planning Production Production BOM Production Orders Purchase Orders Receipts Reporting Reports Routing Sales Sales Order Stockkeeping Unit Subcontracting Task List Warehouse Warehouse Shipment Work Center

Recent Posts

  • Business Central Configuration Audit using Vibe Coding
  • Copilot in Planning Parameter Worksheet
  • Copilot in Planning Worksheet
  • Copilot Inventory Queries
  • Record Deletion Tool for Business Central in AppSource
  • Reopen Finished Production Orders
  • XML Buffer and CSV Buffer Tables
  • Functionality Improvements in NAV 2017
  • Reversing Production Output and Consumption
  • Return Merchandise Authorization (RMA)

Recent Comments

  • Olof on Business Central Configuration Audit using Vibe Coding
  • Andrew Trayfoot on Business Central Configuration Audit using Vibe Coding
  • Barrett Allen on Reopen Finished Production Orders
  • Kateryna on Business Central Configuration Audit using Vibe Coding
  • Takeshi Setoya on Reopen Finished Production Orders
  • Steve on Consignment Inventory
  • Olof Simren on Copilot in Planning Worksheet
  • Omaer Amjad on Copilot in Planning Worksheet

© 2026 · Olof Simren

  • Home
  • About Me
  • Contact Me
  • Downloads
  • White Papers
  • Web Sites
  • Post List
  • Articles
  • FAQ
Prev Next