OFBiz › OFBiz - User

opening balance upload

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

6 messages Options

Moatasim Al Masri

opening balance upload

Dears

This is Moatasim, I need to upload opening balances for company, is there any way to do that without heavy transactions entry?

Best Regards, Moatasim L. Al-Masri Program Manager

P.O.Box 3516 Amman, 11821 The Hashemite Kingdom of Jordan	Tel. +962 (6) 556 2620 Mob (Jordan). +962 79 5426384	/biict @biict
Kingdom of Saudi Arabia	Mob (KSA). +966 55 7885607

taher

Re: opening balance upload

Hi Moatasim,

I'm assuming you mean you don't want to do manual data entry. If this is
the case then perhaps one way to do it is to create a data entity xml file
with all the transactions that you want and then load it from the webtools
or through the command line

On Feb 15, 2017 3:29 PM, "Moatasim Al Masri" <[hidden email]> wrote:

> Dears
>
> This is Moatasim, I need to upload opening balances for company, is there
> any way to do that without heavy transactions entry?
>
>
>
> *Best Regards,*
>
>
>
> *Moatasim L. Al-Masri*
>
> Program Manager
>
>
>
> [image: Description: Logo for Office-4]
>
>
>
> [image: Description: bi email-3-02]
>
>
>
> P.O.Box 3516 Amman, 11821
>
> The Hashemite Kingdom of Jordan
>
> *Tel.* +962 (6) 556 2620
>
> *Mob (Jordan).* +962 79 5426384
>
> [image: Description: bi email-3-04]
>
> [image: Description: bi email-3-05]
>
> /biict
>
> @biict
>
> Kingdom of Saudi Arabia
>
> *Mob (KSA).* +966 55 7885607 <+966%2055%20788%205607>
>
>
>
>
>
>
>
>
>

Moatasim Al Masri

RE: opening balance upload

Thank you Taher
How can do it manual?

Best Regards,

Moatasim L. Al-Masri
Program Manager

P.O.Box 3516 Amman, 11821
The Hashemite Kingdom of Jordan
Tel.                     +962 (6) 556 2620
Mob (Jordan).   +962 79 5426384

/biict
@biict
Kingdom of Saudi Arabia
Mob (KSA).       +966 55 7885607

-----Original Message-----
From: Taher Alkhateeb [mailto:[hidden email]]
Sent: Wednesday, February 15, 2017 2:41 PM
To: [hidden email]
Subject: Re: opening balance upload

Hi Moatasim,

I'm assuming you mean you don't want to do manual data entry. If this is the case then perhaps one way to do it is to create a data entity xml file with all the transactions that you want and then load it from the webtools or through the command line

On Feb 15, 2017 3:29 PM, "Moatasim Al Masri" <[hidden email]> wrote:

> Dears
>
> This is Moatasim, I need to upload opening balances for company, is
> there any way to do that without heavy transactions entry?
>
>
>
> *Best Regards,*
>
>
>
> *Moatasim L. Al-Masri*
>
> Program Manager
>
>
>
> [image: Description: Logo for Office-4]
>
>
>
> [image: Description: bi email-3-02]
>
>
>
> P.O.Box 3516 Amman, 11821
>
> The Hashemite Kingdom of Jordan
>
> *Tel.* +962 (6) 556 2620
>
> *Mob (Jordan).* +962 79 5426384
>
> [image: Description: bi email-3-04]
>
> [image: Description: bi email-3-05]
>
> /biict
>
> @biict
>
> Kingdom of Saudi Arabia
>
> *Mob (KSA).* +966 55 7885607 <+966%2055%20788%205607>
>
>
>
>
>
>
>
>
>

taher

RE: opening balance upload

Well .. manual is just going to the accounting app and adding transactions
by hand. So perhaps your starting point is the below screen

https://ofbiz-vm2.apache.org:8443/accounting/control/FindAcctgTrans?organizationPartyId=Company

On Feb 15, 2017 3:46 PM, "Moatasim Al Masri" <[hidden email]> wrote:

