Stock Audit - Accumulated Quantity Zero with Accumulated Value (SAP B1 10 Hana)

[ardiles]

Dear Experts:

I have a case where when I run the stock audit report, it shows an accumulated value when the quantity is 0 in ALM99. I have the same case with two other items, but first, I would like to know if this is normal, what the explanation would be, and how this value can be adjusted. The problem apparently started in December of last year, but it only appeared in April. That is, if I run the audit report and the stock valued until March 2025, they both match exactly, but the difference only appeared in April. Analyzing this, we see that the problem occurred in December 2024. I see a transfer with a cumulative amount of 0, but with the value, which is the difference we want to adjust or know how to do it.

What tests have we performed:

Remove the entire score and re-enter it

Revalue

Create outputs and inputs

Please seek the support of an expert who can help me

Thanks in advance, everyone

[hdolenec]

In Company Details, there is a checkbox "Manage Item Cost per Warehouse". If not ticked, item cost is determined on company level for all warehouses, which can lead to incorrect stock value if you are only looking at a single warehouse.

For example - you have an item with moving average costing method. You buy one piece to warehouse A for 10€, and another piece to warehouse B for 20€.

Moving average will be 15 for both warehouses (it's calculated on whole company level). If you sell a pice from warehouse B, and you check stock status of warehouse B, you will have a total of 0 pieces with 5€ value (you received 1 piece worth 20€, and sold 1 piece worth 15€).

I believe the best practice would be to always check this option to calculate cost per each warehouse, especially if you have different stock accounts for different warehouses, as this can create inconsistency in trial balance.

[ardiles]

This is my current setup

What we want to see is how to adjust that value to 0, if there is a procedure.

We know it was caused by some incorrectly created Delivery Price transactions and transfers.

I can't find any answers to help me adjust that value to 0.