News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Inventory Valuation Table

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

Answered

Inventory Valuation Table

(0) Share

Report

Report

Posted on by john.ellis

3,482

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

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

YUN ZHU 73,696 Super User 2024 Season 2 on at

Like (1)

Report

RE: Inventory Valuation Table

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans