Atrieve Finance

Purchase Order Print Format

The Purchase Order Print Format allows you to define to the system via parameters the exact format of your purchase order. This is done with the help of a forms format ruler which measures print lines and print positions. While it is possible to calculate these manually, it can be quite difficult. Investing in one of these rulers both saves time and improves accuracy. This program features four screens that define to the system the following information:

  •  General order size parameters (Basic Print Parameters)

  • Order body print lines (Order Body Parameters)

  • Order stub print lines (Order Stub Parameters)

  • Order total lines (Order Total Parameters)

Note: The 'body' of the PO is defined as the fixed portion of the PO. (eg. name/address, etc. information). The 'stub' denotes the variable portion of the PO (e.g. quantity ordered, price, etc.)

** If you are using Purchase Order Management, your PO parameters must be set up through the POM User Parameter Menu.

BASIC PRINT PARAMETERS

PURCHASE ORDER DETAIL PRINT

PARAMETERS

BASIC PRINT

PARAMETERS

# Of Print Lines On Order 66

# OF PRINT LINES IN STUB [01-00] 

29

# Of Print Lines in Body 18

ORDER STUB FIRST OR

LAST L  

ENTER FIELD # TO CHANGE

<ENTER>

# Of Print Lines On Order

  • Enter the number of lines to be printed on the entire order. Example, for an 11 inch form set to print 6 lines per inch, enter 66.

# Of Print Lines On Stub

  • Enter the number of print detail lines to be printed on the stub of the order, excluding total lines.

# Of Print Lines in Body

  • Enter the number of print lines contained in the fixed portion of the order to be printed.

Stub First Or Last

  • Enter 'F' if the stub is to be printed first on the order or 'L' if the stub is to be printed after the body of the order. Note:  Printing of the stub prior to the body is not currently available. 'L' must be entered.

Order Body Parameters 


PURCHASE ORDER DETAIL PRINT Profile

ORDER BODY PARAMETERS

______________________________________________________________________________
 ITEM LINEPPSSizeL/R  FIELD NamePRINT MASK
______________________________________________________________________________
01 05010 30 LV-Name$'LLLLLLLLLLLLLLLL..

02 06010 30 LV-ADDRESS1$'LLLLLLLLLLLLLLLL..

03 07010 30 LV-ADDRESS2$'LLLLLLLLLLLLLLLL..

04 08010 30 LV-ADDRESS3$'LLLLLLLLLLLLLLLL..

ENTER ITEM # TO CHANGE

  • Note: If you must enter more than 15 body parameters, the above screen will repeat for 15 additional parameters.

Item

  • The item number referenced in the Field To Change prompt.

Line

  • The order line number on which to begin printing.

PPS

  • Enter the print position on which to begin printing.

Size

  • For alpha/numeric fields, enter the size of the field to be printed. Enter 'R' to right justify the field.

Field Name

  • Enter a valid field name to represent what to have printed on the order at that print position (see Valid Field Names section). A response of 'HELP' to this field will cause the system to display a list of valid variable names.

Mask

  • Enter any valid BASIC print mask (see Appendix H).

Order Stub Parameters

PURCHASE ORDER DETAIL PRINT Profile

ORDER STUB PARAMETERS

____________________________________________________________________________
 ITEM LINEPPSSizeL/R  FIELD NamePRINT MASK
_____________________________________________________________________________
01 25002 10 LV-NUMBER$'LLLLLLLLL

02 25015 30 LC-Name$'LLLLLLLLL

03 25028 02 LP-DDATE'LLLLLLLLL

04 26002 30 LD-DESC1$'LLLLLLLLLL...

05 26070 14 LT-AMOUNT#,###,###.##-

ENTER ITEM # TO CHANGE <ENTER>

Item

  • The item number referenced in the Field To Change prompt.

Line

  • The order line number on which to begin printing. Note: The system will continue to print detail lines on the next available line until the number of stub lines indicated in the order stub size record has been exhausted or all items have been printed for that order.

PPS

  • Enter the print position on which to begin printing.

Size

  • For alpha/numeric fields, enter the size of the field to be printed.

L/R

  • Enter 'L' to left justify the field or 'R' to right justify the field.

Field Name

  • Enter a valid field name to represent what to have printed on the order at that print position (see Valid Field Names section). A response of 'HELP' to this field will cause the system to display a list of valid variable names.

Mask

  • Enter any valid Basic print mask (see Appendix H).

Order Total Parameters

Item

  • The item number referenced in the Field To Change prompt.

Line

  • The order line number on which to begin printing.

PPS

  • Enter the print position on which to begin printing.

Size

  • For alpha/numeric fields, enter the size of the field to be printed.

L/R

  • Enter 'L' to left justify the field or 'R' to right justify the field.

Field Name

  • Enter a valid field name to represent what to have printed on the order at that print position (see Valid Field Names section). A response of 'HELP' to this field will cause the system to display a list of valid variable names.

Mask

Valid Field Names

  • Generally speaking, valid field names may be broken into 7 categories as listed below:

V - Purchase Vendor Information

C - Pay To Information

S - Ship To Information

P - Purchase Order General Information

D - Detail Item Information

T - Totals Information

W - User Defined Literal Information

FIELD:

Size:

DESCRIPTION:

V-NUMBER$

