We have a client that will be sending us order and invoice data from another system to be imported into GP 10. When we receive the invoice data, the records will include multiple orders that need to be combined into a single invoice. Initially we looked at CRG Solutions' Merger Series but this appears to be a UI tool only integrated into SOP, and does not appear to include any SDK that we could use in our import packages.
We'd like to be able to import and process the incoming data via batch SSIS packages.
Are we going to be forced to manually code the SQL processing of these orders into a single invoice? What developer tools make the most sense here and are there any 3rd party tools that anyone knows of that would be beneficial in this scenario?
*This post is locked for comments