all i want is the total balance of inventory before and after the date filter (if there is one provied)Here is my code:
Item - OnAfterGetRecord()
IF DateFilter <> ‘’ THEN BEGIN
SETRANGE(“Date Filter”,0D,GETRANGEMIN(“Date Filter”) - 1);//before datefilter
openBAL := Inventory;
SETRANGE(“Date Filter”,GETRANGEMAX(“Date Filter”) + 1,01019999D);//after datefilter
closeBAL := Inventory;
All it keeps giving me is the total Inventory for both the openBAL and CloseBAL. I know i am doing something wrong cause ive seen this done in many other places. Can someone please point out my mistake ?