Invoice If cancelled
Stivan_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
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
Stivan D'souza
0
Comments
-
Can somebody help me with these issue........ :?Thanks & Regards,
Stivan D'souza0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 611 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions