l...@camptocamp wrote: > > Hello Gerry, it is a pity that you have not been in Belgium last week, I > really look forward to make your knowledge :-) > > I just have a look to your post and blueprint. It is quite similar what > I suggested last week.
Luc, it doesn't really appear too similar. Please look at this Sept/Oct thread starting here: http://openerp.com/forum/post24923.html#24923 In the thread I evolve my solution and how the addition of opening and closing periods, data purge process, and modified closing processes all work to create a very flexible system that does not require copying balances during the closings; enabling you to pull financial statements for any length of time; recreate previous financial statements; pay invoices for past closed periods and more. To understand the solution you must take time to understand all the figures of the periods that illustrate the different period scenarios. > 1. create opening/ending period (and specific journal if need, but > optional) => if we have a FY with month we will have 14 periods => the > opening and ending period will be specify into the fiscal year Yes, it will be at least N+2 periods where N = number of periods in fiscal year, and assuming only 1 opening and 1 or more closing periods. > 2. transfert profit or lost from P&L to Balance sheet (sum of all "none" > closing type accounts) => that meen the debit and the credit of the > balance sheet is now balanced Yes, this is critical so that you can track P&L within each period and at the period end you transfer the P&L totals to an income summary account on the balance sheet (this must be an equity account btw). This way you can see MTD and YTD P&L progress when you pull reports. The rest is different. > 3. for "balance" account => transfert of the balanced amount to the new > fiscal year (opening period) > > 4. for "unreconciled" accounts => COPY all entries that are not > reconcile at the 31.12 of the current year into the new FY (based on > the reconciliation => if the entry is reconciled with one or more > entries that the date is > than the last date of the current FY) => that > mean you can make the closing when you want (which is not the case now...) > > 5. for "detail" accounts => copy all entries to the new FY > > 6. reconcile all entries created into the opening period => these > entries will now not be visible into bank statement or payment or other > because they are already reconciles => the invoices statut will not be > change because the original entry will not be reconcile > > 7. close all "old" period and FY and also the opening period of the new > fiscal year (to permit to re-open the FY if needed => normally not > allowed, but....) > > > > Comment > - I am not sure it is relevant to add a period type (normal, opening, > adjusting) because we will create 2 fields into the FY (wich is quite > the case now with the v5.0) > - I don't understant what you mean with "Data Purge" > - FYI, camptocamp will publish I hope tomorrow or beginning next week a > "c2c_close_year" module which will implement this for the 4.2 version => > it will now be possible to close at any time you would like. Regards, Gerry -------------------- m2f -------------------- -- http://www.openerp.com/forum/viewtopic.php?p=28571#28571 -------------------- m2f -------------------- _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman/listinfo/tinyerp-users
