Microsoft Great Plains, former Great Plains Software Dynamics/eEnterprise should be considered as ERP platform for midsize and large business, so SQL data maintenance and repair is normal IT procedure, this is why table structure and MRP architecture should be familiar to SQL DB administrator. We will begin with architecture and table name coding and then go down to typical data repair
Select * into IV00101_Backup from IV00101
Then do you data repair. If you need to roll back to old backed up version of the table, do this:
Some additional hints. Microsoft Great Plains is Dexterity application. Dex internal logic adds autoid column DEX_ROW_ID, so you have to drop it prior to restoring the table from backup
Dexterity Customization for Dynamics GP Evaluation Level Paper
When you are developer it is always a good idea to read technical manuals. But if you was just assigned to the IT team to decide if Dexterity is the right tool to customize your ERP application then first you need something which is in style of ‘easy reading papers’ or FAQPlanning Dynamics GP Customization in Large Corporation
If you are reading this page then chances are high that you were not able to find ISV add-on and need customization project. Let’s talk about planning, quality assurance and future event such as version updates.Dynamics GP Invoice Logo Attributed to Specific Company or Crossing the Borders of Three SOP Forms
Initial Great Plains Dynamics architecture had three SOP Invoice forms: Long, Short and Blank. Modern GP is popular in scenarios where you have more than three companies under one business entity umbrella