zero movement inventory

karuchua

am trying to create to create a form to output for me inventory with zero movement.
am trying to filter for the items and also check in the item ledger entries the last posting date then compare against my calculated months and end date.

in the code below but not working,what am i missing?

IF GReportDate = 0D THEN
   GReportDate := WORKDATE;

GYearFormular := '-' + FORMAT(GNoOfMonths) + 'M';

GMonthDates[1] := CALCDATE('CM',GReportDate);
GMonthDates[1] := CALCDATE(GYearFormular,GMonthDates[1]);
GMonthDates[2] := CALCDATE('-CM',GMonthDates[1]);

IF GMonthDates[2] < 080809D THEN
   GMonthDates[2] := 080809D + 3;

LItemLedgEntriesREC.RESET;
LItemLedgEntriesREC.SETCURRENTKEY("Item No.","Posting Date");
LItemLedgEntriesREC.SETRANGE("Item No.","No.");
LItemLedgEntriesREC.SETRANGE("Posting Date",GMonthDates[2],GReportDate);

IF LItemLedgEntriesREC.FINDLAST THEN BEGIN
  SETFILTER("Date Filter",'%1',GMonthDates[2]);
END;

mohana_cse06

try to check calculated GMonthDates by printing message
Message('%1 %2',GMonthDates[1],GMonthDates[2]);

use below statements

GMonthDates[1] := CALCDATE('<CM>',GReportDate);
GMonthDates[2] := CALCDATE('<-CM>',GMonthDates[1]);
GYearFormular := '<-' + FORMAT(GNoOfMonths) + 'M>';

karuchua

i can output the dates but seems not to filter on my aftergetrecord of my form.

mohana_cse06

where did you write this code?

karuchua

its on my aftergetrecord of the form

mohana_cse06

What are you expecting from this code?

SETFILTER("Date Filter",'%1',GMonthDates[2]);

karuchua

am expecting it to filter items that the meet the item ledger entries setrange above,how should it be?

karuchua

no one with an idea ?