Sage Alerts & Workflow Write back into Sage

Question

Looking to have Sage Alerts and Workflow create a PO in Sage 100. It's my understanding that the Sage Alerts Workflow module has collection of API's that can update a database but Sage 100 Providex is difficult to write to and that Sage 100 does not have a REST web service API either. Has anyone used the alerts workflow module for a write back into Sage?

BigLouie · Accepted Answer

It would only be able to write back into the Premium version which is SQL but not a ProvideX version. Now the new version of Sage Alerts and Work Flow has been updated a lot so I would get the User Manual for the newer version and see what it says.

David Speck · Answer

You could have SAW export the data needed to create the PO to a delimited file and then trigger a VI import job, this would be the easiest to implement. 
 Next up would be having SAW execute a script file or SAW's scripting feature (think it uses some variant of Visual Basic) that contains the code to create the PO through sage 100's BOI. This will require knowledge of working with the BOI, you can search this forum for examples and search either this forum or the knowledge base for scripting.docx for a good starter doc. There should also be a course on SageU.

dhalpin · Answer

Thank you. Found out the request is for Sage 100 Premium so it sounds like that's an advantage. Appreciate the feedback.

Sage 100

Sage Alerts & Workflow Write back into Sage

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING