Product Warehouse Control (ICWM_IM13)

The following list defines every field available in the product warehouse control (icwm) table in alphabetical order:

• Bin Location - identifies the primary location of the product in the warehouse. This code can be a maximum of 8 alpha-numeric characters in length.

  When following the standard set up, the main warehouse has two bin location codes: the primary location (entered in this field) and the secondary location; and the secondary warehouse(s) has only one bin location code: the primary location (entered in this field).

  If you are using the multi-bin warehouse feature, the Bin Location (and Secondary Location) field is unavailable. Products in a multi-bin warehouse are assigned to locations using a separate sub-system.

  • When the Picking Sequence Flag on the Order Entry folder in Company Control Initialization (ibis_CC00/Order Entry)is set to L (Location), the detail lines on the Picking Slip will be sorted by the bin location.

  Note: The primary and secondary bin locations may be listed on various reports, including Inventory Evaluation Print (ibis_ic81).

• Company - the company field is available when you create a new record. The company defaults to the company assigned to your user id in the Session Parameters view. You can change the default company during the creation process only. Once the record is created, the company to which the record is associated displays in the General section (at the top of the view).

• Created On - displays the name of the user who created the record you are viewing or maintaining. May not be overridden.

• Created By - displays the date on which the record that you are creating or maintaining was created. May not be overridden. May also represent the creation date of the records you are attempting to retrieve.

• Future Order Quantity - displays the quantity on all future dated sales orders that are so far in the future that they do not impact the reorder (purchasing) process. Creating future dated orders increases the quantity in the Future Order Quantity field. As these orders are filled, the future order quantity decreases.
  • Sales orders are determined to be future orders if the Required Date is greater than the order date plus the No. of Days for Future Order defined in CC00/Order Entry plus the Lead Time for the product. The sales order is a future order but is beyond the product's lead time.

  • If you are using Order Management, sales orders are future orders if the Earliest Receipt Date of the order is greater than the order date plus the No. of Days for Future Order defined in CC00/Order Entry plus the Lead Time for the product.

• Future Order Reserves - displays the quantity on all future dated sales orders that are in the near future so they do impact the reorder (purchasing) process. Creating future dated orders increases the quantity in the Future Order Reserve field. As these orders are filled, the future order reserve quantity decreases.
  • Sales orders are determined to be future orders if the Required Date is greater than the order date plus the No. of Days for Future Order defined in CC00/Order Entry. The sales order is a future order but is within the product's lead time.

  • If you are using Order Management, sales orders are future orders if the Earliest Receipt Date is greater than the order date plus the No. of Days for Future Order defined in CC00/Order Entry.

• In Transit Units - displays the quantity of the product that is in transit from the supplier. The in transit quantity increase when stock is flagged as in transit in P/O Receipt and In Transit Entry (ibis_po60). The quantity in this field decreases when stock flagged as in transit is received in P/O In Transit Receiving Entry (ibis_po63).

• Last Physical Count Date - displays the date of the last physical inventory count for the product/warehouse record.

• Latest Cost - displays the current latest cost of the product/warehouse record. For additional details, please contact your TECSYS SMB Professional Service representative.

