Calculate line total in SO

[Former Member]

Dear all,

i created in the Sales Order a new Userdefined field and called it ADDPrice.

and now i wonna totalize this field and the Unit Price field as new Line Total (Total LC).

ADDPrice + Unit Price + Quantitiy = Line Total

can anybody help me to create this query??

Thank you and best regards

Serkan

Edited by: Serkan Er on Nov 11, 2008 7:37 AM

[Former Member]

Dear all we find the solution for this :

SELECT CAST(REPLACE(REPLACE($[$38.14.0],'$',''),'EUR','') AS NUMERIC)

but what we now need is, it calculate the price with round down and round up

egg.: 2.20 + 2.00= 4.00

we need it in this form

egg.: 2.20 + 2.00= 4.20

thank you and best regards

[Former Member]

I had a similar problem, you need considerate the document's type that is in the invoice header (OINV), 'I' Item or 'S' Service, and the Discount percent DiscPrcnt in the header too.

WHEN T1.DiscPrcnt > 0 THEN T0.LineTotal - (T0.LineTotal * (T1.DiscPrcnt/100)) AS 'LineTotal'

if not T0.LineTotal

this is the net value.

Oscar

[former_member204969]

Try to use this FS:

Select $[$38.14.Number]*$[$38.11.Number]+$[$38.U_ADDPrice.Number]

[Former Member]

Hi ,

you write like this-

ADDPrice +(Unit Price*Quantitiy )=Line Total

or

if you want to sum of linetotal then -

sum(ADDPrice) +sum(Unit Price*Quantitiy )=Line Total