Product GL Distribution Setup overview

Product > Setup > General Ledger Distribution

Function acronym: ICSEG

Use this page to add, copy, or delete GL distribution records. To maintain a record, click the drill down icon for the record you want to change to access the maintenance window.

Complete these setups before entering GL distribution information:

  • GL Accounts Setup
  • Product Warehouse Description Setup
  • Sales Salesrep Setup
  • SA Table Code Value Setup-Product Category

Some General Ledger accounts can be distributed by several combinations and options. These options are determined by the Balance Sheet option in SA Administrator Options-Products-Costs-G/L Update Methods. The balance sheets and income statements are represented by the method chosen.

Note: These options should be set at the beginning of the fiscal year and should not be changed at all during the year. Changing the Income Statement option in SA Administrator Options-Products-Costs-G/L Update Methods or General Ledger account codes causes the General Ledger to be inaccurate. This is because the account codes no longer represent a specific warehouse, product category, and so on. Income statements no longer represent true totals because part of the year represents one warehouse product category and the remainder of the year represents another. If changes are made mid-year, the Product GL Distribution Setup records must be deleted and re-entered correctly.

If you do not specify corresponding GL account codes, the GL account codes from the operator’s record in SA Operator Setup-GL are used. If GL account codes are not set up here or in SA Operator Setup-G/L, all General Ledger distributions are made to the suspense accounts. You must manually balance the accounts.

Seven combinations are available for you to use to distribute to the income statement accounts and three combinations are available for the balance sheet accounts.

Balance Sheet Income Statement
Product Category  Product Category
Warehouse  Warehouse
Both  Customer Type
  Salesrep
  Product Category/Warehouse
  Product Category/Customer Type
  Product Category/Salesrep

The income statement accounts are used if they do not exist in Customer Setup. Accounts from the customer’s record are always used for sales transactions created through Customer Transaction Entry. The SA Operator Setup-GL OE Gross Sales income statement account is used for sales generated through the Sales Entry Invoice Processing Report. This account can be overridden by Product GL Distribution Setup.

General Ledger distribution for the balance sheet accounts can be distributed by product category, warehouse, or both. Selecting both allows for a more specialized distribution. All product categories for each warehouse must be set up with individual GL account codes.

The Product Trial Balance of Stock Inventory Report analyzes how you have set up the Product GL Distribution Setup accounts.