News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Calculate stock on Var...

Business Central forum

Suggested answer

Calculate stock on Variant level

(0) Share

Report

Report

Posted on by Knofan

30

Hey guys

I am trying to calculate (using Power BI) stock on items with variants. And when i check the ItemLedgerEntries table the Variant Code is not there. So there is not way of knowing what variant it refers to. How can i accomplish this?

I read that it should be possible to use the ItemLedgerEntries and ItemVariant table together, but i dont see how that can be done. There are no relations to what Variant was used in the Ledger table.

Any ideas?

Thanks!

Categories:

Inventory and warehouse management

All responses Img

All responses (3)

Answers Img

Answers (0)

TCJ on at

Like (0)

Report

RE: Calculate stock on Variant level

It's probably linked to how you are accessing the data.

Looking at the table definition for the Item Leger Entry Table shows that Variant Code is field 5402 (not changed since at least since Navision 4).
Knofan 30 on at

Like (0)

Report

RE: Calculate stock on Variant level

Hey

Im not sure it helps me. The question is different from what im asking. Its related to cost per item. I need to calculate stock. There is no column with the variant code in the itemledgerentries.
Suggested answer

DAnny3211 9,217 Moderator on at

Like (0)

Report

RE: Calculate stock on Variant level

hi

look this

community.dynamics.com/.../item-variant-cost

DAniele

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,570 Super User 2024 Season 2

#2

Martin Dráb 228,683 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans