Small and medium business | Business Central, N...

Inventory valution quantity does not match with ILE and item card

(0) Share

Report

Posted on by Nirmala Karunarathna

273

I have an issue with inventory valuation report.

The item shows 1 quantity in inventory valuation report. However it does not show in item card. I looked into ILE by filtering 'remaining quantity <>0', even then it does not show. Any idea?

All responses (6)

Answers (0)

Suggested answer

Dallefeld 175 User Group Leader on at

Like (1)

Report

RE: Inventory valution quantity does not match with ILE and item card

My apologies, I was not seeing all of the responses. This Inventory Valuation report is not the standard report that I'm used to seeing. Is it a custom report?

I think @Zhu is leading you in the right direction....to the value entries. You could have a value entry with a posting date. Seeing the item ledger entries would be helpful for support.
Suggested answer

Dallefeld 175 User Group Leader on at

Like (0)

Report

RE: Inventory valution quantity does not match with ILE and item card

Your screenshots are not showing the Inventory Valuation Report or the Item Ledger Entries. These are the two things that are used when looking into inventory quantities and valuation. The first report, could be giving one set of numbers based on a date range while the item list does not apply any date range.
Suggested answer

YUN ZHU 81,849 Super User 2025 Season 1 on at

Like (1)

Report

RE: Inventory valution quantity does not match with ILE and item card

Hi, Have you tried investigating in Value Entries?
Most of the values of Inventory Valuation are obtained from Value Entries.

Hope this helps.

Thanks.

ZHU
Nirmala Karunarathna 273 on at

Like (0)

Report

RE: Inventory valution quantity does not match with ILE and item card

I put same date filters for both inventory valuation report and ILE. Check the screenshots below.
Omar_Berk 45 on at

Like (0)

Report

RE: Inventory valution quantity does not match with ILE and item card

Please check the date filter used in the valuation report. You can compare this quantity with the item ledger entries by filtring on the item (same date filter used in the report)
Suggested answer

Amit_Sharma 2,545 on at

Like (0)

Report

RE: Inventory valution quantity does not match with ILE and item card

Hi,

Do you have done any customization.

Regards

Amit Sharma

www.erpconsultors.com