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?
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.