web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Inventory Valuation Re...
Microsoft Dynamics NAV (Archived)

Inventory Valuation Report - To Group by Location instead of the Inventory Posting Group

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I need to group the Inventory Valuation report by Location instead of the Inventory Posting Group. I added the Location field from the Value Entry dataitem and then on the report layout changed the Group for the Inventory Posting Group to Location. Report comes out with the Locations grouped but I get wrong total sum  for each location when I generate report for more than one location. I tested my result by first generating report just for one location and then generate for all locations using same period and I get different sum for each location compared to those same locations when generated just for the locations alone.

Please I need your advice on how to get this correct.

Thanks.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Have you added Location as Data Item in Report?

  • Community Member Profile Picture
    Community Member on at

    No, I did not add Location as Data Item I added field Location Code on the Value Entry Data Item.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Considering the report logic, try adding the Location as data item on top of the report and see the working. Define the proper location filters @ Value Entry as per your location code.

    I think, this should work.

  • Community Member Profile Picture
    Community Member on at

    Thanks Salot. It worked as you suggested.

  • Suggested answer
    antoniojrsilva Profile Picture
    antoniojrsilva 75 on at

    Hi Ordoon

    I'll need the same as you but I don't understand how you doing.

    Can you help me?

    Thanks

    Antonio 

  • Suggested answer
    antoniojrsilva Profile Picture
    antoniojrsilva 75 on at

    Hi

    Could explain better, maybe with an example, what you suggest to do?

    Thank you 

    Antonio

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
TAHER_El_Mehdi Profile Picture

TAHER_El_Mehdi 2

#1
sliderxb Profile Picture

sliderxb 2

#1
broberts Profile Picture

broberts 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans