Combining SKUs (RCIN)

Introduction

Requirements

How to Combine SKU Numbers

Introduction

Always have a current backup available before running Change Item SKU Number (RCIN).  

This procedure explains how to use RCIN, Change Type "C," to combine two SKUs (You can also use RCIN to change SKUs to a different number, or to run a custom SKU conversion).

When combining two SKUs, the system combines the items' Vendor Alternate Part numbers. It converts the Vendor Alternate Part numbers for the old SKU to the retained SKU number. If both items already have the same vendor/alternate part,  the system retains the information (order multiple (OM), minimum number of OM's, unit to order by, and vendor cost) for the SKU that had the most recent cost change.

 RCIN for Windows is "batch" based, meaning that you add a list of old/new SKUs to a batch. You also display the pending old/new SKUs by batch, and you Finalize by batch.

Click here for the list of records that RCIN automatically updates.

RCIN doesn’t modify QuickFind.  

Requirements

When combining SKUs, both SKUs must:

• have the same record type. L-type and H-type records cannot be combined.

• currently exist on the system

• have the same stocking unit of measure

Click the following links for more information about how each file handles the SKU merge when you combine SKUs:

• Inventory file

  The following fields are combined:

  1. • Quantity on Hand

     • Quantity on Order   

     • Future Order

     • Committed Quantity  

     • Customer Backorder

     • New Order Quantity

     • To Date Sales

     • YTD Transactions    

     • YTD Sales $

     • YTD Replacement Cost $

     •  YTD Average Cost $

     • YTD Promo Units

     • YTD Promo Sales $

     • YTD Promo Cost $

     • YTD Prime Vendor purchase units

     • Last Year Prime Vendor purchase units

     • YTD Other purchase units

     • Last Year Units

     • Last Yr Other purchase units

     • Last Year Replacement Cost $   

     • Last Year Sales $

     • Last Yr Avg Cost $  

     • Last Yr Promo Units

     • YTD Kit Sales $

     •  YTD Kit Sales Units

     • Units for periods 1-13

     • Last Sale Date (the most recent date)

     • Last Receipt Date (the most recent date)

     • Average cost

• Inventory Notes

  If the old SKU’s Note Group was equal to the value of the old SKU, then the system converts the old SKU’s notes to the retained SKU, as long as the retained SKU doesn’t already have that type of Note.

  For example, if both SKUs have a note type 1, the system deletes the note type 1 for the Old SKU.  

• Alternate Part Number file

  This file contains two types of records: manufacturer part numbers and UPC codes. The system deletes the  manufacturer part number for the old SKU. The system converts the UPC codes for the old SKU to the retained SKU number.

• Expanded SKU history file (ISH)

  The system deletes the old SKU information and merges it to the retained SKU. If no expanded history is currently kept for the retained SKU, the information for the old SKU will still be added.

• Tally Cross-Reference file (MTL)

  Lumber users only. The system deletes the Tally 2 records for the old SKU and leaves the retained SKU alone.

• Alternate vendor records (Inventory Maintenance, the Vendor tab )

  The system converts the Vendor Alternate Part numbers for the old SKU to the retained SKU number.   It they each had the same vendor/alternate part number, the information (order multiple [OM], minimum number of OM’s, unit to order by, and vendor cost) is retained for the SKU which had the most recent cost change.

• Point of Sale Order file (Save Orders, Special Orders, Estimates, and Transfers)

  The system converts the old SKU to the retained SKU.

• QuickRecall

  The system converts the old SKU to the retained SKU.

• Category Pricing Plan (CPP)

  The system converts the old SKU to the retained SKU.

• Purchase History file

  The system converts the old SKU to the retained SKU.

•   Item Price Change file

  The system deletes the records for the old SKU but leaves the records for the retained SKU alone.

• Item Promotion file

  The system deletes the records for the old SKU but leaves the records for the retained SKU alone.

• Purchasing and Receiving file

  The system converts the old SKU to the retained SKU. The RCIN report instructs you to run Function AUDITO.

• Physical Inventory Posting file (PIP)

  The system deletes the records for the old SKU but leaves the records for the retained SKU alone.

• Physical Inventory Shrinkage file (MPH)

  The system deletes the records for the old SKU but leaves the records for the retained SKU alone.

• Physical Inventory Audit file (RPH)

  The system deletes the records for the old SKU but leaves the records for the retained SKU alone.

• Kit Records file (MKR)

  The system deletes the kit header records for the old SKU. In addition, if you use Option K, the system converts the kit component records for the old SKU. The system leaves the retained SKU alone.

• Customer Returns

  the system converts the old SKU to the retained SKU.

• POS "Alternate Items"

  the system converts the old SKU to the retained SKU.

• POS "Related Items"

  The system converts the old SKU to the retained SKU.

Combining SKUs

1. Display the RCIN window.

   From the Eagle Browser, click Inventory Menu, then click Change/Combine Item Numbers.

   Alternatively, type RCIN in the Launch bar and press <Enter>.  

2. Click Add. The RCIN Inventory Change Batch Maintenance dialog displays.

3. Enter a batch name for this group of changes. Enter any name you'd like. For example, you could enter today's month/date followed by a letter, such as 1201A, 1201B, 1201C, etc. for December 1 session A, December 1 session B, December 1 session C, etc.

4. Enter the SKU you're NOT keeping in the Old SKU field, and the SKU you're keeping in the New SKU field. In the Change Type field, select B-Combine. Then press Enter.

5. Repeat step 4 as many times as needed to enter the pairs of SKUs you're combining. When finished, click Cancel to close the dialog box.

6. Click Finalize. The Change Item Number report displays.

You can also access the Change Item Number report by typing RCINR in the Launch bar of the Eagle Browser.

7. Spool the report if desired.

8. Click and select S (Standard).

9. Click and select the appropriate options in the Options field.

Click any of the following links for more information about an option.

D-Change Item Description

K-Update Kit Components

P-Preserve Sequence #

R-Report Each Change

S-Preserve Old Retail When Combining Items

T-Preserve Old Location When Combining Items

10. Click Run (F4) to combine the selected items.