You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by "james productive1.com" <ja...@productive1.com> on 2025/07/29 01:24:13 UTC
Starting Ofbiz Accounting - Opening Balances
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
Re: Starting Ofbiz Accounting - Opening Balances
Posted by RICK FLEMING <ri...@gmail.com>.
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 <
jacques.le.roux@les7arts.com> 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 <
> james@productive1.com>
> > 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 <om...@gmail.com>
> >> *Sent:* Tuesday, July 29, 2025 7:46 PM
> >> *To:* james productive1.com <ja...@productive1.com>
> >> *Cc:* ofbizuser <us...@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.abdullwahhab@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 <
> >> james@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 <om...@gmail.com>
> >> *Sent:* Tuesday, July 29, 2025 2:33 AM
> >> *To:* james productive1.com <ja...@productive1.com>
> >> *Cc:* ofbizuser <us...@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 <
> >> james@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
> >>
> >>
>
Re: Starting Ofbiz Accounting - Opening Balances
Posted by Jacques Le Roux <ja...@les7arts.com>.
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 <ja...@productive1.com>
> 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 <om...@gmail.com>
>> *Sent:* Tuesday, July 29, 2025 7:46 PM
>> *To:* james productive1.com <ja...@productive1.com>
>> *Cc:* ofbizuser <us...@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.abdullwahhab@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 <
>> james@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 <om...@gmail.com>
>> *Sent:* Tuesday, July 29, 2025 2:33 AM
>> *To:* james productive1.com <ja...@productive1.com>
>> *Cc:* ofbizuser <us...@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 <
>> james@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
>>
>>
Re: Starting Ofbiz Accounting - Opening Balances
Posted by Omar Abdullwahhab <om...@gmail.com>.
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 <ja...@productive1.com>
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 <om...@gmail.com>
> *Sent:* Tuesday, July 29, 2025 7:46 PM
> *To:* james productive1.com <ja...@productive1.com>
> *Cc:* ofbizuser <us...@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.abdullwahhab@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 <
> james@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 <om...@gmail.com>
> *Sent:* Tuesday, July 29, 2025 2:33 AM
> *To:* james productive1.com <ja...@productive1.com>
> *Cc:* ofbizuser <us...@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 <
> james@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
>
>
Re: Starting Ofbiz Accounting - Opening Balances
Posted by "james productive1.com" <ja...@productive1.com>.
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 <om...@gmail.com>
Sent: Tuesday, July 29, 2025 7:46 PM
To: james productive1.com <ja...@productive1.com>
Cc: ofbizuser <us...@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 <om...@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>> 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 <om...@gmail.com>>
Sent: Tuesday, July 29, 2025 2:33 AM
To: james productive1.com<http://productive1.com> <ja...@productive1.com>>
Cc: ofbizuser <us...@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>> 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
Re: Starting Ofbiz Accounting - Opening Balances
Posted by Omar Abdullwahhab <om...@gmail.com>.
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.abdullwahhab@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 <
> james@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 <om...@gmail.com>
>> *Sent:* Tuesday, July 29, 2025 2:33 AM
>> *To:* james productive1.com <ja...@productive1.com>
>> *Cc:* ofbizuser <us...@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 <
>> james@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
Re: Starting Ofbiz Accounting - Opening Balances
Posted by Omar Abdullwahhab <om...@gmail.com>.
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 <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 <om...@gmail.com>
> *Sent:* Tuesday, July 29, 2025 2:33 AM
> *To:* james productive1.com <ja...@productive1.com>
> *Cc:* ofbizuser <us...@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 <
> james@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
Re: Starting Ofbiz Accounting - Opening Balances
Posted by "james productive1.com" <ja...@productive1.com>.
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 <om...@gmail.com>
Sent: Tuesday, July 29, 2025 2:33 AM
To: james productive1.com <ja...@productive1.com>
Cc: ofbizuser <us...@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>> 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
Re: Starting Ofbiz Accounting - Opening Balances
Posted by Omar Abdullwahhab <om...@gmail.com>.
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 <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