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 <[email protected]> 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 <[email protected]> > *Sent:* Tuesday, July 29, 2025 2:33 AM > *To:* james productive1.com <[email protected]> > *Cc:* ofbizuser <[email protected]> > *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 < > [email protected]> 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
