Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Inventory Valuation Re...

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

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (6)

Answers (1)

Suggested answer

antoniojrsilva 75 on at

Like (0)

Report

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

Hi

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

Thank you

Antonio
Suggested answer

antoniojrsilva 75 on at

Like (0)

Report

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

Hi Ordoon

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

Can you help me?

Thanks

Antonio
Community Member Microsoft Employee on at

Like (1)

Report

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

Thanks Salot. It worked as you suggested.
Verified answer

Community Member Microsoft Employee on at

Like (1)

Report

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

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 Microsoft Employee on at

Like (0)

Report

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

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

Community Member Microsoft Employee on at

Like (0)

Report

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

Have you added Location as Data Item in Report?