rounding with row discount

[kedalenechong]

Hi all

Currently we encountered this rounding problem.

Example

Sales unit price before discount $74.5

row discount 4.0299

Quantity 2.11

Sales price total after Discount = (100-.4.0299/100) x 74.5 x 2.11 = 150.860

However it should be

unit price after Discount $71.5 x 2.11 = 150.87

We have increased all possible Decimals but the result is still the same

Please advise any other special settings?

Kedalene

[Former Member · Accepted solution]

Please go through the below mentioned point...

Administration -> System Initialization -> Document Settings -> Generla Tab:

'Calculate Row Total Using Unit Price'.

[kedalenechong · Accepted solution]

Hi Aravind

I can't find such option you mentioned?  Please show me a screenshot?

What is your SAP Business One version and what is the Localisation?

Kedalene

[Former Member · Accepted solution]

Hi Kedalene,

My Version is 9.2 Indian Localization.

Please find the attached screen shot.

[kedalenechong · Accepted solution]

Hi Aravind

But where is the Calculate Row Total using Unit Price option?

[kedalenechong · Accepted solution]

Hi all

Finally this is solved after updated backend OADM LDiscTotal (Calculate Row Discount from Total Price) from Y to N works.

Seems like this calculation option is no longer visible anywhere in Singapore version 9.1 Document Settings.

Kedalene

[Former Member · Accepted solution]

You are not supposed to do DML operations on SAP defined tables. You might void your support contract with SAP.

Regards

Shiva

[kothandaraman_nagarajan · Accepted solution]

Hi,

We can request some of the disabled function by sending request to SAP. So may be above function activated with the help of SAP.

Thanks