Predator
5th April 2012, 17:54
Hi,

On below case:-
Qty order = 10 pcs
selling price = 1.47
discount = 45%

Infor LN calculation will display net selling price of 8.08

(10*1.47) - (10*1.47*0.45) round up to decimal = 8.08

Did ask Infor to change the logic of calculation which will solve the round problem issue by the way the discount is being calculated:-

10*(1.47 - 1.47*0.45 round up to 2 decimal) = 8.10

The root problem here is Infor is calculate after multiple with qty order and this is not right.

Infor suggest a workaround , for 10 pcs, just key in 10 times each 1 pcs in each SO line and i am very upset with this kind of suggestion.

Please help on this because it involve serious display problem in the invoicing to customer and customer for sure will not accept.

TQ

sushil
25th April 2012, 23:55
Dear,

your profile states that you are using "Baan V" , i am on baan iV .

Years agao - a Similar problem occured to me in PO - Where the Discount Value was Inserted of Discount %.

in LN , if you have a Line Discount Value field then try entering "0.6615".

Good Luck,

Regards,
Sushil Kumar Mudaliar

avpatil
26th April 2012, 18:23
Yes. Baan rounds up the total amount. The issue happens when one needs to display the per unit price, as at time it runs into more than 2 decimals (in USD).

sushil
27th April 2012, 17:44
We Did some Cust. on PO from PSO , I assume that might be reason in PO Values not Rounded off . it always ends up with 0.0000