ofbiz-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rajesh Kumar Mallah (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (OFBIZ-5938) GlAccountOrganizations manually added using accounting forms do not appear on trial report because fromDate gets set to NULL
Date Fri, 13 Oct 2017 16:03:01 GMT

    [ 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.


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)

Mime
View raw message