Invoice If cancelled

Stivan_dsouza21Stivan_dsouza21 Member Posts: 218
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

Comments

  • Stivan_dsouza21Stivan_dsouza21 Member Posts: 218
    Can somebody help me with these issue........ :?
    Thanks & Regards,
    Stivan D'souza
Sign In or Register to comment.