Collapse AllExpand All

12.1.1. Configure Inventory

To configure the Inventory module, go to Inventory > Setup > Configure > Inventory. The following screen will appear:

Configure Inventory module

When configuring the Inventory module, you are presented with the following options:

Defaults

Specify a default event fence:

Event Fence

Select a value between 0 and 999 using the arrows located to the right of the field. Indicates the event fence value that will appear by default whenever a new item site is created. The value is measured in days.

Post Item Site Changes to the Change Log

Select to post to the change log any changes made to Item Site masters.

Post Site Changes to the Change Log

Select to post to the change log any changes made to Site masters.

Enable Multiple Sites

Select to allow more than one site to be entered in the system. If multiple sites are not enabled, your system will be single site only. Users will be prevented from creating more than one site. If your system has multiple sites defined, this option will be hidden.

Transfer Order # Generation

If multiple sites are enabled, select one of the available transfer order number generation methods:

Automatic

Transfer order numbers will be automatically incremented by 1 each time a new transfer order is created. These automatically-generated numbers may not be edited. They are read-only.

Manual

Transfer order numbers must be entered manually whenever you create a new transfer order.

Automatic, Allow Override

Transfer order numbers will be automatically generated and incremented, as under the Automatic option described above. However, this option also allows you to manually override the transfer order number at the time of transfer order creation.

Next #

The next sequentially available transfer order number will display here. You may change the number—creating a new basis for the next transfer order number—by typing the new number into this field. Any changes you make here will be reflected the next time a new transfer order is created.

Default Transit Site

If multiple sites are enabled, specify the default transit site. The specified site will be pre-selected by default whenever transfer orders are entered.

Enable Lot/Serial Control

Select to enable lot/serial tracking capability in the system. If not selected, users will be prevented from creating item sites having either the lot or serial control method. Without the ability to create lot/serial item sites, the lot/serial tracking capability is disabled. If your system has lot/serial item sites defined, this option will be hidden.

Enable As-Of QOH Reporting

Select to add an As Of date option to the quantity on hand (QOH) report so that inventory quantities and values can be determined for any given date. If not selected, inventory values shown in the QOH report will always reflect current values.

Warning

You should only enable as-of QOH reporting during off hours, as this option may require extensive processing when it is run.

Prevent Negative Qty. Inventory

Select if you want to prevent inventory transactions from causing the QOH for item sites to go negative. If not selected, inventory transactions will be allowed to drive QOH negative.

Set default location while transacting location-controlled Items

Select if you want to allow users to set or change the default location for multiple location control (MLC) items while in the process of conducting transactions involving MLC items. If not selected, the default location will have to be set or changed on the item site record for each item.

Costing Methods Allowed

Select any or all of the available methods to value inventory transactions for an item site. If any item sites exist for a particular cost method, that cost method is disabled to prevent unselecting.

Average

Cost distributions for an item site is based on an average of all costs accumulated for the item site. The QOH of item sites defined with this cost method will not be allowed to go negative.

Standard

Cost distributions for an item site is based on the standard cost posted for the item.

Job

Cost distributions for an item site is based on actual accumulation of costs on a work order. This cost method is used exclusively by items with the Job item type.

When Posting a Count Tag for Avg. Cost Items

Specify how you want the inventory value of average costed items to be handled when posting count tags:

Use Standard Cost

Select if you want to use the item's standard cost when posting count tags. This option assumes you are maintaining standard costs for your average cost items.

Use Average cost

Select to use the item's average cost when posting count tags. If no prior average cost exists, the inventory value of a posted count tag will be $0.

Use Actual Cost if no Average Cost

Select to use the item's actual cost if no average cost exists when posting count tags. This option provides an alternate method for valuing inventory in the scenario where no prior average cost exists and also when standard costs are not in use.

When Count Tag Qty. exceeds Slip Qty

Select one of the following options for handling discrepancies in count quantities:

Post Difference to Default Location, if any

