Amohammad at 20:37, 8 April 2024

2024-04-08T20:37:28Z

Amohammad at 20:37, 8 April 2024

2024-04-08T20:37:14Z

DavidT at 19:29, 16 March 2022

2022-03-16T19:29:16Z

DavidT: DavidT moved page IMPBIN to Import Bins

2022-03-16T19:27:43Z

DavidT moved page IMPBIN to Import Bins

DavidT: Created blank page

2022-03-16T19:27:24Z

Created blank page

New page

← Older revision		Revision as of 20:37, 8 April 2024
Line 5:		Line 5:
	===General Information===		===General Information===

−	Import new bin locations per warehouse. Separate import lines will need to be created for each Warehouse/Bin combination needed	+	Import new bin locations per warehouse. Separate import lines will need to be created for each Warehouse/Bin combination needed.

← Older revision		Revision as of 20:37, 8 April 2024
Line 5:		Line 5:
	===General Information===		===General Information===

−	Import new bin locations per warehouse. Separate import lines will need to be created for each Warehouse/Bin combination needed.	+	Import new bin locations per warehouse. Separate import lines will need to be created for each Warehouse/Bin combination needed

← Older revision	Revision as of 19:29, 16 March 2022
Line 1:	Line 1:
	+	===Default Menu Location===

	+	'''Transaction >> Importers/Exporters >> Item Control >> Bin Import'''
	+
	+	===General Information===
	+
	+	Import new bin locations per warehouse. Separate import lines will need to be created for each Warehouse/Bin combination needed.
	+
	+
	+	[[File:Bin_Import.png]]
	+
	+
	+	'''File Name/Browse:''' Use the Browse button to locate and select the completed Bin Import template file (in XLS format).
	+
	+	'''Map Fields:''' Fields must be mapped prior to importing. If no changes have been made to the column headings, the mapping screen should show all green, and you can click OK to continue. If any of the Input Field Name columns on the left are red, single-click on the line on the left column, and then double-click the desired mapped field in the right column to complete the mapping. Repeat for any red lines on the left that should be mapped. If there are additional columns in the source file that should NOT be mapped, they can be left unmapped (displayed in red). Mandatory fields will require that they be mapped before clicking OK.
	+
	+
	+
	+	===Sample Bin Import File===
	+
	+	The Bin Import does not have an 'Export Template' option. You can either create a new Microsoft Excel file in the Microsoft Excel 5.0/95 Workbook (*.xls) format with the exact column labels indicated in the 'File Definitions' section, or download a copy of the template file from the link below.
	+
	+	Note that the f1-f255 column identifiers and the third row descriptions are not used on this template. The imported data should begin on row 2.
	+
	+
	+	===Bin Import File Definitions===
	+
	+	Required fields are indicated with an *
	+
	+	'''*WhseName''' - Warehouse name for the associated bin record. Note that bins are specific to each warehouse location, so separate bin records must be created for each warehouse.
	+
	+	'''*BinName''' - Bin name (30 alphanumeric characters max)
	+
	+	'''Zone''' - Zone name from the Zone Maintenance screen (if using)
	+
	+	'''Multi''' - Enter 'Y', or leave the field blank, to set the 'Allow Multiple Items' flag. Enter 'N' to only allow a single item code for the bin location.
	+
	+	'''PSNum''' - Enter a numeric value (whole number, no decimals) to set the Pulling Sequence Number for the associated bin.
	+
	+	'''TmpLoc''' - Enter 'Y' to set the 'Temporary Location' flag. If left blank, the 'Temporary Location' flag will be unchecked.
	+
	+	'''WMSCon''' - Enter 'Y', or leave the field blank, to make the bin valid in the Warehouse Management Control system. This field should not be set to 'N' unless directed by ABIS personnel.
	+
	+	'''Active''' - Enter 'Y', or leave the field blank, to set the bin as an active bin. Enter 'N' to import an inactive bin record.

← Older revision	Revision as of 19:27, 16 March 2022
(No difference)

Import Bins - Revision history

Amohammad at 20:37, 8 April 2024

Amohammad at 20:37, 8 April 2024

DavidT at 19:29, 16 March 2022

DavidT: DavidT moved page IMPBIN to Import Bins

DavidT: Created blank page