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

Average Cost on an Inventory Valuation Report

(0) Share

Report

Posted on by SPThompson

Hi,

I am new to Navision and we use the NAV 2009 R2 version. I have been asked to provide a list of inventory items with their average cost, quantity and total value. Is there a standard report that I can use to select those features?

Regards

Steve

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

YUN ZHU 101,502 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, I think you can try Inventory Valuation report.

More details: https://docs.microsoft.com/en-us/dynamics-nav-app/design-details-inventory-valuation

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Dallefeld 233 User Group Leader on at

Like (2)

Report
Copy link

Link copied!

ZHU is correct but to be clear. the Inventory Valuation Report calculates the unit cost by taking the value of inventory and dividing it by the quantity on hand. It is not a weighted average.

Was this reply helpful? Yes No
SPThompson 5 on at

Like (0)

Report
Copy link

Link copied!

Hi Kim,

The unit cost is not being reflected on the report. I only get the data per 1st screenshot. The price I am trying to obtain is the Average Cost(LCY) per second screenshot

Regards

Steve

Was this reply helpful? Yes No