header record is missing

Question

Upon attempting to migrate StgSOLine table to the tsoSOLine table an error comes up saying: "Header record is missing". What exactly is contained in this header record?

LouDavis · Accepted Answer

If you look at the schema browser for Sage 500 you will find the information on the Sales Order records to include the Header, detail, and distribution records. 
 Also, you cannot go directly from stgSOLine to tsoSOLine. It doesn't contain all the information tsoSOLine needs (SurrogateKey for example) and you are skipping any validations on the data. stgSOLine is part of the Data Import Manager's Import Sales Order process. 
 If you are trying to import sales orders into Sage 500, I recommend you try using this first. If you are not licensed for it, you can still create a process using stored procedure spsoAPISalesOrderIns. Review this stored procedure and you will see how stgSOLine and the other staging tables are used to create sales orders in Sage 500. I would also recommend working with your reseller to assist in the proper design and the test plan for this process to avoid any possibility of data corruption in the system.

Sage 500

header record is missing

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING