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
