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.
|
|
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
|
|
|