Calculation Amount Inventory with Standard Cost

Dynamics 365 Business Central/NAV Developers Forum
1

Hi EveryBody

I desgin one reports. Calculation Amount of Inventory of Item Code * Standard Cost (table Stockkeeping Unit)

This is code I write :

Value Entry - OnAfterGetRecord()

IF Stockkeeping.GET(“Item No.”) THEN
SETFILTER(“Location Code”,Item.GETFILTER(“Location Filter”));
SETFILTER(“Location Code”,‘BLUE’);
Stockkeeping.SETFILTER(“Location Code”,‘BLUE’);
Stockkeeping.SETRANGE(“Item No.”,“Value Entry”.“Item No.”);

BEGIN
TotaAmountBLUE:= TotalBLUE *Stockkeeping.“Standard Cost”;
END;

Results Standard Cost by Location inaccurate. TotaAmountBLUE wrong.

Please help me edit code. Thanks so much.