The current MAS 500 Sales Order API that is used by a few processes such as Data Migrator is specifically written to validate and create one sales order at a time. For small groups of sales orders to be imported into the system, this does not not cause any issues with performance though it may take some time to do. However, if importing a large number of sales orders, performance does suffer based on the design of the current API and how it validates and processes data.
A new Sales Order API should be created that can handle either small or large amounts of sales order records to be inserted into MAS 500 without degrading performance or taking a large amount of time to do so. Data Migrator routines such as AR Invoices and AP vouchers have been written specifically in such a way, so a model does exists that can be applied to importing sales orders as well.
by: Louis D. | over a year ago | 5 - Integration
Comments
We purchased the Sage Sales Order Import API from the Professional Services Group when we bought MAS500 6_2. This allows us to import hundreds of Sales Orders at a time. We imported over 7000 in the last 3 days. Much to our disappointment, when Sage released the Data Migrator with 7_2 they dropped support for the SO API, even though we had paid maintenance on it. We are still using the SO API with 7_3. Sage needs to either revive and update the API or replace it. It was never something that you could use out of the box. I wonder where my maintenance dollars went?