zero movement inventory

karuchua · 2012-08-30

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 · 2012-08-30

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 · 2012-08-30

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

mohana_cse06 · 2012-08-30

where did you write this code?

karuchua · 2012-08-30

its on my aftergetrecord of the form

mohana_cse06 · 2012-08-30

What are you expecting from this code?

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

karuchua · 2012-08-30

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

karuchua · 2012-08-30

no one with an idea ?

zero movement inventory

Comments

Categories