I/C Categories Screen

Open Inventory Control > I/C Setup > Categories.

Enter a code of up to six characters to identify this category of inventory item. You can use letters and numbers in category codes.

Enter a description for the category.

If you use Sage 300 Order Entry and want to allow commissions to be earned on the sale of items in the category, select this option.

If you do not select this option and specify a maximum commission rate, Order Entry will not record commissions for the sales of items that use the category.

You can select or clear the Allow Commissions option at any time.

Enter a code or use the Finder to select the price list code (pricing method) you want to assign to the category.

When you later select a category while adding an item record, the category's price list code is included automatically. (You can override this price list code when you add an item record.)

For each category, you must enter general ledger account numbers for the five following accounts (Sage 300 Order Entry uses the Sales account, Returns account, and Damaged Goods account—Inventory Control does not use them):

  • Sales. A revenue account which Order Entry credits with the revenue from goods sold.
  • Returns. A revenue contra account which Order Entry debits to record the reduction of revenue caused when previously sold goods are returned or credit notes are issued.
  • Cost of Goods Sold. An expense account which Inventory Control automatically debits with the cost of goods sold, and credits with the cost of goods returned.
  • Cost Variance. An expense account in which Inventory Control records the cost variance between the actual cost and either the standard cost (for items using the standard costing method) or the most recent cost (for items using the most recent costing method) of inventory items sold.
  • Damaged Goods. A revenue contra account that is debited instead of Sales Returns whenever goods are returned as damaged in Order Entry.
  • Internal Usage. The default expense or asset account that is debited when an item in this category is used internally. You can override this account when you enter transactions.
  • If you use Sage 300 General Ledger with your Inventory Control database, you can use the Finder to select general ledger accounts.
  • Click the Finder icon or press F5 to display a list of general ledger account numbers. Highlight the account you want, then press Enter to select it.

Select this option if you do not want to assign this category to any inventory items.

If you make a category inactive, you can no longer assign it to item records. You also cannot save changes to item records that use the inactive category, unless you first assign the records to an active category.

You would primarily use the option when you decide to delete a category, and want to ensure no further inventory records are assigned to it.

You can change the option from Inactive to Active at any time.

This is an information field in which Inventory Control automatically inserts the date of the last change made to the record. You do not fill in this field.

This field appears only if you selected the Allow Commissions option for the category.

Enter the commission rate (as a percentage of sales or margin) to be paid to a salesperson.

  • This rate is used by Sage 300 Order Entry for commissions unless it is 0.0000.
  • If this rate is zero, Order Entry will use the salespersons' rates specified in the Salesperson Commission Rates screen in the Order Entry program.

Note also the following points concerning sales commissions in Order Entry:

If you choose the Track Commissions option on the Options screen in Order Entry, the Order Entry program will:

  • Base commissions on the sales or margin amount, depending on your choice in the Order Entry Options screen.
  • Uses the costing information in Inventory Control to determine margins for commission calculations.
  • Uses the rates specified for the item categories in Inventory Control unless the category commission rates in Inventory Control are zero.
  • Uses the salespersons' rates specified in the Salesperson Commission Rates screen if the commission rates in Inventory Control categories are zero.

Enter the tax class number or select the numbers of the tax classes you want to assign to the category for purchases for each selected tax authority. (You can override this purchase tax class for items you assign to this category.)

Enter a tax class or select the numbers of the tax classes you want to assign to the category for sales for each selected tax authority. (You can override this sales tax class for items you assign to this category.)

Use the Finder to select the taxing authorities you want to assign to the category. (You define taxing authorities in the Tax Services feature in Common Services.)

Overview

You use the I/C Categories screen to:

Note: You must add at least one category to Inventory Control before you can add item records.

Options Tab

Use the Options tab on the Categories screen to:

Taxes Tab

The Taxes tab appears on your screen only if you have activated Tax Services for your Inventory Control company.

Use the fields on this tab to specify the tax authorities and associated sales and purchase tax classes that apply to items in the category.