NOTE For general information on using imports, see Imports FAQ.
The following table lists the format for changing a record in Bin Change Import.
|
Location Prefix |
Bin |
Field Value Name or Number (see table below) |
New Value |
Example You import from a text file that includes the following: NY^A2339^10100^99999
This changes the bin sequence to 99999 for bin A2339 in the NY location.
The following table lists fields that can be updated. You can indicate a field by either its value name or its number.
|
Value Name |
Number |
Maximum Length |
Format |
Description |
Apprise Field |
|
Bin-Sequence |
10100 |
7 |
Integer |
Enter a bin sequence number for the bin. Use the sequence number to create an efficient pick path through a warehouse and/or zone. |
Bin Sequence field in Bin Maintenance |
|
Bin-Zone |
10200 |
20 |
Character |
Enter a zone associated with the bin. |
Zone field in Bin Maintenance |
|
WH-Area |
10300 |
20 |
Character |
Enter a valid warehouse area associated with the bin. For information on setting up warehouse areas, see Warehouse Area Maintenance. |
Warehouse Area field in Bin Maintenance |
|
Bin-Velocity |
10400 |
12 |
Character |
Enter a valid velocity code for the bin. |
Velocity field in Bin Maintenance |
|
Bin-Description |
10500 |
80 |
Character |
Enter a detailed description of the bin. |
Description field in Bin Maintenance |
|
Not-Avail |
10600 |
3 |
Yes/No |
Enter Yes to make the quantity in the bin unavailable for picking or replenishment. Note This option is often selected for a bin that stores product returns. Since there often is uncertainty about the salability of returned products, putting them in a not available bin keeps them under control, but unavailable for sales allocation or picking. Note A bin can only be turned into a not available bin if there are no quantities currently in it. Enter No to allow the quantity in the bin to be available for picking and replenishment. |
Not Available Bin check box in Bin Maintenance |
|
Raw-Material |
10700 |
3 |
Yes/No |
Enter Yes if the bin only stores raw materials. If you enter Yes, you prevent any inventory in the bin from being allocated during pick demand printing. This setting works in conjunction with the Manufacturing module and the use of backflush bins when completing work orders. Enter No if the bin does not only store raw materials. |
Bin Holds Raw Materials Only check box in Bin Maintenance |
|
Staging |
10800 |
3 |
Yes/No |
Enter Yes to mark the bin as only to be used for staging. Enter No if the bin is not only used for staging. |
Staging Bin check box in Bin Maintenance |
|
Speed |
10900 |
3 |
Yes/No |
Enter Yes to have pick demand creation first pick from the bin, regardless of the unit of measure required. Typically, this is used for a high velocity product that is temporarily staged in a speed bin to facilitate an efficient pick. Enter No to not have pick demand creation first pick from the bin. |
Speed Bin Override check box in Bin Maintenance |
|
Do-Not-Pick |
11000 |
3 |
Yes/No |
Enter Yes to have this bin ignored during pick demand creation. Products can be taken out of this bin for work order creation or bin replenishment. Enter No to allow picking from the bin. |
Do Not Pick from This Bin check box in Bin Maintenance |
|
User-Bin |
11100 |
3 |
Yes/No |
Enter Yes to mark the bin as only to be used for a Wireless Warehouse user as a temporary bin when picking or moving products. Enter No to not mark the bin as only to be used for a Wireless Warehouse user as a temporary bin for picking or moving products. |
User Bin check box in Bin Maintenance |
|
Laydown |
11200 |
3 |
Yes/No |
Enter Yes to mark the bin as one that can be used when picking or moving products. Enter No to not use the bin as a laydown bin. |
Laydown Bin check box in Bin Maintenance |
|
Potential-Discrepancy |
11300 |
3 |
Yes/No |
Enter Yes to mark the bin as having a potential inventory count discrepancy. Enter No to mark the bin as not having a potential inventory count discrepancy. |
Potential Discrepancy check box in Bin Maintenance |
|
Do-Not-Issue-Material |
11400 |
3 |
Yes/No |
Enter Yes if you do not want to allow component products to be issued from this bin when issuing material for manufacturing. Enter No to allow material to be issued from the bin. |
Do Not Issue Material check box in Bin Maintenance |
|
Cross-Dock |
11500 |
3 |
Yes/No |
Enter Yes to use cross-dock features, and to make the bin available for cross dock selection in Dock Maintenance. Enter No to not use the bin for cross-dock features. |
Cross Dock Bin check box in Bin Maintenance |
|
Can-Break |
11600 |
3 |
Yes/No |
Enter Yes to allow products in the bin to be broken down to smaller units of measure or built up to larger units of measure. Example If there is a pallet unit of measure of product stored on a high, out-of-the-way bin, you may not want a picker to pick in an each unit of measure from it. Enter No to not allow products in the bin to be broken down to smaller units of measure or built up to larger units of measure. |
Can Break Inventory check box in Bin Maintenance |
|
Cycle-Count-Group |
11700 |
12 |
Character |
Enter a bin cycle count group for the bin. You can use bin cycle count groups to group together similar bins in the same zone or sales location / shipping location for Wireless Warehouse cycle counting. For more information, see Bin Cycle Count Group Maintenance. |
Bin Cycle Count Group field in Bin Maintenance |
|
Height-Capacity |
11800 |
12 |
>>>,>>9.9999 |
Enter the maximum height capacity in the specified dimensional unit of measure for the bin. This is used for directed putaway. |
Height Capacity field in Bin Maintenance |
|
Width-Capacity |
11900 |
12 |
>>>,>>9.9999 |
Enter the maximum width capacity in the specified dimensional unit of measure for the bin. This is used for directed putaway. |
Width Capacity field in Bin Maintenance |
|
Length-Capacity |
12000 |
12 |
>>>,>>9.9999 |
Enter the maximum length capacity in the specified dimensional unit of measure for the bin. This is used for directed putaway. |
Length Capacity field in Bin Maintenance |
|
Capacity-UM |
12100 |
8 |
Character |
Enter the unit of measure for the bin for height, width, and length. This is used for directed putaway. |
Capacity U/M field in Bin Maintenance |
|
Cube-Capacity |
12200 |
12 |
>>>,>>9.9999 |
Enter the maximum cubic capacity for the bin. This is used for directed putaway. |
Cubic Capacity field in Bin Maintenance |
|
Cube-Capacity-UM |
12300 |
8 |
Character |
Enter the unit of measure for the cubic capacity. |
Cubic Capacity (unit of measure) field in Bin Maintenance |
|
Weight-Capacity |
12400 |
12 |
>>>,>>9.9999 |
Enter the maximum weight capacity for the bin. This is used for directed putaway. |
Weight Capacity field in Bin Maintenance |
|
Weight-Capacity-UM |
12500 |
8 |
Character |
Enter the unit of measure for the weight capacity. |
Weight Capacity (unit of measure) field in Bin Maintenance |
|
DRP-Calc-Option |
12600 |
19 |
Character |
Enter one of the following if the bin is marked as not available:
|
DRP Calculation Option field in Bin Maintenance |
|
Pending-Rcpt |
12700 |
3 |
Yes/No |
Enter Yes if the bin is only used to store products for pending receipts. Enter No if the bin is not used to store products for pending receipts. |
Pending Receipt Bin check box in Bin Maintenance |
Before using this import, the following must be set up:
locations
bins