Merge Bin Codes

Use Merge Codes.

(Accredo Saturn Only, in Mercury use Merge Codes)

Navigator > Setup > Company > Utilities > Merge Bin Codes

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

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

The Bin Code 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.

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 Codes for.

Fields

From Code

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

Note: For Bin Tracked locations bins with a Bin Count in progress cannot be merged.

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 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 Codes report. See Report Selections Form.

Post (Alt+T)

Post the changes.