Hello Ben, Thnx...
I tried it as well... but my COGS went hell wire when at the beginning I created few Credit Notes for large quantities of items. I tried to delete invoices and credit notes and recreate service invoices for the deleted amounts but it never came right again. What I am doing is GL entries between inventories and consumables to drop stock levels to the sensible levels... otherwise stock is blowing up taxable profits :)... Even after company grows it never is going to be "buy and resell" set-up. I think combination "stock item" for main components and "service" option will work best for me :)... just entering new codes must be "procedure" controlled to avoid "wild west" entries :) -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Benjamin Brink Sent: 05 June 2013 03:48 PM To: [email protected] Subject: [SQL-Ledger] Re: Stock Control Jersey, Another option is to create a customer record consisting of your company name. Periodically have your company, as customer, purchase remaining stock in one invoice where everything is discounted 100%. This process has the advantage that if you every get really successful, where inventory becomes a significant tax or accounting issue, you don't have to re-setup your sql-ledger just when you're getting busy.. cheers, Ben On 06/05/2013 06:33 AM, J.M. "Jersey" Miszczyk wrote: > Hello Jean-Pierre > > Thank you very much... still a while before the exercise happens... > financial year ends in Feb14 J... but I am preparing . > > Best regards > > "Jersey" > > *From:*[email protected] > [mailto:[email protected]] *On Behalf Of *Jean > Pierre Guillou > *Sent:* 05 June 2013 03:11 PM > *To:* [email protected] > *Subject:* [SQL-Ledger] Re: Stock Control > > 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 <http://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.wise > stamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demai > l%26utm_campaign%3Dpromo_21>CLICK > HERE. > <http://r1.wisestamp.com/r/landing?promo=21&dest=http%3A%2F%2Fwww.wise > stamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demai > l%26utm_campaign%3Dpromo_21> > > > On 5 June 2013 13:17, J.M. "Jersey" Miszczyk <[email protected] > <mailto:[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]> > [mailto:[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] <mailto:[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] <mailto:[email protected]> > http://lists.ledger123.com/mailman/listinfo/sql-ledger > > > _______________________________________________ > SQL-Ledger mailing list > [email protected] <mailto:[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 ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2013.0.2904 / Virus Database: 3184/6378 - Release Date: 06/02/13 _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
