Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
purchase line discount % bug
Reinhard
Member Posts: 249
Hello,
See if you can reproduce this error....
1. Create a Purchase Order.
2. Add an item and a unit cost. (for example 100 pieces for $10 each = $1,000 total amount, not tax liable)
3. Add a line discount % (say 10%)
4. Post receipt for all 100 pieces.
5. Post invoice for 50 pieces.
6. Post invoice for the remaining 50 pieces which should close out the order.
You should have two posted purchase invoices.
Each one should have $50 discounted.
Instead the first invoice posted $100 discount, and the second one $50 discount, for a total of $150.
150/1000 NOT EQUAL 10%!
Is there something I'm doing wrong or is the posting routine incorrect?
As always your feedback is greatly appreciated.
- Reinhard
Nav6.2
P&P Setup: Discount Posting = All Discounts
There are no other vendor, payment, etc. discounts.
See if you can reproduce this error....
1. Create a Purchase Order.
2. Add an item and a unit cost. (for example 100 pieces for $10 each = $1,000 total amount, not tax liable)
3. Add a line discount % (say 10%)
4. Post receipt for all 100 pieces.
5. Post invoice for 50 pieces.
6. Post invoice for the remaining 50 pieces which should close out the order.
You should have two posted purchase invoices.
Each one should have $50 discounted.
Instead the first invoice posted $100 discount, and the second one $50 discount, for a total of $150.
150/1000 NOT EQUAL 10%!
Is there something I'm doing wrong or is the posting routine incorrect?
As always your feedback is greatly appreciated.
- Reinhard
Nav6.2
P&P Setup: Discount Posting = All Discounts
There are no other vendor, payment, etc. discounts.
0
Answers
Basically, the first time posting a partial invoice in a purch. line with a discount %, the entire discount was taken for the whole quantity.
The reason appears to be, in codeunit 90, Purch.-Post, function:
AddSalesTaxLineToSalesTaxCalc(PurchLine : Record "Purchase Line";FirstLine : Boolean)
... IF MaxInvQty <> Quantity THEN "Line Discount Amount" := ROUND("Line Amount" * "Line Discount %" / 100,Currency."Amount Rounding Precision"); ...MaxInvQty is the total quantity remaining to be invoiced. The first time you invoice an order, MaxInvQty will ALWAYS equal Quantity:
Proposed Solution
I commented out the condition and always reset the line discount amount. Appears to post correctly for partial and full invoices.
... //IF MaxInvQty <> Quantity THEN "Line Discount Amount" := ROUND("Line Amount" * "Line Discount %" / 100,Currency."Amount Rounding Precision"); ...Feedback is appreciated. Is it a real bug? If so, how to report?
Maybe someone else could help with this.
Really sorry, since I'm not in NSC anymore.
Andwian