Print Price List





  *PGMMOD                    Print Price List                 DD/MM/YY HH:MM:SS

  Report . . .   I         Headings . .   I         Database File  .   I
  Double Space   I                                  Print Company Name I

  Effective Date 33/33/33  Price Chg Date 33/33/33  New Item Date  .   33/33/33
  Catalog  . .   IIIIIIII  Catalog Only   I         Catalog Sequence   I
  Product Status 33        Stocking Type  33        Inventory Type .   33
  Margin Basis   I         Print Category I         Product Sort Seq   I
  Alternate Keys I
  Facility . .   33        Buyer Code .   III       Brand Short Name   IIIIIIII
  Copies . . .   33        Forms Type    IIIIIIIIII Brand Page Break   I

                               ---  Customer  --
  Column  Field  Heading       Code   -or- Class  Cut
     1     II    IIIIIIIIIIII  3333333      IIII   I
     2     II    IIIIIIIIIIII  3333333      IIII   I
     3     II    IIIIIIIIIIII  3333333      IIII   I
     4     II    IIIIIIIIIIII  3333333      IIII   I
     5     II    IIIIIIIIIIII  3333333      IIII   I
     6     II    IIIIIIIIIIII  3333333      IIII   I

  F3=Exit   F12=Cancel







Introduction

This function allows you to enter fields for processing. Detail_screen This screen allows you to enter the values for a number of fields. When you press ENTER the values will be checked.



Function Keys

F1=Help.

Display related help display. By positioning the cursor at a field on the display and pressing help, help narrative will be displayed for that field. By placing the cursor on the title for the display, help narrative related to the entire function will be displayed. Once the any help narrative is displayed you may then enlarge the display by using the F20 key or you may display expanded help narrative by using the F2 key.

F3=Exit.

Exit the current task. In most cases this will return you to a high level function without displaying all displays encountered in getting to this point.

F4=Prompt.

Display a list of values available to be used in the related field. Place your cursor on the field for which you would like to see a list and press the F4 key.

F5=Reset.

Refreshes the display. In most cases the display will be refreshed to the original values and any keyed information typed after the last enter key will be lost.

F12=Cancel.

Return to previous display without performing any action.

HELP=Help.

Display related help display. By positioning the cursor at a field on the display and pressing help, help narrative will be displayed for that field. By placing the cursor on the title for the display, help narrative related to the entire function will be displayed. Once the any help narrative is displayed you may then enlarge the display by using the F20 key or you may display expanded help narrative by using the F2 key.



Variable Definitions

Report

REQUIRED
A code indicating if the report should be printed.
   N = No
   Y = Yes

Headings

REQUIRED
A code indicating whether or not the Price List Headings are to be printed.
   N = No
   Y = Yes

Database File

REQUIRED
A code indicating whether or not the price list should be output to a data base file.
   N = No
   Y = Yes

Double Space

REQUIRED
A code indicating if the Price List should be double spaced.
   N = No
   Y = Yes

Print Company Name

REQUIRED

Effective Date

REQUIRED
The date the price list is to become effective.

Price Chg Date

OPTIONAL
Only those items having had a price change after this date will be included on the report.

New Item Date

OPTIONAL
The date to be used to determine whether or not item should be printed. Only products having a record date on or after the New Items Date will be included.

Catalog

OPTIONAL
The catalog for which the price list is to be printed. Item not in the catalog will not appear on the price list.

Catalog Only

REQUIRED
A code indicating whether or not to include only items found to be in the catalog associated with the Price List. If "N" is specified, all items will be included. However, prices will be determined based on the catalog criteria for those products found to be in the catalog.
   N = No
   Y = Yes

Catalog Sequence

REQUIRED
A code indicating whether or not the price list should be printed in Catalog sequence.
   N = No
   Y = Yes

Product Status

REQUIRED
A summary number identifying the Product Statuses to be included on the Price List. The summary number is determined by adding together the codes associated with each Product Status as indicated below: 01 = Active; 02 = Discontinued. To get Active only, enter 01. To get discontinued only, enter 02. To get both, enter 03 (01 + 02)

Stocking Type

REQUIRED
A summary number used to identify the Product Stocking Types to be included on the Price List. The summary number is determined by adding together the codes associated with each Product Stocking Type as indicated below: 01 = Not Stocked; 02 = Order as Required; 04 = Shipped Direct; 08 = Stocked; 16 = Unclassified. To get Not Stocked, enter 01. To get Stocked, enter 08. To get Order as Required and Stocked, enter 10 (02 + 08).

Inventory Type

REQUIRED
A summary number identifying the Inventory Type codes to be included on the Price List. The summary number is determined by adding together the codes associated with each Inventory type as indicated below. 01 = Assembled 02 = Bought 04 = Manufactured 08 = Sales Package 16 = Unclassified To list Bought, enter 02. To list Unclassified, enter 16. To List both Manufactured and Assembled, enter 05 (01 + 04).

Margin Basis

OPTIONAL
The cost basis to be used when determining any margins to be printed on the Price List.
   A = Average Cost
   V = Default Vendor Price
   R = Most Recent Cost

Print Category

REQUIRED
A code indicating if the product category description is to print on the price list. The product category will print every time it changes.
   N = No
   Y = Yes

Product Sort Seq

REQUIRED
Enter Yes (Y) if you want to sort products by Sort Sequence within Brand, enter No (N) to sort by Mfg Part Number without using Sort Sequence.
   N = No
   Y = Yes

Alternate Keys

REQUIRED
A code indicating if the code output to the data base file should be output as alternate keys to the product.

Facility

REQUIRED
A unique number assigned by the user identifying a Facility.

Buyer Code

OPTIONAL

Brand Short Name

OPTIONAL

Copies

REQUIRED
The number of Price List copies to print.

Forms Type

OPTIONAL
The forms type to be assigned to the Price List Report.

Brand Page Break

REQUIRED
A code indicating whether each brand should begin on a new page.
   N = No
   Y = Yes

Price List Field 1 Code

REQUIRED
A code identifying the type of value to be place in the price list field.
   06 = Average Cost
   43 = Broken Pack Margin
   14 = Broken Pack Price
   37 = Broken Pack Price Disc
   31 = Catalog Page
   19 = Core Cost
   18 = Core Price
   46 = Customer Product X-Ref
   08 = Default Vendor Price
   17 = Duty In
   21 = Est. Replacement Cost
   22 = Estimated Freight
   15 = Federal Tax
   33 = Hurdle 1 Discount
   39 = Hurdle 1 Margin
   10 = Hurdle 1 Price
   34 = Hurdle 2 Discount
   40 = Hurdle 2 Margin
   11 = Hurdle 2 Price
   35 = Hurdle 3 Discount
   41 = Hurdle 3 Margin
   12 = Hurdle 3 Price
   36 = Hurdle 4 Discount
   42 = Hurdle 4 Margin
   13 = Hurdle 4 Price
   00 = List Price
   44 = Minimum Sell Quantity
   07 = Most Recent Cost
   29 = Price Class
   24 = Primary Bin
   30 = Product Class
   01 = Product Price 1
   02 = Product Price 2
   03 = Product Price 3
   04 = Product Price 4
   05 = Product Price 5
   26 = Quantity Available
   23 = Quantity On Hand
   25 = Secondary Bin
   09 = Sell Price
   32 = Sell Price Discount
   38 = Sell Price Margin
   28 = Sort Sequence
   27 = Tariff In Class
   45 = UPC Number

Price List Field 1 Headng

REQUIRED
The text to be used above the associated field on the report.

Price List Field 1 Acct

OPTIONAL
The customer account to be used when determining the value to be placed in the associated field.

Price List Field 1 Class

OPTIONAL
The Account Price Class to be used when determining the value to be placed in the associated field.

Price List Field 1 Cut

REQUIRED
The Cut Type to be used when determining the value to be placed in the associated field.
   C = Chop Cut
   L = Length
   N = No Cut
   S = Straight

Price List Field 2 Code

OPTIONAL
A code identifying the type of value to be placed in the price list field.
   06 = Average Cost
   43 = Broken Pack Margin
   14 = Broken Pack Price
   37 = Broken Pack Price Disc
   31 = Catalog Page
   19 = Core Cost
   18 = Core Price
   46 = Customer Product X-Ref
   08 = Default Vendor Price
   17 = Duty In
   21 = Est. Replacement Cost
   22 = Estimated Freight
   15 = Federal Tax
   33 = Hurdle 1 Discount
   39 = Hurdle 1 Margin
   10 = Hurdle 1 Price
   34 = Hurdle 2 Discount
   40 = Hurdle 2 Margin
   11 = Hurdle 2 Price
   35 = Hurdle 3 Discount
   41 = Hurdle 3 Margin
   12 = Hurdle 3 Price
   36 = Hurdle 4 Discount
   42 = Hurdle 4 Margin
   13 = Hurdle 4 Price
   00 = List Price
   44 = Minimum Sell Quantity
   07 = Most Recent Cost
   29 = Price Class
   24 = Primary Bin
   30 = Product Class
   01 = Product Price 1
   02 = Product Price 2
   03 = Product Price 3
   04 = Product Price 4
   05 = Product Price 5
   26 = Quantity Available
   23 = Quantity On Hand
   25 = Secondary Bin
   09 = Sell Price
   32 = Sell Price Discount
   38 = Sell Price Margin
   28 = Sort Sequence
   27 = Tariff In Class
   45 = UPC Number

Price List Field 2 Headng

OPTIONAL
The text to be used above the associated field on the report.

Price List Field 2 Acct

OPTIONAL
The customer account to be used when determining the value to be place in the associated field.

Price List Field 2 Class

OPTIONAL
The Account Price Class to be used when determining the value to be placed in the associated field.

Price List Field 2 Cut

REQUIRED
The Cut Type to be used when determine the value to be placed in the associated field.
   C = Chop Cut
   L = Length
   N = No Cut
   S = Straight

Price List Field 3 Code

OPTIONAL
A code identifying the type of value to be placed in the price list field.
   06 = Average Cost
   43 = Broken Pack Margin
   14 = Broken Pack Price
   37 = Broken Pack Price Disc
   31 = Catalog Page
   19 = Core Cost
   18 = Core Price
   46 = Customer Product X-Ref
   08 = Default Vendor Price
   17 = Duty In
   21 = Est. Replacement Cost
   22 = Estimated Freight
   15 = Federal Tax
   33 = Hurdle 1 Discount
   39 = Hurdle 1 Margin
   10 = Hurdle 1 Price
   34 = Hurdle 2 Discount
   40 = Hurdle 2 Margin
   11 = Hurdle 2 Price
   35 = Hurdle 3 Discount
   41 = Hurdle 3 Margin
   12 = Hurdle 3 Price
   36 = Hurdle 4 Discount
   42 = Hurdle 4 Margin
   13 = Hurdle 4 Price
   00 = List Price
   44 = Minimum Sell Quantity
   07 = Most Recent Cost
   29 = Price Class
   24 = Primary Bin
   30 = Product Class
   01 = Product Price 1
   02 = Product Price 2
   03 = Product Price 3
   04 = Product Price 4
   05 = Product Price 5
   26 = Quantity Available
   23 = Quantity On Hand
   25 = Secondary Bin
   09 = Sell Price
   32 = Sell Price Discount
   38 = Sell Price Margin
   28 = Sort Sequence
   27 = Tariff In Class
   45 = UPC Number

Price List Field 3 Headng

OPTIONAL
The text to be used above the associated field on the report.

Price List Field 3 Acct

OPTIONAL
The customer account to be used when determining the value to be placed in the associated field.

Price List Field 3 Class

OPTIONAL
The Account Price Class to be used when determining the value to be placed in the associated field.

Price List Field 3 Cut

REQUIRED
The Cut Type to be used when determining the value to be placed in the associated field.
   C = Chop Cut
   L = Length
   N = No Cut
   S = Straight

Price List Field 4 Code

OPTIONAL
A code identifying the type of value to be placed in the price list field.
   06 = Average Cost
   43 = Broken Pack Margin
   14 = Broken Pack Price
   37 = Broken Pack Price Disc
   31 = Catalog Page
   19 = Core Cost
   18 = Core Price
   46 = Customer Product X-Ref
   08 = Default Vendor Price
   17 = Duty In
   21 = Est. Replacement Cost
   22 = Estimated Freight
   15 = Federal Tax
   33 = Hurdle 1 Discount
   39 = Hurdle 1 Margin
   10 = Hurdle 1 Price
   34 = Hurdle 2 Discount
   40 = Hurdle 2 Margin
   11 = Hurdle 2 Price
   35 = Hurdle 3 Discount
   41 = Hurdle 3 Margin
   12 = Hurdle 3 Price
   36 = Hurdle 4 Discount
   42 = Hurdle 4 Margin
   13 = Hurdle 4 Price
   00 = List Price
   44 = Minimum Sell Quantity
   07 = Most Recent Cost
   29 = Price Class
   24 = Primary Bin
   30 = Product Class
   01 = Product Price 1
   02 = Product Price 2
   03 = Product Price 3
   04 = Product Price 4
   05 = Product Price 5
   26 = Quantity Available
   23 = Quantity On Hand
   25 = Secondary Bin
   09 = Sell Price
   32 = Sell Price Discount
   38 = Sell Price Margin
   28 = Sort Sequence
   27 = Tariff In Class
   45 = UPC Number

Price List Field 4 Headng

OPTIONAL
The text to be used above the associated field on the report.

Price List Field 4 Acct

OPTIONAL
The customer account to be used when determining the value to be placed in the associated field.

Price List Field 4 Class

OPTIONAL
The Account Price Class to be used when determining the value to be placed in the associated field.

Price List Field 4 Cut

REQUIRED
The Cut Type to be used when determining the value to be placed in the associated field.
   C = Chop Cut
   L = Length
   N = No Cut
   S = Straight

Price List Field 5 Code

OPTIONAL
A code identifying the type of value to be placed in the price list field.
   06 = Average Cost
   43 = Broken Pack Margin
   14 = Broken Pack Price
   37 = Broken Pack Price Disc
   31 = Catalog Page
   19 = Core Cost
   18 = Core Price
   46 = Customer Product X-Ref
   08 = Default Vendor Price
   17 = Duty In
   21 = Est. Replacement Cost
   22 = Estimated Freight
   15 = Federal Tax
   33 = Hurdle 1 Discount
   39 = Hurdle 1 Margin
   10 = Hurdle 1 Price
   34 = Hurdle 2 Discount
   40 = Hurdle 2 Margin
   11 = Hurdle 2 Price
   35 = Hurdle 3 Discount
   41 = Hurdle 3 Margin
   12 = Hurdle 3 Price
   36 = Hurdle 4 Discount
   42 = Hurdle 4 Margin
   13 = Hurdle 4 Price
   00 = List Price
   44 = Minimum Sell Quantity
   07 = Most Recent Cost
   29 = Price Class
   24 = Primary Bin
   30 = Product Class
   01 = Product Price 1
   02 = Product Price 2
   03 = Product Price 3
   04 = Product Price 4
   05 = Product Price 5
   26 = Quantity Available
   23 = Quantity On Hand
   25 = Secondary Bin
   09 = Sell Price
   32 = Sell Price Discount
   38 = Sell Price Margin
   28 = Sort Sequence
   27 = Tariff In Class
   45 = UPC Number

Price List Field 5 Headng

OPTIONAL
The text to be used above the associated field on the report.

Price List Field 5 Acct

OPTIONAL
The customer account to be used when determining the value to be placed in the associated field.

Price List Field 5 Class

OPTIONAL
The Account Price Class to be used when determining the value to be placed in the associated field.

Price List Field 5 Cut

REQUIRED
The Cut Type to be used when determining the value to be placed in the associated field.
   C = Chop Cut
   L = Length
   N = No Cut
   S = Straight

Price List Field 6 Code

OPTIONAL
A code identifying the type of value to be placed in the price list field.
   06 = Average Cost
   43 = Broken Pack Margin
   14 = Broken Pack Price
   37 = Broken Pack Price Disc
   31 = Catalog Page
   19 = Core Cost
   18 = Core Price
   46 = Customer Product X-Ref
   08 = Default Vendor Price
   17 = Duty In
   21 = Est. Replacement Cost
   22 = Estimated Freight
   15 = Federal Tax
   33 = Hurdle 1 Discount
   39 = Hurdle 1 Margin
   10 = Hurdle 1 Price
   34 = Hurdle 2 Discount
   40 = Hurdle 2 Margin
   11 = Hurdle 2 Price
   35 = Hurdle 3 Discount
   41 = Hurdle 3 Margin
   12 = Hurdle 3 Price
   36 = Hurdle 4 Discount
   42 = Hurdle 4 Margin
   13 = Hurdle 4 Price
   00 = List Price
   44 = Minimum Sell Quantity
   07 = Most Recent Cost
   29 = Price Class
   24 = Primary Bin
   30 = Product Class
   01 = Product Price 1
   02 = Product Price 2
   03 = Product Price 3
   04 = Product Price 4
   05 = Product Price 5
   26 = Quantity Available
   23 = Quantity On Hand
   25 = Secondary Bin
   09 = Sell Price
   32 = Sell Price Discount
   38 = Sell Price Margin
   28 = Sort Sequence
   27 = Tariff In Class
   45 = UPC Number

Price List Field 6 Headng

OPTIONAL
The text to be used above the associated field on the report.

Price List Field 6 Acct

OPTIONAL
the customer account to be used when determining the value to be placed in the associated field.

Price List Field 6 Class

OPTIONAL
The Account Price Class to be used when determining the value to be placed in the associated field.

Price List Field 6 Cut

REQUIRED
The Cut Type to be used when determining the value to be placed in the associated field.
   C = Chop Cut
   L = Length
   N = No Cut
   S = Straight