Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Suggested answer

Inventory Valuation by Location

Posted on by 265

I used report from NAV 2017 - R1001 - Inventory Valuation, to create a new report that could group by location. Because in the original report i can take the results of all Locations or  filter by a specific. 

My goal is to show all locations .

I added Location as Data Item, and indented Item , and dataitemlink by Code - Location Filter

Then in Code replaced :

//ValueEntry.SETFILTER("Location Code",GETFILTER("Location Filter"));
ValueEntry.SETFILTER("Location Code",Location.Code);

//ItemLedgEntry.SETFILTER("Location Code",Item.GETFILTER("Location Filter"));
ItemLedgEntry.SETFILTER("Location Code",Location.Code);

The original map takes about 2 minutes for all data, tis new map cant generate at all no data(20 minutes nd nothing). Except if i put some filters before generate the report, for example one location or one item.

What i am missing here?

Thanks for help

  • Suggested answer
    Jeffrey Bulanadi Profile Picture
    Jeffrey Bulanadi 644 on at
    RE: Inventory Valuation by Location

    Hi Rikarddo ,

     

    What if you try to change your data item instead?

     

    Try using item ledger entry directly then create a parent group for Location and Items (it can be done easily thru RDLC / RDL)

     

    By this way, you can filter a location to show only the inventory group by that location or inventory per each location group.

     

    If you find this useful please give it a like or verify the answer. By this way you can help other members know that the topic has been answered. Have a nice day. Thank you.

     

    Cheers,

  • Rikarddo Profile Picture
    Rikarddo 265 on at
    RE: Inventory Valuation by Location

    Well the versions are really different, and i need to create a table. I preffer not.

    Any other sugestions?

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 69,933 Super User 2024 Season 2 on at
    RE: Inventory Valuation by Location

    Hi, sorry I don't have a screenshot of NAV, you can download a US version of NAV that includes this feature in the Inventory Valuation feature.

    US:

    pastedimage1657672241832v1.png

    W1:

    pastedimage1657672408310v2.png

    Hope this helps.

    Thanks.

    ZHU

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,554 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,588 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans