Net price calculation
we have a SBO 2007 Patch 42 (not updated from 2005).
we entered an PO in with the following data:
Quantity 2500 meters
Purchasing price: 1,07 EUR
Discount: 9.5 percent
The right net price (from our R/3 system as vendor, or from my pockel calculator) is 2420,87 EUR.
The net price in SBO is 2425,00 EUR.
I know, that the wrong calculation is comming from the decimal places in the general settings and the depending rounding method. Actual our prices are definded in the system with 2 decimal places.
To get the right result of the calculation, I have to change the decimal places of the prices to 5 decimal places, but this looks stupid in the PO and SO screen (examle 5000.00000 EUR for 5000.00 EUR) and we may get a lot of mistakes by the users if they change or enter this price manually in a screen.
I have read in this forum, that, if a SBO systems which where updated from 2005 to 2007, these systems have an additional posibility to calculate the net price (first calculation and then rounding) with a flag in the Documents settings - General tab.
How can I solve this problem ?
- Is there a way to get this flag also as "Only-2007" SBO system ?
- Or is there a way to change the display of the price field in POs or SOs to 2 decimal placed, even when it is defined with 5 decimal places ?
- Or is there any other way to solve this problem ?
Thanks in advance for your help.
Jitin Chawla replied
Calculate the row total using the unit price :
Select to calculate the row total in marketing documents as follows:
Unit Price x Discount x Quantity. The Unit Price is the price before discount.
When deselected, the row total is calculated as follows:
Price after Discount x Quantity.
When selected, the Price after Discount in marketing documents is disabled.
This option is available only if you have upgraded to SAP Business One 2007 A from previous releases
Check the following thread which discusses about tickbox.