SQ, PO..etc.. Row level Discount and difference in unit price and total

[former_member731595]

Dear All,

while applying a discount in PO or SQ ..etc..in row level I get correct unit price after discount Colum value, but in same row total price has minor difference in cents, bear in mind i am using 3 decimal.

For Example :

item for 2nos Quantity : Eur 174.33/each, after applying discount 1.6% = Eur 171.54072

SAP will round the unit to read Eur 171.541/each - which is fine

while applying the total 171.541 X 2 = Euro 343.082, but in SAP gives in the screen and layout print the total Euro 343.081.

how to solve the problem, because this the case for so many items and quantities there will be big difference.

currently we doing it is excel file and then pasted in SAP but the process it takes time especially for so may line items.

{Moderator removed personal data}

layout-print.jpeg sap-screan.jpeg

[KatiNonhebel]

Thank you for visiting SAP Community to get answers to your questions.
I have removed your personal Data as it is not allowed to post email and phone number into the community.
I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond:https://www.youtube.com/watch?v=46bt1juWUUM

Keep in mind, when you receive an answer that was helpful to you, accept it as best answer.

Good Luck

Kati - SAP Community Moderator

[Lakshmipathi]

If the issue is with only print output, ask your ABAP team to carry out necessary code change in the smart form being used currently. On the other hand, if there is a difference in value at transaction level itself, consider maintaining the unit rate per 10 instead of 1

[former_member731595]

Dear Mr. Lakshmi,

thanks for your email, the explanation you gave is related to SAP S4/HANA.

we are using SAP Business One version 9.3.

the problem happening apply a discount row level the unit price after discount multiply by quantity will result some difference of the total price.

also if you check other line item you will realise the difference of the total price after the multiplication of unit price by quantity.

appreciate you reply/solution

[former_member731595]

For Example : item for 2nos Quantity : Eur 174.33/each, after applying discount 1.6% = Eur 171.54072 SAP will round the unit after discount to read Eur 171.541/each - which is fine.

while applying the total 171.541 X 2 = Euro 343.082, but in SAP gives in the screen and layout print the total Euro 343.081. how to solve the problem, because this the case for so many items and quantities there will be big difference.

tried the same now in SAP B1 V10 its same outcome!!

whats your suggestion...

[Lakshmipathi]

When you create a discussion and start adding additional informations as asked by the members, please add the same under Comments and not under Answer as you were not answering but sharing additional information. Also, when you add under comments, a mail will be triggered to who you respond. By the way, I have converted your above Answer to Comment

[Lakshmipathi]

As already indicated, please use the appropriate tags related to your system environment / requirement. Since now only, you indicated that the requirement is in Business One, I have added the related tags for better reach