Item List Price and Base Cost Update (Import)

Modified on Thu, 13 Dec 2018 10:23 by Freddy Donovan — Categorized as: Import- Export Manager, Item Control

Table of Contents [Hide/Show]

   General Information
   Fields/Filters
   File Definitions

General Information¶

Default Menu Location Transaction >> Importers/Exporters >> Item Control >> Item Base Cost/List Price Price Update

Screen Name UPDATECP

Function The Item Base Cost/List Price Update is used to update Item Master price/cost fields, vendor quoted cost values, and can also be used to update Sales Order Configuration (SOC) controlling price/cost values.

The Base Cost/List Price Update has three functions:

Item Master cost/price update: The Base Cost, Standard Cost, and List Price fields on the Item Master Settings tab can be updated with the corresponding values from the import file.

C/V Part quoted cost update: With the UpVPart column flagged as 'Y', and the appropriate entries filled in, matched C/V Part data can be updated with new quoted cost values and dates. The UpVPart features can be used on the same import file along with the Item Master Settings updates.

SOC cost/price update: With the SOCUpdate column flagged as 'Y', the Base Cost and List Price fields will update any matching SOC controlling quantity questions with the new values. When the SOCUpdate column is 'Y', the update will only affect SOC values. It will not affect Item Master Settings or C/V Part details.

Fields/Filters¶

Item Base Cost/List Price Update Screen

XLS File Name/Browse: Use the Browse button to locate and select the completed Base Cost/List Price import template file (in XLS format).

Export Template: Generates a blank Base Cost/List Price import template file

Map Fields: Fields must be mapped prior to importing. If no changes have been made to the column headings, the mapping screen should show all green, and you can click OK to continue. If any of the Input Field Name columns on the left are red, single-click on the line on the left column, and then double-click the desired mapped field in the right column to complete the mapping. Repeat for any red lines on the left that should be mapped. If there are additional columns in the source file that should NOT be mapped, they can be left unmapped (displayed in red). Mandatory fields will require that they be mapped before clicking OK.

File Definitions¶

Required fields are indicated with an *

f1 - VendNo - Vendor number from the C/V Part tab to update quoted cost values. The UpVPart column must be flagged 'Y' to process quoted cost values.

f2 - VPartNo - Vendor part number, also known as Supplier part number. The entries in this field are used to match existing C/V Part records. Entries in this import will not update or replace existing entries. Below are some of the reflexes to understand when entering VPartNo values:

If VPartNo is left blank, the import will match quoted cost updates based solely on the item and vendor combination
If the VPartNo is invalid, or doesn't exactly match the entry in the C/V Part record, it will not update (even if the vendor value is correct)
If the VendNo is blank on the import, the VPartNo can match multiple vendor records with the same vendor part number in the C/V Tab.

*f3 - Item - Item number to be updated

f4 - BaseCost - Item Master base cost value. If the line has the SOCUpdate flag set to 'Y', this value will only update the controlling quantity cost value in matched SOC setups.

f5 - ListPrice - Item Master list price value. If the line has the SOCUpdate flag set to 'Y', this value will only update the controlling quantity price value in matched SOC setups.

f6 - QuoteDate - Quoted Cost effective date for the C/V Part record. The UpVPart column must be flagged 'Y' to process quoted cost values.

f7 - QuoteExpDate - Quoted Cost expiration date for the C/V Part record. The UpVPart column must be flagged 'Y' to process quoted cost values.

f8 - SOCUpdate - Enter a 'Y' to process the base cost and list price values to the price and cost fields inside the SOC setup for the controlling quantity question. When SOCUpdate is 'Y', only the SOC values are updated.

f9 - StdCost - Item Master standard cost value.

f10 - QCost - Quoted Cost value for the C/V Part record. The UpVPart column must be flagged 'Y' to process quoted cost values.

f11 - UpVPart - Enter a 'Y' to process quoted cost details for the C/V Part record.