Hello James , I recommend you to visit the contributors page in apache ofbiz website. Also I can help you in developing your requirements. All the best.
Omar Abu-Arab Java Engineer On Wed, Sep 17, 2025, 10:03 PM james productive1.com <[email protected]> wrote: > We are looking for someone to design a simple web portal for taking 12-24 > monthly trial balances and simply upload into Ofbiz correctly so Financials > are accurate when starting on Ofbiz. Please let me know if you know of > anyone and I can go into more detail > > Sincerely, > > James > ------------------------------ > *From:* Omar Abdullwahhab <[email protected]> > *Sent:* Tuesday, July 29, 2025 7:46 PM > *To:* james productive1.com <[email protected]> > *Cc:* ofbizuser <[email protected]> > *Subject:* Re: Starting Ofbiz Accounting - Opening Balances > > 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 < > [email protected]> 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 < > [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 > > > > -- > Omar Abu-Arab > Java Engineer > >
