Why Aren't All Expected Accounts Being Produced in General Ledger Using "Generate Accounts" in Sage 300 CRE?

Why Aren't All Expected Accounts Being Produced in General Ledger Using "Generate Accounts"?

Why aren't the expected complete accounts appearing in General Ledger when using "Generate Accounts"?

The Reason:

The full account's creation is influenced by the base account's Account type and the chosen prefix. It's essential that these align with the Balance Sheet Level.
  1. Should the base account possess a balance sheet account type (e.g., Asset, Liability, Equity, Retained Earnings) while the chosen prefix corresponds to a profit and loss (P&L) level, the account won't be established.
  2. Conversely, if the base account has a P&L account type (like Income, Cost, Expense, Other Income) and the prefix aligns with a balance sheet level, the account won't form.
For an in-depth understanding, see article titled, "How does the General Ledger create accounts?"

The Solution:

  1. Double-check the Account type of the selected base account under Setup, Prefix/Base, Base Accounts.
  2. Ensure the accurate prefix is chosen during account generation.
  3. Verify the assignment of the balance sheet level (navigate to Reports, Lists, Prefix A).

    • Related Articles

    • How Does the General Ledger Generate Accounts?

      Understanding Account Generation in the General Ledger Process: Start by defining your account format in the Custom Descriptions. Input the relevant prefixes and base accounts. Now, from the Setup menu, choose the Generate Accounts command. This ...

    • How to Generate Accounts in Sage 300 CRE General Ledger (GL)

      Creating Accounts in the General Ledger Instructions: Navigate to the General Ledger and initiate the "Chart of Accounts" creation process using the existing base accounts and their prefixes. Go to Setup and choose Generate Accounts. Identify and ...

    • Statistical Accounts: Capturing Various Operational Metrics in Sage Intacct

      Overview This article provides a guide on using statistical accounts in Sage Intacct to record non-financial data. The tutorial, available here, explains the importance of statistical accounts in capturing various operational metrics. Key Points on ...

    • Common Corrections in Sage Intacct T&M Billing

      Managing Time & Material (T&M) billing in Sage Intacct involves understanding common pitfalls and how to correct them. This tutorial, inspired by a helpful video guide, walks you through the common corrections you might need to make during the T&M ...

    • Missing Project ID Field on General Ledger Report

      Users can Add or Remove Dimensions from the General Ledger Report in Sage Intacct. Added Dimensions will be displayed as separate field on the General Ledger Report and will be included on the Report Export as well. Here's how: 1. Go to ...