Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / Adjusting Negative Inv...
Business Central forum

Adjusting Negative Inventory Stock

(0) ShareShare
ReportReport
Posted on by Daniel Huntley 45

Hi, we are preparing our year-end, we seem to have a number of inventory items with -1 stock level. We have worked out that these items were purchased without a PO and direct to the G/L. I am trying to adjust the inventory to zero however I am getting the error below saying out posting groups aren't complete.

Screenshot-2019_2D00_08_2D00_15-at-08.38.20.png

The two questions I have:

1: Where and what G/L entry do I enter for the stock adjustment posting rule and where would it sit on the CoA?

2: What effect does it have on the P&L/Balance sheet ledgers?

Screenshot-2019_2D00_08_2D00_15-at-08.36.41.png

Any help would be much appreciated.

Thank you

Dan

Categories:
Financial Management
Inventory and warehouse management
Business Central
  • Daniel Huntley Profile Picture
    Daniel Huntley 45 on at
    RE: Adjusting Negative Inventory Stock

    Thanks, I’ve checked the Cronus and when adjusting the stock level it CR the same COGS ledger and DR the Asset inventory ledger. I will use this rule.

    Thanks again,

    Dan

  • Suggested answer
    jcastro Profile Picture
    jcastro 2,245 on at
    RE: Adjusting Negative Inventory Stock

    Hello Daniel,

    Just like Hannes said, the best advice I can give you is try it in a test company to see what the full effect of those postings is.

    Best regards,

  • Daniel Huntley Profile Picture
    Daniel Huntley 45 on at
    RE: Adjusting Negative Inventory Stock

    Great thank you for your reply. I have created the blanks below, not sure why these are needed?

    My retail (product) cost of goods sold (COGS) g/l is 2200, my inventory account is 4700 (Assets),  I don't have inventory adjustment account, would this be as simple as creating one for example 4710 under the same G/L category (Assets).

    Thank you for your help.

    Regards

    Dan

    Screenshot-2019_2D00_08_2D00_15-at-13.31.11.png

  • Verified answer
    Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Adjusting Negative Inventory Stock

    hi,

    You must create a Posting Group Setup with an empty "Gen. Bus. Posting Group" and "RETAIL" in "Gen. Prod. Posting Group".
    Check out the Cronus Company.

    Then you can setup the posting groups.
    The "Inventory Adjmt. Account" and "Direct Cost Applied Account" are used for the G/L postings.
    Give a try in a test database.

    pastedimage1565858397119v1.png

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans