For years I’ve used the copy company setup tool to copy over setup files from one company to another. The tool makes copying over GL accounts, vendors, customers and basic company setup such as fiscal periods and payment terms easy and painless. Pre GP 2010 this was an automated solution. GP 2010 the copy company tool is actually a free component in the Professional Service Tools Library so the PSTL must be installed to use the copy tool with GP 2010.
In the process of copying over the Financials module the checkbook is also copied which is fine except the balance of the checkbook is also copied. This fact is usually figured out after the user has been entering transactions for a period of time and goes to do the first bank reconciliation.
To fix this issue I usually update the CM00100 table with a script like the following:
UPDATE CM00100 SET CURRBLNC = ‘XXXXX’ WHERE CHEKBKID = ‘YYYYYYY’
(Replace XXXXXX’s with the correct Current Balance and YYYYYYY ‘s with the correct Checkbook ID)
To figure out the balance I either figure out what the beginning balance was and subtract that from the current balance or use the current GL balance as a guide. The key would be to make the reconciled balance tie correctly to the GL.
The last reconciled date can also be deleted if that is not wanted either.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13