Also have a look at the file : applications/accounting/src/main/groovy/org/apache/ofbiz/accounting/reports/TrialBalance.groovy
On Wed, Jul 30, 2025 at 2:42 AM Omar Abdullwahhab < omar.abdullwah...@gmail.com> wrote: > Hello James, > I traced the flow of running trial balance, and the computation of > balances is coming from a table that is called, > AcctgTransEntrySums --> which is the view that the trial balance > calculation depends on. > This view is defined in > ofbiz-framework/applications/datamodel/entitydef/accounting-entitymodel.xml > With its related tables (AcctgTransEntry, AcctgTrans, GlAccount). > > <member-entity entity-alias="ATE" entity-name="AcctgTransEntry"/> > <member-entity entity-alias="ACT" entity-name="AcctgTrans"/> > <member-entity entity-alias="GLA" entity-name="GlAccount"/> > ----- > And for you to get more information about the trial balance calculation. > in the accounting module, in the file > ofbiz-framework/applications/accounting/minilang/ledger/GeneralLedgerServices.xml > Look for a simple-method element with an attribute > method-name="computeGlAccountBalanceForTimePeriod" > > All the best. > > > On Tue, Jul 29, 2025 at 2:20 PM james productive1.com < > ja...@productive1.com> wrote: > >> Typically in uploading accounting opening balance to get history you >> would do monthly transaction summaries. Is there a step by step guide to >> this so when trial balance is run is balances the system its coming from. >> The issue we face is Ofbiz is a real time accounting system so any uploads >> affects running totals >> ------------------------------ >> *From:* Omar Abdullwahhab <omar.abdullwah...@gmail.com> >> *Sent:* Tuesday, July 29, 2025 2:33 AM >> *To:* james productive1.com <ja...@productive1.com> >> *Cc:* ofbizuser <user@ofbiz.apache.org> >> *Subject:* Re: Starting Ofbiz Accounting - Opening Balances >> >> Good morning James, >> In case this is the first time for you with ofbiz. >> please read this accounting tutorial ( by Sharan Foga ) >> >> https://cwiki.apache.org/confluence/download/attachments/67635031/Getting%20Started%20with%20Apache%20OFBiz%20Accounting%20Detailed%20Tutorial.pdf?api=v2 >> And regarding transferring accounts and inventory and opening balances >> -- there is an option in the webtools module from which you can upload >> your data as xml. >> The best way to upload data is to correctly understand the data model of >> ofbiz and map it to the data model of quickbooks. >> Thanks >> Omar. >> >> >> On Tue, Jul 29, 2025 at 4:24 AM james productive1.com < >> ja...@productive1.com> wrote: >> >> Good Afternoon. Is there any documentation on the steps to launch Ofbiz >> with financial history for a distribution company. The scenario is the >> ofbiz user is on Quickbooks and wants to go live August 1st 2025. They >> would like to bring over financial history for the calendar year 2025. >> What is the process to upload this data were the financial data in >> Quickbook and Ofbiz reflects the same numbes. >> >> Things to Consider >> Customer has inventory >> Customer has Open AR/AP >> Customer has Open Sales Orders and PO >> Customer has Sales Revenue Account >> >> What is the best way to upload data to start Ofbiz with the correct >> financials? >> >> Thanks, >> >> James >> >> >> >> -- >> Omar Abu-Arab >> Java Engineer >> >> > > -- > Omar Abu-Arab > Java Engineer > > -- Omar Abu-Arab Java Engineer
