GlAccountHistory & computeGlAccountBalanceForTimePeriod

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

GlAccountHistory & computeGlAccountBalanceForTimePeriod

DAVID HUGHES-OWENS
I am doing a bit of investigation around how GL account balances are stored in Ofbiz.

From what I can gather the GlAccountHistory entity stores the opening & closing balances along with a total of debits and credits.

This I presume is created by the computeGlAccountBalanceForTimePeriod service at the point the period is closed?

I can see that this is working when closing fiscal monthly periods, but I am unsure how closing the fiscal year effects the GL account balances. This is more difficult to view due to the dates involved.

My question really is around how to roll over the balance sheet GL account balances into the following fiscal year?

Is there logic built into the service that will roll over the balance sheet balances?

How does it recognise a gl account is balance sheet and not P&L, and to bring the balance forward?
Reply | Threaded
Open this post in threaded view
|

Re: GlAccountHistory & computeGlAccountBalanceForTimePeriod

Sharan-F
Hi David

Have you tried doing a test of a fiscal year closing just using the demo data to see what it brings through?
You can run the accounting reports before and after to get a view of what is being brought forward (or not).

Thanks
Sharan
Reply | Threaded
Open this post in threaded view
|

Re: GlAccountHistory & computeGlAccountBalanceForTimePeriod

DAVID HUGHES-OWENS
Thanks Sharan,

Is there a special process for closing a fiscal year or is it the same as closing any time period?

cheers
Reply | Threaded
Open this post in threaded view
|

Re: GlAccountHistory & computeGlAccountBalanceForTimePeriod

Pierre Smits
Hi David,

According to code in trunk there is only one service defined for closing
time periods in the accounting module called closeFinancialTimePeriod. This
service calls a same-named script in GeneralLedgerServices.xml.

Regards,

Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com


On Mon, May 12, 2014 at 10:12 AM, DAVID HUGHES-OWENS <
[hidden email]> wrote:

> Thanks Sharan,
>
> Is there a special process for closing a fiscal year or is it the same as
> closing any time period?
>
> cheers
>
>
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/GlAccountHistory-computeGlAccountBalanceForTimePeriod-tp4650938p4650954.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>