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
April 19, 2019, 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):
---------------------------------------------------------------------------------------------------------------------

Michael Powacht
April 29, 2019, 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

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

Hi ,

  • Can't reproduce.

  • Please create a new ticket for that.

Regards,
Low

Michael Powacht
May 4, 2019, 2:31 AM

Thanks Heng Sin, will do.

Michael Powacht
May 4, 2019, 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.

Assignee

Heng Sin Low

Reporter

Michael Powacht

Labels

None

Tested By

None

Components

Fix versions

Priority

Minor
Configure