Formula in field

[Former Member]

Hi, if I want to add formula in field, what operators should I use such as +-*/?

For example, fieldA in row of AR invoice plus fieldB in row of AR invoice mulitply by 20%.

Thanks.

Raymond.

[Nussi · Accepted solution]

Hi Raymond,

do you mean a userdefined query ?

regards

David

[Former Member · Accepted solution]

Yes, do you know how?

I tried many times but always syntax error!

Thanks.

Raymond

[Nussi · Accepted solution]

i created in Purchase Order the

Test1, Test2 and Test3 as Price field in the HEADER:

i assigned it on Test3

SELECT $[OPOR.U_TEST2.Number] + $[OPOR.U_TEST1.Number] * 0.5

this query works perfect

regards

David

[Former Member · Accepted solution]

Thanks.

I did the same as you as advised by another experts in this forum. However, there were syntax error.

I was trying to setup formula in fields as follows:

U_Test & U_Test are numeric fields.

SELECT ($[INV1.U_Test.Number]-$[INV1.U_Test3.Number])*0.1

The outcome should be (U_Test-U_Test3)*0.1

U_Test2 & U_Test5 are alphnumeric fields.

SELECT $[INV1.U_Test2]+$[INV1.U_Test5])

The outcome should be U_Test2U_Test5

I have been struggling in the syntax error. Can you help me out?

Thanks.

Raymond

[Nussi · Accepted solution]

Hi Raymond,

i don't know whats wrong.

i tried this query in purchase order line and it works without error

SELECT ($[POR1.U_TEST2.Number] + $[POR1.U_TEST1.Number]) * 0.5

all 3 fields are of Type Price

regards

David

[Former Member · Accepted solution]

Hello Raymond,

Are those UDFs in the Header or in the Rows of the invoice? They must be in the Rows, as you are using the INV1 table.

Best Regards,

Vítor Vieira

[Former Member · Accepted solution]

Hi, the formula is in the row level.

Do you know where can I get a Error Message list that show the type of error the system prompted out?

Thanks.

Raymond

[Former Member · Accepted solution]

David, would you have time to try it in AR Invoice?

Even a simple query like $[Inv1.U_Test]*0.1 has syntax error. I believe that when it goes to document level and involves operator, there is something I omitted.

Thanks.

Raymond

[Former Member · Accepted solution]

It is suddenly work. Thank you all.