set GL Account to be Bank/Credit Card Account after Financial Cubes created

Follow

Charles Spring

• September 08, 2021 14:57

Any suggestions on how to check the "Bank/Credit Card Account" checkbox on a GL Account after Financial Cubes have been created? We get this error: "The Bank/Credit Card Account checkbox can not be changed if Financial Cube records exist"

We have 7 months worth of cubes already when we realized 2 GL Accounts need to be set as Bank/Credit Card Accounts. One GL Account has 5 Transactions (GL Accounts) and one has 3 Transactions.

Thanks for any ideas.

1

• 

  Rebecca Ralls

  • September 08, 2021 20:11

  There are effectively 2 options: Open the periods and unpost the transactions, purge zero balance financial cubes, and toggle the flag, then repost and reclose the periods, OR create new GL Accounts (cloning would be easiest), set the flag on the new GL Accounts, use a Journal entry to transfer the balances (either in summary or detail, depending on your reconciliation needs), and deactivate and rename the old GL Accounts.  

  0

  Comment actions Permalink
• 

  Bao Do

  • September 09, 2021 03:17

  If you reach out to support they have a way to override the system rules and enable it on their end. However I agree with Rebecca that her latter approach is better. There are always unintended consequences when you override the system rules to force a change. The system rules around bank gl accounts mainly are in place bc of the bank reconciliation functionality and you may have issues if you override.

  0

  Comment actions Permalink

Please sign in to leave a comment.