> Thank you Taher
> How can do it manual?
>
> Best Regards,
>
> Moatasim L. Al-Masri
> Program Manager
>
>
>
>
>
>
> P.O.Box 3516 Amman, 11821
> The Hashemite Kingdom of Jordan
> Tel. +962 (6) 556 2620
> Mob (Jordan). +962 79 5426384
>
>
> /biict
> @biict
> Kingdom of Saudi Arabia
> Mob (KSA). +966 55 7885607
>
>
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: Taher Alkhateeb [mailto:[hidden email]]
> Sent: Wednesday, February 15, 2017 2:41 PM
> To: [hidden email]
> Subject: Re: opening balance upload
>
> Hi Moatasim,
>
> I'm assuming you mean you don't want to do manual data entry. If this is
> the case then perhaps one way to do it is to create a data entity xml file
> with all the transactions that you want and then load it from the webtools
> or through the command line
>
> On Feb 15, 2017 3:29 PM, "Moatasim Al Masri" <[hidden email]> wrote:
>
> > Dears
> >
> > This is Moatasim, I need to upload opening balances for company, is
> > there any way to do that without heavy transactions entry?
> >
> >
> >
> > *Best Regards,*
> >
> >
> >
> > *Moatasim L. Al-Masri*
> >
> > Program Manager
> >
> >
> >
> > [image: Description: Logo for Office-4]
> >
> >
> >
> > [image: Description: bi email-3-02]
> >
> >
> >
> > P.O.Box 3516 Amman, 11821
> >
> > The Hashemite Kingdom of Jordan
> >
> > *Tel.* +962 (6) 556 2620
> >
> > *Mob (Jordan).* +962 79 5426384
> >
> > [image: Description: bi email-3-04]
> >
> > [image: Description: bi email-3-05]
> >
> > /biict
> >
> > @biict
> >
> > Kingdom of Saudi Arabia
> >
> > *Mob (KSA).* +966 55 7885607 <+966%2055%20788%205607>
> >
> >
> >
> >
> >
> >
> >
> >
> >
>

Pierre Smits

Re: opening balance upload

In reply to this post by Moatasim Al Masri

Hi Moatasim,

You have several options available with respect to existing:

- convert into xml that can be uploaded through webtools/import
- convert into sql statements and upload into database
- enter manually via the functions in Accounting component

Each requires data preparation, and time to consume.

I have experienced that, with large datasets (in the case of e.g. migration
to new implementations and upgrades), using data conversion & migration
solutions helps.

Best regards,

Pierre Smits

ORRTIZ.COM <http://www.orrtiz.com>
OFBiz based solutions & services

OFBiz Extensions Marketplace
http://oem.ofbizci.net/oci-2/

On Wed, Feb 15, 2017 at 1:29 PM, Moatasim Al Masri <[hidden email]>
wrote:

Moatasim Al Masri

RE: opening balance upload

Hi Pierre
How can I entered manual option? And let ofbiz to know this transaction for opening balance?

Best Regards,

Moatasim L. Al-Masri
Program Manager

P.O.Box 3516 Amman, 11821
The Hashemite Kingdom of Jordan
Tel.                     +962 (6) 556 2620
Mob (Jordan).   +962 79 5426384

/biict
@biict
Kingdom of Saudi Arabia
Mob (KSA).       +966 55 7885607

-----Original Message-----
From: Pierre Smits [mailto:[hidden email]]
Sent: Thursday, February 16, 2017 10:53 AM
To: [hidden email]
Subject: Re: opening balance upload

Hi Moatasim,

You have several options available with respect to existing:

- convert into xml that can be uploaded through webtools/import
- convert into sql statements and upload into database
- enter manually via the functions in Accounting component

Each requires data preparation, and time to consume.

I have experienced that, with large datasets (in the case of e.g. migration to new implementations and upgrades), using data conversion & migration solutions helps.

Best regards,

Pierre Smits

ORRTIZ.COM <http://www.orrtiz.com>
OFBiz based solutions & services

OFBiz Extensions Marketplace
http://oem.ofbizci.net/oci-2/

On Wed, Feb 15, 2017 at 1:29 PM, Moatasim Al Masri <[hidden email]>
wrote: