Thanks Paul! -------- Original Message -------- Subject: Re: Error Closing a Time Period From: Paul Foxworthy <[email protected]> Date: Sun, March 05, 2023 9:51 pm To: [email protected]
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 <[email protected]> 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, <[email protected]> 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: [email protected] > -- Coherent Software Australia Pty Ltd PO Box 2773 Cheltenham Vic 3192 Australia Phone: +61 3 9585 6788 Web: http://www.coherentsoftware.com.au/ Email: [email protected]
