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