web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Cost of sales invoice not matching cost of materials

(0) ShareShare
ReportReport
Posted on by 535

Sorry if I don’t use the right terminology here, but I have a colleague that works with financial element of NAV only recently (last month)with no system knowledge and nobody else on site with any knowledge either. I use D365 within warehousing and logistics as an internal consultant, so can’t help directly but hoped to post this on the forums to get them some help.

basically the scenario is when a works order has been posted the cost of the materials for 1000kg of product is £500. However the 1000kg of this item then invoiced to the customer was £600. The financial set up for this company is average costing. And according to the information I believe these two transactions are related as in they produced this 1000kg to ship and invoice to a customer. So you would expect the values to match.

Any ideas out there as to what could be occurring to create this difference? Or any particular advise to where to look or an approach to view the transactions that could be relating to this difference?

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at
    RE: Cost of sales invoice not matching cost of materials

    Hello,

    The Quantity of 1000KG will certainly post and reduce inventory for the shipment. As for the Revenue and COGS, this will record itself as follows:

    Debit - Accounts Receivable - 500 pounds

    Credit - Revenue - (500) pounds

    Debit - COGS - Average Unit Cost for the Item Shipped

    Credit - Inventory - (Average Unit Cost of the Item Shipped)

    Now to see this better, I am attaching the posting flow for Purchase and Sales Document.

    Hope this helps.

    Steve

    [View:/cfs-file/__key/communityserver-discussions-components-files/34/Purchase-and-Sales-Posting.xls:320:240]

  • tl82 Profile Picture
    535 on at
    RE: Cost of sales invoice not matching cost of materials

    thanks steve helped my colleague understand more

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 2,762

#2
Sumit Singh Profile Picture

Sumit Singh 2,573

#3
YUN ZHU Profile Picture

YUN ZHU 1,930 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans