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
3 Answers
-
Best AnswerJan 18, 2017 at 01:08 AM
Hi,
Yes possible.
For example, select Whscode from OITW where $[RDR1.U_Reason] = 'Damaged'
Regards,
Nagarajan
Add comment
-
Jan 18, 2017 at 07:00 AM
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
Add comment
-
Jan 18, 2017 at 03:42 PM
Thank you Johan and Nagarajan,
These explanations were very helpful!
Add comment
Add comment