Inventory Management Options

Select this check box if your company has several warehouses or other locations (such as stores or departments) for which you require separate general ledger posting and/or reporting. Clear this check box if your company does not track inventory by warehouse or location.

If this check box is selected, use Warehouse Code Maintenance to assign a warehouse code, description, address, and subaccount for the segment to be substituted for each warehouse.

If this check box is cleared, you must enter information for the default warehouse code (the only warehouse for your company) in Warehouse Code Maintenance. The default warehouse code cannot be deleted, but you can access the record at any time to change the description, address, and the post-to subaccount.

Select this check box if each warehouse reorders separately. Clear this check box if reordering will be performed from a central location. This check box is available only if the Require Multiple Warehouses check box is selected.

Enter a warehouse code to be used as the default warehouse code for inventory transactions, or click the Lookup button to list all warehouse codes. This code normally identifies your main warehouse. This field is available only if the Require Multiple Warehouses check box is selected.

Select the account segment description that represents the segment that is substituted when posting inventory transactions by warehouse. A substituted account is defined by selecting a main segment and the segment associated with the warehouse. Segment substitution allows you to post inventory transactions to a substituted account based on an inventory item’s warehouse. For more information, see Setting Up Segment Substitution for Inventory Management by Warehouse.

Descriptions of subaccount segments that appear in this field are defined in Account Structure Maintenance. Select None to post all inventory transactions to one general ledger account, regardless of the warehouse. The selection in this field determines the subaccount that can be entered in the Post to field in Warehouse Code Maintenance.

If you select a segment in this field, and a subaccount is already defined for a warehouse location in the Post to field in Warehouse Code Maintenance, a message appears indicating that all subaccounts will be removed from Warehouse Code Maintenance.

This field is available only if the Require Multiple Warehouses check box is selected.

Select this check box to record any items transferred out of a warehouse as a quantity issued for the item history. Clear this check box if you do not want to record transfers as issues. Tracking transfers as issues affects the turnover information calculated on the Inventory Turnover Report.

Select this check box to set the commission rate by item. Clear this check box to use the standard commission rate for each salesperson established in the Accounts Receivable module. If this check box is selected, you can enter detailed commission information for each item in inventory, and the commission rate will print as zero on the Salesperson Commission Report. This check box cannot be cleared unless None or Standard is selected in the Calculation field in Product Line Maintenance.

Select the method used to calculate the quantity available.

Due to the differences in vendor lead-times from business to business, the quantity on purchase orders can be used when calculating the quantity available. Similarly, due to the differences in manufacturing lead-times, quantity on work orders can be used in the quantity available calculation. The quantity available is determined using the following calculation:

(Quantity on Hand + Quantity on Purchase Order + Quantity on Work Order) - (Quantity on Sales Order + Quantity on Back Order + Quantity Required for Work Order)

This calculation is used for printing the quantity available on Inventory Management reports and on reports produced by the Bill of Materials module.

Note Changing this option results in a message prompt to recalculate the item balance and history information. For more information, see Recalculate Item Balance and History.

This field is used in conjunction with the Current Inventory Period field to differentiate between the current year and a future year. If Fiscal Periods is selected in the Base Inventory Periods On field, click the Lookup button to list all years defined in Fiscal Year Maintenance.

Select the current inventory period. This field defaults to the current general ledger accounting period.

This field is used in conjunction with the Current Calendar Year/Current Fiscal Year field to differentiate between the current period and a future period. When Inventory Management period end is processed, this field is incremented automatically. This field is independent of the General Ledger module, and performing General Ledger period-end processing does not increment this period.

Select this check box to enable warranty tracking. If this check box is selected, Warranty Code Maintenance is available, warranty codes can be assigned to item codes, and expiration dates are calculated for warranty items.

Note The Warranty Code field in Item Inquiry is available only if this check box is selected.

Select this check box to integrate the Inventory Management module with General Ledger. Clear this check box if you do not want general ledger postings from the Inventory Management module to update to General Ledger or post to the General Ledger Posting Recap.

Note This field is not available for Sage 100 Premium.

Select this check box to integrate the Inventory Management module with Job Cost. Clear this check box if you do not want to integrate the Inventory Management module with Job Cost. When these modules are integrated, inventory items can be issued directly to jobs. You can also designate distribution to specific job numbers and cost codes.

Type a description for each inventory category. Categories are user-defined sort fields that can be used to sort information on inventory reports. Information can be sorted by criteria such as shelf life, physical size, color, or catalog number. Categories can also be used to select specific items for label printing or a physical count worksheet.

Each description entered here appears as a field name on the Item Maintenance Additional tab. As you establish the record for each item, you can enter specific data. For example, if Category 1 is defined as Color, you might enter colors, such as Black, Red, and White in that field for each item. If you leave a Category Description field blank during this setup, that sort field is not available.

Select this check box to record additions to an item in detailed format. The Item Audit Report lists all new additions to an item. Clear this check box to record additions in summary format. The Item Audit Report lists additions as they appear in their old and new format. This check box is available only if an option other than None is selected in the Item Changes to Track field.

This field indicates that batch processing is available for Transaction Entry and can only be viewed.

Select this check box to enable batch entry for Transaction Entry. Clear this check box if you do not want to allow batch processing.

Type the next batch number to be assigned when using the batch processing feature in Transaction Entry. You can type numeric or alphanumeric characters. This field is available only if the Allow Batch Entry check box is selected.

Enter....	If....
00001	you want the next batch number assigned to be 00001.
A0005	you want the next batch number assigned to be A0005.

Type the next sales entry number to be assigned when the Next Number button is clicked in Transaction Entry . You can type alphanumeric and special characters.

Type the next issue entry number to be assigned when the Next Number button is clicked in Transaction Entry. You can type alphanumeric and special characters.

Type the next transfer entry number to be assigned when the Next Number button is clicked in Transaction Entry. You can type alphanumeric and special characters.

Type the next adjustment entry number to be assigned when the Next Number button is clicked in Transaction Entry. You can type alphanumeric and special characters.

Type the next receipt entry number to be assigned when the Next Number button is clicked in Transaction Entry. You can type alphanumeric and special characters.

Type the next count card number to be assigned when the Next Number button is clicked in Count Card Entry. You can type alphanumeric characters. The next count card number can also be entered in the Default Values for Count Card Entry window; if the number is changed in that window, it will be updated in this task.

Select the default unit of measure to be used in Count Card Entry; this should be the unit of measure used when counting inventory. The default unit of measure can also be selected in the Default Values for Count Card Entry window; the option selected in that window will take precedent over the option selected in this task.

Note Receipt labels print only for items received that are set up for labels in Item Maintenance.