Skip to main content

Notifications

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

Calculate stock on Variant level

(0) ShareShare
ReportReport
Posted on by 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!

  • TCJ Profile Picture
    TCJ on at
    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 Profile Picture
    Knofan 30 on at
    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 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: Calculate stock on Variant level

    hi

    look this

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

    DAniele

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans