I have successfully inserted sales orders with their respective lines but now I need to create shipments for them. Which stored procedure is used to do this?
I don't believe Sage ever created a pending shipment API. If you need one we have one available at E2B Teknologies that we wrote.
Would it be as simple as inserting rows directly into the shipment and ship line tables?
Sorry to say but no. There is also the pick list portion to be concerned about, impacts on inventory, associated invoices, GL transactions, etc. You can see how complex the process is by doing a SQL Trace from Pick List Creation to Shipment Commit/Post processes. As you will see it is a lot more than simply creating records in tsoShipment and tsoShipLine.
And there are no stored procedures that would automatically insert rows into these respective linked tables for the shipments to be inserted?
And there are no stored procedures that would automatically insert rows into these respective linked tables for the shipments to be inserted?
*Community Hub is the new name for Sage City