Publication Date: 11/12/2024 Share Print

Previous Topic

Next Topic

Book Contents

Book Index

Bin Update Import Button, via Inventory Query

Inventory Detail Bin Update Import option is used to mass upload and/or override bin locations per batch number. This option allows you the vendor to quickly update or override a digital file listing these Bins and related information for the import and quick creation of a Bin.

First, the user must prepare the file. For information regarding how to prepare the import file, refer to Preparing File For Import, via the Import Button of the System Standards Training Manual.

Criteria for Bin Update Import file:

Column Name

Data Type

Limitation

Path

Part Number

Alphanumeric

25

Inventory/ Update/ Inventory Supervisor/ General tab

Serial Number

Alphanumeric

20

Inventory/ Update/ Inventory Supervisor/ General tab

Batch

Numeric

08

Inventory/ Update/ Inventory Supervisor/ General tab

Goods Rcvd Batch

Numeric

08

Inventory/ Update/ Inventory Supervisor/ Other tab

Bin

Alphanumeric

20

Inventory/ Update/ Inventory Supervisor/ Other tab

QOH

N/A

N/A

N/A

Base (Location)

Alphanumeric

10

Inventory/ Update/ Inventory Supervisor/ General tab

New Bin

Alphanumeric

20

Inventory/ Update/ Inventory Supervisor/ Other tab

Go to Inventory/ Update/ Inventory Supervisor. From the Inventory Supervisor window, select the Inventory Detail Bin Update Import but_inventory_detail_bin_update_import_small button.

Image27

The Inventory Detail Bin Update Import window appears:

picture 48

The following import file will be used. Note the highlighted part numbers and their corresponding information.

Note: The new bin must exist in the database in order for the import to complete without any errors.

Note the current bin locations for the parts:

Complete all of the Import steps.

For information regarding how to Import a file, refer to Importing a File via Import Button of the System Standards Training Manual.

Select 'Yes' to override the existing bin with the new bin.

The import is complete:

The bins were successfully updated:

See Also

Inventory Query Buttons

Requisition Button, via Inventory Query

Picklist Creation Button, via Inventory Query

P/N Master QRY Button, via Inventory Query

Effectivity Button, via Inventory Query

Interchangeable Button, via Inventory Query

Order QRY Button, via Inventory Query

P/N Detail Print Button, via Inventory Query

Bin Control Button, via Inventory Query

Inventory Transaction All Button, via Inventory Query

Attachment Button, via Inventory Query

Top of Page Publication Date: 11/12/2024 Share Print