Settings Page

<< Click to Display Table of Contents >>

Navigation:  Master Records > Inventory Type > Set Up Inventory Type Record >

Settings Page

Previous pageReturn to chapter overviewNext page

 

The Settings Page allows you to set, review and amend a variety of parameters that you want to be the default in the inventory item records to which this inventory type record will be applied.  In this page, you can enter a variety of basic information about the inventory item that is usually the same for all or most of the inventory items assigned this inventory type.

 

 

To set up the settings and general parameters for this inventory type in this page, perform the following procedures:

 

1.Define the settings for recording inventory items of this type by choosing or entering values in the following fields:

 

oStatus

Click the List box button in this field to specify a default status for the inventory items to which you will assign this inventory type.  The inventory type can either be Active or Inactive.

 

notes_c

Note:  You cannot add inventory items with inactive status to a purchase order, sales invoice, sales order or RMA transaction.  Purchase orders, purchase quotes, sales invoices, sales orders and sales quotes and RMA transactions created before an inventory item is made inactive can still be edited and shipped even after the inventory item’s status is changed to inactive.

 

oWeight

Enter in this field, the default shipping weight for inventory items of this type.  The inventory item’s shipping weight can be used by the system, in conjunction with freight codes that apply freight charges by weight.  Leave this field blank if you want to apply freight charges based on something other than shipping weight.

 

oQuantity Decimal

Click the spinner button beside this field to choose the default decimal places (0-4) that the system will use in quantity values for inventory items of this type.  The default value comes from the General tab of the IC Module Setup function. If you enter a number of decimal places other than zero, the decimal point and the decimal places will decrease the space for the whole number portion of the quantity.

 

oCost Method

Click the List box button and choose the cost method that you want to use in valuing inventory items of this type.  The cost method specified in the IC Module Setup function is the default for new inventory type records. Change the cost method, if necessary.  If the IC module is not activated, users can only use Average for the cost method. If the Activate IFRS Features checkbox is marked in Company Setup, the LIFO cost method will be unavailable.

 

notes_c

Note:  If you must change the cost method after saving the inventory type record, you cannot make the change in the Inventory Type Maintenance > Cost Method field; use the Change Inventory Cost Method function instead.

 

2.To set up the default price and applicable cost values of inventory items of this type, enter values in the following fields:

 

oCurrent Cost

This read-only field shows the item's unit cost as recorded in the system.

 

oStandard Cost

Enter in this field the default standard cost to be applied to inventory items of this type. The standard cost will be used as a basis in updating other costs and prices for this item through the Inventory Cost Update and Inventory Price Update functions of the Inventory Control module. It is also the cost that is used when receiving items through warehouse transfers and recording finished jobs when the Inventory Control and Manufacturing modules are activated, respectively.

 

oReturn Cost

Enter in the field the estimated default cost of one returned unit from customers that will be added back to inventory. The default per unit cost can be overwritten at the time of the specific return if you determine a more appropriate or accurate cost.  This is often hard to do, especially if much time has elapsed, if the original cost was set using LIFO, FIFO or Specific ID, or if the returned units are to be devalued due to their used condition. However, if their condition approximates that of new units, you may want to use the current (weighted) Average Cost per unit as the return cost.  You can update the Return Cost on a regular basis to reflect current costs.

 

oUse Checkbox

Mark this checkbox if you want to configure AccountMate to use the specific cost as follows:

Average Cost

Last Received Cost

 

oList Price

Enter in this field, the basic price that you will quote to sell a unit of an inventory item of this type.  The unit price may contain zero up to four decimal places.

 

oMaximum Discount

Enter in this field, the default maximum sales discount rate that you can offer for inventory items of this type.

 

oCommission

Enter in this field, the applicable commission code if you want to grant commission to sales people on sale of inventory items of this type.

 

3.Set up the restocking values of an inventory item using this type by entering values on the following fields:

 

oRepair Charge

