Calculate inventory at an earlier date

MT78

Hello everybody,

i would like to calculate the inventory quantity at an earlier date (ex: knows the inventory for an item on 30 april 2008)

On the report with this code it's always the same quantity => inventory at this moment :
_________________________________________________________________________

RecItem is a variable record on Item table
VarDateStock is variable as date (user inform the date on report filter)

RecItem.INIT;
RecItem.SETRANGE(RecItem2."No.",Item."No.");
RecItem.SETRANGE(RecItem2."Date Filter",VarDateStock);
IF RecItem.FIND('-') THEN
BEGIN
RecItem.CALCFIELDS(RecItem.Inventory);
VarStockFinMois:=RecItem.Inventory;
END;

Thanks a lot for your help

The same code on customer or vendor is ok when i want to know the sales for a period.

MBerger

If you look at the flowfield "inventory" in the item table, you'll see that it doesn't use the "date filter" flowfilter. Use the field "Net change" instead

MT78

Thanks for your answer i'm going to check and test that

Alex_Chow

Make sure when you set your filter on the "Date Filter', you do from 0D to the date you want.