Adding a reference to external id for GL Accounts

[Jacopo Cappellato-4]

I have to implement the following "story": a chart of accounts, that is also maintained in an system that is external to OFBiz, is imported into OFBiz; the ids of the accounts in the two systems are different and we want to maintain a reference to the external ids in OFBiz.

I would propose the following change: add a new field to the GlAccount entity named "externalId" (to adopt the same pattern of the OrderHeader entity) and store in it the external id of the account.

What do you think?

Jacopo

[Jacques Le Roux]

Looks like the best because simple idea to me. I can't see why we would need more.

Jacques

From: "Jacopo Cappellato" <[hidden email]>

>I have to implement the following "story": a chart of accounts, that is also maintained in an system that is external to OFBiz, is
>imported into OFBiz; the ids of the accounts in the two systems are different and we want to maintain a reference to the external
>ids in OFBiz.
>
> I would propose the following change: add a new field to the GlAccount entity named "externalId" (to adopt the same pattern of the
> OrderHeader entity) and store in it the external id of the account.
>
> What do you think?
>
> Jacopo
>

[BJ Freeman]

I created an new entity for externalsytems, that I use for importing and
exporting. and created a relationship between it and the GL.
I did this because I wanted more information to do reconciliation in ofbiz.
my 2 cents.

=========================
BJ Freeman
http://bjfreeman.elance.com
Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93>
Specialtymarket.com <http://www.specialtymarket.com/>

Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man
Linkedin
<http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro>


Jacopo Cappellato sent the following on 4/26/2010 12:45 AM:
> I have to implement the following "story": a chart of accounts, that is also maintained in an system that is external to OFBiz, is imported into OFBiz; the ids of the accounts in the two systems are different and we want to maintain a reference to the external ids in OFBiz.
>
> I would propose the following change: add a new field to the GlAccount entity named "externalId" (to adopt the same pattern of the OrderHeader entity) and store in it the external id of the account.
>
> What do you think?
>
> Jacopo
>

[Ashish Vijaywargiya]

+1.

--
Ashish

On Mon, Apr 26, 2010 at 1:15 PM, Jacopo Cappellato
<[hidden email]> wrote:
> I have to implement the following "story": a chart of accounts, that is also maintained in an system that is external to OFBiz, is imported into OFBiz; the ids of the accounts in the two systems are different and we want to maintain a reference to the external ids in OFBiz.
>
> I would propose the following change: add a new field to the GlAccount entity named "externalId" (to adopt the same pattern of the OrderHeader entity) and store in it the external id of the account.
>
> What do you think?
>
> Jacopo