Explain Sales Codes

The General Ledger accounts described within the Company Setup are the default accounts for the system.  The GL Sales Codes are used to direct the sales, cost of goods sold, and discount accounts according to a unique Customer and Item Code combination created at the time of the sale.

 

When an invoice is created, each item within the invoice generates its own unique general ledger release.  The structure of your income statement will determine how the GL Sales Codes are implemented.  It has been our experience that the "Inventory Oriented Income Statements" is the most common use of the Sales Codes.

 

If your income statement reports sales by customer type, create GL Sale Codes with a different Customer Code for each type of customer designated within the income statement.  For each GL Sale Code created, the Item Code would be the same (DEF) since the type of item being sold does not have an impact on the income statement.

If your income statement reports sales by inventory type, create GL Sale Codes with a different Item Code for each type of inventory designated within the income statement.  For each GL Sale Code created, the Customer Code would be the same, since the type of customer making the purchase has no impact on the income statement.

If your income statement reports sales by both customer and inventory, creating a matrix of sales codes that includes all combinations of customer and inventory codes will allow the system to operate properly.

 

After applying the Customer Codes and Item Codes to the system, the following results would occur.  For example, if a customer was assigned a Customer Code of ”001” and they purchased an item with an Item Code of ”DP1," the following Income Statement accounts would be affected.  In this example, the first segment (31000 - Department 001 Sales) indicates the item grouping while the second segment (001 - Customers from the northern region) is indicating the type of customer.