Wednesday, September 30, 2015

GP Contract Administration - Importing Contracts and Contract Lines

We just completed our third project doing a data migration (or integration) to the GP Field Service Contract Admin module.  Unfortunately, Microsoft Dynamics GP never released an eConnect adaptor for the Contract Admin module.  But, doing direct SQL inserts into the master tables for contracts was easier than it would normally be.

Microsoft added SQL Triggers to the SVC00600 (contract header) and SVC00601 (contract lines) tables that automatically fill in default values, calculate billing periods, revenue recognition, and a lot of other stuff.

If you need help integrating to this module, email me and we can set up a time to discuss.

No comments:

Post a Comment