Keystone Forms

From KeystoneIntranet
Revision as of 12:58, 14 July 2023 by WikiAdmin (talk | contribs) (1 revision imported)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search


While forms can be stored in the customer directory (e.g. ...\cust\forms), this should only be done if the form is specific to a computer. Custom Forms belong in the database.

Sections

Form Section

Command Purpose Comment Keystone Version
BEGINCOPY n apply block of form only for nth copy applies to all form sections 2.7.16
CHAIN name the next form in the chain
COLUMNS n number of columns on each form used for labels
COPIES n number of copies of each form
CPI n characters per inch
ENDCOPY indicates end of COPY block 2.7.16
FONTNAME name default font for the form
LENGTH n number of lines on the form impacts automatic page breaks
LINES n number of lines for each label used for labels
LPI n lines per inch
MARGIN top,left,bottom,right specify page margins default is no margins 3.6.18.1
OPTION EXTEND_DETAIL allow form detail to extend into footer area 2.1.4
OPTION IMAGE_FIX fix image drawing issue some printers print border on right/bottom edge of images 3.2.3.1
OPTION LANDSCAPE force landscape orientation for the form 2.6
OPTION SUMMARIZE_PRODUCTS summarize product totals when printing invoices 1.6.6
PDFPAGES n | ALL number of PDF document pages to include on form default is first page only 4.3.9.10
PRINTER name creates a virtual printer name Keystone can map this name to a physical printer with different settings per user
TITLE name descriptive name of this form some options display this to the user when selecting forms
VERSION n indicates the version number of the form used for special processing by some Keystone options 2.5.25
WIDTH n number of columns on the form increase as needed but keep in mind this will reduce the font size

Heading

Information that prints 1 time at the top of the form.

Alternate headings (e.g. "HEADING 4") are used in certain types of forms for special sections of a form.

Detail

Information that repeats for each line of detail.

Certain forms may have alternate detail lines with unique behavior. This could be an alternate type of detail or sub-detail. e.g. "DETAIL 2" on an invoice is used to print comments.


Total

Information that prints at the bottom of the form.

Command Purpose Comment Keystone Version
NEWPAGE Start new page on a form Only verified for Total Section 3.3.1

Sample Total with a NEWPAGE:

TOTAL  

     LINE 42

COLUMN 41
     BOX 5,24,0,20
     BOX 5,24
     BOX 5,36
        LINE +1 COLUMN 44       TEXT SUB TOTAL
                COLUMN 65       FORMAT ######.00        FIELD CALC_SUBTOTAL

        LINE +1 COLUMN 44       TEXT SALES TAX-
                COLUMN 54  FIELD TAX_AUTHORITY
                COLUMN 65       FORMAT ######.00        FIELD CALC_SALESTAX

        LINE +1 COLUMN 44       TEXT TICKET TOTAL
                COLUMN 65       FORMAT ######.00        FIELD CALC_TICKETTOTAL
     NEWPAGE 

        LINE +2 COLUMN 1        
        LINE +1 COLUMN 30       TEXT *** WARNING ***
        LINE +1 COLUMN 10       TEXT Cement is not good for you and It doesn't taste very good.
        LINE +1 COLUMN 10       TEXT Do not eat cement or stuff made from cement.  Do not eat 
        LINE +1 COLUMN 10       TEXT Tide Pods either.
        LINE +1 COLUMN 1        LEFT IMAGE 2
! DoNotEatCement.jpg
        LINE +3 COLUMN 13       TEXT RECEIVED BY:
                COLUMN 26       TEXT ________________________________________
        LINE +2 COLUMN 1        

Working With Forms

Formats

        LINE +1 COLUMN 1        FORMAT mm/dd/yy         FIELD TICKET_DATE 
                COLUMN 10       RIGHT 7                 FIELD TICKET_NO
                COLUMN 18       FORMAT ####0.00         FIELD QTY_SOLD
                COLUMN 27                               FIELD UNIT_OF_MEASURE
  • Date: The date April 5, 2018 with a format of mm/dd/yy will print as 04/05/2018, mm/dd/yyyy as 4/05/2018
  • Right/Left Slide text to the right or left of the designated space.
  • Numbers with # and 0: # is a placeholder that prints if needed. 0 will always print a value. Example: 403.25 printed with a format of ####0.00 prints as " 403.25", with a format of 00000.00 as "00403.25"


Comments

Lines that begin with a ! are comments. They can be removed as needed.

!   AVAILABLE CALCULATED FIELDS
!   ===========================

Images

In form Maintenance, select Load on the Images tab.
Load the image.

When Setting up the form, refer to the image by number. The following code places an image in column 3, scaled to be 12 characters wide:

LINE 2 COLUMN 3
LEFT 12 IMAGE 2


CHAIN command: Creating Multiple Forms

The Chain command allows multiple forms to print at one time. These forms can be identical or unique, and can print to multiple printers.

The Chain command is used in the FORM section. Syntax: CHAIN [formname].FRM (e.g. CHAIN ARTCK.FRM)

In order to use multiple printers, make sure that the printer ALIAS is unique for each of the forms. Make sure to update the Plant to point to the correct form. Then in Ticket Printing/ Printer setup you can assign each alias to a printer.

When mixing a special form and a standard form, it is probably best to have the special form chain to the standard form. This prevents you from needing to create a new standard form and makes setting up the printers easier. The Printer setup develops the Alias list from the primary form for each plant. So if a special form with a unique alias is used as the primary form for a plant, then that Alias will appear on the list.

Bar Codes

Here is a section from a sample ticket form file that shows how to print barcodes on ticket forms.

NOTE that this should work in a similar way for dot-matrix (With EPSON emulation) and laser printers. However, for dot-matrix printers the only (currently) supported bar code format is Code 39. For laser/inkjet printers you must have a bar code font available on the printer, and you would specify that font name where you see “FONTNAME BARCODE39” in the sample below.

FORM
LENGTH 66       WIDTH 80        PRINTER ARTicket
     FONTNAME VERDANA


HEADING
     LINE 1     COLUMN 1                   
                FONTNAME BARCODE39
                     FORMAT 00000000      FIELD TICKET_NO                
                FONTNAME DEFAULT

     LINE 8     COLUMN 5                   FIELD PLANT_NO
           COLUMN 10  FORMAT #0":"00       FIELD TICKET_TIME
           COLUMN 30                       FIELD TRUCK_NO
           COLUMN 38                       FIELD DRIVER_NAME
           COLUMN 58  FORMAT MM/DD/YY      FIELD TICKET_DATE
           COLUMN 71                       

Boxes/Shading

The BOX command may be used in any form printing section (Heading, Detail, Total.) The syntax is as follows:

BOX Height, Width [,Weight [,Shading [,Color]]]

Example:

BOX 1,76,0,20,clYellow

Height and Width are expressed in printed characters.

Weight is optional (default is 8 pixels) and indicates the number of pixels for the box border. The border is drawn in the current COLOR setting (black is default.)

Shading is optional (default is no shading) and specifies the shading percentage (0-100.) Lower shading is brighter color, higher shading is darker color.

(Keystone 3.6.4.7+) Color is optional (default is black) and specifies the shading color. The borders are drawn in the current font color.

When Color is black it is treated as white internally, meaning that a lower shading will tend toward white (no shading) while a higher shading will tend toward black.

See Also

Keystone Form Colors
Sample Forms
Payroll: Form Versions
Invoice Form Fields
Ticket Form Fields
AP Check Form Fields