You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by ja...@productive1.com on 2023/02/20 20:38:57 UTC
Error Closing a Time Period
We are trying to close a time period and we are getting the following
error:
"could not commit transaction for service [closeAlltimePeriods] call
Roll Back error could not commit transaction, was rolled back instead
because of Error in Service [resetOrgGLAccountBalances] Cannot reset GL
Account balances: resulting trial balance are not equal"
Here is my question. 1. What exactly does closing a period do? 2. How
can I see the transaction so we can fix?
Thanks,
James
Re: Error Closing a Time Period
Posted by Paul Foxworthy <pa...@cohsoft.com.au.INVALID>.
Hi again James,
I have found resetOrgGLAccountBalances in the OpenTAPS codebase in GitHub:
https://github.com/opentaps/opentaps-1/blob/49f3ebcd3645b7e76fe3d71f43904ce65d7901b8/opentaps/financials/servicedef/services_ledger_ext.xml#L296
So the OpenTAPS community could probably help you more than OFBiz. If you
use the link above you will see the class where the service is implemented,
and I presume the web tools in OpenTAPS will also tell you.
Hope that helps.
Paul Foxworthy
On Mon, 6 Mar 2023 at 15:34, Paul Foxworthy <pa...@cohsoft.com.au> wrote:
> Hi James,
>
> You can use the web tools to see all services and how they have been
> implemented. On the trunk demo site,
> https://demo-trunk.ofbiz.apache.org/webtools/control/ServiceList .
>
> Neither closeAllTimePeriods nor resetOrgGLAccountBalances are listed in
> services in the trunk, and those services are not in the stable demo of
> version 18.12 either. Could they be customisations in your OFBiz?
>
> Closing a period is saying that you have reviewed the accounts and no more
> transactions will be added. For a large organization, closing a period is
> an important part of financial controls and reporting. Once a person in a
> CFO or similar role has closed the books, people can't make additional
> changes to the accounts for those periods.
>
> Apart from using webtools to find the implementation of those services, my
> general advice is - grep is your friend. Search your code base for those
> service names and the error message. From the error messages, I gather
> there is a closeAllTimePeriods service that closes for multiple time
> periods. There *is* a service closeFinancialTimePeriod, so I wonder if
> closeAllTimePeriods is calling that service repeatedly for different time
> periods. So you could add additional logging to work out which period is
> failing, and then run a trial balance report to try and identify why the
> trial balance doesn't total zero as it should.
>
> Hope that helps.
>
> Paul Foxworthy
>
> On Tue, 21 Feb 2023 at 07:39, <ja...@productive1.com> wrote:
>
>> We are trying to close a time period and we are getting the following
>> error:
>> "could not commit transaction for service [closeAlltimePeriods] call
>> Roll Back error could not commit transaction, was rolled back instead
>> because of Error in Service [resetOrgGLAccountBalances] Cannot reset GL
>> Account balances: resulting trial balance are not equal"
>>
>> Here is my question. 1. What exactly does closing a period do? 2. How
>> can I see the transaction so we can fix?
>>
>> Thanks,
>>
>> James
>>
>>
>>
>
> --
> Coherent Software Australia Pty Ltd
> PO Box 2773
> Cheltenham Vic 3192
> Australia
>
> Phone: +61 3 9585 6788
> Web: http://www.coherentsoftware.com.au/
> Email: info@coherentsoftware.com.au
>
--
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192
Australia
Phone: +61 3 9585 6788
Web: http://www.coherentsoftware.com.au/
Email: info@coherentsoftware.com.au
Re: Error Closing a Time Period
Posted by Paul Foxworthy <pa...@cohsoft.com.au.INVALID>.
Hi James,
You can use the web tools to see all services and how they have been
implemented. On the trunk demo site,
https://demo-trunk.ofbiz.apache.org/webtools/control/ServiceList .
Neither closeAllTimePeriods nor resetOrgGLAccountBalances are listed in
services in the trunk, and those services are not in the stable demo of
version 18.12 either. Could they be customisations in your OFBiz?
Closing a period is saying that you have reviewed the accounts and no more
transactions will be added. For a large organization, closing a period is
an important part of financial controls and reporting. Once a person in a
CFO or similar role has closed the books, people can't make additional
changes to the accounts for those periods.
Apart from using webtools to find the implementation of those services, my
general advice is - grep is your friend. Search your code base for those
service names and the error message. From the error messages, I gather
there is a closeAllTimePeriods service that closes for multiple time
periods. There *is* a service closeFinancialTimePeriod, so I wonder if
closeAllTimePeriods is calling that service repeatedly for different time
periods. So you could add additional logging to work out which period is
failing, and then run a trial balance report to try and identify why the
trial balance doesn't total zero as it should.
Hope that helps.
Paul Foxworthy
On Tue, 21 Feb 2023 at 07:39, <ja...@productive1.com> wrote:
> We are trying to close a time period and we are getting the following
> error:
> "could not commit transaction for service [closeAlltimePeriods] call
> Roll Back error could not commit transaction, was rolled back instead
> because of Error in Service [resetOrgGLAccountBalances] Cannot reset GL
> Account balances: resulting trial balance are not equal"
>
> Here is my question. 1. What exactly does closing a period do? 2. How
> can I see the transaction so we can fix?
>
> Thanks,
>
> James
>
>
>
--
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192
Australia
Phone: +61 3 9585 6788
Web: http://www.coherentsoftware.com.au/
Email: info@coherentsoftware.com.au