Price Updates - Import (F2) Function

Import (F2)

The Price Updates options offer a variety of Import (F2) options. Due to the number of Price Update options, Import may only apply in certain circumstances and certain conditions are applied to items prior to import.

Main Menu > Inventory > Price Updates, Import (F2)

Conditions Applied Before Import

The following list of conditions are applied when items are imported:

All Import (F2) options except the Wizard exclude "pull-to-length" tally items which are linked to other items. Other tally item types are not specifically excluded; however, not all are necessarily supported.

When using the Level Maintenance option, items selected for import are checked to see if any of the item's price levels involve a type "P" (set price). If so, the item is copied (imported); otherwise, if no price levels involve a specifically set price (P), the item is notcopied.

Import Availability by Price Update Type

In the table shown below, the import types are listed along the top row (horizontally) and the types of price updates are listed in the first (left-most) column. For example, the "Matrix Code" Import (F2) option is only provided when using a "Price Cost Entry" or "Sale Item Setup" update type, and not provided with any of the other options.


Matrix Code

Inventory

Purchase Order

Receipt

Vendor Promotion

Previous Sale

Previous Price Update

Wizard

Price Cost Entry

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Branch Entry

No

Yes

Yes

Yes

Yes

Yes

Yes

No

Sale Item Setup

Yes

Yes

Yes

Yes

Yes

Yes

Yes

No

Level Maintenance

No

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Price Level Entry

No

Yes

Yes

Yes

Yes

Yes

Yes

Yes

File Maintenance

No

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Cost/Margin Entry

No

No

No

No

No

No

No

No

Delete Posted Sale

No

No

No

No

No

No

No

No

Promotions Setup

No

No

No

No

No

No

No

No

ACE Rewards

No

No

No

No

No

No

No

No

Matrix Code

This option imports inventory items matching a price matrix code you specify. Matrix codes may be defined from either the Code Definitions form or from Item Maintenance and the Branch, Codes tab Price Matrix maintenance icon Special_Form_Icon. When a matrix code is assigned to an item, pricing is calculated using defined multipliers and the specified basis price or cost. Multipliers less than 1.0 reduce the basis and multipliers greater than 1.0 increase the basis. Typically a number less than 1.0 would be used to provide a discount from the basis (which in this case would typically be either suggested list or store retail (level 0)). Numbers greater than 1.0 would usually be used with a basis that represents one of the item's costs (market, last receipt, or average cost) to calculate a price that is higher than the cost.

Import (F2), Matrix Code

Import (F2), Matrix Code

Only two (2) Price Update options support Import (F2) by Matrix code: Price Cost Entry and Sale Item Setup.

Inventory

The Import (F2) option for inventory offers a variety of options for selecting and copying inventory items into a transaction's data grid. Selection choices include the following: group/section range, keyword, location code, and classification.

Inventory Copy

Inventory Copy

The Selection control used here matches the control used by inventory reports and functions identically. For more detailed information about selection by inventory,Closed click here

Purchase Order

This option is used to copy items from an existing purchase order document. The item number, retail price (if any), and unit cost from the purchase order are copied. Unit Cost is converted to match the item's Pricing Unit of Measure if different. The retail price should already match the item's Pricing unit of measure unless it has been changed since the Purchase Order document was created. This Import (F2) option is available for most Price Update options excluding the following: Cost/Margin Entry, Delete Posted Sale, ACE Rewards, and Promotions Setup.

Receipt

This option is used to copy items from an existing inventory receipt document. Only items with a received quantity greater than zero are copied (imported). Only the item from the Inventory Receipt document is copied, not any pricing or cost information. Item costs are updated when inventory (items) are received. This Import (F2) option is available for most Price Update options excluding the following: Cost/Margin Entry, Delete Posted Sale, ACE Rewards, and Promotions Setup.

Vendor Promotion

Vendor promotions originate from a supplier and indicate special pricing for specific items for a specified period of time. This import option is only used with Do it Best® EDI currently. It does not refer to ACE Rewards™ or "promotions" which aren't traditional sale pricing and are applied with additional criteria.