• Line Point - represents the inventory level that triggers a purchase order if a supplier is on cyclical review (i.e. cycle in days is set for the supplier in P/O Suppliers (ibis_po11). The line point inventory level is greater than the reorder point level by the quantity forecast during the review cycle. The line point value can be manually entered and maintained or can be calculated and reset automatically using the Purchasing, Forecast and Lead Time Recalculation (ibis_po25) and Purchasing Recalculation Print (ibis_po26) process.

• Maximum Unit Quantity - represents the desired maximum stock level. The maximum quantity can be manually entered and maintained or once the product has accumulated sufficient history, the maximum quantity can be calculated and reset using the PO25/26 process. The maximum quantity cannot be less than the safety stock/minimum quantity for the product.
  • The automatic recalculation of the maximum quantity for a product by the PO25/26 process maybe be prevented by disabling the Recalculate Maximum field in P/O Criteria (ibis_po_pc.po09).

  • The maximum quantity value is used by the ROQ Order Up To Maximum method (Re-Order Quantity). The Method of ROQ Calculation is set in P/O Criteria (ibis_po_pc.po09).

• Modification Counter - this field is not maintainable. The date and time the record was last modified.

• Modified By - this field is not maintainable. The user or system process that last modified the record.

• Modified On - this field is not maintainable. The date on which the record was last modified.

• Movement Counter - this field is used by an internal file only. The counter is used to track the movement of the product in the warehouse.

• MultiBin Replenishment Max - this field is available only when a multibin warehouse is entered in the warehouse field. The replenishment maximum is the desired maximum stock level for the product in the pick area of the warehouse. The Multibin Warehouse Suggested Putaway and Replenishment Print (ibis_wh81) program uses this entry to automatically invoke the replenishment of bins.

• MultiBin Replenishment Point - this field is available only when a multibin warehouse is entered in the warehouse field. The replenishment point is the point at which additional product needs to be added to the primary location or pick area for the product.

• OM Allocated Quantity - displays the Order Management allocated quantity of the product for the current warehouse.

• On Backorder - the on backorder quantity is the difference between the sales order quantity and the available quantity. The on backorder quantity increases when the order quantity is greater than the available quantity. When stock is received and released to back orders, the on backorder quantity decreases.
  • Note: The on backorder field includes the back ordered quantity from estimate orders.

• On Hand - the on hand quantity is equal to the physical inventory count of the product if there are no outstanding sales orders (i.e. sales orders filled but not invoiced). Stock receipts and credit notes increase the quantity on hand and invoice scheduling decreases the quantity on hand. Inventory adjustments and physical counts also update the on hand quantity.

• On Order Units - the quantity (in units) on purchase orders with the supplier. The on order quantity increases with POs and decreases as stock is flagged as in-transit and when the stock is received in P/O Receipt and In Transit Entry (ibis_po60).

• On Reserve - the on reserve quantity is the shippable quantity on all outstanding sales orders (including estimate orders), direct bills and credit notes. The on reserve balance decreases when the order is invoiced and scheduled.

• Opening Balance - the opening balance is also referred to as the available balance. The available balance is determined as follows:

  Available = On Hand - On Backorder - On Reserve - WO Reserve

  When order management is on, the available quantity is determined as follows:

  Available = On Hand - On Docs - Allocated Qty

  (Where On Docs are sales orders with SDNs, credits and directs bills and where the Allocated Qty is from stock only.)

• PO Movement Counter - this field is used by an internal file only. The counter is used to track the PO movement of the product.

• Primary Warehouse - a value of Yes indicates that the warehouse is the primary warehouse. This field is automatically set to Yes for the warehouse defined as a main warehouse in CC00/Inventory Control.
  • A value of No indicates that the warehouse is a secondary warehouse. Secondary warehouses are usually only single-bin, unless the secondary warehouse is set up as a multibin warehouse in CC00/Multi-Bin Warehouse.

• Product - enter the product code. This field is validated against the products (ibis_ici1.im13) table.

• Production Accumulated Qty - this field is used for work orders. For additional details, please contact your TECSYS SMB Professional Service representative.

• Production Planned Qty - this field is used for work orders. For additional details, please contact your TECSYS SMB Professional Service representative.

• Purchase Hold - applies to lot/serial controlled products only. The quantity represents the portion of current on hand stock that is not to be considered in the reorder process because a serial number or lot has been put on hold. Quantity available as calculated by the purchasing module is reduced by this quantity. For more details on the purchase hold, see the Product Holds (ibis_im98) help topic.

• Qty Intransit Allocated to Orders - stock that is pre-allocated using Order Preallocation Entry (ibis_oe40). Note: This field is not used with order management.

• Quantity on Shipping Documents - this field is used with order management. For additional details, please contact your TECSYS SMB Professional Service representative.

• Reorder Point - represents the quantity at which re-purchasing should occur. The reorder point can be manually entered and maintained or once the product has accumulated sufficient history, the reorder point value may be calculated and reset automatically using PO25/PO26.
  • When the automatic purchase order generation routines are running, any product with a net available quantity below the reorder point (also known as the order point) will trigger a purchase order.

  • When printing the P/O Reorder Print (ibis_po20), the report may optionally be restricted to printing only those products whose quantity available has fallen below the reorder point (ROP), which highlights products that require immediate purchasing attention.

• Reorder Quantity - represents the suggested order quantity. The reorder quantity can be manually entered and maintained or the reorder quantity can be calculated and reset automatically using PO25/PO26.
  • Reorder quantities are calculated based on a combination of the purchase criteria (from P/O Purchasing Information (ibis_popi.po13)) and the forecast usage. Both values can be calculated by the PO25/PO26 process; the P/O Forecast Calculations (ibis_po07) and P/O Criteria (ibis_po_pc.po09) are maintained in order to define how forecast and purchase criteria are calculated by the process.

  • The reorder quantity is a value reported on the P/O Reorder Print (ibis_po20) report.

• Safety Stock / Minimum Qty - represents the minimum desired stock level. The safety stock/minimum quantity can be manually entered and maintained or once the product has accumulated sufficient history, the minimum quantity can be calculated and reset automatically using the PO25/26 process. The minimum quantity cannot be greater than the maximum unit quantity for the product.
  • The minimum quantity is equivalent to the safety stock level. This value prints on the P/O Reorder Print (ibis_po20) report. Additionally, this value is used by the stock depletion test performed during order entry and invoicing. If the order quantity entered will deplete the stock level to 50% of its minimum quantity, a warning will be given to the operator (for products within the class code range specified).

  • Note: All products require a safety stock level. During normal operations, safety stock is not used to fill orders; it is purchased as insurance against the possibility of unanticipated demand, abnormally long lead times, transportation strikes, etc. Sufficient safety stock levels should be maintained to prevent stock-out costs (i.e. the cost of "lost" sales); however, safety stock levels should not be so high that inventory carrying costs are over-burdened.

• Secondary Location - identifies an alternative location of a product within the main warehouse only. This code can be a maximum of eight alpha-numeric characters in length.
  • The Secondary location is most commonly the 'overflow' stock area in the Warehouse.

  Note: The primary and secondary bin locations may be listed on various reports, including Inventory Evaluation Print (ibis_ic81).

• Selling Hold - applies to lot/serial controlled products only. The quantity represents the portion of current on hand stock that is not available for sale because a serial number or lot has been put on hold. Quantity available is reduced by this value. For more details on selling holds, please see the Product Holds (ibis_im98) help topic.

• Unit Monthly Forecast - stores the monthly forecast usage (in SKU's). The value can be manually entered and maintained or once the product has accumulated sufficient history, the value may be calculated and reset using the PO25/26 process. Weighting factors established by the forecast calculation are applied to the monthly demand units maintained for the product.
  • Note: The forecast should be calculated and maintained on a monthly basis to reflect the changing trends of the product's requirements.

• Weighted Average Cost - displays the weighted average cost of the product/warehouse record. For additional details, please contact your TECSYS SMB Professional Service representative.

• Whse - enter the warehouse code in which the product is kept. This field is validated against the Sales Office/Warehouse Numbers (ibis_sab.cc96) table.

• Work Order Reserve - this field is only used for products that have been flagged as component products for work order products in Work Order Products (ibis_wo13). The work order reserve quantity is the quantity entered in WO13 for the component product multiplied by the quantity entered on the purchase order for the WO product itself.
  • For example, a WO product '1102' has multiple component products including '1101-Black' for a quantity of 2 and '1101-Red for a quantity of 1 entered in WO13. A purchase order for '1102' is created for a quantity of 2. When you enter the component product '1101-Black' in Product Consolidated Inquiries (ibis_ic45), a quantity of 4 displays as the WO Res quantity, and when you enter '1101-Red' in IC45, a quantity of 2 displays in the WO Res field.

For the functionality of each action (i.e. button) available on this view, refer to the About the Actions topic.