problem with code

mkpjsr

Hi all,

I am creating a report to show item's inventory based on location, here i want to calculate the total of quantity for items under two locations called "Main Store" and "Production".
so i have written the following code but its calculating the total for all locations.

My report is having one data item called "Item" and i have written the code under OnAfterGetRecord trigger.

SETFILTER("Location Filter",'%1|%2','MAIN STORE','PRODUCTION');
CALCFIELDS(Inventory);
TotalQty := Inventory;

what is wrong with the code.

Luc_VanDyck

This works for me in the demo W1 NAV 5.0 SP1 company:

GET('1968-W');
SETFILTER("Location Filter",'%1|%2','GREEN','RED');
CALCFIELDS(Inventory);
MESSAGE('%1',Inventory)

Result is 8.

GET('1968-W');
SETFILTER("Location Filter",'%1|%2','GREEN','YELLOW');
CALCFIELDS(Inventory);
MESSAGE('%1',Inventory)

Result is 14.

GAP

Try Writing the code Setfilter on predataitem trigger
the rest on aftergetrecord trigger.

veerendra

Is the problem fixed with the solution provided by GAP :thumbsup:

mkpjsr

veerendra wrote:

Is the problem fixed with the solution provided by GAP :thumbsup:

The code is working fine under OnAfterGetRecord Trigger also,

actually i had written SETRANGE("Location Filter") after SETFILTER thats why it was not working

thanx u all for the reply