You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Anil Patel <to...@gmail.com> on 2007/05/02 03:40:51 UTC
InvoiceItemTypeGlAccount, Should we add a field for offsetting glAccountId
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
Re: InvoiceItemTypeGlAccount, Should we add a field for offsetting glAccountId
Posted by Anil Patel <to...@gmail.com>.
Got it, Thanks
Regards
Anil
On 5/1/07, David E. Jones <jo...@hotwaxmedia.com> 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
>
>
>
Re: InvoiceItemTypeGlAccount, Should we add a field for offsetting glAccountId
Posted by "David E. Jones" <jo...@hotwaxmedia.com>.
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