Product Warehouse Product Setup - General field descriptions

Fields are presented in alphabetical order within each section. Click a link to access the field descriptions for that section:

General

Pricing

Authorized Replenishment Path (ARP)

Location

Freight

eSource

General

Auto Back Order Fill

If selected, Sales Entry Processing Back Order Fill automatically fills Sales orders and Transfers each time this product is received. If you do not select this option, you must manually distribute the quantities received each time this product is received. Even though the product is not automatically distributed, it will print on the Receipts Report so you know where to put the quantities received and specify on the Sales Entry Processing Back Order Fill Report that there are orders to fill.

Back Order All if Short

If this option is selected and the Net Available in Product Warehouse Product Setup-Cost & Pricing-Balances is less than the quantity necessary to cover the entire quantity ordered, all of the quantity ordered is back ordered. This resembles the customer disposition of Ship Complete, but at the line level rather than the order level. Unless you have enough stock to completely fill an order, the entire quantity ordered is back ordered.

Exceptions: Any drop ship lines that were through back order fill will not be affected by this setting. If the Sales order line is a drop ship line, it will not auto back order the full line if the quantity is short. The system fills what has been received and back orders the remaining amount.

Control

Use this field if the product is serialized or based on lots. If this field is left blank, neither serials nor lots are used with this product.

This field is enterable if your Give Supervisor Status to This User option in SA Operator Setup-Other Options is set to Yes and your Function Security for Product Setup is 3.

In Product Warehouse Product Setup, you can override the company wide setting for assigning a serial number. In the Control field, when you select Serial, the Serial Receiving field is displayed beside the Control field. Use this field to determine when the serial number is assigned. The options are a) based on the SA Administrator Options default [AO Default], b) during receiving [Receive], or c) during sales [Sales]. If you specify Sales in this field, and you are using Storeroom, serial numbers are assigned when the product leaves Storeroom, or is moved or adjusted within Storeroom.

If a product has serial numbers or lot numbers, you can assign those numbers during various functions. Before setting up serial and lot products, you can specify a company-wide setting for when a serial or lot number is specified in SA Administrator Options-Products-Defaults-Receiving. For example, Assign Serial# During Receiving. You can also set the Force Lot/Serial Input option in SA Administrator Options-Documents-Sales Order-Entry Settings. Serial or lot records can be created during Purchase Entry Receipt of Inventory, Transfer Entry Receipt of Inventory, or as products are entered in Sales Order Entry. If you create them from Purchase or Transfer, all serial numbers automatically display in Sales Order Entry and allow you to select the ones you are selling, if the Force Lot/Serial Input option is selected in SA Administrator Options.

Serial numbers and lot numbers are required before orders can be invoiced through Sales Order Entry Invoice Processing Report, shipped in Transfer, or fully received in Purchase or Transfer.

Use caution with this field. If you enter an order when this field is blank, and then change the field to serial or lot, you must perform these manual steps if your customer returns the product:

  • Product Warehouse Product Setup: Change the Extended field to blank.
  • Sales Order Entry: Enter the order as a Return Merchandise (RM).
  • Sales Entry Invoice Processing Report: Process the RM.
  • Product Warehouse Product Setup and Product Extended Serial/Lot Number Setup: Change the Extended field to Serial or Lot.
  • Product Extended Serial/Lot Number Setup: Set up a record for the item.
Count Required

Used by the Product Entry Cycle Count Report and Product Entry Physical Count Report. All products that are marked to be counted automatically print on the count sheets, regardless of whether they qualify according to the selected parameters.

The Count Required field is automatically selected through Sales Shipping Feedback Entry or Transfer Shipping Feedback Entry when the quantity to be shipped, which is the quantity used to commit stock in Product Warehouse Product Setup, is greater than or less than the quantity ordered. This situation indicates Inventory Control did not match what was found in the warehouse and the product should be counted immediately to rectify the problem. When the Count Required field is selected, the field is displayed on the next count sheet. If the count run is removed and not updated, the field returns to selected.

This does not include those products in other warehouses that are marked to be counted.

Leeway

Product Warehouse Description Setup Reservation Leeway fields are checked for leeway days.

Preference

A tier is a product category used in conjunction with "Tier" and is integrated with Infor Interaction Advisor. During the product setup process, classify SKUs (stock keeping units) based on product quality (tiers) and warehouse priority (preferences). Preferences can be assigned in Leeway Product Warehouse Product Setup. Tiers can be assigned in for the product. When you run the Product Setup-General-Category and/or . Tiers can be assigned in Product Catalog Setup-General-Settings. Then, use tiers and preferences during Sales Order Entry to offer your customers interchanges or substitutions. This functionality adds visibility into comparable or important product attributes, such as quality, availability, location, or price.

Price Label Date

This value is the date that a price label was last printed for the product. When you run the IB Customer Price Labels Report to print labels that are based on price changes, this value is used to determine if a new label is required. If a new label is printed, this value is updated.

Price Label Last Price

This value is the price that was last printed on a price label for a product. When you run IB Customer Price Labels Report to print labels that are based on price changes, this value is used to determine if a new label is required. If a new label is printed, this value is updated.

Price Label Unit

This value is the unit that was last printed on a price label for the product. When you run the IB Customer Price Labels Report to print labels that are based on price changes, this value is used to determine if a new label is required. If a new label is printed, this value is updated.

Reservation

An attribute that overrides the standard inventory reservation rule and changes the timing at which inventory is reserved, or not reserved.

Leeway Reservation Type Description When Used
Delayed This type delays reservation for a regular, serial, lot products or tally component based on the promise date of the order or transfer – Product Warehouse Product Setup Leeway days. This calculation does not consider the product’s lead-time, replenishment review dates, or any other parameter. Used for products that can be consistently managed by the system’s inventory reservation rule but are sometimes placed on orders that will not be shipped right away.
Against Receipts Standard products are automatically reserved up to the total of the net available amount [on hand – reserved – committed + pending receipts]. The pending receipts must have a PO due date that is on or before the order or transfer’s promise date. Used for high-demand products that are constantly being replenished.
Always For standard products, this reservation type applies the Delayed rules in addition to always reserving inventory in Product Warehouse Product Setup, regardless of the stock levels or pending (pre-received) receipt quantities. Used for high-demand products that cannot be consistently managed by the traditional system inventory reservation rule. Works for products purchased frequently for pick up on the way deliveries to customers.
Blank This reservation type invokes the standard inventory reservation rule. Used for products that can be consistently managed by the standard system. You must use this option for labor products.
Note: The Reservation field can be set only to Delayed when:
  • The Force Lot/Serial Input check box is selected on the SA Administrator Options - Documents - Sales Orders - Entry Settings screen.
  • The products are of type serial or lot.
  • The products are controlled by the Warehouse Manager or Warehouse Logistics.
Sales Manager

Select this option if the Sales information for this warehouse product should be stored in the sales history files.

In Storeroom, sales order entry lines for customer-owned inventory are not included in Sales Manager data since it has already been sold to the customer.

Status

In addition to the Status field on the Product Setup record, the Product Warehouse Product Setup Status field is specific to the warehouse product and identifies the product type or ordering limitations the product might have. The options are Direct Ship, Order As Needed, Order As Needed-NonStk,Stock, or Do Not Reorder.

Note:  If you are on the Warehouse Products window, you can also choose Exclude OAN-NS.

To exclude inactive OAN-NS products from displaying, select the Active Only option and then choose OAN-Non Stock from the Status drop-down.

This field is enterable if your SA Operator Setup Supervisor Status field is selected, and your security for Product Setup is set at 3 or higher. The Order as needed-Non Stk option is available only if you SA Operator Setup-Other Entry Options, Allow Change/Copy of ICSW Status for OAN-NS is selected.

The Status is automatically defaulted to Stock for new warehouse products. Stocked warehouse products are your regular products. All quantities and year-to-date figures are updated. If you change a product with a stock status of Order as needed or Do Not Reorder, you are asked if you want to clear ordering controls. This is recommended to show this item as surplus if an on hand balance exists. If a product's status is changed to OAN or DNR and there are existing ordering controls, it may not show up as surplus as the on hand amount could be less than the line point, or other control values. Changing the product status of a stock product that is part of an active forecast or reservation triggers the ic-icswforecastreserv Event Manager event.

This table shows valid combinations of the product status set up in Product Setup relative to the status set up with this field.

Product Setup Product Warehouse Product Setup Result
Active Direct ship, Order as needed,Order as needed-NonStk, Stock, Do Not Reorder. valid
Labor Stock valid
  Order as needed, Order as needed-NonStk not valid
  Direct ship not valid
  Do Not Reorder not valid
Superseded Direct ship, Order as needed, Order as needed-NonStk, Stock, Do Not Reorder valid
Inactive Direct ship, Order as needed, Order as needed-NonStk, Stock, Do Not Reorder not valid

Combinations that are not valid will ignore the status on the warehouse product record and handle the product according to the status on the product's record in Product Setup.

If a warehouse product is no longer active, you may manually maintain the status to Do Not Reorder or allow Product Administration Inventory Classification and Rank Report to automatically maintain it when it becomes a class 13 product, depending on the option selected. When a warehouse product is Do Not Reorder, the product can be sold through Sales Order Entry but it will not automatically be reordered through Purchase Order Entry.

If a Do Not Reorder product is displayed on a PO RRAR, the recommended order quantity will be 0 and must be overridden to place the product on a purchase order. If quantity exists for a DNR in another warehouse, a tie can be created to a warehouse transfer. A warehouse product can be set to Do Not Reorder for a temporary period or permanently. Non-stock products that were ordered for a customer, who later decided not to accept the products, could be set up as do not reorder products. This allows you to track the quantities, and if the product is requested by a customer, you will have a better chance of selling the product.

Assign a Direct ship status only to warehouse products that can only be sold through direct orders. Direct orders occur when your vendor ships an order placed by you directly to your customer. The invoicing is handled through your office, but the product never enters your inventory system. Direct ship warehouse products do not involve quantities, only prices, discounts, and costs. These products can only be placed on an Sales Order Direct Order or Line DO or a Transfer Direct Order.

Order as needed and Order as needed - Nonstock products are not truly stocked in your warehouse. When they are entered in Sales Order Entry, they will be special orders. A product's status can be set to Order as needed either manually or optionally through Product Administration Inventory Classification and Rank Report, if it becomes a class 13 product, depending on the option selected. A message alerts you to any open purchase orders or warehouse transfers if they exist. This a warning and you can proceed.

Sales Manager can provide analysis information on direct ship and non-stock products.

Pricing

Base Price

The base price for this warehouse product, which is generally the standard retail price. The base price can be multiplied against the Price/Discounting price multiplier (%) to determine the correct price for Sales Order Entry.

The Customer Setup record can be set up to always take the base price to prevent the customer from receiving a price break. This field may be updated by PD Mass Maintenance Entry.

List Price

The list price for this warehouse product if your preference is to record list prices. The list price can be multiplied against the Price/Discounting price multiplier (%) to determine the correct price for Sales Order Entry. The date of the Last Price Chg field in Product Warehouse Product Setup is updated when list prices change. This field may be updated by The list price for this warehouse product if your preference is to record list prices. The list price can be multiplied against the Price/Discounting price multiplier (%) to determine the correct price for Sales Order Entry. The date of the Last Price Chg field in Product Warehouse Product Setup is updated when list prices change. This field may be updated by PD Mass Maintenance Entry.

Price Type

The product price type in PD Price Discounting Pricing Setup-Customer and PD Special Price Type Discounts Setup. The product price type in PD Price Discounting Pricing Setup-Customer is referred to as the product type rather than the product price type. The price types are set up in SA Table Code Value Setup. When a valid price type is entered, the description appears to the right of the field.

Price type is beneficial for assigning a specific price level to certain types of products, for example, Electrical, Plumbing. The price type should be set up if pricing and discounting is going to be determined by product types. PD Price Discounting Pricing Setup Types 2, 4, and 8 use product type. The price type is also used to group products to grant the customer special grouping discounts as described in PD Special Price Type Discounts Setup.

This field may be updated by PD Maintenance Entry.

UPC#

The Universal Product Code is a product identifier consisting of up to six components for a total of 24 digits. The UPC number is set up in Product UPC Information Setup. It is displayed here for information only. If no UPC number is displayed in this field, it has not been set up in Product UPC Information Setup for the ARP vendor and product line designated for this product record.

The UPC number consists of those components you have defined in SA Administrator Options-Product-Alternates/UPC. Two components, the vendor number and product number, are required and are hard coded in SA Administrator Options-Product-Alternates/UPC as 6 and 5 digits in length, respectively.

The vendor number is assigned by the Uniform Code Council with the National Electrical Manufacturers Association (NEMA), and the product number is assigned by the manufacturer for unique identification.

The UPC number prints on all purchase orders and is stored on all orders in Sales.

Authorized Replenishment Path (ARP)

Apply Supplier Warranty Allowance

Select this option if the product is included in a Supplier Warranty Allowance program. The allowance is calculated at the header level and line level on purchase orders. The calculation is based on a percentage of the ARP vendor's product cost. The percentage is specified on the vendor record.

ARP Warehouse

If a warehouse authorized replenishment path is specified in the ARP field, specify a warehouse in this field. This should be the warehouse resupplying the product to your warehouse. The ARP warehouse must be a different warehouse than the warehouse storing this product.

The warehouse must exist in Product Warehouse Description Setup. If a product's ARP is a warehouse, the Product Warehouse Product Setup order method is not min/max, the Product Warehouse Product Setup Season Begin field is 0, and no PD Price Discounting Pricing Setup-Vendor record exists, this warning message is displayed when you press Enter: Min/Max Recommended (8605).

Set up a default in Product Line Setup-Order. When you specify the Vendor and Product Line values in Product Warehouse Product Setup-New, the data on the Product Line Setup record that matches the vendor and product line is used to populate the corresponding fields on the new Product Warehouse Product Setup record. This ensures the initial data for any new Product Warehouse Product Setup record associated with that product line is created with the same default data. This speeds up the creation of the record because you have less data to specify on a new record.

If you are integrating Value Add with the Infor CPQ (CPQ) product configurator, you must set the ARP type to replenish the fabricated product through the VA module. This type allows ties to be created between the sales order lines and the VA order.

See the information about the VA integration with product configurator.

Change ARP Vendor

Click this button to change the ARP vendor by selecting a vendor from the Alternate Vendors list.

The Change ARP Vendor option is displayed if you have selected the Limit Alternate Vendors option in SA Administrator Options-Products-Alternates/UPC and have set up alternate vendor products in Product Extended Product Cross Reference Setup-Alternate Vendor.

When you click Change ARP Vendor, you can select a vendor from the list of alternate vendors set up for the product in Product Extended Product Cross Reference Setup-Alternate Vendor. When you click OK, the information about the vendor from the Product Extended Product Cross Reference Setup record is copied to the vendor information fields in the Authorized Replenishment Path section, replacing the previous ARP vendor’s information. If the new ARP vendor’s Price is different, the Replacement Cost and Replacement Cost Date is also updated in Product Warehouse Product Setup-Costs.

Note: The list of alternate vendors displayed in the Alternate Vendor lookup window can be limited based on System Administrator options, operator security, and division security. To limit vendors by division, see the information on Alternate vendors by warehouse, and Division security.
Cut Replenishment Length
Specify a value to be used as a minimum length before replenishment is initiated. When the length of an existing, available linear cut lot piece is decreased by being cut or by manual adjustment, the length of the remaining available piece is compared to the specified Cut Replenishment Length value.
Cut Replenishment Output
Specify the email address to receive the RARR output when the length of the cut piece drops below the Cut Replenishment Length and Email is the specified Cut Replenishment Output Type.
Cut Replenishment Output Type
Specify an output type to generate a RARR report when the length of the linear cut piece drops below the specified Cut Replenishment Length value. The generated RRAR report is determined by the Authorized Replenishment Path (ARP) Type value for the linear cut lot product in that warehouse. The output of the RRAR report can be emailed to specified operators in the Cut Replenishment Output field or viewed in the Report web part.
Family Group

A smaller, more specialized section of the product line and is set up in SA Table Code Value Setup. This field is optional and is used to display family group items on the PO/WT RRAR when one item in the family group falls below line point. For example, within electrical wiring, three-way wiring may be grouped within the same family. Any combination and quantity of the products ordered from this family may qualify for a special discount. When one item in the family group falls below line point, review the entire group to see if you should order more products to qualify for the special discount.

