Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Process Recalculate Cube not loading GL journal facts due to c_calendar_id

Description

Process "Recalculate Cube" does not load GL Journal accounting facts into fact_acct_summary under the following example conditions:

Org A is assigned to Calendar A
Org B is assigned to Calendar B

Cube A (for organization A) is assigned to Calendar A
Cube B (for organization B) is assigned to Calendar B

I record a GL journal with Org=A. The journal and the generated accounting facts are assigned to a c_period_id assigned to its default calendar_id=1000000 instead of Calendar A.
I record a GL journal with Org=B. Same as above: accounting facts are assigned to default calendar_id 1000000 instead of Calendar B.

Because of the difference in calendar_id between cube definition and accounting facts, the GL journal facts are not included in the aggregation in table fact_acct_summary.

A possible solution could be to derive the GL journal organization's Period_ID/Year/Calendar_ID instead of the
default Period_ID/Year/Calendar_ID.

Environment

None

Activity

Show:

Michael Powacht May 4, 2019 at 2:38 AM

Hello Heng Sin,
I have created a new JIRA: https://idempiere.atlassian.net/browse/IDEMPIERE-3961
To simulate this scenario, I have created a second accounting schema called "2nd schema" in Carlos' demo system https://demo.globalqss.com/webui/index.zul so you'll be able to simulate it there.

Michael Powacht May 4, 2019 at 2:31 AM

Thanks Heng Sin, will do.

Heng Sin Low May 4, 2019 at 2:23 AM

Hi ,

  • Can't reproduce.

  • Please create a new ticket for that.

Regards,
Low

Michael Powacht April 29, 2019 at 1:40 AM

Hi Carlos, I noticed another problem today:
We use multiple accounting schemes.

  • When I create a new GL Journal header and select an organization, it populates PERIOD correctly and when I change ACCOUNT DATE, it updates PERIOD correctly. However, when I change accounting schema in the Journal header, PERIOD gets removed and there are no periods to be selected. Only after changing ACCOUNT DATE to some other date will PERIOD be re-derived.

  • The other thing that would be nice here is if a callout would update journal header CURRENCY based on Accounting Schema CURRENCY.

Thanks,
Michael

Michael Powacht April 19, 2019 at 6:22 AM
Edited

Thanks @Carlos Ruiz ,
I performed some more tests today including a GL Journal with Special Period which gets loaded into the cube as expected. I use the following SQL query for a basic periodic checks for any differences between FACT_ACCT and FACT_ACCT_SUMMARY (Cube):
---------------------------------------------------------------------------------------------------------------------

Fixed

Details

Assignee

Reporter

Components

Fix versions

Priority

Created January 18, 2019 at 3:08 AM
Updated July 17, 2019 at 10:01 AM
Resolved April 17, 2019 at 8:32 AM