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

277

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?

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Amit 2,559 on at

Like (0)

Report

Hi,

Do you have done any customization.

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No
Omar_Berk 45 on at

Like (0)

Report

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)

Was this reply helpful? Yes No
Nirmala Karunarathna 277 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,574 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (1)

Report

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.

Was this reply helpful? Yes No