Enter in this field, the value that you will charge the customer when an inventory item of this type is returned for repair. This field does not accept a negative value and is enabled only if you have installed and activated the Return Authorization module. The value you enter in this field will be used in RMA transactions in calculating the repair charges if the return code includes a repair action.

 

oMinimum Restocking Amount

This field will be enabled only if you install and activate the Return Authorization module. Enter in this field the default minimum restocking amount to be used in the RMA transaction involving inventory items of this type if restocking charges are allowed.

 

oRestocking

This field will be enabled only if you install and activate the Return Authorization module. Enter in this field, the default percentage rate that will be applied to the RMA transaction involving inventory items of this type if restocking charges are allowed for the returned items. The system will apply the restocking rate to the total extended price of the returned items to compute for the restocking charge.

 

4.If the Revenue Amortization feature is activated, the settings in the Revenue Amortization area is accessible. Select the default revenue amortization settings for the inventory records to which this inventory type is applied:

 

oAmortize

Mark the Amortize checkbox to configure the system to mark this setting by default in the inventory item records assigned with this inventory type code; otherwise, leave the checkbox unmarked. Note that marking this checkbox will activate the succeeding settings in this area.

 

oMethod

Click the List box button beside the Method field, and choose between the following amortization options:

 

Straight-line

Choose this option to configure AccountMate to amortize in equal amounts over a period of time the inventory item assigned with this type.

 

Specific

Choose this option to configure AccountMate to amortize based upon specific user-defined parameters the inventory item assigned with this type.

 

oAmortization Frequency

Accept or amend the default amortization frequency by clicking the List box beside the Amortization Frequency field and choose one of the following options:

Weekly

Monthly

Bimonthly

Quarterly

Semi-Annually

Annually

 

oNo. of Cycles

Enter in the No. of Cycles field the number of times you allow users to amortize. You may enter a number from 1 through 9999.

 

5.If the inventory type is for a serialized item, select the appropriate settings in the Serialized Item area:

 

oUse Serial #

Mark this checkbox  if you want the system to require usage of serial numbers for each unit of this inventory item. This checkbox is automatically marked and disabled if the item cost method selected is Specific ID.

 

oPre-assign Serial Number

This checkbox is enabled only if the Use Serial # checkbox above is marked. Mark this option if you want the system to require usage of serial numbers for the units of an inventory item of this type for tracking purposes.

 

oPrint Serial # on Invoice

This checkbox is enabled only if the Use Serial # option above is marked. Mark this checkbox if you want to enable printing of serial numbers on the sales invoice; otherwise, leave it unmarked.

 

6.In the Lot Control area, complete the following option boxes if the inventory type is for a lot controlled inventory item:

 

oUse Lot #

Mark this option box if you want the system to require usage of lot numbers for the units of an inventory item of this type for tracking purposes.

 

oPrint Lot # on Invoice

Mark this option box if you want to print lot numbers on sales invoices when units of the inventory item of this type are being billed to your customers. This field is accessible only when you mark the Use Lot # option box.

 

oCheck Minimum Shelf Life

Mark this checkbox if you want to define the lot item's shelf life. Once this checkbox is marked, be sure to specify the lot item's shelf life in the fields below.

 

oMinimum Days to Sell

Enter in this field the amount of time (in days) a lot-controlled item must be sold before it expires. This field is enabled after marking the Check Minimum Shelf Life checkbox.

 

oMinimum Days to Use

Enter in this field the amount of time (in days) a lot-controlled item may be held in inventory before it expires. This field is enabled after marking the Check Minimum Shelf Life checkbox.

 

notes_c

Notes:  

The options above are only available when you have the Inventory Control and Lot Control modules installed and activated.

You can no longer change the settings for the Use Lot # checkbox once you have saved this record.

 

7.In the Kitting Area, select the default options for kit inventory items assigned this type:

 

oKit Item

Mark this option box if you want inventory items of this type to be tagged as kit inventory items; otherwise, leave it blank.

 

oRequire Prebuild

