Modifying Check Layout

Users can modify the system check layout to suit their business needs. The fields can be re-arranged as needed, and the information to print in the “l_detail” field can be modified as well.

Configuration

Grid Layouts – The system default grid layouts can be modified to change what is included in the l_detail field on each check printout. 

Users should also reference the "Configuration" section of the Managing Report Layouts page prior to creating any report. 

Process

Managing the available Check Layouts

  1. Navigate to System > Maintenance > Grid Layouts.
  2. Find the check grid layouts (checkdtl, checkprintap, checkprintar, checkrun2, etc) > click "New".
    • Note: The checkprintap grid layout controls the fields that will show within the l_detail field when printing checks via Manual Checks or via a Check Run. The checkprintar grid layout controls the fields that will show within the l_detail field when printing checks and issuing refunds via Cash Receipts.
  3. The field names listed in this grid will print on this specific check detail. The width for each field will define the length for each field within the l_detail. Make changes as desired then click "Save" and "Exit".
  4. Navigate to Print Outs > Maintenance > Report Layouts.
  5. Find the system report “lazcheck” > click "Modify" > click "Edit Report".
  6. Make changes as desired then save and exit.

Note: Users must log out and back in after modifying the check layout for changes to take effect.

Using the available Check Layout fields

The check layout (listed as the "lazcheck" system report) is the only printed document that is only able to be printed to a physical printer. This is because the functions that it uses also makes the postings to the general ledger. For this reason, the list of fields available to the check header and the check detail are outlined below. The following notes should also be reviewed prior to editing a Check Layout:

  1. The fields on the Check Header may not be modified by users.
  2. To print a Vendor ID Number (housed on the Vendor record's General tab) on AP checks, the "l_vendid" may be added to the check header section on the check report layout (lazcheck).
  3. On AP checks, there are three options regarding which record's name and address details get printed. It is possible to list only the name, and omit the address. To do so, use the expression "IIF(empty(l_rname), l_compname, l_rname)". Listed in the order which they are evaluated by the system, the three options are:
    • Vendor Group - Linked to a Vendor record via the Order Defaults tab.
    • Remit To - Defined on a Vendor record via the Remit To tab.
    • Vendor - Defined on a Vendor record via the General tab.

Section

Field

Description

Check Header

ca_postref

A unique reference number for non-check payments types that can be entered on the Print Check form. Correctly tracks the non-check payment types printed in sequential order. 

l_veid

"Vendor Number" as displayed on the Vendor's General tab. Copy of the natural database field dmvend.ve_id.

ve_p1id

"Search1" selection as listed on the Purchase Order's Misc 1 tab. Options for the field are managed via Purchasing > Maintenance > PO Search 1-2. Defined by the Data Dictionary as "User 1 ID".

l_date

"Date Paid" (date that prints on the check) selected on the Process Checks form when Processing Accounts Payable.

l_check

"Reference" Number entered on the Process Checks form when Processing Accounts Payable.

l_cashprt

"Total Cash" (amount the check is for) calculated on the Process Checks form when Processing Accounts Payable in numerical format. Ex: $10.00.

l_saynum

"Total Cash" (amount the check is for) calculated on the Process Checks form when Processing Accounts Payable written out in words to match numerical amount. Ex: Pay ten dollars and 00/100.

l_cashchid

"Cash Account" selected on the Process Checks form when Processing Accounts Payable that will be impacted by the check. Can be used in an IIF statement to determine what company the check was printed for and then print the proper company information on the check.

l_compname

"Vendor" Name as listed on the Vendor's General tab.

l_vendid

"ID" as listed on the Vendor's General tab.

l_name, l_street, l_street2, l_city, l_state, l_zip, l_country

"Vendor" Name, "Street", "Street 2", "City", "State", "Zip", and "Country" as listed on the Vendor's General tab.

l_rname, l_rstreet, l_rstreet2, l_rcity, l_rstate, l_rzip, l_rcountry

"Remit To Name", "Street", "Street 2", "City", "State", "Zip", "Country" as listed on the Vendor's Remit To tab.

l_detail

Section for check details, managed via System > Maintenance > Grid Layouts.

l_picture

Picture/Logo to print on the check.

Check Detail

recno

If multiple checks are printed at one time, as indicated in the "Number of Checks" field on the Process Checks form when Processing Accounts Payable, this represents the check sequence number.

gldate

"Received" date as selected on the Receive form when receiving Purchase Orders.

invdate

"System Invoiced" date as selected on the Enter Invoice Received form when entering Vendor invoices.

invvend

"Vendor Invoiced" date as selected on the Enter Invoice Received form when entering Vendor invoices.

theirpo

"Invoice Number" as entered on the Enter Invoice Received form when entering Vendor invoices.

totgross

"Total Gross" amount as listed on the Process Checks form when Processing Accounts Payable.

deducted

"Deductions" as listed on the Process Checks form when Processing Accounts Payable.

cashdisc

"Cash Discounts" as listed on the Process Checks form when Processing Accounts Payable.

totcash

"Total Cash" as listed on the Process Checks form when Processing Accounts Payable.

company

"Vendor" Name as listed on the Vendor's General tab.

compnum

"Vendor Number" as displayed on the Vendor's General tab.

vendid

The record entry sequence number of the Vendor selected on the Purchase Order. In other words, if this was the 6th Vendor record added to DEACOM, the "vendid" would be 6.

vgid

The record entry sequence number of the Vendor Group to which the Vendor selected on the Purchase Order belongs. In other words, if this was the 3rd Vendor Group record added to DEACOM, the "vgid" would be 3.

shipto

"Name" of the Ship-to Location as selected on the Misc 1 tab when entering a Purchase Order. When viewing a Purchase Order, the selection is available on the Ship-to tab. Ship-to Locations are managed via Purchasing > Maintenance > Ship to Locations.

shipnum

The record entry sequence number of the selected Ship-to Location selected on the Purchase Order. In other words, if this was the 4th Ship-to Location record added to DEACOM, the "shipnum" would be 4.

remarks

"Remarks" as entered on the (1) Enter Invoice Received form when entering Vendor invoices or (2) Manual Checks form via the "Remarks" button prior to printing the check.

ordjoin

The Purchase Order number without dashes.

ordnum

The Purchase Order number with dashes.

paysched

The schedule of expected payments as detailed on the Edit Payment Schedule form via the "Pay Schedule" button on the Purchase Order. Only available if the Terms selected on the Purchase Order have the "Multi-Payment Terms" flag set to true.

balance

The amount listed in the "Balance Due" field of the Purchase Order header.

totdue

The amount listed in the "Amount" field of the Purchase Order header.

fcid

The record entry sequence number of the Currency selected on the Purchase Order. In other words, if this was the 1st Currency record added to DEACOM, the "fcid" would be 1.

fcrate

"Currency Conversion" rate as listed on the Purchase Order header.

totdue

The amount listed in the "Amount" field of the Purchase Order header.

fcrate

"Currency Conversion" rate as listed on the Purchase Order header.

paydate

"Paid" date as listed on the Purchase Order's Dates tab.

history

"Order History" as detailed on the Purchase Order General tab.

abstotdue

Absolute value of the totdue variable. Useful when desiring to see the absolute total due when issuing credits via Cash Receipts.

absbalance

Absolute value of the balance variable. Useful when desiring to see the absolute balance when issuing credits via Cash Receipts.

abstotgross

Absolute value of the totgross variable. Useful when desiring to see the absolute total gross value when issuing credits via Cash Receipts.

Check Type Suggestions

The check can be modified to accommodate any check; however we have found modifying the check layout can be very tedious and time consuming when the check stock has pre-printed check stubs.  It is easiest to design checks that use check stock with the check in the middle and blank check stubs.  Some of the check stock we have found the easiest to work with are listed below.  Please note that you can also order the corresponding envelopes from these companies as well.