GL Journal - Switching accounting schema removes PERIOD


  • 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. To simulate this scenario, I have created a second accounting schema called "2nd schema" in Carlos' demo system so you'll be able to simulate it there.

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




Michael Powacht
May 9, 2019, 2:21 AM

Thanks Elaine and Heng Sin,
I successfully tested the 2 changes:

  • AcctSchema callout to update period

  • AcctSchema callout to update currency

Carlos Ruiz
May 8, 2019, 10:15 AM

Great!! Thanks

Heng Sin Low
May 8, 2019, 10:02 AM

@Carlos, you should thank Elaine instead

She did the changes and testing, I just did the review and commit.

Carlos Ruiz
May 8, 2019, 9:59 AM

Hi ,

This is something that used to annoy me:

  • Window: Table & Column

  • Navigate to column Test.CreatedBy

  • Change the Reference from Table to Search

  • The Reference Key and Constraint Type are gone

So, I just tested and your commit here fixed that !!!

Thanks a lot.


Carlos Ruiz

Heng Sin Low
May 8, 2019, 9:41 AM

, patch have been pushed to 6.2 branch, please verify, thanks.

Your pinned fields
Click on the next to a field label to start pinning.


Heng Sin Low


Michael Powacht