Mark this option box if you want the system to require that kit inventory items be built before shipping to customers; otherwise, leave it blank. This field is accessible only when you have activated the Kit Item option.

 

oUse Kit #

This option is accessible only if you put a check mark in the Kit Item field. Mark this option box if you want inventory items of this type to require assignment of kit numbers that you can use for tracking purposes; otherwise, leave it blank.

 

oPrint Kit # on Invoice

Mark this option box if you want to print kit numbers on sales invoices when units of the inventory item of this type are being billed to your customers. This option is accessible only if you mark the Kit Item option box above.

 

oCustomizable

Mark this checkbox if you want to customize the kit formula for kit items of this type during creation of sales orders. This checkbox is enabled if the Kit Item checkbox is marked.

 

notes_c

Note:  You cannot assign a drop ship warehouse for a kit inventory item (i.e., when the Kit Item checkbox is marked).

 

8.In the Inventory Specification area, mark the following checkbox when applicable:

 

oUse Specification

Mark the Use Specification checkbox if you want to mark by default the Use Specification option in the inventory item record assigned this type. The Specification area is enabled only if you have activated the Item Specification module.

 

notes_c

Note:  You can no longer change the settings for the Use Specification checkbox once you have saved this record.

 

9.If applicable, mark the different option boxes in the General area of this page. The settings that you specify here will become the default settings on inventory records assigned with this inventory type record:

 

oUpdate On-hand Quantity

Mark this checkbox to automatically update the on-hand quantity of this inventory item when you create a transaction that increases or decreases its on-hand quantity. This option is inaccessible and unmarked if you created a kit item not requiring prebuild. This option is recommended for physical inventory items for automatic updating of on-hand quantities. For a serialized item (i.e., the Specific ID cost method is assigned), it is required to update the on-hand quantity; thus, this checkbox is automatically marked and inaccessible.

 

oCheck On-hand Quantity

Activate this checkbox if you want the system to verify whether the available quantity sufficiently covers the quantity ordered by or invoiced to customers for the inventory items of this type. If the available quantity is less than the ordered quantity, the system will display a warning message informing you that the inventory item has insufficient quantity. You may suppress this feature if the inventory item is not carried in stock and is obtained only as needed. This checkbox is unmarked and inaccessible if you unmarked the Update On-hand checkbox or created a kit inventory item not requiring prebuild.

 

notes_c

Note:  It is recommended that no shipments be made for inventory items with zero on-hand quantities. If the on-hand quantity reaches zero, the cost of additional units shipped will be recorded at the last average per unit cost. When the inventory item quantity increases later due to receipts, replacements, or adjustments, the negative quantity and amount resulting from the “over shipment” will be offset against the additions to inventory. The difference between the cost of the shipped inventory items and the subsequent increase in the inventory item quantity is automatically posted to the GL Account ID entered in the Cost Variances field in the GL Account Selection function. You can generate the Inventory Adjustment Report to view these adjustments.

 

oAllow Negative On-hand Quantity

Mark this checkbox to allow transactions that result in negative on-hand quantity of the inventory items to which this type is applied.

 

oAllow Negative Price

Mark this checkbox if you want to allow entry of negative prices when entering sales order and other sales transactions for inventory items assigned this type. This allows you to enter line item adjustments to the price of the inventory item on sales orders and other documents (e.g. when the inventory item is on sale at an extra 20% discount to all customers).

 

oAllow Negative Quantity on Invoice

Mark this checkbox if you will allow entering a negative quantity for inventory items assigned this inventory type on sales invoices and sales returns recorded through the Accounts Receivable module.  You cannot enter a negative quantity on a sales order, sales quote or purchase order.  This option is inaccessible if you select the Specific ID or Average with SN cost method and/or if you activate the Lot Control and/or Kit Item options in this tab.  You can use this feature to record allowances, exchanges or adjustments.  Though you cannot enter a negative price, a negative number of units multiplied by a positive price will equal a negative sales value.

 

notes_c

Note:  It is acceptable to have negative amount for your AR invoice line items as long as the net sales invoice amount is not negative. On the other hand, the net amount on a sales return should always be negative.

 

