Skip to Content
avatar image
Former Member

Formatted search, more than one fields that trigger the formatted search

Hi all,

I have a formatted search that refresh my UDF to 0 whenever the "Document Total" change.

The reason behind it is to work with the stored procedures. Stored procedure will stop user adding Purchase Order, if they haven't save as draft. When user "saved as draft" the UDF will become 1, hence user can add the draft.

My formatted search is to make sure user to "save as draft" once they have changed the united price/quantity.

Now my situation is i want user to "saved as draft" again when the "department", "division" and "subject" have any changes.

because for the formatted search, i can only choose one field to trigger my formatted search. Is there any way to solve my problem?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 29, 2018 at 11:27 AM

    Hi James,

    You could use the query that you use to determine if a document was "saved as draft", directly in the stored procedure, instead of with a FMS first.

    In the stored procedure you can then write all other conditions as well, like department was changed, etc.



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Johan Hakkesteegt

      Hi Johan,

      U_PODraft is just a field created for this fms and store procedure. It is used to force user to save as draft being creating a PO. the data type is numeric.