The Duplicates Report locates item numbers in the system that are the same and presents a report for review.
Duplicated on
This is the main part of the report. You can select to report duplicate item IDs or duplicate UPC codes
Type of Report
Summary will list the duplicate item ID/UPC code and give a description. Detailed export will show the pair of duplicated items with a description of each. Detailed export will also allow you to create a file for Combining the duplicate items.
Create file for use with "Combine Items" process
If you selected Detailed export from above, you can create a file to use in the Combine Item process. Click Export file and it will bring a save window up. Save the file and remember the file name and location where the save file is. This way, after you look at the report, you can go into Combine Items and import the file. For information on how to do this, click
here.
Primary Vendor
From this drop down menu, you can select the primary vendor. By clicking the button next to this menu, you can select a vendor from the find window.
In the example below, RENTAL-5 is indicated as one of the duplicates within the current system. A confirmation of this duplication is made when the "RENTAL-5" item is searched for in the Item Lookup function.
The TransActPOS system can deny the creation of duplicate item number with the "No Duplicate Items in Add Wizard" found in System | Company Setup |
POS Information 1.
Note: Duplicates may be desired within some systems to provide the user with a list of common items.
Confirmation of RENTAL-5 within an Item Lookup search.
If a unique item number is desired, from within the Item Maintenance screen of IC | File Maintenance, select Edit and change the item number to a new number (i.e RENTAL-15) and select Save. The system will ask if the original Item ID needs to be saves as a secondary lookup. Respond accordingly.
If the secondary lookup option was selected, the original Item ID will appear within the Lookup By listing. In this example, the item could be located by either "RENTAL-5" or "RENTAL-15".
Duplicate report in action
-
Select UPC Code within the "Duplicated on" option.
-
Select Detailed Export within the "Type of Report" option.
-
Choose the Primary Vendor by using the Ellipsis (...)
-
Select Generate and then Preview
-
The reports presents the occurrences of when a UPC is references between different Item IDs. Choosing the Item ID on the left (Item to Keep) and the "other" Item ID on the right (Item to Combine) allows the user to examine the details of the UPC related items.
-
Choosing the
Cmbne (Combine) in the middle of the screen will combine the Item ID on the right into the item ID on the left.
Choosing the Cmbne (Combine) in the middle of the screen results in the following sequence of screen which allows the users to select which fields of references in the final combine process.
By default the following screen appears with the radio buttons selected on the left.
The may be to manually select which field will be used on the final combining process as seen below.
Select 3. Combine to process the combine process.
Confirm the Combine process with a Yes, if desired.
The indicated fields are transferred to the "Item to Keep" Item ID.
Upon selecting Close, the system presents the opportunity to print a label for the resulting Item ID directed to the indicated Label form and Label printer. If desired, adjust the settings and select Print. Otherwise select Close to return to the report.
Note: The report does not refresh as a result of the combining of an item. Rerunning the report will report duplicates that are present in the system at the current time of the report.