Merge Bin Location

Navigator > Setup > Company > Utilities > Merge Bin Location

You can merge two Bin Location records into one. The effect on the data is:

Description, Custom 1 and Custom 2 fields on the From Bin Location will be deleted
Products in the From Bin Location will be moved to the To Bin Location

The Bin Location record with the To Code will be retained in the masterfile data. The From Code record will be deleted.

Warning: You will be prompted to back up your data before running this utility, as this utility restructures Accredo data files. If you experience power or other failure during posting, restore the backup and perform the Merge again.

Important: Do not run a file recovery before performing the steps above as file recovery will delete records relating to missing codes.

A log is appended to the Error Log. Each merge is appended to an Alias.csv file in the data directory as a change log. Use this when integrating with a third party application to identify the merged records.

Selections

Location

Select the location to display Bin Locations for. (Accredo Saturn Only)

Fields

From Code

Select an existing code from the list of codes. To include inactive records click Show Inactive Records (Ctrl+I).

To Code

Select an existing code, that the From Code will be changed to.

From Description

To Description

The descriptions for the codes. Read only.

Grid Toolbar

Expand Toolbar (Alt+F9)

Expand the toolbar to give access to all toolbar options. Press Esc to close the expanded toolbar.

Insert (F4)

Insert a line.

Move up / Move down

(Shift+Up)

(Shift+Down)

Move a line up or down the grid.

Delete (F3)

Delete a line.

Customise (Alt+F5)

Opens Customise Fields, you can customise the fields visible in the grid.

Import (Alt+I)

Import a list of bin location codes to be merged. This can save time from entering codes individually. The import file must be a text file with one line per code change. The fields on the line can be separated by commas (CSV format) or Tab characters (Tab delimited).

Field	Format	Size
From code	Alpha	16
To code	Alpha	16

Additional fields will be ignored by the import. Only lines in which the From code and To code differ, and a match for the codes is found are imported. When you import you are prompted with the Merge Importing report selections, this report shows the records that have been imported into the grid and error messages for lines which are not imported. If there are errors an exceptions file containing the rejected records is created with file name extension .EXC. Click Post (Alt+T) to merge the imported selections.

Buttons

Print (Ctrl+P)

Print the Summary of Merge Bin Locations report. See Report Selections Form.

Post (Alt+T)

Post the changes.