We faced a problem in Sales Order workflow where the signed flag becomes BLANK when header condition not met.

SOLVED

Hi experts,

We faced a problem in Sales Order workflow where the signed flag becomes BLANK when header condition not met.

When creating a new sales order in LIVE folder, it doesn't trigger the workflow because the "header condition was not met", and the APPFLG flag changed automatically from 1 (No) to 0 (blank), where it should be "5" (Yes, Automatic Signed).

I duplicated the folder from LIVE to TEST folder (using Data Extraction and Data integration function), so all basis setup information is the same (i.e. workflow rules, parameters, server environment, assignment value, sales order information).

When creating new sales order in TEST, though the header condition is not met, the APPFLG changed from 1 to 5(Yes, automatic). This is working fine.

Here is the conditions for our workflow rule

I activated the debug mode for both folder. 

Below is the Debug log in LIVE folder.

Notice that when creating new sales order , the default value for APPFLG is 1, but upon clicking "Create" it seems to have changed the APPFLG to 0 therefore it passed through the 3rd condition in the workflow rules. 

the following is the debug log for TEST folder. The APPFLG was not changed. 

I have checked the specifics of SOH, it does not have codes relevant to APPFLG assignment.

Anyway I duplicated the complete folder using Data integration, i presume any specifics should also be copied to the TEST folder.

This happens in X3 PU9 patch 3 (both folder has same patch).

I checked also the TRT in both folders. some files are different.
I tried to copy some related different files to TEST Folder but

Any idea how to proceed troubleshooting / fixing this?

Your valuable feedback is greatly appreciated. Thank you very much in advance. 

  • 0
    SUGGESTED

    Hi,

    Check out the blog Troubleshooting tools of the Trade. There are a couple of tools such as the Object Difference Analyzer that may be helpful in troubleshooting.

  • +1
    verified answer

    I saw that you created a specific field YPRIOD and put in Header Condition, when you did this you blocked all workflow, incluiding the control of APPFLG Field, and that way this field is changed to blank.

    I suggest that you make same changes in your workflow.

    1- Check the parameter value "APPSOH", and select "Yes Optional", because with this option "if no condition was selected in Assignment rule" (You must logoff os X3 to this change is is validated) the sales roder will be "Yes Automatic"

    2- Inside Assignment rule in the table, insert a new line with this YPRIORD

    3- Click in "Values" button insert the value that "1" in all condition lines

    This way, when the X3 don't find no condition, your sales order will be "Yes Automatic" in APPFLG filed.

    If you want, send me a email if you need more help with this workflow

    [email protected]

  • 0 in reply to Bruno Silva
    SUGGESTED

    Hi Bruno,

        Thanks for your answer, it works! After modifying the parameter and the setting in Assignment value, the APPFLG now will set to "Yes Automatic" when header condition not met.

        Now, the problem is that the customized field YPRIMOD is not changing accordingly due to the specifics, but it is another problem, we will escalate to our technical. Thanks again for your kind assistance.    

  • 0 in reply to pnightingale

    Hi pnightingale,

        Thanks for the troubleshooting guide. I came across it once but couldn't locate it later. It is a good blog with useful tip on troubleshooting, will definitely need it. Thanks!