Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / Inventory Adjustments ...
Business Central forum
Answered

Inventory Adjustments Account for Income Statement

(0) ShareShare
ReportReport
Posted on by john.ellis 3,480

Hi:

There is an Inventory Adjustments account in the cost section of the chart of accounts containing a large negative balance, because the beginning costs and quantities for the new inventory items were posted in the Item Journal earlier this month.

Since this results in a large figure in the cost section of the income statement and since this was the beginning of the posting of inventory costs and quantities for these new items, should this account be excluded from the income statement?

Thanks!

John

Categories:
Other
Financial Management
Data Migrations
Reports and Business Intelligence
  • john.ellis Profile Picture
    john.ellis 3,480 on at
    RE: Inventory Adjustments Account for Income Statement

    I didn't have purchase orders, sales orders, or any other documentation.  I just knew that those items plus their quantities and costs needed to be inputted.

    Anyway, from an accounting standpoint, is there a way to "write this off" so that these inflated figures do not appear on the balance sheet or income statement?

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,423 User Group Leader on at
    RE: Inventory Adjustments Account for Income Statement

    John, you can put items on purchase orders/invoices/credit memos and also on sales invoices/orders/credit memos. If you assemble or produce items, there are other features for that as well.

    These are the best method for handling inventory subledger.

  • john.ellis Profile Picture
    john.ellis 3,480 on at
    RE: Inventory Adjustments Account for Income Statement

    I didn't know how to get costs and quantities into the Inventory subledger other than by entering and posting costs and quantity in the item journal.

    For future reference, what would have been a better way?

    Secondly, from an accounting standpoint, is there a way to "write this off" so that these inflated figures do not appear on the balance sheet or income statement?

    John

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,423 User Group Leader on at
    RE: Inventory Adjustments Account for Income Statement

    To add to Josh and MahGah. Your beginning inventory debited balance sheet and credit inventory adjustment on income statement. When the beginning general ledger balance sheet is entered it will debit balance sheet also, making your balance sheet too high. Whether you do the entry now or once your beginning balance sheet, you will need to credit inventory on the balance sheet and debit the inventory adjustment account.

    Typically, the beginning inventory from the item journal should have zero accounting impact.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,419 on at
    RE: Inventory Adjustments Account for Income Statement

    As Josh said this setup is sensible. You just need to talk to your accounting team and see how you can manage this case. It could be that they agree with one time transaction to fix it or add explanation to their documents.

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,155 on at
    RE: Inventory Adjustments Account for Income Statement

    In that posting scenario the other side is the inventory account- which is on the balance sheet. If you’re writing stock off for example it requires a representation on the P&L. I would think this setup is therefore sensible

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,564 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,651 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans