cancel
Showing results for 
Search instead for 
Did you mean: 

calculate line in a sales order

Former Member
0 Kudos

Hi,

does anyone know if it is possible to calculate an amount on a line in a sales order as shown in linenr 3.

Ex:

linenr item quantity price total

1 A 5 10 50

2 B 10 10 100

3 C 1 (25+100)*0.10 15

Regards,

Henrik Fladkjaer

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member583013
Active Contributor
0 Kudos

Henrik,

Is it some kind of additional charge or tax you are trying to calculate. The way your have pictured adding a Third line with the total is not going to be possible is SBO out of the box. Unless you want to do them manually it will require Customization work using SDK.

If you could take a little time to explain me the business need I might be probably able to propose an alternate approach. Its your call finally

Suda

former_member583013
Active Contributor
0 Kudos

As I asked you earlier what are you trying to do with (50+100)* Understand your business requirement of What is 50 and what is 100 andWhere is it coming from would help me come up with an answer.

Suda

Former Member
0 Kudos

Hi

I will make a calculation in line 3 in a Sales order.

In the first line 5 pieces is multiplied with 10$ = 50$

In the second line 10 pieces is multiplied with 10$ = 100$

The sum of Line 1 and 2 is (50$ + 100$)

In line 3 I will like to make an calculation where (50$ + 100$) is multiplied with 10% (0.1) = 15

The total sum of the Sales order is now:

Line 1 = 50$

Line 2 = 100$

Line 3 = 15$

-


Total = 165$

============

Henrik

former_member583013
Active Contributor
0 Kudos

Henrik,

Could you breifly explain what you are trying to do on the business logic with (25+100) *

This would help me get you an answer

Suda

Former Member
0 Kudos

Hi Suda

I am sorry it is (50+100)

Line 1: 5*10 = 50

Line 2: 10*10 = 100

Line 3: (50+100)*0.10 = 15

Regards,

Henrik