The vendor's promotional data is compared to your inventory's vendor-item data to locate matching items. Pricing may be adjusted from the vendor's price if your corresponding item has a matching vendor-item with a package quantity defined. Package quantity is not considered if the "disable package conversion" is set on the vendor-item or the unit of measure already matches the default UM for Price Updates and the package quantity is one. If package conversion is not disabled, the package quantity is converted to the base unit of measure (based on the package quantity's designated unit of measure). This figure may be used to adjust the price if the resulting quantity isn't a one-to-one relationship with the vendor's package quantity. Costs, when applicable, are not adjusted and typically would not be found in promotional data.

Import_Vendor_Promotion

The promotion ID, promo description, and vendor code are listed for selection.

Important! Since your vendor's units of measure may not match with the measures your company uses for pricing, you should always visually compare prices to their associated units of measure to make sure they make sense before processing any changes.

When this option is used along with the Sale Pricing option, starting and ending sale dates are set to match the vendor's promotion by default.

Items must be marked for "copy" using the EDI Promotions utility prior to import. Only selected "copy" items are imported.

This Import (F2) option is usually used with the Sale Pricing option; however, it is available for most Price Update options excluding the following: Cost/Margin Entry, Delete Posted Sale, ACE Rewards, and Promotions Setup.

Previous Sale

This option allows you to copy items from a previously applied "sale" price update. Sale Price updates are selected by document, not dates. After selecting a sale document, a dialog is shown asking whether you want to set the "new" price to match the most recent sale price for the items being copied (imported). The most recent sale price is not necessarily the same as the price from the document you select. If you select "no," only the items and their current pricing are copied (imported) into the data grid.

Import_Previous_Sale_Prompt

Warning!

If you respond "Yes" to the prompt, the price is set to match the most recent sale price for the item even if the Price Update selection is not Sale Pricing!

This Import (F2) option is usually used with the Sale Pricing option; however, it is available for most Price Update options excluding the following: Cost/Margin Entry, Delete Posted Sale, ACE Rewards, and Promotions Setup.

Previous Price Update

The "previous price update" option allows you to copy items from a previously applied price update (does not include "sale" pricing which are maintained separately). No conditions are applied to the data and only the list of items from the document is copied (imported). Pricing from the document is not imported.

Wizard

The Import (F2), Wizard option provides a generic way to import external data into the application. There are two methods for data selection: document and Windows file. The document option allows you to select any document. The "Windows File" option can be used to import data from a delimited file or spreadsheet, for example. Different transactions have different requirements. As one example, the wizard may be used for copying inventory items into a transaction's data grid. In this case, copying inventory items is only possible if the source document or data selected contains item information.

To import data using the Wizard:

1. In the Tags & Labels Printing form, choose Import (F2) and choose the Wizard file or document from the context list.
The Import Wizard dialog box displays.

Import Wizard

2. Choose the kind of file you are importing the information from (Document or Windows file) and choose the name and location of the file from the list.
The Grid Mapping section changes based on the transaction and is used for determining which data columns (listed in the "Preview Data" panel) are to be used from the source (document or file). The source document or file will contain some columns that apply to the transaction specific "mapping" and some that don't. Mapping selections can be saved for future use. This is suggested if you repeatedly copy data from the same document type or file source.

3. Choose the Item, List Price, Price UM, Market Cost, and Cost UM locations in the original file from the drop down lists to map the data you are importing correctly.
Note: Depending upon the type of information you are importing, these list options change. Additional conditions may be applied to the data after the user chooses Process. Choosing Cancel clears and closes the form without importing any data.

4. Select the Remove Invalid Items option, if applicable. (Not Required).
The "Remove Invalid Items" check box can be used to permit processing when one or more valid item rows are present in the data. For example, if you had ten (10) items and two (2) of the items had errors, checking the "remove invalid items" would produce a Task List with a "warning" and "accept warnings" button instead of a hard error. This would allow processing of the eight (8) item rows without any errors.

5. Choose Process (F12)to complete the import wizard process.

Due to the mapping feature, the Wizard frequently can be used as a work around when other more specific Import functions are not provided.

The Import (F2) Wizard closes immediately after processing, so you'd want to "export" your errors before processing if you want to review and fix the items with errors later on. If you forget, you can always import the same file, export the errors and then cancel the import.

In the Price Updates transaction, and when enabled, the Wizard offers mapping fields that correspond with the selected Price Update option.