If Invoice is cancelled, then Credit Memo is created.
If Invoice and Credit Memo posting date is same then report must show Zero Value of Invoice.
If Invoice and Credit Memo posting date are not same then report must show Values of Invoice.
My customisation in report is for only
If Invoice is cancelled, for ur reference below is the code:
Sales Invoice Line - OnAfterGetRecord()
IF "Sales Invoice Line"."Cancelled Invoice" = TRUE THEN BEGIN
"Sales Invoice Line"."Quantity (Base)" := 0;
"Sales Invoice Line"."Line Amount":=0;
"Sales Invoice Line".Amount:=0;
"Sales Invoice Line"."Inv. Discount Amount":=0;
"Sales Invoice Line"."Line Discount Amount" := 0;
"Sales Invoice Line"."Transport Subsidy" := 0;
"Sales Invoice Line"."BED Amount":=0;
"Sales Invoice Line"."eCess Amount":=0;
"Sales Invoice Line"."SHE Cess Amount":=0;
"Sales Invoice Line"."Tax Base Amount":=0;
"Sales Invoice Line"."Tax Amount":=0;
"Sales Invoice Line"."Amount To Customer":=0;
"Sales Invoice Line"."Excise Prod. Posting Group":='';
"Sales Invoice Line"."Batch No.":='';
END;
How should i proceed futher
Thanks & Regards,
Stivan D'souza
0
Comments
Stivan D'souza