formatted search for distribution rule

[Former Member]

i have created one UDF as asses-sable value in OOCR table . While calculating distribution rule, i am giving manual distribution rule, in that amount

should be calculated based on asses-sable value not on base value

[kothandaraman_nagarajan]

Hi,

Try this:

Select ($[OOCR.U_assessablevalue] * 12.36)/100

Thanks & Regards,

Nagarajan

[Former Member]

The issue is not get resolved .But thanks for all your replies

Thanks&Regards:

mohan

[kothandaraman_nagarajan]

Hi,

Have you checked above query? any error message? Tested in 8.81 version, getting result.

Thanks & Regards,

Nagarajan

[Former Member]

Hello Mohan,

Use the form values instead of the database values. The database-values are only available when you did commit the data to the database. So old value should be taken.

Take following query & try..

Select ($[OOCR.U_assessablevalue] * 12.36)/100

And here Center Code should not be blank. When you try to make FMS work.

Regards

Rakesh

[kothandaraman_nagarajan]

Hi,

Try this :

Select $[-OOCR.u_assesablevalue] *0.1236

Thanks & Regards,

Nagarajan

[Former Member]

hi all

i tried all your queries but not working.

thanks& Regards:

mohan

[Former Member]

Try this query first $[OOCR.u_assesablevalue]. If it returns a value, then add your formula.

Select $[OOCR.u_assesablevalue] * (12.36/100)

if not, then I think it's not workable.

[Former Member]

Have you entered anything in the Center Code? This can't be empty when you try to make FMS work.

[Former Member]

Have you tried this?

Select $[-OOCR.u_assesablevalue.number] *0.1236

[Former Member]

no  not working

[former_member192773]

Hello Mohan,

Use: Select $[$-Formtype.u_assesablevalue.number] *0.1236

Replace FormType by the Formtype of the form. Find this in your down-left-corner after activate System-information (View-System Information).

Notice the "-" before the formtype because you would like to get the data from a UDF-Form.

Regards Teun

[former_member192773]

Hello Mohan,

Please post your Formatted Search.
I think you should add a "-" before the formtype because the UDF-tab/screen had the same formtype as the main form but only negative.

HTH.

Regards Teun

[Former Member]

Select $[OOCR.u_assesablevalue] *12.36/100 this is my formated search query

[Former Member]

Hi,

Create One more UDF and assign the FMS (as below mentioned) on that field. Tell the user to copy and paste the amount on the field. I think we cant assign FMSon OCR1 Rows.

SELECT $[OMDR.U_assesablevalue]*12.36/100

[former_member192773]

Hello Mohan,

Use the formvalues instead of the database values. The database-values are only available when you did commit the data to the database.

Regards Teun

[Former Member]

Hi,

Try:

Select $[OOCR.u_assesablevalue.number] *0.1236

Thanks,

Gordon