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 <omar.abdullwah...@gmail.com> Sent: Tuesday, July 29, 2025 7:46 PM To: james productive1.com <ja...@productive1.com> Cc: ofbizuser <user@ofbiz.apache.org> 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 <omar.abdullwah...@gmail.com<mailto: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<http://productive1.com> <ja...@productive1.com<mailto: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<mailto:omar.abdullwah...@gmail.com>> Sent: Tuesday, July 29, 2025 2:33 AM To: james productive1.com<http://productive1.com> <ja...@productive1.com<mailto:ja...@productive1.com>> Cc: ofbizuser <user@ofbiz.apache.org<mailto: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<http://productive1.com> <ja...@productive1.com<mailto: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
