Dynamics GP Copy Company Tool

After i have created a new Dynamics GP Company , i used The Copy Company Tool , which copies master files and setup tables from an old company to a new one as below. (It seems i just discovered something now while trying to capture a screen shot , As i can see it doesn’t detect 64 Bit ODBC i am running Windows 7 64 which i use for Dynamics GP, you should define normal ODBC) .

 

After running through the process everything went smoothly , I logged to Dynamics GP and Opened Inquiry –> Inventory –> Item. I found some quantities there . It seems it just copied the tables fields, So directly i run a Inventory reconcile but quantities are still there . weird isn’t it ?

Note : I only run reconcile on Inventory and it didn’t work, so you better try to reconcile the others first.

Any way , i created SQL scripts for resetting and below they are :

AR Reset Script	AP Reset Script
UPDATE [TWO].[dbo].[RM00103]    SET [CUSTBLNC] = 0       ,[AGPERAMT_1] = 0       ,[AGPERAMT_2] = 0       ,[AGPERAMT_3] = 0       ,[AGPERAMT_4] = 0       ,[AGPERAMT_5] = 0       ,[AGPERAMT_6] = 0       ,[AGPERAMT_7] = 0       ,[LPYMTAMT] = 0       ,[LSTTRXAM] = 0       ,[LSTFCHAM] = 0       ,[UPFCHYTD] = 0       ,[TDTKNYTD] = 0       ,[TDTKNLYR] = 0       ,[TDTKNLTD] = 0       ,[TDISAYTD] = 0       ,[RETAINAG] = 0       ,[TNSFCYTD] = 0       ,[UNPSTDSA] = 0       ,[UNPSTDCA] = 0       ,[UNPSTOSA] = 0       ,[UNPSTOCA] = 0       ,[NCSCHPMT] = 0       ,[TTLSLYTD] = 0       ,[TTLSLLTD] = 0       ,[TTLSLLYR] = 0       ,[TCOSTYTD] = 0       ,[TCOSTLTD] = 0       ,[TCOSTLYR] = 0       ,[TCSHRYTD] = 0       ,[TCSHRLTD] = 0       ,[TCSHRLYR] = 0       ,[TFNCHYTD] = 0       ,[TFNCHLTD] = 0       ,[TFNCHLYR] = 0       ,[FNCHCYTD] = 0       ,[FNCHLYRC] = 0       ,[TBDDTYTD] = 0       ,[TBDDTLYR] = 0       ,[TBDDTLTD] = 0       ,[TWVFCYTD] = 0       ,[TWVFCLTD] = 0       ,[TWVFCLYR] = 0       ,[TWROFYTD] = 0       ,[TWROFLTD] = 0       ,[TWROFLYR] = 0       ,[WROFSLIF] = 0       ,[WROFSLYR] = 0       ,[WROFSYTD] = 0       ,[HIBALLYR] = 0       ,[HIBALYTD] = 0       ,[HIBALLTD] = 0       ,[LSTSTAMT] = 0       ,[ONORDAMT] = 0       ,[TTLRTYTD] = 0       ,[TTLRTLTD] = 0       ,[TTLRTLYR] = 0	UPDATE [TWO].[dbo].[PM00201]    SET [HIESTBAL] = 0       ,[CURRBLNC] = 0       ,[NOINVYTD] = 0       ,[NOINVLIF] = 0       ,[NOINVLYR] = 0       ,[NOPINYTD] = 0       ,[NOPILIFE] = 0       ,[AMBLDTYD] = 0       ,[AMBLDLIF] = 0       ,[AMBLDLYR] = 0       ,[AMTPDYTD] = 0       ,[AMTPDLIF] = 0       ,[AMTPDLYR] = 0       ,[TEN99AYTD] = 0       ,[TEN99ALIF] = 0       ,[TEN99ALYR] =0       ,[DISAVYTD] = 0       ,[DISAVLIF] = 0       ,[DISAVLYR] = 0       ,[DISTKYTD] = 0       ,[DISTKNLF] = 0       ,[DISTKLYR] = 0       ,[DISLSYTD] = 0       ,[DISLSTLF] = 0       ,[DISLSLYR] = 0       ,[FINCHLIF] = 0       ,[FINCHLYR] = 0       ,[FINCHYTD] = 0       ,[WROFSYTD] = 0       ,[WROFSLIF] = 0       ,[WROFSLYR] = 0       ,[RTRNSYTD] = 0       ,[RTRNSLIF] = 0       ,[RTRNSLYR] = 0       ,[TRDTKLIF] = 0       ,[TRDTLYR] = 0       ,[TRDTYTD] = 0       ,[NFNCHLIF] = 0       ,[NFNCHLYR] = 0       ,[NFNCHYTD] = 0       ,[RTNGOWED] = 0       ,[LSTCHAMT] = 0       ,[LSTINVAM] = 0       ,[CURUNPBN] = 0       ,[UNPDFNCH] = 0       ,[DYCHTCLR] = 0       ,[AVGDTPYR] = 0       ,[AVDTPLIF] = 0       ,[ACCRDINV] = 0       ,[ONORDAMT] = 0       ,[WITHYTD] = 0       ,[WITHLYR] = 0
BR Reset Script	INV Reset Script
UPDATE [TWO].[dbo].[CM00100]    SET [Last_Reconciled_Balance] = 0       ,[CURRBLNC] = 0       ,[Reconcile_In_Progress] = 0       ,[Deposit_In_Progress] = 0       ,[ADPVADLR] = 0	Update     IV00102 Set       [QTYRQSTN] = 0       ,[QTYONORD] = 0       ,[QTYBKORD] = 0       ,[QTY_Drop_Shipped] = 0       ,[QTYINUSE] = 0       ,[QTYINSVC] = 0       ,[QTYRTRND] = 0       ,[QTYDMGED] = 0       ,[QTYONHND] = 0       ,[ATYALLOC] = 0       ,[QTYCOMTD] = 0       ,[QTYSOLD] = 0       ,[LSORDQTY] = 0       ,[LRCPTQTY] = 0

 

Hope that helps

Edit : Please refer to This, it is so important to read.