Sage Alerts & Workflow Write back into Sage

SOLVED

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?

Parents
  • +1
    verified 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.

Reply
  • +1
    verified 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.

Children