You might look into third party quickbooks interface programs that will upload a csv file into quickbooks. I used one a few years ago... It was easier than using the native ofbiz accounting package. The one I used allowed for mapping acct numbers from ofbiz to quickbooks. -Rick
On Thu, Sep 18, 2025 at 9:23 AM Jacques Le Roux < [email protected]> wrote: > Hi, > > Though not up to date, this page can be useful : > https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Service+Providers > > HTH > > Jacques > > Le 17/09/2025 à 23:25, Omar Abdullwahhab a écrit : > > 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 > >> > >> >
