Feature - Bin Master CSV Import

Feature - Bin Master CSV Import

Release Date: 8/7/25
Version: 8.5 and Above

This feature allows the user to update the Bin Master file via CSV import. This option is available from Inventory Management-> Maintenance-> Bin Master File-> Import.



This application  supports Pre-Interface, Interface, and Layout options.



The Layout options shows the required layout for the CSV file.



The following fields are supported in the import CSV file:
  1. Bin Number - This field is required.
  2. Comment - The comment field will be updated with this information if changing bins. If the CSV does not have value in this column, then the existing comment in Bin Master (IMBINFIL) will be retained.  If you wish to remove the existing Bin Master comment value, please provide the string $$BLANK$$ if removing an existing comment in change mode.
  3. Fixed Priority - This field provided will override the value if changing bins. Be careful if you do not provide a value in this column. In that case, the bin priority will be assigned with system date, resulting in a FIFO basis.



  1. Mode - The options are A=Add, C=Change, and D=Delete. Default value is "C."
  2. Location - Enter the warehouse location for the update. A valid location must be entered. F7 search is available.  This field is required. You can only import bin information one location at a time.
  3. CSV File Name - Enter the full path and file name of the CSV file to be processed. The application will remember the last file name entered.                
  4. Import File With Header Row - If the CSV file contains a header row, enter Y. Otherwise, enter N. The application will remember the last entry.

The Pre-Interface and Interface report output will show the data provided in the CSV and the status of update including any error messages.



Add Mode Validation:
  1. All bins that are added will set the Stock Bin flag to Y.
  2. Bin number cannot already exist at import location.
  3. Bin number will be limited to 8 characters or less.
  4. The bin number is required.
  5. Comment is limited to 30 characters or less.
  6. Fixed Priority must be zero or a valid date.
Change Mode Validation:
  1. Bin must exist at the import location.
  2. The bin number is required.
  3. Comment is limited to 30 characters or less. If $$BLANK$$ is provided in the CSV file, the comment will be removed from the bin master record.
  4. Fixed Priority must be either zero or a valid date. Note: This CSV import utility updates the Priority values in both the IMBINFIL and IMBININV tables. The values in IMBINFIL affect the bin inventory priority for future receipts to a bin, while the values in IMBININV affect the current inventory bin priority.  .
The main purpose of the Change mode is to update the "Priority," which is useful when bin priorities need to be reassigned. In Elliott WMS (Warehouse Management System), the system suggests bins for picking inventory based on their priority values. Bins with lower priority values are suggested first. If there is no 'Fixed Priority' value, the bin priority defaults to the system date, which results in bin suggestions on a FIFO (First In, First Out) basis. If you do not want to use the FIFO basis, you can designate a "Fixed Priority." For example, you may assign lower-level bins to be suggested first, while higher bins—requiring special equipment—are suggested later.

If the bin has a fixed priority and you pass a zero, we will remove the fixed priority from the bin master record and update any bin inventory records with the system date. If the fixed priority in the CSV file is different from the fixed priority on file, the bin master file is updated as well as all associated bin inventory records on file will be changed.

CSV Value

 Fixed Priority Before

Fixed Priority After

Bin Inventory Date

1/1/2001

00/00/00

1/1/2001

1/1/2001

00/00/00

12/31/2020

00/00/00

System Date

12/31/2030

12/31/2020

12/31/2030

12/31/2030

Spaces

12/31/2020

00/00/00

System Date

Delete Mode Validation:
  1. Bin must exist at the import location.
  2. The bin number is required.
  3. The comment and fixed priority field will be ignored. 
  4. If there is any existing inventory in the bin inventory file, this is an error condition and the interface will stop.

Programs Added: IMBINIMS.CBL, IMBINIMP.CBL
Programs Modified: IMBINMNT.CBL

CLS

    • Related Articles

    • Feature - New Item Import Through CSV File

      Program Original Release Date: 05/15/2007 Document Release Date: 08/21/2020 Version: 7.5 & Up The feature can be accessed in I/M, Utility, and New Item Import. It allows you to import new items from either an ASCII or CSV file. This document only ...

    • Feature - Inventory Transfer Management Batches Using CSV Import

      Release date: 8/3/2018 "Free" Inventory Transfer Management batches are batches that have been entered by hand through the Inventory Transfer Management application and not automatically generated by Elliott when inventory needs to be transferred. ...

    • Feature - Customer CSV Import

      Release date: 9/25/2019 Version: 8.5 and up For the Customer CSV Import, select AR --> Utility --> Customer/eContact import --> customer/econtact Import --> Customer import This new screen program will have three menu options: Pre-Interface, ...

    • Feature - Added a Function "Create Inventory Trx CSV Import"

      Release date: 12/29/2016 Updated: 2/21/2017 Updated: 4/25/2017 Updated: 5/2/17 Added a function to IM / Maintenance / Item file / Create / Create Inventory Trx CSV Import to automate the receipt of inventory items thru returned inventory. This ...

    • Feature - Mass Billing by CSV Multi-Bin Support

      Release Date: 5/28/24 Version: 8.5 and Above Currently when a user chooses COP -> Billing Selection -> Mass-billing -> by CSV File and the multi-bin enhancement is enabled, the user will receive the error message "Multi-bin is not supported with this ...