FMS

[Former Member]

Hi Expert,

I want to do FMS for Unit Price minus U_Aggred rate (UDF) multiply by Quantity in Purcahse Order.

I tried but its not work can u pls give me correct query.

Rgds

Sudhir.

[Former Member]

Hi sudhir,

Use the following query.

SELECT (((select $[POR1.Price.Number]) - (select $[POR1.U_Aggredrate.Number])) (select $[POR1. Quantity.Number]))*

Regards,

Datta Kharat

[Former Member]

HI,

Iam tried above query but its not working can any one help me out.

Sudhir.

[Former Member]

Try this:

Select $[$38.14.number] - $[POR1.U_Aggredrate.number] * $[$38.11.number]

[Former Member]

If your UDF is a header level one, the $\[$38.U_Aggredrate.number] refernce is not valid. You should use the $\[OPOR. U_Aggredrate.number] form.

[Former Member]

Hi,

Thanks for reply.

UDF ie.U_Agreedrate is on row level when i run query it gives me syntax error near minus -

Select $[38.14.number] - $[POR1.U_Aggredrate.number] * ([38.11.number])

Please help me to resolve above issue.

Sudhir.

Edited by: sudhir pawar on Jun 5, 2010 7:49 AM

[Former Member]

Sudhir, whenever you post any code please use code part in Toolbar. else its very difficult to identify the code.

[Former Member]

Hi Sudhir,

Your query has the right syntax. If there is error, check your UDF name and property.

Thanks,

Gordon

[Former Member]

Hi

U can alter this query as per ur field and try

Select ($[POR1.Price.number] - $[POR1.U_dty.number])* ($[POR1.Quantity.number])

Giri

[Former Member]

Hi GIri,

Thanks for reply,

I update query as per syntax u provided me.

Select ($[38.14.number] - $[38.U_Aggredrate.number]) * ([38.11.number])

But it gives me Internal error -1003 while excution in PO.

Please correct me if i done above query.

Sudhir

[Former Member]

Hi Sudhir,

First you need to select that field in which you want your output,Put your cursor there and press ShiftAltF2, and select your query there which has been provided in above post, query seems to be correct.

Also if you want to populate the field after entering data in field, you can define that also.

If you face any prob let me know the whole step which u doing.

Regards,

[Former Member]

Hi,

As per ur suggestions i done same but still the error comes "internal error 1003", may be above query field not correct .

Pls suggest me.

Sudhir.

[Former Member]

Sudhir,

Better way to take consult developer.

Regards,

MAHESH.