InvoiceItemTypeGlAccount, Should we add a field for offsetting glAccountId

[Anil Patel]

Hi,
I am working on some accounting code porting from my closed source
application based on Ofbiz to current Ofbiz trunk. We saved GlAccount Id for
posting the Invoice in a database table. Something what
InvoiceItemTypeGlAccount entity is supposed to do. I am wondering if its
good Idea to also store offsetting glAccountId in this table corresponding
to each InvoiceItemType.

Comments will help making a acceptable design decision.

Regards
Anil Patel

[David E Jones]

On May 1, 2007, at 7:40 PM, Anil Patel wrote:

> Hi,
> I am working on some accounting code porting from my closed source
> application based on Ofbiz to current Ofbiz trunk. We saved  
> GlAccount Id for
> posting the Invoice in a database table. Something what
> InvoiceItemTypeGlAccount entity is supposed to do. I am wondering  
> if its
> good Idea to also store offsetting glAccountId in this table  
> corresponding
> to each InvoiceItemType.
>
> Comments will help making a acceptable design decision.

I'd say no as it doesn't really work this way.

Generally when posting an invoice you'll have one AcctgTransEntry for  
each InvoiceItem, and then a single balancing AcctgTransEntry. The  
balancing entry for the entire invoice is generally the accounts  
receivable (for a sales invoice) or accounts payable (for a purchase  
invoice) for the given organization.

-David

[Anil Patel]

Got it, Thanks

Regards
Anil

On 5/1/07, David E. Jones <[hidden email]> wrote:

>
>
> On May 1, 2007, at 7:40 PM, Anil Patel wrote:
>
> > Hi,
> > I am working on some accounting code porting from my closed source
> > application based on Ofbiz to current Ofbiz trunk. We saved
> > GlAccount Id for
> > posting the Invoice in a database table. Something what
> > InvoiceItemTypeGlAccount entity is supposed to do. I am wondering
> > if its
> > good Idea to also store offsetting glAccountId in this table
> > corresponding
> > to each InvoiceItemType.
> >
> > Comments will help making a acceptable design decision.
>
> I'd say no as it doesn't really work this way.
>
> Generally when posting an invoice you'll have one AcctgTransEntry for
> each InvoiceItem, and then a single balancing AcctgTransEntry. The
> balancing entry for the entire invoice is generally the accounts
> receivable (for a sales invoice) or accounts payable (for a purchase
> invoice) for the given organization.
>
> -David
>
>
>