CurrForm.ItemAvailMatrix.MatrixRec.SETRANGE("Use As In-Transit",ShowInTransit);
IF ShowColumnName THEN
MatrixHeader := CurrForm.ItemAvailMatrix.MatrixRec.Name
ELSE
MatrixHeader := CurrForm.ItemAvailMatrix.MatrixRec.Code;
Stock:=0;
QtySoldNotPst:=0;
Item.RESET;
Item.SETFILTER("No.","Item No.");
Item.SETFILTER("Variant Filter","Variant Code");
Item.SETFILTER("Location Filter",'%1',CurrForm.ItemAvailMatrix.MatrixRec.Code);
Item.SETFILTER("Date Filter",GETFILTER("Date Filter"));
IF Item.FINDFIRST THEN BEGIN
Item.CALCFIELDS(Inventory);
Store.RESET;
Store.SETFILTER(Store."Location Code",CurrForm.ItemAvailMatrix.MatrixRec.Code);
IF Store.FINDFIRST THEN
QtySoldNotPst := BOUtils.ReturnQtySoldNotPosted("Item No.",
Store."No.","Variant Code",GETFILTER("Date Filter"));
Stock:=Item.Inventory-QtySoldNotPst;
END;
I Edited this C\AL Code but while saving gives me an error which is in the picture below i need help with this issue please
0
Comments
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
Don't forget to put it here also:
QtySoldNotPst := BOUtils.ReturnQtySoldNotPosted("Item No.",
Store."No.","Variant Code",matrixrec.GETFILTER("Date Filter"));
|To-Increase|