[
https://issues.apache.org/jira/browse/OFBIZ-5938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16203753#comment-16203753 ]
Rajesh Kumar Mallah edited comment on OFBIZ-5938 at 10/13/17 4:02 PM:
----------------------------------------------------------------------
the change in accounting/control/AssignGlAccount?organizationPartyId=company
does produce correct result. But accounting/control/ListGlAccountOrganization remains
unchanged.
{{
select gl_account_id,organization_party_id,role_type_id,from_date, last_updated_stamp from gl_account_organization where organization_party_id='10000' order by last_updated_stamp desc limit 10;
gl_account_id | organization_party_id | role_type_id | from_date | last_updated_stamp
---------------+-----------------------+--------------+---------------------------+-------------------------------
9999999 | 10000 | | 2017-10-13 21:28:25+05:30 | 2017-10-13 21:28:48.691+05:30
6152545 | 10000 | | | 2017-10-13 20:55:11.977+05:30
2051500 | 10000 | | | 2017-10-13 20:45:45.531+05:30
1502000 | 10000 | | 2001-01-01 00:00:00+05:30 | 2017-10-13 16:51:34.21+05:30
}}
was (Author: rmallah):
the change in accounting/control/AssignGlAccount?organizationPartyId=company
does produce correct result. But accounting/control/ListGlAccountOrganization remains
unchanged.
{{
select gl_account_id,organization_party_id,role_type_id,from_date, last_updated_stamp from gl_account_organization where organization_party_id='10000' order by last_updated_stamp desc limit 10;
gl_account_id | organization_party_id | role_type_id | from_date | last_updated_stamp
---------------+-----------------------+--------------+---------------------------+-------------------------------
9999999 | 10000 | | 2017-10-13 21:28:25+05:30 | 2017-10-13 21:28:48.691+05:30
6152545 | 10000 | | | 2017-10-13 20:55:11.977+05:30
2051500 | 10000 | | | 2017-10-13 20:45:45.531+05:30
1502000 | 10000 | | 2001-01-01 00:00:00+05:30 | 2017-10-13 16:51:34.21+05:30
}}
> GlAccountOrganizations manually added using accounting forms do not appear on trial report because fromDate gets set to NULL
> ----------------------------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-5938
> URL:
https://issues.apache.org/jira/browse/OFBIZ-5938> Project: OFBiz
> Issue Type: Bug
> Components: accounting
> Affects Versions: Release Branch 14.12, Trunk
> Reporter: Christian Carlow
> Assignee: Jacques Le Roux
> Priority: Minor
> Fix For: 14.12.01, 15.12.01
>
> Attachments: OFBIZ-5938.patch
>
>
> To reproduce:
> 1. Manually assign a glAccount to an organization (Accounting->Global GL Settings->Chart Of Accounts->Assign Gl Account or Accounting->Organization GL Settings->Setup->Chart of Accounts)
> 2. Perform operations that create transactions for the organizations glAccount
> 3. Run the Accounting->Organization GL Settings->Accounting->Reports->Trial Balance
> Notice that the glAccountId assigned in step 1 is not listed in the results. This is due to TrialBalance.groovy applying a fromDate filter to GlAccountOrganizationAndClass which is not set in step 1. Updating glAccountOrganization fromDate to something within the trial balance range resolves the problem.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
Locked
