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

Inventory Adjustment Accounting

(6) ShareShare
ReportReport
Posted on by 873
OK, I'm aware of the different methods of inventory adjustment and it is as advertised, very easy.

With our product posting group setup, I've got the COGS account of each Posting Group set also as the Inventory Adjustment Account as this seems to make the most sense.

I know another option would be a dedicated COGS account for adjustments.  Is there a "prescribed" option between those two?  A third option I'm not considering (I don't want to use an expense account)?

Consider these scenarios:

1. I need to add initial inventory to my BC company and I want to balance the entries to an opening equity account.

2. I neglected to add some parts to an invoice that were discounted 100% to a customer so I want the parts cost to go against the proper COGS account for my income statement.

3. I've just run my periodic inventory count, and I've only got 5 "widgets" instead of the 10 BC says I have.  This appears to have been due to human error, and I want to account for the loss in a way that I can track inventory lost due to slippage.

Now, unless I'm mistaken, I would need to manually edit the General Product Posting Group setups to be able to do all 3 of these things, meaning change the posting when my scenario/purpose changes.

I've considered that I could change the posting setups to all point to the opening equity account while we load the initial inventory, then I could change them back to the COGS accounts.

For scenario 3, can I get data for inventory adjustments in BC that includes the reason code and in that way, know the financial impact of slippage or any other reason code for inventory adjustments?  Is this what others are doing?

I've also considered setting up an entire set of posting groups for "loss" for each of the existing groups.  With the item journal, you can add "posting group" as a field through personalization.

Thank you for your insights.
I have the same question (0)
  • Gerardo Rentería García Profile Picture
    23,574 Most Valuable Professional on at
    Inventory Adjustment Accounting

    Hi, good day
    I hope this can help you, and give you some hints.

    Count, adjust, and reclassify inventory - Business Central | Microsoft Learn

    Inventory analytics - Business Central | Microsoft Learn

    Best Regards
    Gerardo

  • Verified answer
    Ahmad Subhani Profile Picture
    545 on at
    Inventory Adjustment Accounting

    Hi,

     

    • Initial Inventory Load

      → Use Opening Equity or Inventory Opening Balance account.

      Recommended: Temporarily point Inventory Adjustment Account to equity, or use reclass journal.

    • Free Item to Customer (100% Discount)

      → Use standard COGS account.

      Recommended: Keep current setup for this — you're assigning cost to revenue correctly.

    • Inventory Shrinkage (Slippage)

      → Use dedicated “Inventory Loss” expense account.

      Recommended: Use reason codes + separate posting group (via personalization).

     

    Then filter/report based on Reason Code or G/L Account.

     

    Mark the Answer as Verified if this is Helpful.
     

  • Verified answer
    Mansi Soni Profile Picture
    8,874 Super User 2025 Season 2 on at
    Inventory Adjustment Accounting
    Hello,
     

    Posting Group Setup

    There is no single prescribed setup for inventory adjustment accounts; it depends on your reporting preferences. Using the COGS account for adjustments can make sense if you treat losses and write-offs as part of cost of sales. However, using separate G/L accounts (e.g., inventory shrinkage, slippage, or adjustment accounts) allows better visibility and auditability. Avoid general expense accounts unless they’re specifically tracked.

    Scenario 1 - Initial Inventory Load

    For loading opening inventory, best practice is to post against an Opening Equity account or a designated Inventory Opening Balance account to clearly differentiate it from operational COGS. Temporarily change the Inventory Adjustment Account in the General Product Posting Group or use a unique posting group for this purpose.

    Scenario 2 - Zero-Price Items to Customer

    If the items were intentionally given away (e.g., promotional), then using the COGS account is correct since the cost needs to hit your income statement. You can use Item Journals with a Reason Code and maintain the default posting group setup if you want this to reflect in COGS properly.

    Scenario 3 - Inventory Count Loss (Slippage)

    Yes, Reason Codes in Business Central allow you to tag adjustments and later report on them. If you associate Reason Codes with specific G/L accounts, BC posts to those accounts automatically no need to change posting groups. Set up Inventory Slippage as a Reason Code with its own adjustment account for better tracking.

    On Managing Multiple Use Cases Without Manual Changes

    Rather than manually editing the posting setup each time, it’s better to use either:
    Different Reason Codes with G/L account mapping, or
    Different General Product Posting Groups assigned temporarily in journals, especially when doing special transactions like slippage or initial loads.

    This helps maintain audit trail, visibility, and accuracy without compromising standard posting setup

    Yes, many companies either use reason codes with mapped accounts or create duplicate posting groups (like _LOSS variants) to cleanly handle edge cases like slippage, giveaways, or initial inventory all while keeping standard posting untouched. Your thinking is aligned with best practices.

    Hope this answer will help you!

    Regards,
    Mansi Soni


     
  • Verified answer
    Sohail Ahmed Profile Picture
    11,087 Super User 2025 Season 2 on at
    Inventory Adjustment Accounting

    There’s no fixed rule, but a practical way to handle your scenarios is to use Reason Codes linked to specific Inventory Adjustment G/L accounts instead of constantly changing posting setups.

    • Scenario 1 (Opening Balances): Use a reason code like OPENING and point it to an equity account. Post through Item Journals.
    • Scenario 2 (100% Discounted Items): Let this hit your regular COGS account—treat it like a normal sale.
    • Scenario 3 (Inventory Loss/Slippage): Create a reason code like LOSS linked to a loss/shrinkage account and use it during negative adjustments.

    You can track all adjustments by filtering Posted Item Journals or G/L Entries by reason code. No need to keep changing posting groups—use reason codes to control posting accounts cleanly.

     

    ✅ Mark this answer as verified if it helps you.

  • AXEON Man Profile Picture
    873 on at
    Inventory Adjustment Accounting
    Thank you for some great comments and confirming my conclusions. 
     
    A couple of you have eluded to Reason Codes being linked to GL accounts and journal batches to effect different posting results. 
     
    I can find no information on how this is done.  I searched before ever posting this question as that would have been the preferred solution but I still can't find any information that this is actually possible. 
     
    Anyone have instructions for this that work?
  • Suggested answer
    Mansi Soni Profile Picture
    8,874 Super User 2025 Season 2 on at
  • Suggested answer
    Jainam M. Kothari Profile Picture
    12,126 Super User 2025 Season 2 on at
    Inventory Adjustment Accounting
    Hello,
     
     
    It is common to use the COGS account for inventory adjustments, best practice varies by scenario.
     
     
    For initial inventory loads, posting to an opening equity account ensures clean financials; for missed invoice items, using the COGS account maintains income statement accuracy; and for inventory slippage, tracking via dedicated posting groups or reason codes allows for clear audit trails and loss analysis.
     
    Many businesses use reason codes and custom posting setups to differentiate adjustment types, enabling detailed reporting without relying on expense accounts
  • AXEON Man Profile Picture
    873 on at
    Inventory Adjustment Accounting
    Well, in none of those links is a process to connect Reason Codes with GL Account posting.  So, that's a dead-end as far as I'm concerned.
     
    Thank you for great feedback, everyone.  Hopefully, this helps someone else in the future as well.

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 4,160

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,943

#3
Sumit Singh Profile Picture

Sumit Singh 2,823

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans