In a report we want to get the value of inventory feild from stockkeeping unit table based on few conditions. In stock keeping unit table ,the inventory feild is a flow feild.
when we get the inventory value based on few condition like item no in item card,and some specified location, the value of inventory is not printing in the report but if we print any other feild like Standard cost feild in stockkeeping unit table based on those condition ,the value is printed in the report.
Is this problem due to the inventory feild as flowfield?if so how do we access the flowfeild value in a report.
for eg::
"Stockkeeping unit".SETRANGE("Stockkeeping unit"."Item No.",Item."No.");
"Stockkeeping unit".SETRANGE("Stockkeeping unit"."Location Code",'FACT SHEAR');
"Stockkeeping unit"."Standard Cost" := "Stockkeeping unit"."Standard Cost";
Here we are able to get the standard cost value in the report but if it is
"Stockkeeping unit".Inventory := "Stockkeeping unit".Inventory;
the value is not printing in the report.
The differance between the two feild is only the flowfield.
0
Comments
"Stockkepping Unit".CALCFIELDS(Inventory) ?