Inventory Valuation

Rikarddo

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

KTA8

first if the location filter isn't something the user can't choose, you should use setrange instead. You can also should use another key that uses location code instead the default one that should use entry nº

Rikarddo

If I replace

ItemLedgEntry.SETFILTER("Location Code",Location.Code)

for

ItemLedgEntry.SETRANGE("Location Code",Location.Code);

the behaviour is similiar
Please any help?

KTA8

Rikarddo wrote: »

If I replace

ItemLedgEntry.SETFILTER("Location Code",Location.Code)

for

ItemLedgEntry.SETRANGE("Location Code",Location.Code);

the behaviour is similiar
Please any help?

Did you give it a try using setcurrentkey with a key that includes location?