Select to post excess count tag quantity to an item's default location if the item's count tag quantity exceeds its count slip quantity. Applies only if a default location has been defined for the item. Default locations are defined for an item in the item site record.

Do Not Post Count Tag

Select to prevent count tag quantity from being posted if it exceeds the item's count slip quantity.

Note

By default, the system allows only one unposted count tag per item site. If an unposted count tag already exists for an item site, then an additional duplicate count tag may not be added.

Count Slip # Auditing

Select one of the following count slip number auditing methods:

Allow Duplications

Allows any count slip numbers to be used. Duplicate count slip numbers will also be allowed.

No Unposted Slip # Duplications within a site

Prevents duplicate unposted count slip numbers from existing within a given site. However, duplicate unposted count slip numbers may exist within multiple sites.

No Unposted Slip # Duplications

Prevents duplicate unposted count slip numbers from existing within multiple sites.

No Slip # Duplications within a site

Prevents duplicate count slip numbers from existing within a given site. However, duplicate count slip numbers may exist within multiple sites.

No Slip # Duplications

Prevents duplicate count slip numbers from existing within multiple sites.

Allow Inventory Receipt Cost Override (Average costing method only)

Select this option to enable cost overrides for average costed items at the point when inventory is received. If not selected, any unposted or uninvoiced receipts or PO returns against items previously received at an override cost value could be negatively affected.

To configure the inventory shipping and receiving options, select the Shipping and Receiving tab. The following screen will appear:

Configure Shipping and Receiving

When configuring shipping and receiving, you are presented with the following options:

Shipment # Generation

By default, shipment numbers are generated automatically.

Next #

Enter the next shipment number to be used. The system assigns shipment numbers to sales order line item quantities when stock is issued to shipping. All stock at shipping for an individual sales order is assigned the same shipment number. If no stock is already at shipping, then a new shipment number will be used.

Kit Components Inherit COS from Kit Parent

Select if you want the components of kit items to inherit the same cost of sales (COS) account used by the parent kit item. If not selected, the kit components will use the COS accounts defined in their respective sales account assignments.

Disallow Purchase Order Receipt of Qty greater than ordered

Select to ensure the maximum receiving quantity does not exceed the quantity ordered. If selected, the system will prevent users from receiving more purchase order line item quantity than the quantity ordered. Not selecting this option means users will be allowed to receive quantity in excess of the quantity ordered.

Warn if Purchase Order Receipt Qty differs from receivable Qty

Select to generate a warning message if the entered quantity to receive does not match the quantity remaining to be received. The warning message will alert users that a difference exists. However, it will not prevent users from continuing.

By the following amount:

Specify the percentage difference between receipt quantity and receivable quantity which when reached should trigger a warning message.

Record Purchase Price Variance on Receipt

If selected, purchase price variances (PPV) will be recorded when purchase order receipts are posted. This option applies to standard costed items. If not selected, then the default system behavior will be in effect—that is, PPV will be recorded when vouchers are posted. It's technically possible (although unlikely) for PPV be recorded both at receipt and at voucher time. This situation would occur if and only if the vouchered cost is different from the purchase order cost. For the PPV to be recorded twice, the following conditions would have to exist: First, there would have to be a difference between purchase order price and an item's standard cost, and, second, there would also have to be a difference between the purchase order price and the vouchered price.

Default Shipping Form Copies

Indicate the number of shipping form copies you want to print by default:

# of Copies

Specify the number of copies you want to print. To add a watermark or show/hide prices on the printed form, double-click on a copy line.

Update item's Actual Cost on Receipt

Select if you want the actual cost for a purchase order item to be updated when that item is received. This feature complements and does not replace the standard process, whereby a received item's actual cost is updated at the point when a voucher for that item is posted.

Add Eligible S/O's to Packing List Batch on Receipt

Select if you want sales orders linked to purchase orders to be automatically added to the packing list batch when line items on the purchase order are received.