Creating shipments

What is the process of creating shipments in Sage through insertion into the sql database? I have inserted into the picklist table, the shipment/ship line table, and the batch table and shipments are still not showing up in the Sage 500 software. The shipments show up in both the shipment and ship line view tables. Is there something I am missing?

No Data
  • Shipping is a little more complex than inserting records into tables.  If you run a SQL trace while you go through each process (Create Pick, Confirm Pick, Generate Shipment, Commit Shipment, Post Shipment) you will see what I mean especially if you are dealing with lot items, serialized items, or BTO kits. 

    We've built a SQL API that mimics this functionality as well as the packaging aspects of it that uses staging tables and stored procedures in a similar manner that Sage 500 Date Migrator routines do.   

    If you want to learn more about this API contact Dom Dellomo at [email protected] for more info.