To perform this task, you must have System Administrator permissions and familiarity with basic Salesforce administration tasks.

Sub Type Dependencies

Type, Sub Type 1, and Sub Type 2 are dependent picklist Fields on the GL Account that are used to classify GL Accounts for easier reporting in Salesforce Native Reports. Accounting Seed does not allow the addition of custom Type values.

  • Types: (These values are not editable.)
    • Balance Sheet
    • Revenue
    • Expense

  • Sub Type 1 is dependent on Type:
    • Balance Sheet GL Accounts Sub Types: (These values are not editable.)
      • Assets
      • Liabilities, or
      • Owner’s Equity
    • Revenue and Expense Sub Types:
      • Sub Type 1 is customizable. Typically, this would be Revenue and Expense groupings like operating expenses or professional services.

  • Sub Type 2 is dependent on Sub Type 1:
    • Sub Type 2 is not required, but it provides an extra level of grouping in Financial Reports.
    • If you are using Sub Type 2 for some GL Accounts, then you will want to have a Sub Type 2 for all GL Accounts.
    • All values are customizable.

 

Create Sub Type Values

You can customize Sub Type 1 and Sub Type 2 picklist values through the GL Account object setup in Salesforce.  

  1. Navigate to the Custom Objects page.
    • Salesforce Classic: Click Setup, and then click Build > Create on the left menu, and then click Objects.
    • Lightning Experience: Click the Gear icon at the top of the page and click Setup. Click Platform Tools on the left menu, and then click Objects and Fields > Object Manager.

  2. Click GL Account.

  3. On the GL Account (Managed) page, scroll down to Custom Fields & Relationships and click the link for the Sub Type 1 or Sub Type 2 field.

  4. On the Sub Type 1 (Managed) or Sub Type 2 (Managed) page, scroll down to the Values section and click New. (On this page you can also Activate, Deactivate and Reorder your picklist values.)

  5. On the Add Picklist Values page:
    • Type a new Sub Type picklist value.
    • If you imported your Chart of Accounts with Sub Type values, then these items will be imported as Inactive Values. You will need to activate them in the Inactive Values section.
    • If there are active Sub Type 1 or Sub Type 2 values not in use, then they should be changed to Inactive.

  6. Once your Sub Type picklist values have been created or activated, go back to Custom Fields & Relationships and click the link for the parent level of your picklist. Type is the parent to Sub Type 1 and; Sub Type 1 is the parent to Sub Type 2.

  7. Scroll down to the Field Dependencies section and click Edit to include the values added in Step 5.



Link Sub Types to Types

When new GL Accounts are created, they must be associated with a Type, such as Balance Sheet, Revenue, or Expense. They can then be sub-grouped; this is where Sub Type 1 and Sub Type 2 are selected.

For example, if you select your Type as Balance Sheet, then your Sub Type 1 will only allow you to select groupings that relate to a Balance Sheet, such as Assets and Liabilities. Based on the Sub Type 1 selected, the Sub Type 2 will only allow groupings that relate to that asset.

  1. Navigate to the Custom Objects page.
  2. Click GL Account.
  3. On the GL Account (Managed) page, scroll down to Custom Fields and Relationships and select either Type or Sub Type 1.
  4. Scroll down to Field Dependencies and click the Edit link.
  5. Double-click value(s) to associate with a particular Type or Sub Type 1 value.

 

 
ASU-banner-4.jpg
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.