Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Calculate stock on Variant level

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,217 Moderator 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,683 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans