VAT Amount Line Table(InsertLine Issue)

tooo
Member Posts: 138
EDIT: It was assigning the wrong variable to "VAT Base", working fine now.
Below is the InsertLine function from the VAT Amount Line table(table 290) i have a custom report and sometimes the VAT amount will be zero and because of this the VAT footer wont display on the report due to the first IF statement on the InsertLine function, can anyone suggest a way around this please?
Below is the InsertLine function from the VAT Amount Line table(table 290) i have a custom report and sometimes the VAT amount will be zero and because of this the VAT footer wont display on the report due to the first IF statement on the InsertLine function, can anyone suggest a way around this please?
IF ("VAT Base" <> 0) OR ("Amount Including VAT" <> 0) THEN BEGIN Positive := "Line Amount" >= 0; VATAmountLine := Rec; IF FIND THEN BEGIN "Line Amount" := "Line Amount" + VATAmountLine."Line Amount"; "Inv. Disc. Base Amount" := "Inv. Disc. Base Amount" + VATAmountLine."Inv. Disc. Base Amount"; "Invoice Discount Amount" := "Invoice Discount Amount" + VATAmountLine."Invoice Discount Amount"; Quantity := Quantity + VATAmountLine.Quantity; "VAT Base" := "VAT Base" + VATAmountLine."VAT Base"; "Amount Including VAT" := "Amount Including VAT" + VATAmountLine."Amount Including VAT"; "VAT Difference" := "VAT Difference" + VATAmountLine."VAT Difference"; "VAT Amount" := "Amount Including VAT" - "VAT Base"; "Calculated VAT Amount" := "Calculated VAT Amount" + VATAmountLine."Calculated VAT Amount"; MODIFY; END ELSE BEGIN "VAT Amount" := "Amount Including VAT" - "VAT Base"; INSERT; END; END;
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions