Cheque Design and Printing

From NEOSYS User Support Wiki

1 Cheque Design and Printing

Cheque design.jpg


1.1 Design

To open this page: In Payment Journal page click on Print Cheques -> Click on Design -> Cheque design page opens up.

1.1.1 Account Number

The bank account for which the cheque design is being configured

1.1.2 Is Default

Tick to set this design as the default one for all bank accounts that do not have a cheque design format for themselves.

1.1.3 Left Margin/ Top Margin

Specify where the Left/Top Margin starts from.

1.1.4 Units

Select the unit for measuring the alignment

1.1.5 Preview Cheque Layout

Used for checking whether any of the fields are overlapping with each other or exceed the page limit

1.1.6 Field Name

The Field Names depend on the level selected. Refer here for the list of field names.

1.1.7 Level

Used for defining the scope of the Field Name.

1.1.8 Top/Left

Enter how many units from the top/left the field must begin

1.1.9 Width/Height

Enter the width and height of the field

1.1.10 Alignment

Select the alignment (left/right/centre) for the text within the field

1.1.11 Repeats

Refer here

1.1.12 Exclude

Tick this to omit the corresponding line from showing in the Printout

1.2 List of Field Names


1.2.1 ALL_INVOICE_NOS_OR DETAILS

1.2.2 ACCOUNT_NO

Supplier account number

1.2.3 ALL_DETAILS

Displays details of every line in the voucher, one below the other, in a single page.

1.2.4 AMOUNT_PAID

1.2.5 BANK_ACCOUNT_NAME

Name of the bank account for which the cheque is printed

1.2.6 BANK_ACCOUNT_NO

The account no. of the bank for which the cheque is printed

1.2.7 CHEQUE_AMOUNT

The Total Amount entered in the journal entry

1.2.8 CHEQUE_CURRENCY

The currency entered in the journal entry

1.2.9 CHEQUE_DATE

Date mentioned in the journal entry

1.2.10 CHEQUE_NO

The value entered in the cheque advice/remittance advice. Will have brackets around it, if the voucher is unposted.

1.2.11 CHEQUE_PAYEE

Details of the 1st line in the voucher file

1.2.12 CHEQUE_WORDING

The cheque amount in words

1.2.13 DETAILS

Details of the 2nd line in the voucher file, minus details from the first line. If left blank, it picks up the name of the second account in the voucher file.

1.2.14 INVOICE_DATE

The date mentioned in the allocation voucher file

1.2.15 INVOICE_NOS_OR_DETAILS

If allocated, then the text from the allocation voucher's reference field appears here. If unallocated, then the details of the contra-line appears here

1.2.16 INVOICE_NO

Picks up the supplier invoice number from the Reference field of the allocated voucher

1.2.17 INVOICE_NOS

Picks up the supplier invoice number from the Reference field of the allocated voucher, example INV#123. If {INVOICE_NO} is also one of the fields used in cheque design, then {INVOICE_NOS} gives the journal type of the allocation voucher, the text from the reference field of the allocation voucher, and the date menioned in the allocation voucher file. Eg. PUR INV#123 30/6/2014

1.2.18 INVOICE_ORIGINAL_AMOUNT

Picks up the allocated amount from the allocation voucher file

1.2.19 INVOICE_OUTSTANDING_AMOUNT

The outstanding amount for each of the invoices being paid.

1.2.20 INVOICE_PAID

The allocated voucher number appears here

1.2.21 INVOICE_TYPE

Gives the type of the allocated voucher. Eg. PUR, MPU etc.

1.2.22 NO_OF_PAGES

1.2.23 PAGE_NO

1.2.24 PAGE_X_OF_X

1.2.25 PAYEE_ADDRESS

1.2.26 VOUCHER_NO

The voucher for which the cheque is printed


1.3 Printing Cheques

This assumes that the cheque layout has already been performed using Cheque Design.

These instructions mainly help you to configure the printer suitably for printing cheques from NEOSYS.

  1. In NEOSYS Finance, Journals, Journal Entry, select Journal Type “Payments” and click the open button to get an existing posted or unposted journal on screen.
  2. Click the “Print Cheques” button
  3. Click “Test”
  4. When the cheque layout appears onscreen – click File, Print Preview.
    Note that the “Test” option also shows boxes around the printable fields. The boxes are there to help in checking the alignment and do not appear in the final cheque printing.
  5. In Print Preview, click Printer Setup/Configure.
    If you don’t want to change your default printer configuration, then “add new printer” in Windows and use that for all cheque printing.
    NB This step is critical for success.
    - Remove all heading and footing text.
    - Reduce all the margins to zero - or as close to zero as your printer will allow.
    - Ensure that print scaling is set to 100%
    - Ensure any “Fit to Page” or similar option is switched off.
  6. Print onto a blank sheet of paper.
    Note: The paper type and size on which you run the tests is largely irrelevant. As long as it is at least as wide and deep at the final target paper size, you can do the test formatting on any paper. All you have to do is get everything the right distance from the top and the right distance from the left for every item. ie the same position from the top-left hand corner as the cheque.
  7. Compare the printout to a page of your real cheques by lining them up on the top and left edges. Hold them up to a bright light to see if the text will print ok on the cheque.
  8. If all the fields need to be moved up, you can move the print up by entering a negative top margin in the Cheque Design screen.
    Or, if all the fields need to be moved down then enter a positive number.
    Use a similar strategy to move all the fields to the left (negative) or right (positive).
    The margin you enter you should be in the units of measurement specified in the Cheque Design screen heading. Do not change the unit of measurement unless you are prepared to re-enter all of the cheque design layout positions.
  9. If all is ok, close the test layout and, back on the Print Cheques screen, click the Print button instead of the Test button.
  10. Ensure that the configuration is done as per step 5 above and do a test print on real cheques.

1.4 Avoiding continuation pages on remittance advices/cheque printouts

If you are regularly paying a large number of invoices with a single payment and wish to avoid getting multiple pages for remittance advices/cheque printouts, if you do not need to see the

full allocated invoice details then you can use the following strategy to print just the invoice numbers in one flowing text column. This usually avoids the need for continuation pages

unless the number of invoices being paid is very great.

A suitable strategy caters for payments that have more than one “line” in the journal - to allow discounts etc. Therefore we use 3 “repeats”.

Set the “Repeats” to 3 and set the “Height” to one third of the total vertical space available for the allocation table. The more height assigned, then the more invoice numbers can be

fitted in

Chequeprintout.jpg


1.5 How to copy cheque layouts

Cheque layouts are designed in NEOSYS per bank account.

There is no way in the normal user interface to copy layouts from one account to another but it can be done in maintenance mode.

1.6 Designating one bank account as the default layout for all other accounts

Check the "Use as default" checkbox in the cheque design screen of the bank that you want to be the default.

Any bank accounts that do not have specific cheque layout designs will then use the designated default account.

If no bank account is designated as the default then, if it exists, the cheque design of account XXX999 will be used as the default.

1.7 To copy a cheque design from bank account XXXX to YYYY

In maintenance mode:

COPY DEFINITIONS CHEQUEDESIGN*XXXX (O) TO: CHEQUEDESIGN*YYYY

1.8 Copying cheque layouts between databases on the same NEOSYS installation

To copy a cheque design from bank account XXXX in database A to YYYY in database B.

Step 1. In maintenance mode of database A:

COPY DEFINITIONS CHEQUEDESIGN*XXXX (O) TO: (DOS DESIGN1.CQD)

Step 2. In maintenance mode of database B:

COPY DOS DESIGN1.CQD (O) TO: (DEFINITIONS CHEQUEDESIGN*XXXX)

Notes:

  1. (O) is optional and is required only if you are overwriting the target
  2. DESIGN1.CQD can vary to allow copying multiple formats at the same time but "DESIGN1" must be no more than 8 alphanumeric characters and ".CQD" must be exactly ".CQD" otherwise there is risk of damaging the NEOSYS installation files.

1.9 Copying cheque layouts between NEOSYS installations

Use the instructions as for Copying cheque layouts between databases on the same NEOSYS installation but add the following step between the two steps.

Use operating system facilities copy the DESIGN1.CQD file(s) from the x:\neosys\neosys folder on the source installation to the same folder on the target installation.