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

Announcements

News and Announcements icon
Community site session details

Community site session details

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

Cost of Goods Sold (FIFO)

(0) ShareShare
ReportReport
Posted on by 3,530

Hi:

1210 and 1220 are separate Inventory accounts, while 5000 and 5010 are separate Cost of Goods Sold accounts.  Each "set" of these Inventory and Cost of Goods Sold accounts pertain to two separate inventoried items.

In the Sales Invoice that I posted for these two items, you'll notice from the screenshot below that the total amounts for these Inventory and Cost of Goods Sold accounts were "backed out".  Essentially, the effect for Inventory and Cost of Goods Sold was a "wash".

Now, these two items were sold at a low quantity and FIFO is the inventory valuation method.

In this test company, the quantities of all inventoried items had been first imported without a Unit Cost.  That's because we have not been given initial cost figures by this client.  In any case, these imported quantities each were around 20.

In order to provide a Unit Cost for each of these two items, I entered a Positive Adjustment of 5 with an estimated cost for each item and did so prior to posting this Sales Invoice.

Did the posting of this Sales Invoice produce a "wash", because the initial imported quantities of the items were at a $0.00 Unit Cost layer?

Thanks!

John

3124.Capture.PNG

I have the same question (0)
  • Suggested answer
    IB-29041624-0 Profile Picture
    1,191 Moderator on at

    Thats is a very possible explanation. But in order to check the actual cost of the sold goods you should check the item ledger entries and the values entries connected to your sales transaction.  You should fine them if you do navigate / search for entries on your posted sales invoice.

  • john.ellis Profile Picture
    3,530 on at

    And, for both items, Item Ledger Entries shows $0.00.  That solved the mystery!

    Thanks, NorthW!

    John

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 649 Super User 2026 Season 1

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 447 Most Valuable Professional

#3
YUN ZHU Profile Picture

YUN ZHU 388 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans