Jersey Simplist would be to export balances as CSV and use the import scripts to import into a new dataset - You need to however take care so that you don't double count.
All imports to be done on last day of previous period (eg closing balances) : Import AR & AP balances first (using suspense codes) to update GL Post journal in GL to cancel suspense accounts so that TB is empty Import closing GL balances as journal If you want to start with a proper bank recon, for your cash balances, input several transactions in your TB - one for the closing bank balance and one for each of your non-reconciled items. This way, your old un-cleared items will appear on your first bank recon. Hope this helps. Regards Jean-Pierre _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Jean-Pierre Guillou CEO *DCDM Management Services Ltd* Tel PABX : (230) 202 3000 Tel Direct : (230) 202 3057 Fax : (230) 208 0086 Web :www.dcdm-ms.com Business Registration Number : C07051938 ******************************************************************** Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivering the message to the intended recipient), you should not read it, nor copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply E-mail. Opinions, conclusions and other information in this message that do not relate to the official business of any member firm of the DCDM Organisation shall be understood as neither given nor endorsed by the firm. Please consider the environment before printing this e-mail! Want a signature like mine? <http://r1.wisestamp.com/r/landing?promo=21&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_21> CLICK HERE.<http://r1.wisestamp.com/r/landing?promo=21&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_21> On 5 June 2013 13:17, J.M. "Jersey" Miszczyk <[email protected]> wrote: > Thnx J...**** > > ** ** > > Some of them I did that way already, “booked” against appropriate > accounts. I was checking if there is a different way.**** > > ** ** > > The other question... Say I close books now. How could I populate a new > accounting set with take on balances? Is there a way? Or I have to start > with a clean slate?**** > > ** ** > > Best regards**** > > “Jersey”**** > > ** ** > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Chris Travers > *Sent:* 05 June 2013 10:54 AM > *To:* SQL-Ledger Users > *Subject:* [SQL-Ledger] Re: Stock Control**** > > ** ** > > ** ** > > ** ** > > On Wed, Jun 5, 2013 at 1:26 AM, J.M. "Jersey" Miszczyk <[email protected]> > wrote:**** > > Hello Guys,**** > > **** > > A morning quickie... might already be addressed before:**** > > **** > > Is it possible to run SQL Ledger with stock codes for products but without > stock control? COGS drives me bananas and every 3 months I am running stock > adjustment via GL writing excessive stock against various consumables > accounts.**** > > ** ** > > Sure. Just create everything as a service.**** > > ** ** > > Best Wishes,**** > > CHris Travers **** > > **** > > **** > > **** > > **** > > **** > > **** > > **** > > **** > > **** > > **** > > **** > > **** > > **** > > **** > > **** > > **** > > **** > > **** > > **** > > > _______________________________________________ > SQL-Ledger mailing list > [email protected] > http://lists.ledger123.com/mailman/listinfo/sql-ledger**** > > ** ** > > _______________________________________________ > SQL-Ledger mailing list > [email protected] > http://lists.ledger123.com/mailman/listinfo/sql-ledger > >
_______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
