WM Bin Location and Product Setup - Products field descriptions

Fields are presented in alphabetical order within each section.

Product Detail

Most of the fields in this section are read-only.

Bin Location

The bin location that is specified for this product in Product Warehouse Description Setup.

Product

The product number that is specified for this product in Product Setup.

Stocking

The stocking unit that is specified for this product in Product Setup.

Warehouse

The warehouse that specified for this product in Product Warehouse Description Setup.

Quantities

Committed

This field shows the total quantity of products to be moved out. Products can be committed as a result of action taken in Sales Order Entry, WM Accept/Review Replenishment Entry, KP Work Order Center Entry, or WM Entry Replenish Primary Bins Report. This field is updated by Sales Entry Pick Tickets Report and Transfer Entry Print Warehouse Transfer Report. The value in this field can be larger than the On Hand value. It can also be a negative number resulting from merchandise being returned in Sales Order Entry.

Maximum

This field is for replenishment actions and applies only to Primary bin locations. The WM Entry Replenish Primary Bins Report and Purchase Pre-Receiving Report use this value to determine the maximum number of products that the bin can hold. This field should not be a negative number or zero.

Minimum

This field is for replenishment actions and is used by the WM Entry Replenish Primary Bins Report to determine when the bin needs replenishment. This field should not be a negative number and should be less than the maximum. The Purchase Pre-Receiving Report checks this value if the Fill Primary Bin First option in SA Administrator Options-Products-Warehouse Manager is No. If the On Hand quantity is less than the Minimum, the bin is filled. If the option is Yes, then the bin is filled to the Maximum value, regardless of the quantity that is specified in this field.

On Hand

This field shows the total quantity stored in the bin for this product. You can specify this quantity when you are initially adding bin locations and associating products with the bin location. After Warehouse Manager is implemented, this quantity should match the quantity in Product Warehouse Product Setup. This field cannot be edited if the Allow User to Change Master Balances option in SA Operator Setup-Controls-Accounting is set to No.

This value can be a negative number if the Pick Only Primary Bins option in SA Administrator Options-Products-Warehouse Manager is Yes. In this case, available quantities of the product may be in non-primary locations. Bin replenishment restocks the primary location, based on the WM Entry Replenish Primary Bins Report settings. This field is updated by Purchase Receipt of Inventory Entry, Transfer Receipt of Inventory Entry, WM Accept/Review Replenishment Entry, KP Work Order Center Entry, and the Sales Entry Invoice Processing Report.

Received

This field shows the number of products that have not been 'put away' because of an action that was taken in these functions:

  • KP Work Order Center Entry
  • KP Entry Print Work Orders Report
  • Purchase Receipt of Inventory Entry
  • Purchase Pre-Receiving Report
  • Transfer Pre-Receiving Report
  • Transfer Receipt of Inventory Entry
  • Transfer Shipping Feedback Entry
  • WM Entry Replenish Primary Bins Report
  • WM Transaction Entry

Updating in Purchase Receipt of Inventory Entry and Transfer Receipt of Inventory Entry moves the quantities from Received to On Hand. The value in this field may be a negative number. This field cannot be edited if the Allow User to Change Master Balances option in SA Operator Setup-Controls-Accounting is set to No.

Dates

First Stored and Last Stored

These fields correspond to the date fields in WM Bin Location and Product Setup, but only pertain to this product. The dates are updated by these functions:

  • KP Work Order Center Entry (Accept)
  • Purchase Order
  • Sales Order Entry (Return Merchandise)
  • Transfer (Receiving Warehouse)
  • WM Entry Replenish Primary Bins Report Update mode
  • WM Transaction Entry
  • WM Accept/Review Replenishment Entry
  • WM Bin Location and Product Setup
Last Picked

This field is updated to indicate the last time any product was picked from this bin. This date is updated by these functions:

  • KP Work Order Center Entry (Accept)
  • Purchase Order (Return Merchandise)
  • Sales Order Entry
  • Transfer (Shipping Warehouse)
  • WM Entry Replenish Primary Bins Report Update mode
  • WM Transaction Entry
  • WM Accept/Review Replenishment Entry
  • WM Bin Location and Product Setup

Counts

Times Picked

This is the aggregate number of times a product has been picked from this bin. This field is updated by these functions:

  • KP Work Order Center Entry (Accept)
  • Purchase Order (Return Merchandise)
  • Sales Order Entry
  • Transfer
  • WM Accept/Review Replenishment Entry
  • WM Entry Replenish Primary Bins Report Update mode
Times Stored

This is the accumulated number of times a product has been stored in this bin. This field is updated by these functions:

  • KP Work Order Center Entry (Accept)
  • Purchase Order
  • Sales Order Entry
  • Transfer
  • WM Accept/Review Replenishment Entry