NCNR

Specify Y to designate this warehouse product as non-cancellable or non-returnable (NCNR). This notifies your buyers and customer service reps that it should only be added to sales or purchase orders when the customer is aware that the order cannot be canceled, or when the item cannot be returned to you or to the vendor for a full refund. This value defaults from the master Product Setup record but can be overridden for the warehouse product. Leave this field blank if this product is not an NCNR item.

During Sales Order Entry, the NCNR option is displayed on the Line Items grid and Extended view.

Products that are designated as NCNR cannot be entered on a Return Merchandise (RM) order or return line in Sales Order Entry or Purchase Order Entry unless the option, , Allow Entry of NCNR field is selected for the operator in SA Operator Setup - OE/PO Entry Options.

Product Line

The product line in which the vendor places this product. The product line is used to group similar products together and is based on targets. For example, all types of electrical wire may be placed in one product line. The vendor can give you discounts based on this product but also based on the product line. Greater discounts are usually available if several products, in any combination, are ordered from a product line rather than ordering them individually.

Set up a default in Product Line Setup-Order. When you specify the Vendor and Product Line values in Product Warehouse Product Setup-New, the data on the Product Line Setup record that matches the vendor and product line is used to populate the corresponding fields on the new Product Warehouse Product Setup record. This ensures the initial data for any new Product Warehouse Product Setup record associated with that product line is created with the same default data. This speeds up the creation of the record because you have less data to specify on a new record.

If the Require Vendor #/Product Line setting in SA Administrator Options-Products-Defaults is set to Vendor and Product Line, this value is required when creating a product record or maintaining the General view of an existing record.

Push/Pull

Does the ARP warehouse supplying this product automatically replenish your stock when you require it, or do you place orders with the warehouse to be replenished? If the warehouse automatically determines when you require more stock and pushes it out to you, select Push. If you control your product supply, select Pull.

Set up a default in Product Line Setup-Order. When you specify the Vendor and Product Line values in Product Warehouse Product Setup-New, the data on the Product Line Setup record that matches the vendor and product line is used to populate the corresponding fields on the new Product Warehouse Product Setup record. This ensures the initial data for any new Product Warehouse Product Setup record associated with that product line is created with the same default data. This speeds up the creation of the record because you have less data to specify on a new record.

Rebate Sub-type

The rebate sub type for this product. Use rebate sub types to group products for rebate purposes. The rebate sub type is set up in SA Table Code Value Setup, and your entry in this field is validated. If the rebate sub type does not exist in SA Table Code Value Setup, an error message is displayed. You cannot continue until you have entered a valid rebate type.

If the vendor number in SA Table Code Value Setup does not match the Product Warehouse Product Setup ARP vendor number, this message is displayed:

Warning: PDST Vendor Does Not Match ARP Vendor For Product (8053) 
Rebate Type

The rebate type for this product. Use rebate types to group products for vendor rebate offers. The rebate type is set up in SA Table Code Value Setup, and your entry in this field is validated. If the rebate type does not exist in SA Table Code Value Setup, an error message is displayed. You cannot continue until you have entered a valid rebate type.

If the vendor number in SA Table Code Value Setup does not match the Product Warehouse Product Setup ARP vendor number, this message is displayed:

Warning: PDST Vendor Does Not Match ARP Vendor For Product (8053)
Type

The ARP, authorized replenishment path, is the preferred method this warehouse product is supplied/replenished to your warehouse. There will be exceptions, but follow the ARP path as much as possible. Generally, do not arbitrarily change the source from which you obtain the product. For example, do not randomly order the product from another warehouse one time, from the manufacturer another time, and from a dealer yet another time. This sort of activity contributes to an unmanageable inventory.

The products in this warehouse can be received from a specific vendor or warehouse, supplied from central (regional distribution center), assembled on a prebuilt kit work order, or supplied under a vendor managed inventory (VMI) agreement with a vendor.

Vendor replenishment paths always resupply this warehouse product from the vendor listed in the field below. The product is displayed on the PO RRAR when it needs to be replenished. If you choose Warehouse or Central Whse, this warehouse product is displayed on the WT RRAR when it needs to be replenished and is replenished from the warehouse specified in the ARP Whse field.

