General Range Edit

Products>File>General Range Edit

 

The Product Code or Codes must be selected for the other button choices to be activated.

If a cost factor (pad, freight, installation costs, etc.) or descriptive field (Style, Name, etc.) should change, there is no need to update individual product records.  This can be accomplished globally by denoting what factor needs adjusting through this selection.  If there are records tagged for printing and change costs before printing, those records must be untagged and re-tagged to print the updated information on the tag.

Two steps are necessary to do a general range edit.  First, select which data field is changing from the edit section.  After selecting one field (multiple selections are not allowed), click OK to enter more specific parameters.

Edit

This section allows specifying which Cost, Text Fields, or Toggles for product records will be changed when the general range edit is performed.  Records will be compared with the data typed into each field on this screen.  If a complete match is found, the OLD data will be replaced with the NEW data.

Load % of the cost will calculate the load based on the current cost and enter a dollar amount in the Load field so you can use that amount in a formula such as: C*L

Load % will simply enter a % in the LP field. and can be used regardless of the cost (if the cost increased or decreases) in your formula, such as:  C+(C*LP)

Costs or Text Fields

Click the selection button next to the cost or Text field to edit.  The names of the old field and new field will change depending on which of these is chosen.

Toggle Values

Clicking this edit option allows changing the active-inactive status of everything selected by the range criteria to the status selected in the dialogue box which opens when this button is selected. 

 

Running General Range Edit WITHOUT the 'Only for:' box checked will apply the edit to ALL RECORDS THAT MEET THE RANGE CRITERIA specified.  If NO RANGE CRITERIA are specified the edit will be applied to all products.

When trying to edit fields that are locked in electronically imported records, those product records will be excluded from the edit.

Only For

Be sure to check this to limit changes to only records with the value listed in the old field.

Old Field

Enter what the system should match.  This field will be labeled with the selection made on the first screen.

New Field

Enter the new data that will replace the old data. Note: This routine cannot be used to populate information into a blank field, only to edit existing data.

Range Criteria

Select Product Code(s)

This screen allows you to select the type of product you are looking for and tag the Product Codes needed. You may select individual codes or click the tag all button to select all the product codes in a list.

Entry Types

E-Commerce-Records imported via RFMS E-Commerce

Imported & Imported w-xref - records that were imported through a routine such as FloorLink, PL Import, etc.

Manual - records entered by hand.

RFMS Created-records created that have been created in inventory and did not have a product record associated with them.

Individual Types may be selected or the Tag All button can be used.

Dates

Transaction Date

The transaction date displays the last system date on which the record was updated (selling price changes excluded). The transaction date may not be manually changed.

Starting -Ending Input Date

Input date is when the product record was entered into your RFMS system. It cannot be changed. This will allow you to take a group of products that came in on a particular day and apply the formulas at that time.

These date parameters allow entering formulas that won’t affect past or future products.

Other Buttons in Criteria

These buttons allow the selection or exclusion of certain criteria.

The search tool at the top makes it easier to find the specific criteria.  Type letter, letters or the full name in the search box and click Tab.

Individual criteria may be selected or the Tag All button can be used.

The Exclude Selected checkbox at the bottom of the screen allows the tagged or selected manufacturers to be excluded instead of being part of the criteria.