Displaying discount amount on sales invoice

Smashed_Pumpkin
Member Posts: 47
Hi,
Is it possible to display the early settlement discount amount on a sales invoice? At present the printout says something like "If paid by xx/xx/xx you get 1.5% discount", but I'd like the report to state the actual discount amount allowed (some of our customers work out the discount incorrectly).
Is it possible to display the early settlement discount amount on a sales invoice? At present the printout says something like "If paid by xx/xx/xx you get 1.5% discount", but I'd like the report to state the actual discount amount allowed (some of our customers work out the discount incorrectly).
0
Comments
-
Yep,
You can find the amount by looking af Customer Ledger Entries with the same document no. and look in the field "Original Pmt. Disc. Possible".
Declare the variable: CustLedg (Record, Cust. Ledger Entry)
and PossDiscountAmount (Decimal)
and use the code:
PossDiscountAmount := 0;
custledg.setcurrentkey("Document No.");
custledg.setrange("Document no.","No.");
custledg.setrange("Document Type",custledg."Document Type"::Invoice);
custledg.setrange("Posting date","posting date"); // Just to be sure...
if not custledg.find('-') then
custledg.init
else
PossDiscountAmount := custledg."Original Pmt. Disc. Possible";Regards,
Henrik Frederiksen, Denmark0 -
Thanks for the help0
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