If you choose Kit, the product must be a prebuilt kit that is designated in Product Warehouse Product Setup, and this product is displayed on the KP RRAR rather than on the WT RRAR or PO RRAR. A product that is under a VMI contract will be ignored by the PO/WT RRAR processes, but product data will be reviewed by the vendor who will determine when the product should be replenished. The PO Entry VMI Initial Product Data Load is used only at the beginning of a VMI program. PO Entry VMI Product Activity Data EDI 852 tracks inventory changes for products with an ARP of VMI and is usually transmitted through EDI to the vendor daily.

Set up a default in Product Line Setup-Order. When you specify the Vendor and Product Line values in Product Warehouse Product Setup, the data on the Product Line Setup record that matches the vendor and product line is used to populate the corresponding fields on the new Product Warehouse Product Setup record. This ensures the initial data for any new Product Warehouse Product Setup record associated with that product line is created with the same default data. This speeds up the creation of the record because you have less data to specify on a new record.

If you are creating a Product Warehouse Product Setup record for a product that already exists in Product Catalog Setup, the vendor and product line will default from the Product Catalog Setup record if a product line exists on the Product Catalog Setup record and the Product Warehouse Product Setup ARP field is Vendor.

If you are integrating Value Add with the Infor CPQ product configurator, you must set the ARP type to replenish the product through the VA module. Specify Fab Value Add. This type allows ties to be created between the Sales Order Entry lines and the VA order.

Vendor

If a vendor authorized replenishment path is specified, specify a vendor number. This number should be the number of the vendor resupplying this product to your warehouse. The vendor number must exist in Vendor Setup. If the vendor is inactive, a warning message is displayed, but you will be allowed to proceed. Update the status on the vendor record in that situation.

Set up a default in Product Line Setup-Order. When you specify the Vendor and Product Line values in Product Warehouse Product Setup-New, the data on the Product Line Setup record that matches the vendor and product line is used to populate the corresponding fields on the new Product Warehouse Product Setup record. This ensures the initial data for any new Product Warehouse Product Setup record associated with that product line is created with the same default data. This speeds up the creation of the record because you have less data to specify on a new record.

If the Require Vendor #/Product Line setting in SA Administrator Options-Products-Defaults is set to Vendor and Product Line or Vendor, this value is required when creating a product record or maintaining the General view of an existing record.

To change the ARP Vendor on the fly, selectChange ARP Vendor. You can change the vendor to one of the vendors in the Alternate Vendors list.

If you have enabled the National Program functionality, use this field to specify the National Program Claim Account that you specified in Customer Setup-Ordering and associated with this Vendor [Manufacturer]. An authorized replenishment path (ARP) vendor is the primary source for a product. The Product Warehouse Product Setup ARP vendor is used as the vendor for matching PD Pricing Setup-National Program records.

Vendor Product

The product number the vendor uses for this product. This number can optionally print on all purchase orders placed with the vendor. If this field is blank, your product number prints on the purchase order. This field can also be used to cross-reference this product.

Location

Allocate

If the Warehouse Manager option is selected, this field is functional. Retain the default blank, or optionally, select Cube Capacity or Size Type Restricted. If Allocate is blank or set to Cube Capacity, Warehouse Manager assumes that for one stocking unit of product, one cube of space is taken and the product is restricted to bins of that size. If you have defined size types in SA Table Code Value Setup, and you select Size Type Restricted here, this product is restricted to bins with that size type.

Bin Loc #1 and Bin Loc #2

Multiple bin locations are allowed for each product in a warehouse. Specify the primary bin location in Bin Loc #1, and optionally, a secondary location in Bin Loc #2. The sections represent the Building/Section/Row/Shelf, for example, AA/A1/003/012. The field is alphanumeric. Bin locations #1 and #2 are printed on all pick tickets and physical count sheets to help you find the products. These are used as putaway suggestions on the pre-receiving report. You can set up additional bin locations by clicking Additional Bins. This button is accessible as an inquiry if you are not in Edit mode.

