Solution Properties
Solution ID:
224924150049485
Last Modified Date:
Wed Jun 30 22:05:54 UTC 2021
Taxonomy Path:
Category//Reporting
Author:
[email protected]
Accounts are printing in the wrong section on the financial statements
Description
Cause
  • The account has the wrong account type assigned.
  • The account is in the incorrect set of Account Ranges on the financial statement design.
Resolution
  1. If you are using prefixes, correct the Account type on the base account set up:
    1. In General Ledger, from the Setup menu, select Prefix/Base, Base Accounts.
    2. Select the base account.
    3. Press ENTER twice.
    4. Select the correct Account type.
    5. Click Save.
    6. Repeat for any additional accounts.
    7. Click Close.
  2. Correct the Account type on the full account set up:
    1. From the Setup menu, select Accounts.
    2. Select the account.
    3. Press ENTER twice.
    4. Select the correct Account type.
    5. Click Save.
    6. Repeat for any additional accounts.
    7. Click Close.
  3. Update the Account Ranges in the financial statement design so that the account is included in the correct section or grouping.
    • If you print customized financial statement designs, follow the steps in Option A.
    • If you use the default financial statement designs, follow the steps in Option B.
      • Option A
        Update your customized financial statement designs and your net income accumulator.
        1. In Financial Statement Designer, click File, Open.
        2. Select the design that does not display the accounts in the correct section. Click Open.
        3. Double-click the amount options line (the line with green 9999s) where the account is appearing incorrectly.
        4. In the Amount Options window, adjust the account ranges so that it no longer includes the incorrect account. 
        5. Click Save then Close.
        6. Double-click the amount options line (the line with green 9999s) where the account should be included.
        7. In the Amount Options window, adjust the account ranges so that the account is included.
        8. Click Save then Close.
        9. If the account is an Income, Cost, Expense, or Other Income account, update the net income accumulator:
          • If you use the Default Net Income - Accrual accumulator or the Default Net Income - Cash accumulator, update your accumulator as follows:
            1. From the File menu, select Create.
            2. Click Yes to the message "The accumulator Default Net Income - [Accrual/Cash] already exists. Do you want to overwrite it? Cancel will stop creation of default statements."
            3. Click Cancel on the remaining messages.
          • If you use a custom net income accumulator, update your accumulator as follows:
            1. From the Tools menu, select Accumulators.
            2. Select the appropriate accumulator from the Accumulator Name list.
            3. Adjust the account ranges to include or exclude the account as appropriate. You may be adjusting an existing row or adding a new row. If you add a new row, be sure to select the appropriate +/- sign and the appropriate Field.
            4. Click Save then Close.
            5. From the File menu, select Save to save the design changes.
      • Option B
        Update the default financial statements. The default financial statement design names are BalSAccr, BalSCash, CompAccr, CompCash, IncSAccr, IncSCash, TBalAccr, and TBalCash
        • Note: Recreating the default financial statements overwrites any customizations you saved to the default designs.
          1. In Financial Statement Designer, from the File menu, select Create.
          2. Click Yes to each message that appears.
          3. Close all the open financial statement design windows.
          4. Exit Financial Statement Designer.
  4. If the account was set to an incorrect account type when the fiscal year was closed, refer to one of the following articles as appropriate:
    • Article ID 17721 "A General Ledger account type was incorrectly set as an asset, liability, or equity account when the fiscal year was closed"
    • Article ID 17724 "A General Ledger account type was incorrectly set up as an income or expense account when the fiscal year was closed"
DocLink: A General Ledger account type was incorrectly set as an asset, liability, equity, or suspense when the fiscal year was closed
DocLink: A General Ledger account type was incorrectly set up as an income or expense account when the fiscal year was closed
Defect ID
Steps to duplicate
Related Articles