Generate a report which shows gaps in Purchase Invoice No.

kvpveeraprasad

How toGenerate a report which shows gaps in Purchase Invoice No. if any( if any No. is missing)?

ufuk

What's the question?

something like:

IF yourfield = '' THEN
//do what you want
ELSE
CurrReport.SKIP

mabl4367

Try this!

Purch. Inv. Header - OnPreDataItem()

Purch. Inv. Header - OnAfterGetRecord()
recPurchInvHeader2.SETVIEW("Purch. Inv. Header".GETVIEW);
recPurchInvHeader2.GET("No.");
IF recPurchInvHeader2.NEXT() <> 0 THEN BEGIN
IF EVALUATE(iStartNo,DELCHR("Purch. Inv. Header"."No.",'=',DELCHR("Purch. Inv. Header"."No.",'=','0123456789'))) AND
EVALUATE(iStopNo ,DELCHR(recPurchInvHeader2."No.", '=',DELCHR(recPurchInvHeader2."No.", '=','0123456789'))) AND
(iStopNo - iStartNo = 1) THEN
CurrReport.SKIP();
END
ELSE
CurrReport.SKIP();



Integer - OnPreDataItem()
SETRANGE(Number,iStartNo,iStopNo);

Integer - OnAfterGetRecord()
cPrefix := DELCHR("Purch. Inv. Header"."No.",'=','0123456789');

ufuk

NAV already has a report for that (for the sales): Have a look at report 124.