You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Xavier Olivella <xa...@xoli.cat> on 2007/07/17 20:48:42 UTC
General Ledger questions.
Hi everybody
I am setting up my own GL Chart of accounts with Spanish model and it's
working quite good (thanks to documentation!) except for the nightmare
of converting the defaults and accountTypes to its Spanish GL
equivalent :-(
Anyway I have a couple of questions.
1- I know how to set up all receivable and payable invoices to its
default GL account but, can I set up some specific GL account for some
customers and some providers? It's very usual here, so it would be
perfect for my accountant. The idea is that all invoices to (or from) a
particular PartyID may be posted to a GL account "linked" or associated
to that Party.
2- The second one is related to previous. If there's a parent GL account
that has several child accounts, how can I set up the parent balance to
be the sum of all child balances? You can figure it would be very useful
in above case among others.
I've been looking in docs and google lucklessly :-(
Thanks in advance!
Re: General Ledger questions.
Posted by Vince Clark <vc...@globalera.com>.
That helps. Thanks for the clarification.
David E Jones wrote:
>
> This line isn't easily drawn. Initially opentaps financials was just
> an add-on to OFBiz, but these days they are working on replacing
> functionality in OFBiz accounting, so the functional areas overlap
> quite a bit.
>
> In general OFBiz has all of the data model, low level posting
> services, etc but we don't yet have automated posting services or
> financial reports and those are the big gaps that opentaps fills.
>
> -David
>
>
> Vince Clark wrote:
>> David
>>
>> Speaking of OpenTaps, can you provide some clarification on where the
>> line is drawn between OFBiz functionality and the OpenTaps Financials
>> module?
>>
>> For example, does OFBiz take transactions all the way to posting to the
>> GL? If so, is OpenTaps really just enhanced functionality and reporting?
>>
>> I'm trying to understand when it makes sense to pull in that module or
>> just use OFBiz OOTB.
>>
>> David E Jones wrote:
>>> Hmmm... if you are actually using any of these things it must be with
>>> the opentaps financials module or something as these aren't actually
>>> built into OFBiz.
>>>
>>> There are some efforts coming to build all of this out in OFBiz
>>> itself, but that is really not close to done yet.
>>>
>>> If you are using opentaps, the opentaps forums/lists/whatever might
>>> yield more helpful information.
>>>
>>> Good luck!
>>> -David
>>>
>>>
>>> Xavier Olivella wrote:
>>>> Ok, thanks for your note, but I would like ofbiz to POST to a specific
>>>> account, not to get the report (which is working fine by the way).
>>>>
>>>> The second one is not working for me, but I don't know if there's
>>>> another thing to set up plus the parent-child relationship.
>>>>
>>>> Thanks anyway.
>>>>
>>>>
>>>> El dt 17 de 07 del 2007 a les 12:52 -0600, en/na David E Jones va
>>>> escriure:
>>>>
>>>>> Just a quick note: those both sound like things you could do after
>>>>> the fact in the reports and such that you write. In fact, the second
>>>>> one is already implied and part of what OFBiz does.
>>>>>
>>>>> -David
>>>>>
>>>>>
>>>>> Xavier Olivella wrote:
>>>>>> Hi everybody
>>>>>>
>>>>>> I am setting up my own GL Chart of accounts with Spanish model and
>>>>>> it's
>>>>>> working quite good (thanks to documentation!) except for the
>>>>>> nightmare
>>>>>> of converting the defaults and accountTypes to its Spanish GL
>>>>>> equivalent :-(
>>>>>>
>>>>>> Anyway I have a couple of questions.
>>>>>>
>>>>>> 1- I know how to set up all receivable and payable invoices to its
>>>>>> default GL account but, can I set up some specific GL account for
>>>>>> some
>>>>>> customers and some providers? It's very usual here, so it would be
>>>>>> perfect for my accountant. The idea is that all invoices to (or
>>>>>> from) a
>>>>>> particular PartyID may be posted to a GL account "linked" or
>>>>>> associated
>>>>>> to that Party.
>>>>>>
>>>>>> 2- The second one is related to previous. If there's a parent GL
>>>>>> account
>>>>>> that has several child accounts, how can I set up the parent
>>>>>> balance to
>>>>>> be the sum of all child balances? You can figure it would be very
>>>>>> useful
>>>>>> in above case among others.
>>>>>>
>>>>>>
>>>>>> I've been looking in docs and google lucklessly :-(
>>>>>>
>>>>>> Thanks in advance!
>>>>>>
>>
--
Vince Clark
Global Era
The freedom of open source.
(303) 493-6723
(303) 455-2409 fax
vclark@globalera.com <ma...@globalera.com>
www.globalera.com
Re: General Ledger questions.
Posted by David E Jones <jo...@hotwaxmedia.com>.
This line isn't easily drawn. Initially opentaps financials was just an add-on to OFBiz, but these days they are working on replacing functionality in OFBiz accounting, so the functional areas overlap quite a bit.
In general OFBiz has all of the data model, low level posting services, etc but we don't yet have automated posting services or financial reports and those are the big gaps that opentaps fills.
-David
Vince Clark wrote:
> David
>
> Speaking of OpenTaps, can you provide some clarification on where the
> line is drawn between OFBiz functionality and the OpenTaps Financials
> module?
>
> For example, does OFBiz take transactions all the way to posting to the
> GL? If so, is OpenTaps really just enhanced functionality and reporting?
>
> I'm trying to understand when it makes sense to pull in that module or
> just use OFBiz OOTB.
>
> David E Jones wrote:
>> Hmmm... if you are actually using any of these things it must be with
>> the opentaps financials module or something as these aren't actually
>> built into OFBiz.
>>
>> There are some efforts coming to build all of this out in OFBiz
>> itself, but that is really not close to done yet.
>>
>> If you are using opentaps, the opentaps forums/lists/whatever might
>> yield more helpful information.
>>
>> Good luck!
>> -David
>>
>>
>> Xavier Olivella wrote:
>>> Ok, thanks for your note, but I would like ofbiz to POST to a specific
>>> account, not to get the report (which is working fine by the way).
>>>
>>> The second one is not working for me, but I don't know if there's
>>> another thing to set up plus the parent-child relationship.
>>>
>>> Thanks anyway.
>>>
>>>
>>> El dt 17 de 07 del 2007 a les 12:52 -0600, en/na David E Jones va
>>> escriure:
>>>
>>>> Just a quick note: those both sound like things you could do after
>>>> the fact in the reports and such that you write. In fact, the second
>>>> one is already implied and part of what OFBiz does.
>>>>
>>>> -David
>>>>
>>>>
>>>> Xavier Olivella wrote:
>>>>> Hi everybody
>>>>>
>>>>> I am setting up my own GL Chart of accounts with Spanish model and
>>>>> it's
>>>>> working quite good (thanks to documentation!) except for the nightmare
>>>>> of converting the defaults and accountTypes to its Spanish GL
>>>>> equivalent :-(
>>>>>
>>>>> Anyway I have a couple of questions.
>>>>>
>>>>> 1- I know how to set up all receivable and payable invoices to its
>>>>> default GL account but, can I set up some specific GL account for some
>>>>> customers and some providers? It's very usual here, so it would be
>>>>> perfect for my accountant. The idea is that all invoices to (or
>>>>> from) a
>>>>> particular PartyID may be posted to a GL account "linked" or
>>>>> associated
>>>>> to that Party.
>>>>>
>>>>> 2- The second one is related to previous. If there's a parent GL
>>>>> account
>>>>> that has several child accounts, how can I set up the parent
>>>>> balance to
>>>>> be the sum of all child balances? You can figure it would be very
>>>>> useful
>>>>> in above case among others.
>>>>>
>>>>>
>>>>> I've been looking in docs and google lucklessly :-(
>>>>>
>>>>> Thanks in advance!
>>>>>
>
Re: General Ledger questions.
Posted by Vince Clark <vc...@globalera.com>.
David
Speaking of OpenTaps, can you provide some clarification on where the
line is drawn between OFBiz functionality and the OpenTaps Financials
module?
For example, does OFBiz take transactions all the way to posting to the
GL? If so, is OpenTaps really just enhanced functionality and reporting?
I'm trying to understand when it makes sense to pull in that module or
just use OFBiz OOTB.
David E Jones wrote:
>
> Hmmm... if you are actually using any of these things it must be with
> the opentaps financials module or something as these aren't actually
> built into OFBiz.
>
> There are some efforts coming to build all of this out in OFBiz
> itself, but that is really not close to done yet.
>
> If you are using opentaps, the opentaps forums/lists/whatever might
> yield more helpful information.
>
> Good luck!
> -David
>
>
> Xavier Olivella wrote:
>> Ok, thanks for your note, but I would like ofbiz to POST to a specific
>> account, not to get the report (which is working fine by the way).
>>
>> The second one is not working for me, but I don't know if there's
>> another thing to set up plus the parent-child relationship.
>>
>> Thanks anyway.
>>
>>
>> El dt 17 de 07 del 2007 a les 12:52 -0600, en/na David E Jones va
>> escriure:
>>
>>> Just a quick note: those both sound like things you could do after
>>> the fact in the reports and such that you write. In fact, the second
>>> one is already implied and part of what OFBiz does.
>>>
>>> -David
>>>
>>>
>>> Xavier Olivella wrote:
>>>> Hi everybody
>>>>
>>>> I am setting up my own GL Chart of accounts with Spanish model and
>>>> it's
>>>> working quite good (thanks to documentation!) except for the nightmare
>>>> of converting the defaults and accountTypes to its Spanish GL
>>>> equivalent :-(
>>>>
>>>> Anyway I have a couple of questions.
>>>>
>>>> 1- I know how to set up all receivable and payable invoices to its
>>>> default GL account but, can I set up some specific GL account for some
>>>> customers and some providers? It's very usual here, so it would be
>>>> perfect for my accountant. The idea is that all invoices to (or
>>>> from) a
>>>> particular PartyID may be posted to a GL account "linked" or
>>>> associated
>>>> to that Party.
>>>>
>>>> 2- The second one is related to previous. If there's a parent GL
>>>> account
>>>> that has several child accounts, how can I set up the parent
>>>> balance to
>>>> be the sum of all child balances? You can figure it would be very
>>>> useful
>>>> in above case among others.
>>>>
>>>>
>>>> I've been looking in docs and google lucklessly :-(
>>>>
>>>> Thanks in advance!
>>>>
>>
--
Vince Clark
Global Era
The freedom of open source.
(303) 493-6723
(303) 455-2409 fax
vclark@globalera.com <ma...@globalera.com>
www.globalera.com
Re: General Ledger questions.
Posted by Xavier Olivella <xa...@xoli.cat>.
Yes, I'm using Opentaps, but i thought all this stuff was Ofbiz
business...
Thanks for your patience, I'll try in Opentaps forum.
El dt 17 de 07 del 2007 a les 13:31 -0600, en/na David E Jones va
escriure:
> Hmmm... if you are actually using any of these things it must be with the opentaps financials module or something as these aren't actually built into OFBiz.
>
> There are some efforts coming to build all of this out in OFBiz itself, but that is really not close to done yet.
>
> If you are using opentaps, the opentaps forums/lists/whatever might yield more helpful information.
>
> Good luck!
> -David
Re: General Ledger questions.
Posted by David E Jones <jo...@hotwaxmedia.com>.
Hmmm... if you are actually using any of these things it must be with the opentaps financials module or something as these aren't actually built into OFBiz.
There are some efforts coming to build all of this out in OFBiz itself, but that is really not close to done yet.
If you are using opentaps, the opentaps forums/lists/whatever might yield more helpful information.
Good luck!
-David
Xavier Olivella wrote:
> Ok, thanks for your note, but I would like ofbiz to POST to a specific
> account, not to get the report (which is working fine by the way).
>
> The second one is not working for me, but I don't know if there's
> another thing to set up plus the parent-child relationship.
>
> Thanks anyway.
>
>
> El dt 17 de 07 del 2007 a les 12:52 -0600, en/na David E Jones va
> escriure:
>
>> Just a quick note: those both sound like things you could do after the fact in the reports and such that you write. In fact, the second one is already implied and part of what OFBiz does.
>>
>> -David
>>
>>
>> Xavier Olivella wrote:
>>> Hi everybody
>>>
>>> I am setting up my own GL Chart of accounts with Spanish model and it's
>>> working quite good (thanks to documentation!) except for the nightmare
>>> of converting the defaults and accountTypes to its Spanish GL
>>> equivalent :-(
>>>
>>> Anyway I have a couple of questions.
>>>
>>> 1- I know how to set up all receivable and payable invoices to its
>>> default GL account but, can I set up some specific GL account for some
>>> customers and some providers? It's very usual here, so it would be
>>> perfect for my accountant. The idea is that all invoices to (or from) a
>>> particular PartyID may be posted to a GL account "linked" or associated
>>> to that Party.
>>>
>>> 2- The second one is related to previous. If there's a parent GL account
>>> that has several child accounts, how can I set up the parent balance to
>>> be the sum of all child balances? You can figure it would be very useful
>>> in above case among others.
>>>
>>>
>>> I've been looking in docs and google lucklessly :-(
>>>
>>> Thanks in advance!
>>>
>
Re: General Ledger questions.
Posted by Xavier Olivella <xa...@xoli.cat>.
Ok, thanks for your note, but I would like ofbiz to POST to a specific
account, not to get the report (which is working fine by the way).
The second one is not working for me, but I don't know if there's
another thing to set up plus the parent-child relationship.
Thanks anyway.
El dt 17 de 07 del 2007 a les 12:52 -0600, en/na David E Jones va
escriure:
> Just a quick note: those both sound like things you could do after the fact in the reports and such that you write. In fact, the second one is already implied and part of what OFBiz does.
>
> -David
>
>
> Xavier Olivella wrote:
> > Hi everybody
> >
> > I am setting up my own GL Chart of accounts with Spanish model and it's
> > working quite good (thanks to documentation!) except for the nightmare
> > of converting the defaults and accountTypes to its Spanish GL
> > equivalent :-(
> >
> > Anyway I have a couple of questions.
> >
> > 1- I know how to set up all receivable and payable invoices to its
> > default GL account but, can I set up some specific GL account for some
> > customers and some providers? It's very usual here, so it would be
> > perfect for my accountant. The idea is that all invoices to (or from) a
> > particular PartyID may be posted to a GL account "linked" or associated
> > to that Party.
> >
> > 2- The second one is related to previous. If there's a parent GL account
> > that has several child accounts, how can I set up the parent balance to
> > be the sum of all child balances? You can figure it would be very useful
> > in above case among others.
> >
> >
> > I've been looking in docs and google lucklessly :-(
> >
> > Thanks in advance!
> >
Re: General Ledger questions.
Posted by David E Jones <jo...@hotwaxmedia.com>.
Just a quick note: those both sound like things you could do after the fact in the reports and such that you write. In fact, the second one is already implied and part of what OFBiz does.
-David
Xavier Olivella wrote:
> Hi everybody
>
> I am setting up my own GL Chart of accounts with Spanish model and it's
> working quite good (thanks to documentation!) except for the nightmare
> of converting the defaults and accountTypes to its Spanish GL
> equivalent :-(
>
> Anyway I have a couple of questions.
>
> 1- I know how to set up all receivable and payable invoices to its
> default GL account but, can I set up some specific GL account for some
> customers and some providers? It's very usual here, so it would be
> perfect for my accountant. The idea is that all invoices to (or from) a
> particular PartyID may be posted to a GL account "linked" or associated
> to that Party.
>
> 2- The second one is related to previous. If there's a parent GL account
> that has several child accounts, how can I set up the parent balance to
> be the sum of all child balances? You can figure it would be very useful
> in above case among others.
>
>
> I've been looking in docs and google lucklessly :-(
>
> Thanks in advance!
>