[SererraMike]

When creating an item fulfillment, I have a workflow that creates a custom record. Most of the fields I’m populating work well, but I’d like to populate the IF# as well. This is obviously a problem because the trans # isn’t assigned until after the IF is saved. Does anyone have a way around this?

Thanks,
This is a cached copy. Click here to see the original post.

[trimblee]

Have you tried changing the Trigger Type to After Submit?

[SererraMike]

Thanks Evan. I have. It seems even After Submit, still fires before there is a # assigned.

[mcelosa]

Did you set the Initiation to After Record Submit? What is the field type of the one you’re setting the value of the transaction number with? Did you select ‘Current Record’ under the ‘Selection’ on the Create Record action page? Kindly check these three as it could only be a misconfiguration.

[PatrickAlc]

This could be done without any scripting involve. If the custom record has field that is linked to the IF then the Transaction # can simply be source using the sourcing and filtering.

Best Practice: If you are creating a record B out of another record A you should always create record B after saving record A and should link them by a custom field.

[SererraMike]

Thanks for the information.Both the workflow itself & the action are set to “After Record Submit”.
The custom record has a Free Form Text field that I’m trying to populate with the transaction #. (I’ve tried to do this with a List/Transaction field as well, but prefer to use the text field).
To set the field I’ve tried setting “Value Field” = Transaction Number & “Formula” = {transactionnumber} in the Parameters area.
None of the methods I’ve tried have populated the field. Using the formula method I get the message: ERROR: Field ‘transactionnumber’ Not Found.

[mcelosa]

Thank you for those details SererraMike. To solve your issue, the formula that you should use is {tranid} instead of {transactionnumber}. The {transactionnumber} is a field similar to {tranid} but it is only supported for some other transaction types, Vendor Bill record for example.

The problem is that the {tranid} is not part of the current field metadata of SuiteFlow. Please submit a support case to raise this to the attention of our development team.

[Author]

Posts