[
https://issues.apache.org/jira/browse/OFBIZ-5938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16196031#comment-16196031
]
Rajesh Kumar Mallah commented on OFBIZ-5938:
--------------------------------------------
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: Pranay Pandey
> 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)
