Can I change the balance sheet or fiscal entity level in General Ledger?
Description


Cause
Resolution
[BCB:1:Backup warning:ECB]


[BCB:5:Third-party support:ECB]



Changing the balance sheet level in General Ledger changes the chart of accounts numbering system. To assist with your decision, review How does General Ledger generate accounts? It includes examples of the balance sheet level at prefix A, prefix B, and prefix C.

The resolution of this issue may require a chargeable key change. Review the information below before you contact Sage 300 Construction and Real Estate Support. If a key change is required, you will be referred to Sage Expert Services. There is a fee for their services.

Changing the balance sheet level in General Ledger:

  • If you have not generated any accounts and need to change your balance sheet level, choose Option 1.
  • If you have generated accounts, but have not yet entered any transactions, choose Option 2.
  • If you have generated accounts, but entered only a few small entries, choose Option 3.
  • If you have generated accounts and operated with the current account structure, and your balance sheet and fiscal entity levels are set at prefix A and you want to create balance sheet accounts at prefix B OR your balance sheet level and fiscal entity level are set to prefix B and you want to create balance sheet accounts at prefix C, choose Option 4.
  • If you have generated accounts and operated with the current account structure, and your balance sheet and fiscal entity levels are not set at prefix A, choose Option 5.

Option 1
If you have not yet generated accounts, change your balance sheet level as follows:

  1. From the File menu, select Company Settings, GL Settings.
  2. In the Fiscal Entity section, verify the selected option.
    • Tip: If you do not see a Fiscal Entity section, and Calendar/Fiscal Settings is available, then your fiscal entity level is data folder.
  3. Click Cancel.
  4. Continue with the steps below depending on the selected option from step 2:
    • Data Folder:
      1. From the File menu, select Company Settings, GL Settings.
      2. Click Calendar/Fiscal Settings.
      3. In the Balance Sheet Level section, change the balance sheet level to the level that you want.
      4. Click OK twice.
      5. Set up any additional prefixes required by the balance sheet level change (Setup, Prefix/Base).
    • Prefix:
      1. From the Setup menu, select Prefix/Base, and then select the fiscal entity prefix.
      2. Click Fiscal Settings.
      3. In the Balance Sheet Level section, change the balance sheet level to the level that you want.
      4. Click OK.
      5. Click Save and then click Close.
      6. Set up any additional prefixes required by the balance sheet level change (Setup, Prefix/Base).

Option 2
Change your balance sheet level as follows if you have generated accounts, but have not entered any transactions:

  1. Delete all of your full accounts. See How do I delete multiple General Ledger accounts at the same time? for information on how to quickly delete multiple General Ledger accounts at one time.
  2. Refer to the steps in Option A to change your balance sheet level.
  3. Generate your accounts again (Setup, Generate Accounts).

Option 3
Contact your Sage Consultant or Sage Expert Services if you need assistance with this process.

Change your balance sheet level as follows if you have generated accounts and posted a few entries:

  1. Reverse all the entries using the same accounting date as the originals. Perform reversals in the application of origin to avoid being out of balance.
  2. Move all of your transactions from current to history (Tools, Move Transactions, Current to History) and then from history to history (Tools, Move Transactions, History to History) to move your transactions completely out of your data folder. See How do I move General Ledger transactions from my current file to another current or history file? for more information on moving transactions in General Ledger.
  3. Delete all of your full accounts. See How do I delete multiple General Ledger accounts at the same time? for information on how to quickly delete multiple General Ledger accounts at one time.
  4. Refer to the steps in Option A to change your balance sheet level.
  5. Generate your accounts again (Setup, Generate Accounts).

Option 4
Contact your consultant or Sage Expert Services to complete a workaround that changes your balance sheet level if both of the following conditions apply to you:

  • You have generated accounts, set up other applications, and operated with your existing account structure.
  • Your balance sheet level and fiscal entity level are set to prefix A and you want to create balance sheet accounts at prefix B OR your balance sheet level and fiscal entity level are set to prefix B and you want to create balance sheet accounts at prefix C.

After the workaround is completed, you can create or generate accounts and make journal entries to create beginning balances.


Option 5
Contact Customer Support to schedule a key change with Sage Expert Services if all of the following conditions apply to you:

  • You have generated accounts, set up other applications, and operated with your existing account structure.
  • Your balance sheet level and fiscal entity level are not both set to prefix A.



[BCB:20:Chat 300 CRE US:ECB]

Steps to duplicate
Related Solutions

Sage Expert Services available for Sage 300 Construction and Real Estate