Inventory Valuation Table

(0) Share

Report

Posted on by john.ellis

3,510

Hi:

I meant to post this question here in the NAV Forum but accidentally posted it, first, in the Business Central Forum.

So, I apologize for the "cross posting".

In tying the Item Table with the Inventory by Location table using Get Data in Excel, we're trying to get the item cost by location.

But, the same cost figure appears for each location. So, that can't be right.

We, next, tried to pull the Value Entry table into Excel. But, since this table contains a record for each inventory-based transaction, reviewing this table is not feasible.

In using Get Data in Excel, what is the best means of accessing an inventory valuation table and determining item cost by location?

Thanks!

John

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

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

Like (1)

Report

Hi, Is it possible to use Item ledger Entries?

I think you can use the following three fields, and it would be nice to create a Query.

"Posting Date", "Location Code", "Cost Amount (Actual)"

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No