Monday, September 27, 2010

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) .

 image

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.

No comments:

Post a Comment