3
The main problem is that the applied invoice discount is not distributed coherently between the lines, especially when there are negative lines or lines with different VAT.
Example:
- create two lines with quantity 1 and unit price 1000.
- create the third line with quantity -1 and unit price 1000.
- apply an invoice discount of 10% and on the first and second line the invoice discount amount excluding vat will be 100 and on the third line is -100.
- create the fourth line with quantity 1 and unit price 1000.
- create the fifth line with quantity -1 and unit price 1000.
- on the fourth and fifth lines the invoice discount amount is not calculated yet.
- release the document and BC recalculate the invoice discount for each line.
- we think that the correct result must be 100 or -100 that is the 10% of each line for each line but is not whats happen.
- BC take the invoice discount on the positive lines (200) and divided it between all the positive lines (200/3=66,66) then take the invoice discount on the negative lines (-100) and divided it between all the negative lines (-100/2=-50)
- the result is that I have a document with 10% of invoice discount but the invoice discount of each line is not 10%.
We think that can be useful an option that allow to recalculate the invoice discount during the release. In that case the system calculates again the invoice discount % on each line. Using Calc. Inv. Discount on Sales & Receivables Setup is not a solution because this flag prevents the manual management of the invoice discount %.
STATUS DETAILS
New