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.

  • +1 in reply to David Speck
    verified answer

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

  • 0 in reply to dhalpin

    DO NOT attempt to write back via SQL, you will bypass crucial logic only handled by the business objects. You MUST go through VI or the BOI.

Reply Children