[
https://issues.apache.org/jira/browse/OFBIZ-5938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16196031#comment-16196031 ]
Rajesh Kumar Mallah edited comment on OFBIZ-5938 at 10/13/17 5:19 PM:
----------------------------------------------------------------------
I faced this issue with 16.11 also and had to manually update using SQL
update gl_account_organization set from_date='2001-01-01 00:00:00+05:30' where organization_party_id='10000';
steps summary:
1) create a new organisation
2) assign gl_accounts to it
3) carry out some transations
4) try checking trial balance.
it shall display cr:0 dr:0
after updating the 'from_date' it worked as expected.
regds
mallah.
was (Author: rmallah):
I faced this issue with 11.6 also and had to manually update using SQL
update gl_account_organization set from_date='2001-01-01 00:00:00+05:30' where organization_party_id='10000';
steps summary:
1) create a new organisation
2) assign gl_accounts to it
3) carry out some transations
4) try checking trial balance.
it shall display cr:0 dr:0
after updating the 'from_date' it worked as expected.
regds
mallah.
> 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
