FMS to populate Warehouse as per line UDF selected.

[former_member268870]

Dear Experts,

I want to know if the following is possible: My client wants to have the Warehouse Code populate automatically on a Return when a line UDF return reason is marked as Damaged.

As I understand this selection of the UDF is not stored somewhere until the document is added and therefore the FMS will not work. Is this correct?

Any suggestions would be welcome.

Regards,

Marli

[kothandaraman_nagarajan · Accepted solution]

Hi,

Yes possible.

For example, select Whscode from OITW where $[RDR1.U_Reason] = 'Damaged'

Regards,

Nagarajan

[former_member268870]

Thank you Johan and Nagarajan,

These explanations were very helpful!

[Johan_H]

Hi Marli,

While a document is not added yet, all the information entered in the form, is saved temporarily. The parameter syntax that Nagarajan has used (the bolded part) accesses this temporary data.

The FMS will not work until information is entered into the trigger field, and obviously any fields that are used in the query must also be filled in, before the FMS can return a value. Also when using the Copy to or Copy from functionality, if the trigger field is filled in from the source document that way, the FMS will not be triggered.

Currently a limitation of the FMS is that you can only determine a single trigger field. That means that if your FMS query is dependent on two different fields that the user is supposed to fill in, the FMS can only be triggered by one of these two fields.

Regards,

Johan