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

Inventory Valuation by Location

(0) Share

Report

Posted on by Rikarddo

273

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

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

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:

W1:

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Rikarddo 273 on at

Like (0)

Report

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

Any other sugestions?

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 8,760 on at

Like (0)

Report

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,

Was this reply helpful? Yes No