To prevent discrepancies during physical and cycle counts, the system updates the bin locations when you specify them for items in Product Count Entry and click Add Product to Count. If you are not using TWL or Warehouse Manager, when you add a new line and bin location to a count, the bin location is saved. The bin location data is managed using these rules:

  • If the location is already used in Product Warehouse Product Setup, the data is saved without update, because it is already saved.
  • If the Bin Location in Product Warehouse Product Setup is blank, the new bin location is saved: first in Binloc #1, then Binloc #2.
  • If there are two bin locations in Product Warehouse Product Setup, a new Product Additional Bin Location Setup record is created.

If you are using the Bin Location field in Integrated Barcode, Product Bin Maintenance Entry can be used to update bin locations in your default warehouse or warehouse group. The default warehouse and warehouse group are assigned in SA Operator Setup. When a product is added to a bin location, the function updates the first available Product Warehouse Product Setup Bin Loc field in this order:

  • Bin Loc #1 is updated (if blank), otherwise:
  • Bin Loc #2 is updated (if blank); otherwise:
  • The record is added to Product Additional Bin Location Setup.

When a product is deleted from a bin location, it is removed from the corresponding Bin Loc field or the Product Additional Bin Location Setup field is deleted. If Bin Loc #1 is cleared, items from Bin Loc #2 are not shifted.

Bin Type

If you are using Warehouse Manager, this field is functional. Retain the default blank, or optionally, select from the list. Selecting a bin type restricts the bin in which this product can be stored. Restrictions improve Purchase Pre-Receiving Report processing. If you retain the default blank, the Purchase Pre-Receiving Report searches through every open bin, making the report generation time consuming.

Bin types are set up in SA Table Code Value Setup and assigned to bin locations in WM Bin Location Setup. The value is alphanumeric and is used in conjunction with WM Bin Location Setup, WM Cross Reference Setup, and Product Warehouse Product Setup. Common examples of bin types are Floor, Bulk, Peg, Flow, Drawer, or Rack.

Priority

If the Warehouse Manager option is selected, this field is functional. Select FIFO Priority or Code. When you select FIFO Priority, the stored date is used to determine which bin location was "first in," and prioritizes that bin to be picked. When you select Code, the priority code in WM Bin Location Setup is used. SA Administrator Options-Products-Warehouse Manager control the priority in which bins are picked for primary, single, alternate, and open bins.

Restrict To

If the Warehouse Manager option is selected, this field is functional. Use this field to restrict storage of this product to specific building or row in a bin. We recommend you specify the same building and row used for this record's bin location. That is, match the format Bldg/Row/Section/Shelf.

For example, specify AA/A1. During Purchase Entry Receipt of Inventory, when you try to assign a bin and the bin is not in the specified building or row, you receive a message: WARNING: Product Warehouse Product Setup (ICSW) Building/Row Bin Type Restriction Not Compatible with WMSB (8699). Restrictions improve Purchase Pre-Receiving Report processing.

Warehouse Manager

Is this product controlled by Warehouse Manager? If so, select this option. Warehouse Manager can help you make efficient use of your warehouse investments by promoting an organized workflow in your warehouse, designating areas where products can be stored, designating primary bins and alternate bins for overflow stock, promoting organized receiving procedures, providing a replenishment system, and providing location analysis information. If you are already using TWL (Total Warehouse Logistics), do not implement Warehouse Manager for a TWL warehouse.

Freight

Extra Freight 1 and Extra Freight 2

These fields are used for the Freight Rate Shopping functionality.

In the Extra Frt 1 field, specify an extra freight charge that is used to calculate the Order Extra Freight 1 amount that defaults in the Addons 3 field if that record is selected in the Freight Rate Shop window in Sales Order Entry-Taxes & Totals .

In the Extra Frt 2 field, specify an extra freight charge to calculate the Order Extra Freight 2 amount that defaults into the Addons 4 field if that record is selected in the Freight Rate Shop window in Sales Order Entry-Taxes & Totals.

The charge is per item, so if the field value is $1.00 and the quantity ordered or shipped is 4, then $4.00 is applied as the extra freight charge.

Freight Free

Used for Freight Rate Shopping functionality. Select this option to exclude the product from freight calculations that are displayed in the Freight Rate Shop window in Sales Order Entry-Taxes & Totals and Sales Shipping Feedback Entry-Header.

eSource

Automatically Source BO?

This option is not currently used. Leave it blank.