Adjusting Negative Inventory Stock

(0) Share

Report

Posted on by Daniel Huntley

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

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Hannes Holst 5,767 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Daniel Huntley 45 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

jcastro 2,245 on at

Like (1)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
Daniel Huntley 45 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No