I have a customer who for marketing reasons wants to have the line discount % applied to the unit price instead of the line value. I have suggested I just show this as the 'Net Price' using a formula field on the sales order report to give an indicative price but they insist on having it shown, calculated and posted using 2 decimal places. For example :Current Method (Standard Navision)
Qty Price Disc % Line Value After Disc
6 72.66 25 326.97
Qty Disc % Net Price Line Value
6 25 54.50 327.00
Here the Net Price is actually 54.495 rounded to 2 decimal places which has the effect of increasing the line value.
Unless I'm missing something it seems to me that to do this I would have to re-write all the unit price/discount/VAT line value calculations in Navision to work under this method which I'm really not keen to do.
Has anybody else done this as a modification or has any suggestions?
Any help appreciated,