Skip to main content

Notifications

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,494

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

  • john.ellis Profile Picture
    3,494 on at
    RE: Cost of Goods Sold (FIFO)

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

    Thanks, NorthW!

    John

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,025 Moderator on at
    RE: Cost of Goods Sold (FIFO)

    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.

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 1,063

#2
YUN ZHU Profile Picture

YUN ZHU 1,002 Super User 2025 Season 1

#3
Mansi Soni Profile Picture

Mansi Soni 780

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans