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

Olof Simren - Microsoft Dynamics NAV & 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:

  • Click to share on Facebook (Opens in new window) Facebook
  • Click to share on X (Opens in new window) X

Related


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

Subscribe to get the latest posts sent to your email.

Tags: CostsFinanceInventory
13 Comments
Share
8

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

Mandatory Dimensions by Account Type

Feb 20, 2014

Dimensions are great in Dynamics NAV and one of the[...]

Assembly Order Posting to General Ledger

Jul 20, 2015

I have previously described how production orders are posting into[...]

Inventory With Zero Value

Mar 20, 2014

Dynamics NAV has an ‘Inventory Value Zero’ field in the[...]

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

My Dynamics NAV Partner

Naviona, LLC

Developers Wanted

Naviona is looking for NAV/BC developers. Let me know if you want to work with the best (instead of the rest :-)).

Categories

  • Assembly (3)
  • Development (31)
  • Finance (14)
  • General (26)
  • Inventory (22)
  • Manufacturing (34)
  • Miscellaneous (25)
  • Purchase (9)
  • Sales (11)
  • Warehouse (7)

Tags

.net Add-in Assembly Assembly BOM CAL Capacity Components Consumption Contact Costs Customer Development Dimensions Excel Finance Flushing General Ledger Inventory Item Items Lot Size Low-Level Code MRP NAV 2015 NAV 2016 Output PDF Planning Production Production BOM Production Orders Purchase Orders Receipts Reporting Reports Role Center Routing Sales Sales Order Sales Orders Stockkeeping Unit Subcontracting Task List Warehouse Warehouse Shipment

Recent Posts

  • XML Buffer and CSV Buffer Tables
  • Functionality Improvements in NAV 2017
  • Reversing Production Output and Consumption
  • Return Merchandise Authorization (RMA)
  • Sales Quote without Customer
  • Parallel Routings
  • Add Fields to the Item Tracking Lines
  • Field Level Security using Events in Dynamics NAV 2016
  • Schedule MRP
  • Activate WMS Functionality for Existing Location

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 (31)
  • Finance (14)
  • General (26)
  • Inventory (22)
  • Manufacturing (34)
  • Miscellaneous (25)
  • Purchase (9)
  • Sales (11)
  • Warehouse (7)

Tags

.net Add-in Assembly Assembly BOM CAL Capacity Components Consumption Contact Costs Customer Development Dimensions Excel Finance Flushing General Ledger Inventory Item Items Lot Size Low-Level Code MRP NAV 2015 NAV 2016 Output PDF Planning Production Production BOM Production Orders Purchase Orders Receipts Reporting Reports Role Center Routing Sales Sales Order Sales Orders Stockkeeping Unit Subcontracting Task List Warehouse Warehouse Shipment

Recent Posts

  • XML Buffer and CSV Buffer Tables
  • Functionality Improvements in NAV 2017
  • Reversing Production Output and Consumption
  • Return Merchandise Authorization (RMA)
  • Sales Quote without Customer
  • Parallel Routings
  • Add Fields to the Item Tracking Lines
  • Field Level Security using Events in Dynamics NAV 2016
  • Schedule MRP
  • Activate WMS Functionality for Existing Location

Recent Comments

  • Isabel de los Santos on Production Lot Sizes
  • Abdelatif EL HANI on Reversing Production Output and Consumption
  • Roshan on Processing of Receipts
  • kuldeep Nama on Subcontracting Part 1: The Basics
  • Janine on Flushing Methods
  • Nathalie on Activate WMS Functionality for Existing Location
  • Georges W on Bill-to vs. Sell-to Customer
  • Richard L on Subcontracting Part 4: Warehouse Receipts

© 2025 · Olof Simren

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