Ouch! 1) Opening a new year *and database* is not as simple as one might think. 2) This task is therefore best done with a bookkeeper at hand, if possible a DB adminisrator might come in handy as well. 3) Cut of report can be easier done by limiting the parameters when requesting a report. Simply put the date range from - till and run the report. 4) Unless youre DB is getting awfully big and slow, why bother? Close periods OK (enforce reversal rules) but that is possible.
The year end process as in SQL-Ledger makes it not necessary to clean out transactions or do all kind of special year-end transactions. That is part of the beauty of it imho. Use Jan 1 iup to Dec 30 for all years work, close books per Dec 31. Do that every year, and you can compare years, even 5 years back if you want, without hassle. You do not get that in Quicken! If you r*eally *want to change to a new DB anyway, make sure you enter any available stock via INVOICE, call the supplier OPENING BALANCE. That way you will art least get the COGS right. Enter outstanding AR or AP invoices, get the details in so you can tack of later receipts or payments.. And the same for any other values on the remainig balance sheet, use Journal Entry seems most logical solution. Finally do not forget to "park" the result of the year's period so far somewhere for good measure. So you can later see what money was made when and where, either in db old or db new. Normally (since all accounts should be reconciled anyway) this sort of operation is done per a year-end moment. Hth, Paul 2010/9/4 Lewi Kristianto <[email protected]> > dear lists, > > I have created a new database with sql-ledger 2.8.30 to newly database, > I have dump plain database, and copy data for inserting data for table > contact, customer, vendor, parts > from old database to new empty database, > the reason behind this is I want to cut off my report to new month Sept > 2010 > > but now I can't display the report from AR-Report-Transactions, Outstanding > and all report after its > but I can still see the report from POS-Receipts, > > the AR transaction itself can see only in chart of accounts, and I click > for sub detail of Account Receivable Account > in there show the ar transaction that I already input, but not in > AR-Reports-Transaction > > I think this is related with import data procedure that I doing wrong way? > > please help, > I'm still understanding this table structure of sql-ledger > > > regards, > > > > -- > Lewi S. Kristianto (ichtus) > > > _______________________________________________ > 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
