How to automatically create Work Ticket in Production Management from Sales Order using BOI

SUGGESTED

I have built an order importer that automatically creates sales orders based off of an EDI file from our customers.  It works great.  We are currently upgrading Sage 100 to include Production Management Plus and I want to be able to add in the ability to automatically create a Work Ticket from a Sales Order.  I know in the Sage UI it is simply a checkbox but I can't seem to locate anything using BOI to accomplish that same thing.  Does anyone know how this can be done?

  • 0

    I'm not sure which checkbox you are referring to.  Which version are you upgrading to and are you using a third party enhancement like ScanForce or Scanco's PM Plus?  If using one of the third party enhancements, you may be able to reach out to them to see if it can be made to work with a sales order imported using VI.

  • 0 in reply to David Speck

    This is for Sage 100 Advanced 2021, with the Scanco Production Management Plus add-on.  There are settings in Sales Order Options to have Make to Order Procurement Types automatically create a Work Ticket.  When I manually key in a line item on a Sales Order and tab through to the end, it pops up a message box that says "Work Ticket ### created".  When I set all the same values on a line item when creating a Sales order through BOI, I cannot get it to automatically create the work ticket.  I have a feeling that integration was not built but was hoping since it was a setting inside of Sales Order Options that somebody might know how to do it if it was possible.

  • 0 in reply to justinp
    SUGGESTED

    I don't have the enhancement so I can't see if it is using additional fields in the detail or variables to track it.  It is possible that their logic is restricted to the Sales Order UI class. You can try creating a sales order through a VI import and see how that behaves.  You might want to check the SO_SalesOrderDetail table for additional third party fields that might be used control the behavior.  You could use DFDM or the VI Import to view the fields.