oAllow Discard

This checkbox is enabled if the Return Authorization module is installed and activated. Mark this checkbox to allow discarding of returned inventory items of this type. If you deactivate this option, you cannot select a return code that includes a Discard Action for this item in the RMA or RTV transaction.

 

oAllow Repair

This checkbox is enabled if the Return Authorization module is installed and activated. Mark this checkbox to allow repairs of returned inventory items of this type. If you do not use this option, you cannot select a return code that includes a Repair Action for this item in the RMA or RTV transaction.

 

oTaxable

Mark this checkbox if you want inventory items of this type to be taxable when sold; otherwise, leave this checkbox blank.  If you activate this option, the tax rate applied to this inventory item will depend on the tax code assigned to the customer’s address to where it will be shipped.  

 

caution_c1

If you do not activate this option or do not mark the Taxable checkbox, the item will not be taxable even if the shipping address has a tax code assigned to it..

 

oGST Taxable

For companies with Canada country tax, mark this checkbox if you want to apply goods and services tax (GST) to the inventory item; otherwise, leave this unmarked. The default setting comes from the inventory type code entered in the Inventory Type field. You may mark or unmark this checkbox anytime.

 

oPST Taxable

For companies with Canada country tax, mark this checkbox if you want to apply provincial sales tax (PST) to the inventory item; otherwise, leave this checkbox unmarked. The default setting comes from the inventory type code entered in the Inventory Type field. You may mark or unmark this checkbox anytime.

 

10.In the Allow Overwrite area, select the default overwrite settings for the inventory records to which this inventory type is applied:

 

oDescription

Mark this option box if you want the system to allow you to overwrite the description of inventory items of this type when creating purchase orders, sales orders, sales quotes and sales invoices; otherwise, leave it blank. Overwriting a description allows you to customize the description; however, this lessens control over its accuracy.

 

oPrice

Mark this option box if you want to overwrite the price of inventory items of this type when creating sales invoices, sales quotes and sales orders; otherwise, leave it blank. Overwriting prices allows you to be competitive in adjusting prices for particular customers, but weakens control over when, for whom and by how much, prices are changed.

 

oDiscount

Mark this option box if you want to overwrite the discount percentage rate of an inventory item of this type when creating sales invoices, sales quotes and sales orders; otherwise, leave it blank. Overwriting discount rates allows you to be competitive in adjusting discounts for particular customers at particular times, but weakens control over when, for whom and by how much, discounts are changed.

 

notes_c

Note:  When recording purchase order transactions, you can overwrite the purchase discount regardless of whether this same option in the inventory item record is marked or not.

 

oTax Status

Mark this checkbox if you want to adjust the tax status when creating sales invoices, quotes and orders of inventory items of this type; otherwise, leave it blank. Overwriting the inventory item’s tax status allows you to adjust its taxability on sales invoices and sales orders to meet certain conditions.

 

oWeight

Mark this option box if you want to overwrite the shipping weight of inventory items of this type when creating sales invoices, sales quotes and sales orders; otherwise, leave it blank. Overwriting the inventory item’s shipping weight on sales invoices and sales orders allows you to correct the weight when packaging combinations of inventory items or using different packaging materials that add to the item weight.

 

oRevenue Code

Mark this option box if you want to overwrite the revenue code of the inventory item of this type when creating sales invoices, sales quotes and sales orders; otherwise, leave it blank. Overwriting revenue codes allows you to apply the revenue to more appropriate accounts when necessary, but lessens your control over the accuracy of those choices. The code you enter in this field applies a set of default revenue and cost of sales accounts to the inventory item to which this type is assigned.

 

oCommission

Mark this checkbox if you want to amend the commission code when you create sales order or sales invoices for inventory items of this type.

 

 

 

See Also

Set Up Inventory Type Record

Information Page

Warehouse Page

Remarks Page

GL Accounts Page

 

 

 

 

 

© 2023 AccountMate Software Corporation