Discount - Amount included VAT
Soloper
Member Posts: 102
Hi all;
Is it possible to calculate discount over "VAT Included Amound" in F9 Screen?
For example;
Amount : 80
VAT : 25
Amount included VAT : 105
I want to discount 5 for total amount and make the invoice amount 100 with VAT.
Possible?
Thanks;
Is it possible to calculate discount over "VAT Included Amound" in F9 Screen?
For example;
Amount : 80
VAT : 25
Amount included VAT : 105
I want to discount 5 for total amount and make the invoice amount 100 with VAT.
Possible?
Thanks;
0
Comments
-
As far as I know it's impossible to calculate an invoice discount on Amount Including VAT, for a simple and logical reason: an invoice discount is not a part of the "value added".
Solution to your problem:
Change the discount amount: with Inv. Discount Amount = 3.81 you will have (if your VAT Rate is 31.25%): Total Excl. VAT = 76.19, VAT = 23.81, Total Including VAT = 100.
Use Payment Discount instead of Invoice Discount:Payment discount can be calculated with or without VAT (see General Ledger Setup help).My candle burns by both ends, it will not last the night,
But oh my foes and oh my friends, it gives a lovely light0 -
Thanks philippe.
Could you give me a fingertip about how to use it?
How tu setup?0 -
Soloper wrote:Hi all;
Is it possible to calculate discount over "VAT Included Amound" in F9 Screen?
For example;
Amount : 80
VAT : 25
Amount included VAT : 105
I want to discount 5 for total amount and make the invoice amount 100 with VAT.
Possible?
Thanks;
I've added a new textbox on F9 form (which has a SourceExpr : VatIncDisc)
I wrote down the following code into OnValiteTrigger of that control :
TotalSalesLine[1]."Inv. Discount Amount":=VatIncDisc*(1-(VATAmount[1]/TotalAmount2[1]));
UpdateInvDiscAmount(1);
Solved.
Thanks0
Categories
- All Categories
- 73 General
- 73 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
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 333 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