Qty (obsolete vs new)

[Sanif_Sentosa]

Hi, why are my Obsolete and new Qty on hand, to receive, and to deliver are different?
The accurate ones are the Obsolete, all the New ones are incorrect.

[Tut]

No one can possibly answer your question. You need to explain what you are showing, how you obtained duplicate columns, etc. Even then, no one can explain specific numbers because we cannot see your records.

You need to drill down on the columns to see what transactions contribute to them. Inventory quantities are almost impossible to troubleshoot remotely. You will have to carefully examine your drill-downs to track a specific inventory item, transaction by transaction.

[Patch]

@Sanif_Sentosa

why are my Obsolete and new Qty on hand, to receive, and to deliver are different?

Because they show different things see

Added "Qty available", "Qty to be available" and "Qty to order" columns to “Inventory Items”

The latest version (23.10.21) is enhancing columns under Inventory Items further. The following new columns have been added: Qty available Qty available indicates the stock that is physically available for new sales or use. It’s calculated by subtracting Qty to deliver from Qty on hand. Essentially, it shows the inventory on hand minus the quantity that is already committed to open Sales Orders. The real value of Qty available column becomes evident when a business has regular sales orders an…

and

Improved Calculation for "Qty to receive" and "Qty to deliver" in Inventory Items

In the latest version (23.10.18), to enhance the accuracy and ease of use for users, the way we calculate Qty to receive and Qty to deliver under the Inventory Items tab has been modified. What’s New The Qty to receive and Qty to deliver columns in Inventory Items will now be calculated based on open sales and purchase orders. What this Means Previously, these columns under the Inventory Items tab considered all invoices, goods receipts, and delivery notes entered into the system, regardless o…

[Sanif_Sentosa]

i mean, if the Obsolete Qty is one day to be removed, then I would have problem with the inventory management, because it doesn’t show the proper Qty.

[Patch]

Manager is continuously evolving, introducing better ways of doing things.

Please look at the new approach for inventory quantity management. Hopefully you will find it is actually a better, and no longer want to use the obsolete fields in the future.