You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Hans Bakker <ma...@antwebsystems.com> on 2009/07/19 16:48:20 UTC
all accounting specialists please read
I am digging in the accounting module and found the following I need
your advice on.
There is view called "AcctgTransAndEntries"
this view links mainly the AcctgTrans and AcctgTransEntries together.
However it also links the GlAccountId and the GlAccountClass in the
view, which means if the transaction does not have a GlAccountId or
GlAccountClassId it will not show.
This 'anomaly' shows most on the invoice transactionlist at the bottom
of the screen, if no glAccountId could be found the transaction is not
listed, but is there.
so it is proposed that these fields are optional in this view:
- <view-link entity-alias="ATE" rel-entity-alias="GLA">
+ <view-link entity-alias="ATE" rel-entity-alias="GLA"
rel-optional="true">
<key-map field-name="glAccountId"/>
</view-link>
- <view-link entity-alias="GLA" rel-entity-alias="GLAC">
+ <view-link entity-alias="GLA" rel-entity-alias="GLAC"
rel-optional="true">
HOWEVER.....
This view is used in many places in services. I scanned most of them and
there is often a selection on GlAccount of GlAccountClass so the outcome
should still be the same.
So can i put in this change? I realize it could have some impact on the
accounting processing and everybody should be aware of this change.
On the other hand every service should get all the entries of a
transaction and not only the ones with a filled account and class...
Regards,
Hans
--
Antwebsystems.com: Quality OFBiz services for competitive rates
Re: all accounting specialists please read
Posted by Sharan-F <sh...@gmail.com>.
Hi
If you think about unposted transactions or transactions that fall into the
Error Journal then you can get the case where the GLAccountId isnt included
in one or both sides of the accounting transaction.
I think this normally happens because there is missing setup in the GL
account defaults showing what the default account should be.
Thanks
Sharan
Vince Clark wrote:
>
> GlAccountId is a required field in AcctgTransEntry so I don't see how it
> could not be there in the transaction.
>
> Vince Clark
> vclark@globalera.com
> (303) 493-6723
>
> ----- Original Message -----
> From: "Hans Bakker" <ma...@antwebsystems.com>
> To: "dev" <dev@ofbiz.apache.or
> Sent: Sunday, July 19, 2009 8:48:20 AM GMT -07:00 US/Canada Mountain
> Subject: all accounting specialists please read
>
> I am digging in the accounting module and found the following I need
> your advice on.
>
> There is view called "AcctgTransAndEntries"
>
> this view links mainly the AcctgTrans and AcctgTransEntries together.
>
> However it also links the GlAccountId and the GlAccountClass in the
> view, which means if the transaction does not have a GlAccountId or
> GlAccountClassId it will not show.
>
> This 'anomaly' shows most on the invoice transactionlist at the bottom
> of the screen, if no glAccountId could be found the transaction is not
> listed, but is there.
>
> so it is proposed that these fields are optional in this view:
> - <view-link entity-alias="ATE" rel-entity-alias="GLA">
> + <view-link entity-alias="ATE" rel-entity-alias="GLA"
> rel-optional="true">
> <key-map field-name="glAccountId"/>
> </view-link>
> - <view-link entity-alias="GLA" rel-entity-alias="GLAC">
> + <view-link entity-alias="GLA" rel-entity-alias="GLAC"
> rel-optional="true">
>
> HOWEVER.....
>
> This view is used in many places in services. I scanned most of them and
> there is often a selection on GlAccount of GlAccountClass so the outcome
> should still be the same.
>
> So can i put in this change? I realize it could have some impact on the
> accounting processing and everybody should be aware of this change.
> On the other hand every service should get all the entries of a
> transaction and not only the ones with a filled account and class...
>
> Regards,
> Hans
>
> --
> Antwebsystems.com: Quality OFBiz services for competitive rates
>
>
>
--
View this message in context: http://www.nabble.com/all-accounting-specialists-please-read-tp24557664p24562889.html
Sent from the OFBiz - Dev mailing list archive at Nabble.com.
Re: all accounting specialists please read
Posted by Hans Bakker <ma...@antwebsystems.com>.
If the system cannot find the GLAccountId it is left null and the record
is put in the error journal.... so it can be null....
Regards,
Hans
On Sun, 2009-07-19 at 17:15 -0500, Vince Clark wrote:
> GlAccountId is a required field in AcctgTransEntry so I don't see how it could not be there in the transaction.
>
> Vince Clark
> vclark@globalera.com
> (303) 493-6723
>
> ----- Original Message -----
> From: "Hans Bakker" <ma...@antwebsystems.com>
> To: "dev" <dev@ofbiz.apache.or
> Sent: Sunday, July 19, 2009 8:48:20 AM GMT -07:00 US/Canada Mountain
> Subject: all accounting specialists please read
>
> I am digging in the accounting module and found the following I need
> your advice on.
>
> There is view called "AcctgTransAndEntries"
>
> this view links mainly the AcctgTrans and AcctgTransEntries together.
>
> However it also links the GlAccountId and the GlAccountClass in the
> view, which means if the transaction does not have a GlAccountId or
> GlAccountClassId it will not show.
>
> This 'anomaly' shows most on the invoice transactionlist at the bottom
> of the screen, if no glAccountId could be found the transaction is not
> listed, but is there.
>
> so it is proposed that these fields are optional in this view:
> - <view-link entity-alias="ATE" rel-entity-alias="GLA">
> + <view-link entity-alias="ATE" rel-entity-alias="GLA"
> rel-optional="true">
> <key-map field-name="glAccountId"/>
> </view-link>
> - <view-link entity-alias="GLA" rel-entity-alias="GLAC">
> + <view-link entity-alias="GLA" rel-entity-alias="GLAC"
> rel-optional="true">
>
> HOWEVER.....
>
> This view is used in many places in services. I scanned most of them and
> there is often a selection on GlAccount of GlAccountClass so the outcome
> should still be the same.
>
> So can i put in this change? I realize it could have some impact on the
> accounting processing and everybody should be aware of this change.
> On the other hand every service should get all the entries of a
> transaction and not only the ones with a filled account and class...
>
> Regards,
> Hans
>
--
Antwebsystems.com: Quality OFBiz services for competitive rates
Re: all accounting specialists please read
Posted by Vince Clark <vc...@globalera.com>.
GlAccountId is a required field in AcctgTransEntry so I don't see how it could not be there in the transaction.
Vince Clark
vclark@globalera.com
(303) 493-6723
----- Original Message -----
From: "Hans Bakker" <ma...@antwebsystems.com>
To: "dev" <dev@ofbiz.apache.or
Sent: Sunday, July 19, 2009 8:48:20 AM GMT -07:00 US/Canada Mountain
Subject: all accounting specialists please read
I am digging in the accounting module and found the following I need
your advice on.
There is view called "AcctgTransAndEntries"
this view links mainly the AcctgTrans and AcctgTransEntries together.
However it also links the GlAccountId and the GlAccountClass in the
view, which means if the transaction does not have a GlAccountId or
GlAccountClassId it will not show.
This 'anomaly' shows most on the invoice transactionlist at the bottom
of the screen, if no glAccountId could be found the transaction is not
listed, but is there.
so it is proposed that these fields are optional in this view:
- <view-link entity-alias="ATE" rel-entity-alias="GLA">
+ <view-link entity-alias="ATE" rel-entity-alias="GLA"
rel-optional="true">
<key-map field-name="glAccountId"/>
</view-link>
- <view-link entity-alias="GLA" rel-entity-alias="GLAC">
+ <view-link entity-alias="GLA" rel-entity-alias="GLAC"
rel-optional="true">
HOWEVER.....
This view is used in many places in services. I scanned most of them and
there is often a selection on GlAccount of GlAccountClass so the outcome
should still be the same.
So can i put in this change? I realize it could have some impact on the
accounting processing and everybody should be aware of this change.
On the other hand every service should get all the entries of a
transaction and not only the ones with a filled account and class...
Regards,
Hans
--
Antwebsystems.com: Quality OFBiz services for competitive rates