Invoice Laser: Difference between revisions
Jump to navigation
Jump to search
Intra>User m (1 revision imported) |
(No difference)
|
Revision as of 00:01, 10 January 2017
Sample Invoice Laser form with multiple fonts and optional graphics.
! ARINV.FRM
! Standard Plain Paper Invoice
!
!
! AVAILABLE CALCULATED FIELDS
! ===========================
!
! Field Name Data Type Description
! -------------------- --------------- ---------------------------------------------------
! CALC_AGING1 Currency Aging Total 1 (most current)
! CALC_AGING2 Currency Aging Total 2
! CALC_AGING3 Currency Aging Total 3
! CALC_AGING4 Currency Aging Total 4
! CALC_AGING5 Currency Aging Total 5 (least current)
! CALC_AGING4&5 Currency Aging Total 4 + Aging Total 5
! CALC_CREDITTERMS String Customer Terms
! CALC_CUSTADDR1 String Customer Name & Address Line 1
! CALC_CUSTADDR2 String Customer Name & Address Line 2
! CALC_CUSTADDR3 String Customer Name & Address Line 3
! CALC_CUSTADDR4 String Customer Name & Address Line 4
! CALC_DELVTOTAL Currency Delivery Products Total
! CALC_DISCBALDUE Currency Discounted Balance Due (Grand Total - Discount Total)
! CALC_DISCDATE String Discount Valid Until Date
! CALC_DISCOUNTLINE String Discount Message Line ([AMOUNT] = disc avail, [DATE] = disc valid date)
! CALC_DISCTOTAL Currency Discount Total Only
! CALC_EXTPRICE Currency Extended Price for current line (includes roll-up)
! CALC_FINCHGBAL Currency Customer Finance Charge Total
! CALC_INVMSG1 String Invoice Message Line 1
! CALC_INVMSG2 String Invoice Message Line 1
! CALC_INVMSG3 String Invoice Message Line 1
! CALC_INVMSG4 String Invoice Message Line 1
! CALC_INVOICEDATE String Invoice Date
! CALC_INVOICENO Integer Invoice Number
! CALC_INVTOTAL Currency Grand Total
! CALC_MATLTOTAL Currency Non-Delivery Products Total
! CALC_NETDUE Currency Invoice Total Due after payments
! CALC_NEWARBAL Currency A/R Balance after this invoice
! CALC_NFAGING1 Currency Non-Finance Charge Aging Total 1 (most current)
! CALC_NFAGING2 Currency Non-Finance Charge Aging Total 2
! CALC_NFAGING3 Currency Non-Finance Charge Aging Total 3
! CALC_NFAGING4 Currency Non-Finance Charge Aging Total 4
! CALC_NFAGING5 Currency Non-Finance Charge Aging Total 5 (least current)
! CALC_NFAGING4&5 Currency Non-Finance Charge Aging Total 4 + Aging Total 5
! CALC_NONTAXTOTAL Currency Non-taxable Total
! CALC_PAYMENTTOTAL Currency Total payments for this invoice
! CALC_PRIORARBAL Currency A/R Balance prior to this invoice
! CALC_RETADDR1 String Company Return Address Line 1
! CALC_RETADDR2 String Company Return Address Line 1
! CALC_RETADDR3 String Company Return Address Line 1
! CALC_RETADDR4 String Company Return Address Line 1
! CALC_SALESTAX Currency Sales Tax Total
! CALC_SUBTOTAL Currency Merchandise Total
! CALC_TAXABLETOTAL Currency Taxable Total
! CALC_TAXIND String Taxable Indicator for current line (* or blank)
! CALC_TAXINDYN String Taxable Indicator for current line (Y/N)
! CALC_TAXRATEPCT Currency Tax Rate (as a %)
! CALC_TKROLL_DELVTOTAL Currency Ticket Rollup Delivery Products Total
! CALC_TKROLL_MATLTOTAL Currency Ticket Rollup Non-Delivery Products Total
! CALC_TKROLL_QTY_SOLD Currency Ticket Rollup Quantity Sold
! CALC_TKROLL_TAXTOTAL Currency Ticket Rollup Sales Tax Total
! CALC_TKROLL_TKTTOTAL Currency Ticket Rollup Ticket Total
! CALC_UMS String U/M
! CALC_UMSTOTAL Currency U/M subtotal
! CALC_UMSTOTALLINE String U/M subtotal (line format)
! CUST_USER_1 String User 1 from ARTCUST table
! CUST_USER_2 String User 2 from ARTCUST table
! JOB_PO_LOC String Job Invoice Description -or- Job Id
! ORDER_CODE String Order Code for invoice
! PLANT_ADDRESS_1 String Plant Address 1
! PLANT_ADDRESS_2 String Plant Address 2
! PLANT_NAME String Plant Name
! PLANT_PHONE_NO String Plant Phone Number
! PLANT_SCREEN_ID String Plant Screen Id
! QTY_SOLD Currency Qty Sold for current line (includes roll-up)
! SALESPERSON_NAME String Salesperon's Name
! SPLIT_LIMIT Currency Split Tax Limit for invoice
! SPLIT_RATE Currency Split Tax Rate for invoice
! TAX_RATE Currency Tax Rate for invoice
! UNIT_PRICE Currency Unit Price for current line (includes roll-up)
!
! COND_NONTAXTOTAL Boolean True to print non-tax total
! COND_PRODUCTTOTALS Boolean True to print u/m total
FORM
TITLE Plain Paper Invoice
LENGTH 66 WIDTH 80 PRINTER ARInvoice
NEWPAGE
FONTNAME Verdana
HEADING
LINE 2 COLUMN 1
! LEFT 24 IMAGE c:\xfr\ghlogo.jpg
COLUMN 10 FIELD CALC_RETADDR1
LINE +1 COLUMN 10 FIELD CALC_RETADDR2
LINE +1 COLUMN 10 FIELD CALC_RETADDR3
LINE +1 COLUMN 10 FIELD CALC_RETADDR4
LINE 1 COLUMN 1
FONTNAME Times New Roman
FONTSIZE 36
BOLD ON
COLUMN 1 RIGHT 80 TEXT INVOICE
BOLD OFF
FONTNAME Default
LINE +4 COLUMN 44 TEXT Customer No.
COLUMN 59 FIELD CUST_NO
LINE +1 COLUMN 44 TEXT Invoice Date
COLUMN 59 FIELD CALC_INVOICEDATE
LINE +1 COLUMN 44 TEXT Invoice Number
COLUMN 59 FIELD CALC_INVOICENO
COLUMN 69 TEXT Page ~PAGENO~
LINE +1 COLUMN 44 TEXT Job Id
COLUMN 59 FIELD JOB_PO_LOC
IF CUSTOMER_PO
LINE +1 COLUMN 44 TEXT PO # / Lot #
COLUMN 59 FIELD CUSTOMER_PO
ENDIF
LINE +1 COLUMN 44 TEXT Credit Terms
COLUMN 59 FIELD CALC_CREDITTERMS
LINE 12 COLUMN 13 FIELD CALC_CUSTADDR1
LINE +1 COLUMN 13 FIELD CALC_CUSTADDR2
LINE +1 COLUMN 13 FIELD CALC_CUSTADDR3
LINE +1 COLUMN 13 FIELD CALC_CUSTADDR4
LINE +2 COLUMN 1
BOX 1,80,0,20
BOX 35,80
BOX 35,9
BOX 35,17
BOX 35,28
BOX 35,58
BOX 35,69
COLUMN 3 TEXT Date
COLUMN 11 TEXT Ticket
COLUMN 23 TEXT Qty
COLUMN 30 TEXT Description
COLUMN 64 TEXT Price
COLUMN 73 TEXT Amount
! LINE +1 COLUMN 1 HLINE 80
DETAIL
LENGTH 32
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
COLUMN 30 FIELD DESCRIPTION
COLUMN 59 FORMAT ######0.00 FIELD UNIT_PRICE
COLUMN 69 FORMAT ######0.00 FIELD CALC_EXTPRICE
COLUMN 80 FIELD CALC_TAXIND
DETAIL 2
LINE +1 COLUMN 30 FIELD DESCRIPTION
! DETAIL 3
! *********** WARNING! **************
! Uncommenting the DETAIL 3 section changes the behavior of Print Invoices as follows:
! -- all ticket detail lines for the same product/unit of measure are summarized into a single line
! ---- and printed using the DETAIL 3 section
! -- comments are printed as usual
! -- additional products on a ticket are printed using the DETAIL section with zero price
! -- the calculated fields that begin with the prefix CALC_TKROLL_ are only available in the DETAIL 3 section
! ---------- Product Summary heading
HEADING 4
LINE +2 COLUMN 7 TEXT ***** PRODUCT SUMMARY *****
LINE +1 COLUMN 7 TEXT PRODUCT QUANTITY U/M
! ---------- Product Summary detail
DETAIL 4
LINE +1 COLUMN 7 FIELD PS_DESCRIPTION
COLUMN 37 FORMAT ######0.00 FIELD PS_QUANTITY
COLUMN 48 FIELD PS_U_OF_M
TOTAL
LINE 52
IF COND_PRODUCTTOTALS
COLUMN 1 CENTER 80 FIELD CALC_UMSTOTALLINE
ENDIF
LINE +1 COLUMN 1
BOX 6,50,0,20
BOX 6,50
BOX 6,80
! HLINE 80
LINE +1
COLUMN 1
COLUMN 5 FIELD CALC_INVMSG1
COLUMN 53 TEXT Sub-Total
COLUMN 67 FORMAT ########0.00 FIELD CALC_SUBTOTAL
LINE +1 COLUMN 5 FIELD CALC_INVMSG2
IF COND_NONTAXTOTAL
COLUMN 53 TEXT Non-Tax Total
COLUMN 67 FORMAT ########0.00 FIELD CALC_NONTAXTOTAL
ENDIF
LINE +1 COLUMN 5 FIELD CALC_INVMSG3
COLUMN 53 TEXT Sales Tax-
FIELD CALC_TAXAUTH
COLUMN 67 FORMAT ########0.00 FIELD CALC_SALESTAX
LINE +1 COLUMN 5 FIELD CALC_INVMSG4
COLOR clRed
COLUMN 53 TEXT Invoice Total
COLUMN 67 FORMAT ########0.00 FIELD CALC_INVTOTAL
COLOR clBlack
LINE +1 COLUMN 1
! HLINE 80
LINE +2 COLUMN 1
COLOR clRed
CENTER 80 FIELD CALC_DISCOUNTLINE
COLOR clBlack
TOTAL 2
LINE +2 COLUMN 36 TEXT CONTINUED