Attach Single Form to Multiple Epicor Records

This was something I did not find any documentation for, and I couldn’t find a specific discussion regarding multiple attachments solving this exact problem.

Our business issue: Migrating purchase requests from a physical form to use ECM Forms. Our initial case was a little too naive and the approach was for a single form attached to a single PO record. However, we make multiple POs depending on the purchase request, given multiple suppliers.

The solution? DataLink with multivalued return → Field Groups → DataLink Field Group.

  1. The user is prompted to input a comma separated list of POs.
  2. The value is tested to continue workflow
  3. Datalink is executed which splits the input string and returns the SysRowID from each PO value.
  4. Multivalued return is placed into a field group with the 1 field of POSysRowID (though it could be reusable for any process)
  5. DataLink Field Group “Attach File To ERP” with the field group selected and set to “From” and the SysRowID parameter set as the field in the field group.

image

image

Hope someone finds this helpful as I’m genuinely surprised this hasn’t come up before.

4 Likes

This is great - thanks for posting!

3 Likes