cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Creating a discount amount column in sap business one

Former Member
0 Kudos
881

I have a client who wants a discount amount column item wise in marketing documents. I tried creating it bu going to Tools >> customization tools >> User-Defined fields management >> marketing documents >> Rows then i added Discount amount field. but when include a discount amount in that field its not deducted from that total invoice.

Any one with a solution can you please help.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi

Thanks all for your responses, if i get to put more light on what the client would like.

SAP has a standard field of the discount%,which is ok

Now the client does not want to use that field,he wants to use the discount amount on the line items

e.g a customer buys two items    1. HP costs 1000$   with a discount 100$  so total will be 900$

                                                 2. HP costs 5000$   with no discount        so total will be 5000

So the total invoice figure will be                                                                                      5900$ 

PLEASE HELP                                                                       

Former Member
0 Kudos

Hi,

You can input the value as 900 in the price after discount field which you can activate from form settings. Have you tried this one?

Thanks,

Joseph

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Try this:

Enter discount amount in Total (LC) field in marketing documents.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hi,

The total invoice amount is a calculated field that hard-coded by SAP. If you want to add your logic to the formula, system will not help you. You have to try SDK to reach your goal.

Thanks,

Gordon

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

All marketing documents are already added with discount and amount.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hello Nagarajan

Thanks for the quick If u take a look at the marketing documents the discount included per item is the discount % and what i want to include is the discount amount per item instead of the discount %

Thanks

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

How did you calculate discount amount ? How did you update this field (UDF)?

Thanks & Regards,

Nagarajan