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?
It looks like the stored procedure, spsoCreateShipLines, would work with inserting into the ship line tables
As I mentioned it is a much larger process than simply creating the lines and involves numerous stored procedures to ensure pertinent sections are updated as appropriate.. So if you need to create shipments, I would again recommend the API we created for this purpose. It mimics the Sage 500 process from pick list through shipment creation, and if you desire commit/posting of the shipment.
Not properly creating shipment records can have an adverse impact on your Sage 500 system and cause data corruption.
I see. If you could point me toward the documentation and code for this API that would be awesome. Maybe a link or something like that? Thanks for the timely responses
Contact Dom Dellomo at [email protected] and he can assist you with documentation and any questions you may have.
*Community Hub is the new name for Sage City