Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Net price calculation

Hi Gurus,

we have a SBO 2007 Patch 42 (not updated from 2005).

we entered an PO in with the following data:

Material: Systemtube

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.

Michael Benner

replied

Hi,

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.

Note

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.

Document Settings - Calculate the row total using the unit price

Regards,

Jitin

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question