VAT amount in sales invoices

GD
Member Posts: 49
hello,
i have a small problem, i want in a sales invoice to print in each item detail line the Vat amount, and not the VAT identifier. I tried to take it from the Vat Amount Line record but in each detail line it sums the amount of the previous detail line.
any help?
george
i have a small problem, i want in a sales invoice to print in each item detail line the Vat amount, and not the VAT identifier. I tried to take it from the Vat Amount Line record but in each detail line it sums the amount of the previous detail line.
any help?
george
0
Comments
-
You can take the amount in the field VAT Base amount of each sales line, and using the VAT %, calculate the VAT Amount for that line.
It's a quite peculiar solution, but it can work.Best Regards,
Manuel Barral Paul0 -
or you could use
Oustanding amount - line amount excl. vat0 -
What IS the best way in code to find the excluding and including price of a unit on each line of an order
when its released there is loads of ways with unit price, unit price excl vat, line amount, line amount excl vat, amount, vat base amount, loads of them....
However most of these fields are empty when the order is open. Which method is the safest and best to find the two values on an open order? Bearing in mind of course that "prices including vat" can be ticked sometimes and not others.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
- 322 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