Skip to main content

Notifications

Business Central forum
Suggested answer

What is the correct action to take to adjust stock with minimal impact to the gl accounts

Posted on by 42
Hi all,
 
please assist my client with this query
 
We need your guidance with regards to the stock adjustments required.
 
  1. What is the correct action to take to adjust stock with minimal impact to the GL – stock count / stock take / stock adjustment?
  2. Adjust the sub-ledger to agree to actual stock with little impact to the GL amount.
  3. Order clean up.
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    What is the correct action to take to adjust stock with minimal impact to the gl accounts
    I wrote a blog post around this a while ago.
    That might be helpful for you.
     
  • Suggested answer
    Shauna Langley Profile Picture
    Shauna Langley 612 Super User 2024 Season 2 on at
    What is the correct action to take to adjust stock with minimal impact to the gl accounts
    Hi,
     
    Using physical inventory journals or item journals will post to the following G/L accounts.
     
    Inventory Posting Setup
     
    The inventory account will be reduced if you are negatively adjusting stock.
     
    General Posting Setup
    The debit will then be posted to the inventory Adjmt. Account.
     
    I am not sure why there should be minimal impact on the G/L but usually at stock take on these can be set to the same G/L account so that the debit/credit hits the same account and the opening TB will then populate your stock account.  Maybe that is an option?
     
    Hope that helps,
    Shauna 

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,041 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans