Zero accounting in the midlle of the road

[masionas]

Hi Guys,

The preface: We have been using ofbiz for about a year now. It had orders, inventory etc. and hence has accounting postings etc.

I wonder if there is an easy and proved way to clean the ledger totally and lets start it over from the next order created or inventory received? Lets say we have found some bugs in postings before, thats why we can't rely on accuracy of current totals in ledger. But once we fix the code and want to start fresh accounting totals how do we do it?

Thank you for any ideas.

[masionas]

Hey,

It is hard to believe no one else has this type of challenge?

[Pierre Smits]

Hi Michael,

Cleaning the ledger (and all of the other datasets) in the database is
easily done with 'ant clean-data'. And subsequently load the seed data with
'ant run-install-seed'. But, make sure that you have backups of your
datasets.

With regards,

Pierre Smits

2012/1/9 masionas <[hidden email]>

> Hi Guys,
>
> The preface: We have been using ofbiz for about a year now. It had orders,
> inventory etc. and hence has accounting postings etc.
>
> I wonder if there is an easy and proved way to clean the ledger totally and
> lets start it over from the next order created or inventory received? Lets
> say we have found some bugs in postings before, thats why we can't rely on
> accuracy of current totals in ledger. But once we fix the code and want to
> start fresh accounting totals how do we do it?
>
> Thank you for any ideas.
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Zero-accounting-in-the-midlle-of-the-road-tp4278904p4278904.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Iyad Khaddam]

Some hints on accounting that may help:

You can create 2 accounting periods (custom time periods), during the same
time periods (from date and thru date are the same). Accounting
Transactions will be posted on both of them. If you clean one of those
periods, trans will keep being posted to the other.

Closing a time period will post totals to GlAccountHistory. You can set
ending balances there for the previous time period ( say TimePeriod 2011).
They will be needed in the current open time period (TimePeriod 2012).

Note: try these on a test server.

On Thu, Jan 26, 2012 at 11:28 PM, masionas <[hidden email]>wrote:

> Hey,
>
> It is hard to believe no one else has this type of challenge?
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Zero-accounting-in-the-midlle-of-the-road-tp4278904p4332047.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>



--
Thanks
IyadK

[prasath]

Hi,

 If you only want to clean the accounting trans data, just delete entries
in acctg_trans_entry,acctg_trans and gl_account_history.

Thanks
prasath


On Fri, Jan 27, 2012 at 1:39 PM, Iyad Khaddam <[hidden email]> wrote:

> Some hints on accounting that may help:
>
> You can create 2 accounting periods (custom time periods), during the same
> time periods (from date and thru date are the same). Accounting
> Transactions will be posted on both of them. If you clean one of those
> periods, trans will keep being posted to the other.
>
> Closing a time period will post totals to GlAccountHistory. You can set
> ending balances there for the previous time period ( say TimePeriod 2011).
> They will be needed in the current open time period (TimePeriod 2012).
>
> Note: try these on a test server.
>
> On Thu, Jan 26, 2012 at 11:28 PM, masionas <[hidden email]
> >wrote:
>
> > Hey,
> >
> > It is hard to believe no one else has this type of challenge?
> >
> > --
> > View this message in context:
> >
> http://ofbiz.135035.n4.nabble.com/Zero-accounting-in-the-midlle-of-the-road-tp4278904p4332047.html
> > Sent from the OFBiz - User mailing list archive at Nabble.com.
> >
>
>
>
> --
> Thanks
> IyadK
>