Supply chain | Supply Chain Management, Commerce

Inventory Aging Report showing negative on-hand value

(1) Share

Report

Posted on by Fischjm78

We are working with our accountant and they are asking for our inventory value. When we run an aging report it is close to what we calculate but it is off. The aging report as pictured shows a negative value, when we pull the on hand report for inventory it says we have a positive value on hand. Is this a good report to run for inventory value? The inventory value report has the same issue. What in my setup maybe causing this.

I have the same question (2)

All responses (11)

Answers (0)

Suggested answer

UbaidNoor 74 on at

Like (0)

Report

Hello FISCHJIM

Can you please give a little more detail do you want to look at the stock aging or do you want to see the numbers and values of the stock that your company has?

Because this report is NOT recommended for the STICK VALUE.

If you want to run the stock value report then please run the INVENTORY VALUE REPORT STORAGE (highlighted in RED) and for the inventory stock report you should run INVENTORY AGING REPORT STORAGE (highlighted in Green) under the cost management module.

Was this reply helpful? Yes No
Fischjm78 36 on at

Like (0)

Report

I want to see the value of my inventory on hand. What is the best report for that?

Was this reply helpful? Yes No
Fischjm78 36 on at

Like (0)

Report

The inventory Value report is showing a negative value? When I look at my on hand report it is a positive value, we do not use negative inventory here. What is causing this?

Was this reply helpful? Yes No
UbaidNoor 74 on at

Like (0)

Report

best report for that is INVENTORY VALUE REPORT STORAGE

Was this reply helpful? Yes No
Fischjm78 36 on at

Like (0)

Report

Correction this is an inventory value report that is showing negative qty's.

Was this reply helpful? Yes No
UbaidNoor 74 on at

Like (0)

Report

can you please share the snapshot of the onhand for the same item with the physical and financial cost showing in this snapshot?

Additionally, please check if the item model group attached to the product is having the FINANCIAL NEGATIVE INVENTORY selected as YES or NO?

Was this reply helpful? Yes No
Fischjm78 36 on at

Like (0)

Report

This is my physical onhand for that item.

Was this reply helpful? Yes No
Fischjm78 36 on at

Like (0)

Report

Financial Negative inventory is checked for this item model group.

Was this reply helpful? Yes No
UbaidNoor 74 on at

Like (0)

Report

You need to understand the concept of physical QUANTITY and financial VALUE.

Your qty is in +ve status which is fine but your value is negative which can be true because you might have received and sold the items physically but the invoices (actual financial value) is not yet posted in the system.

What I recommend here, is please try to run the inventory recalculation for this item only and see if this solves your issue.
If it does please mark the answer as verified.

Was this reply helpful? Yes No
Fischjm78 36 on at

Like (0)

Report

That did not work, There should be a positive value to this item because physically they are sitting in my ware house and have not been sold. They are materials that go into a production to make a final product that we sell. No reservation against the product. We are using a standard costing model for this product.

Was this reply helpful? Yes No