Item

The item and SKU you wish to select for catalog planning. A message similar to the following displays if you enter an item or SKU that has not been assigned to an offer:

No SKU/Offer Records exist for item (TH9078 BLCK)

Item: Alphanumeric, 12 positions; required.

SKU: Alphanumeric, one 14-position field (full SKU) or three 4-position fields (split SKU); optional.

Offer

The offer you are updating with catalog pricing information. This field displays only if you enter this screen by pressing F14 through Work with Items/SKUs (fast path = MITM).

Alphanumeric, 3 positions; display-only.

Item/SKU

The item or SKU you selected for catalog planning.

Item: Alphanumeric, 12 positions; display-only.

SKU: Alphanumeric, one 14-position field (split SKU) or three 4-position fields (full SKU); display-only.

Default cost

The default cost of the item/SKU. The default cost defaults from the cost on the first Create Item Screen in Work with Item/SKUs. If a cost has not been defined in Work with Item/SKUs, this field displays blank.

Numeric, 10 positions with a 4-place decimal; display-only.

Item description

The description of the item you selected for catalog planning.

Alphanumeric, 40 positions; display-only.

SKU description

The description of the SKU you selected for catalog planning.

Alphanumeric, 40 positions; display-only.

Actual offer price

The offer price defined for this item/SKU. The actual offer price is defined in the currency of the offer. If you advanced to this screen through Work with Catalog Planning, the system defaults the price for the offer defined in the Current Offer Number system control value. If you advance to this screen through a create or change Item or SKU Offer screen (MITM), the price defined for that offer defaults.

Note: If you process orders that are subject to Value Added Tax (VAT), the system pulls the price defined in the Price field instead of the price defined in the Tax inclusive price field from Work with Item/SKUs. See the Tax Included in Price (E70) system control value.

Numeric, 7 positions with a 2-place decimal; required.

Cost

The average or standard cost of the item/SKU. This cost defaults from the SKU screen in Work with Item/SKUs (fast path = MITM). The cost is defined in your local currency.

You define whether the system uses average or standard costing in the Costing Method (A25) system control value.

Numeric, 11 positions with a 4-place decimal; required if you enter an offer price.

Currency code

A code that represents the currency defined for the offer. This field displays only if Multi Currency by Offer (E03) is set to Y and you advanced to this screen by pressing F14 on a create/change Item/SKU Offer screen in Work with Item/SKUs. See Accounts Payable Working with Currency (WCUR) for more information on currency and conversion rates.

Alphanumeric, 3 positions; display-only.

Conversion rate

The rate at which the currency is converted to your local currency. The system divides the amount in the foreign currency by the conversion rate to determine the amount in your local currency.

Example: If you set the conversion rate for Canadian dollars at 1.3, the system would convert $10.00 to $7.69 in your local currency, dividing 10 by 1.3.

This field displays only if Multi Currency by Offer (E03) is set to Y and you advanced to this screen by pressing F14 on a create/change Item/SKU Offer screen in Work with Item/SKUs.

Numeric, 11 positions with a 7-place decimal; required.

Effective date

The date the price or quantity break discount becomes valid. This date should be equal to or greater than the effective date of the offer. The customer receives this price when placing an order on this date or later. The system defaults the current date in this field.s

If you establish multiple effective dates for the same item/offer, the system uses the price associated with the effective date closest to, but not greater than, the order date.

Example: If you establish effective dates of Feb. 20, and Mar. 31 and the customer places an order on April 1, the customer receives the price associated with the effective date of March 31.

Numeric, 6 positions (MMDDYY format); required if an offer price has been defined.

Gross est freight

Your "best guess" on the vendor's freight charges for this item or SKU. Gross estimated freight is defined in your local currency. The gross estimated freight defaults from the Item Class file. This amount is added to an item's cost to represent the estimated freight charges. Including estimated freight charges is helpful if you sell merchandise before the actual freight charges are known.

The system includes estimated freight in the cost of an item when determining gross profit in order entry, maintenance, inquiry and item availability. Gross profit margin is the amount of the item's price that exceeds your cost of the item. You can use gross margin to determine the profit of an item on an order based on the item's selling price, or to determine the profit of an entire order. See Order Entry Inquiring into Item Availability (DIAV) for more information on how the system calculates gross profit.

The system uses the following calculation to determine the gross estimated freight if you have defined an estimated freight and estimated freight percentage for a class of items:

estimated freight + (item's cost x estimated freight percent) = gross estimated freight

Example:

estimated freight = 5.00

estimated freight percent = 70.00%

item's cost = 2.00

5.00 + (2.00 x 70.00%)

5.00 + 1.40 = 6.40 (gross estimated freight)

See Working with Item Classes (WICL) for more information on defining estimated freight by item class.

Numeric, 9 positions with a 2-place decimal; optional.

Desired G/M% (Desired gross margin percent)

The percentage of the item's price that should exceed the cost of the item. This value defaults from the Item Class file, but you can override it. This percentage can not be greater than 99.99. You can use this value to help you decide how to price an item in an offer so that the price results in a profitable outcome.

Numeric, 6 positions with a 2-place decimal; optional.

Duty

An additional charge that you may be required to add to orders shipping to certain countries. Duty is defined in your local currency. The system uses an item's harmonize code to determine whether to add a duty charge to an order. See Updating Harmonize Codes (UPHC) for more information on assigning a harmonize code to an item or SKU. See Customer Service Setting Up the Country File (WCTY) for more information on setting up duty rates for countries.

This field is always blank. If you enter a duty rate for this item, the system uses the rate only in the calculations pertaining to this screen.

Numeric, 12 positions with a 2-place decimal; optional.

Gross cost

The system-calculated cost of the item based on the values entered in the Cost, Gross estimated freight and Duty fields. The system uses the following calculation to determine gross cost:

cost + gross estimated freight + duty = gross cost

Example:

cost = 4.00

gross estimated freight = 6.40

duty = 1.00

4.00 + 6.40 + 1.00 = 11.40 (gross cost)

Numeric, 10 positions with a 2-place decimal; display-only.

Suggested sale price

The system-calculated sale price based on the values entered in the Gross cost, Conversion rate and Desired gross margin percent fields. The system uses the following calculation to determine the suggested sale price:

(gross cost x conversion rate)/(1 - desired gross margin percent) = suggested sale price

Example:

gross cost = 10.00

conversion rate = 1.00

desired gross margin percent = 20.0%

(10.00 x 1.00)/(1 - 20%)

10.00/.8 = 12.50 (suggested sale price)

Example using multiple currencies:

gross cost = 10.00

conversion rate = 2.00

desired gross margin percent = 20.0%

(10.00 x 2.00)/(1-20%)

20.00/.8 = 25.00 (suggested sale price)

Numeric, 7 positions with a 2-place decimal; display-only.

Gross margin amount

The system-calculated gross margin based on the values entered in the Actual offer price, gross cost and Conversion rate fields. The system uses the following calculation to determine gross margin amount:

actual offer price - (gross cost x conversion rate)

Example:

actual offer price = 30.00

gross cost = 10.00

conversion rate = 1.00

30.00 - (10.00 x 1.00)

30.00 - 10.00 = 20.00 (gross margin amount)

Example using multiple currencies:

actual offer price = 30.00

gross cost = 10.00

conversion rate = 2.00

30.00 - (10.00 x 2.00)

30.00 - 20.00 = 10.00 (gross margin amount)

Numeric, 9 positions with a 2-place decimal; display-only.

Gross margin % (Gross margin percent)

The system-calculated gross margin percent based on the values entered in the Actual offer price, gross cost and Conversion rate fields. The system uses the following calculation to determine gross margin percent:

[actual offer price - (gross cost x conversion rate)]/actual offer price) x 100

Example:

actual offer price = 30.00

gross cost = 10.00

conversion rate = 1.00

[30.00 - (10.00 x 1.00)]/30.00) x 100

(30.00 - 10.00)/30.00) x 100

(20.00/30.00) x 100

.66 x 100 = 66.67% (gross margin percent)

Example using multiple currencies

actual offer price = 30.00

gross cost = 10.00

conversion rate = 2.00

[30.00 - (10.00 x 2.00)]/30.00) x 100

(30.00 - 20.00)/30.00) x 100

(10.00/30.00) x 100

.33 x 100 = 33.33% (gross margin percent)

Numeric, 5 positions with a 2-place decimal; display-only.

Item/SKU

The item and SKU you selected for catalog planning.

Item: Alphanumeric, 12 positions; display-only.

SKU: Alphanumeric, one 14-position field (full SKU) or three 4-position fields (split SKU); display-only.

Price

The offer price defined for this item/SKU. The offer price defaults from the price defined on the Catalog Planning Screen (Catalog Pricing).

Numeric, 7 positions with a 2-place decimal; display-only.

Item description

The description of the item you selected for catalog planning.

Alphanumeric, 40 positions; display-only.

SKU description

The description of the SKU you selected for catalog planning.

Alphanumeric, 40 positions; display-only.

Offer

An offer associated with this item/SKU. See Marketing Working with Offers (WOFR).

Alphanumeric, 3 positions; optional.

Description

The description of the offer.

Alphanumeric, 30 positions; display-only.

Selected

This field identifies whether you want to update the offer with the catalog planning information. Valid values are:

Selected = This offer will update with the catalog planning information.

Blank = This offer will not update with the catalog planning information.

Alphanumeric, 8 positions; optional.