10

Vendor Number

V-Name$

1-40

Vendor Name

V-ADDRESS1$

1-30

Vendor First Address line

V-ADDRESS2$

1-30

Vendor Second address line

V-ADDRESS3$

1-30

Vendor Third address line

V-ADDRESS4$

1-30

Vendor Fourth address line

V-POSTALCODE$

10

Vendor Postal/Zip code

V-ALT_LOCATION$

4

The alternate vendor location code defined in the vendor file (field 32).  If applicable, this will be uploaded into the vendor file  from payroll as part of the 'Employee Update from payroll'.

V-ALT_LOCATION_DESC$

30

The alternate vendor location code description defined in the vendor file.  If applicable, this will be uploaded into the vendor file  from payroll as part of the 'Employee Update from payroll'.

V-PAYCODE$

2

Vendor Currency pay code (eg: US Funds)

V-PHONE$

10

Vendor Phone number

V-FAX$

10

Vendor Fax number

C-NUMBER$

10

Pay to Vendor #

C-Name$

1-40

Pay to Vendor Name

C-ADDRESS1$

1-30

Pay to Vendor First Address Line

C-ADDRESS2$

1-30

Pay to Vendor Second Address Line

C-ADDRESS3$

1-30

Pay to Vendor Third Address Line

C-ADDRESS4$

1-30

Pay to Vendor Fourth Address Line

C-POSTALCODE$

10

Pay to Vendor Postal/Zip code

S-Name$

1-40

Ship To Name

S-ADDRESS1$

1-30

Ship to First address line

S-ADDRESS2$

1-30

Ship to Second address line

S-ADDRESS3$

1-30

Ship to Third address line

S-ADDRESS4$

1-30

Ship to Fourth address line

S-POSTALCODE$

10

Ship to Postal/Zip Code

S-PHONE$

10

Ship to vendor phone number

S-FAX$

10

Ship to vendor fax number

P-NUMBER$

10

P.O. Number

P-ESTIMATE


Total P.O. estimate amount

P-IDATE$


Prints as 880122

P-IDATE

9

P.O. date printed in the form

P-IDAYDATE

2

The day portion of the P-IDATE

P-IMONTHDATE

3

The month portion of the P-IDATE$ field.

P-IN_MONTHDATE

2

The month portion of the P-IDATE field as numeric. Requires print mask 'L.

P-IYEARDATE

2

The year portion of the P-IDATE field.

P-DDATE

6

Prints as 880301.

P-DDATE$

9

Delivery date in 01-MAR-88. Requires print mask 'LLLLLLLL.

P-DDAYDATE

2

The day portion of the P-DDATE field. Requires print mask 'L.

P-DMONTHDATE

3

The month portion of the P-DDATE$ field.

P-DN_MONTHDATE

2

Month portion of the P-DDATE field as numeric. Requires print mask 'L.

P-DYEARDATE

2

The year portion of the P-DDATE field. Requires print mask 'L.

P-REQNO$

10

Requisition Number

P-BUYER$

2

Buyer Number

P-ENDUSE$

1-30

User defined end use field.

P-DELTO$

1-30

User defined deliver to field.

P-SHIP$

1-30

User defined ship to field.

P-FOB$

1-30

Free on Board Designation

P-TERMS$

1-30

Pay terms (eg: net 30)

P-BATCH$

10

Batch number used to create the PO.

D-GLNO$

20

Will print the General Ledger account

D-EXTEND


Detail line extended amount

D-ORDERED


Detail line amount ordered

D-PRICE$

10

Detail line unit price

D-TAXCD$


Tax Code fields need not be entered in your print parameters. If tax codes are being used, these fields automatically print the description of the tax code and dollar amounts on the line below the last description line printed.

D-ITEM$

2

Line item number on the PO stub.

D-MEASURE$

10

Detail line unit of measure

D-DESC$

1-50

The description field on the PO.

D-STOCK$

10

Inventory stock item number.

D_PART$

10

Manufacturers part number

 FIELD:

Size:

DESCRIPTION:

T-AMOUNT


Total amount of PO.

T-ITEM


Total # of items on PO.

T-GLN0$


Prints the first GL account number encountered on a PO in the total section.

T-COMMIT


This prints the committed amount associated with a GL account.
(T-GLNOS)

T-REST$


This will print the words 'OTHER GL'S' if there are more GL's on the PO than were specified in the print parameters.

T-R_COMMIT


This will print the total of all commitment amounts associated with
T-REST$

W-LITERAL$

1-30

User defined print variable - Maximum 30 characters.

W-PAGE$


Will print the page number on the purchase order.

  • Note: PO Print program creates a print file ('job number.POL') which must be sent to the printer separately. By selecting option 2 in the PO Print Processing menu (Print PO's), this file will be created in your directory.

  • All fields which incorporate a $ are alphanumeric. All fields without a $ are numeric and require a print mask.

  • Certain fields are only functional in certain areas of the PO. The P-, V-, C-, and S- fields pertain only to the 'body' portion of the PO; D- functions only in the 'stub'. These fields are internally stored within the system. The T-field pertains to the total portion only. The W-Literal$ field will theoretically function in any of the fields, although for practical purposes it should be implemented only in the 'body' portion of the PO.

Basic Valid Print Masks

See Appendix H.