Chapter 86: Printing the Merchandising Cost Report (PMCR)

Purpose: Use this report to review the prices you pay your primary vendor for items and SKUs, including any PO additional charges that are included. This report also lists the offer price of each item, and calculates the gross margin percentage.

You can also populate a file with the report data for download.

This report sorts by offer. You can select up to 20 offers for the report; only items that are available through those offers will be selected for the report.

Select Offers for Merchandising Cost Report Screen

How to display this screen: Enter PMCR in the Fast path field at the top of any menu or select Print Merchandising Cost Report from a menu.

INR1340 ENTER Select Offers for Merchandising Cost Rpt 10/18/99 13:09:55 Generate File : N (Y/N) File Name: Enter Offers F3=Exit F9=Accept F12=Cancel

Field	Description
Generate file	This field indicates whether to create a file containing the selected items for the Merchandising Cost Report. You might wish to create a file for download from the iSeries. Valid values are: Y = Create a Merchandise Cost Download file, containing the items and data from the report. You will need to indicate the file name, below. N (default) = Do not create a file; generate the report only. Alphanumeric, 1 position; required.
File name	Enter the name to use when creating the Merchandise Cost Download file. The file name you specify should not contain any records, even for a different company; otherwise, you will need to clear this file before running the report. See the Step-by-step instructions. This field is required if the Generate file field is set to Y; otherwise, the system displays an error message if you attempt to enter a file name. Unless you specify another library, the file will be created in the default Data Base Library (A37) defined in the System Control file. Alphanumeric, 10 positions; required if the Generate file field is set to Y.
Enter offers	Enter up to 20 offers to include in the Merchandising Cost Report. You must enter at least one offer. Only items that you sell through an offer listed here will be included. The report begins a new page for each selected offer. If an item is included in more than one of the selected offers, it will appear on the report under each offer. Offers are defined in and validated against the Offer file. See Marketing Chapter 2: Working with Offers (WOFR). Alphanumeric, three positions; required.

Step-by-step instructions

1. Optionally, set the Generate file flag to Y and enter the file name, using Tab to move from field to field.

2. Enter at least one and up to 20 offers to include on the report and in the file.

3. Press Enter. The system validates your entries and highlights any fields you need to correct.

4. Press F9 to submit the Merchandising Cost Report and, optionally, populate the file, or press F3 or F12 to cancel. The system submits the job MERCH_COST.

Confirm delete window: You cannot add records to the specified file if it already exists when you generate the report. If the file name you entered already exists in your default data library and contains information, the system displays a pop-up window such as the following:

Confirm Delete The File ' IXMRCH ' already exists. Do you wish to Clear this File (Y/N)? N Enter 'Y' and press ENTER to confirm Delete. Enter 'N' and press ENTER to not Delete. F12=Exit

You must type Y at this window; this action tells the system to clear the file, generate the report and repopulate the file. If you Press Enter while the flag is set to N, you will not be able to generate the report or add records to the file.

Note: The file you populate, if any, will have the same layout as the Merchandise Cost Download file (IXMRCH).