Cheque Design and Printing - Revision history

Steve at 11:24, 25 February 2018

2018-02-25T11:24:20Z

← Older revision		Revision as of 11:24, 25 February 2018
Line 4:		Line 4:


	=== ~~Cheque~~ Design ===		=== Design ===

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

Steve at 11:23, 25 February 2018

2018-02-25T11:23:07Z

← Older revision		Revision as of 11:23, 25 February 2018
Line 1:		Line 1:
			== Cheque Design and Printing ==

	[[File:Cheque_design.jpg\|1200px]]		[[File:Cheque_design.jpg\|1200px]]

Priyanka: /* Cheque Design */

2017-10-19T11:59:18Z

Cheque Design

← Older revision		Revision as of 11:59, 19 October 2017
Line 3:		Line 3:

	=== Cheque Design ===		=== Cheque Design ===

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

	==== Account Number ====		==== Account Number ====
Line 39:		Line 41:
	==== Exclude ====		==== Exclude ====
	Tick this to omit the corresponding line from showing in the Printout		Tick this to omit the corresponding line from showing in the Printout


	===List of Field Names===		===List of Field Names===

Arvind at 07:42, 17 December 2014

2014-12-17T07:42:14Z

Show changes

Arya Mohandas at 13:15, 28 August 2014

2014-08-28T13:15:27Z

← Older revision		Revision as of 13:15, 28 August 2014
Line 7:		Line 7:


	'''Is Default:''' ~~If ticked, then the system assumes~~ this design ~~to be~~ the default ~~cheque design~~ for all bank accounts that do not have a cheque design format for themselves.		'''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.


	'''Left Margin/ Top Margin:''' ~~Specifies~~ where the Left/Top Margin starts from.		'''Left Margin/ Top Margin:''' Specify where the Left/Top Margin starts from.


Line 19:		Line 19:


	'''Field Name:''' The ~~field names~~ depend on the level selected. [[Cheque_Design_and_Printing#List_of_Field_Names \| Refer here for the list of field names.]]		'''Field Name:''' The Field Names depend on the level selected. [[Cheque_Design_and_Printing#List_of_Field_Names \| Refer here for the list of field names.]]


	'''Level:''' Used for defining ~~whether~~ the ~~field is specific to a particular page or all pages~~.		'''Level:''' Used for defining the scope of the Field Name.


Line 37:		Line 37:


	'''Exclude:''' ~~If ticked,~~ the corresponding line ~~will be omitted~~ from the ~~printout.~~		'''Exclude:''' Tick this to omit the corresponding line from showing in the Printout

Arya Mohandas: /* Cheque Design */

2014-08-28T11:55:50Z

Cheque Design

← Older revision		Revision as of 11:55, 28 August 2014
Line 1:		Line 1:
	==Cheque Design==		==Cheque Design==

			[[File:Cheque_design.jpg\|1200px]]


Line 17:		Line 19:


	'''Field Name:''' The field names depend on the level selected. Refer here for the list of field names		'''Field Name:''' The field names depend on the level selected. [[Cheque_Design_and_Printing#List_of_Field_Names \| Refer here for the list of field names.]]


Line 83:		Line 85:


	'''{INVOICE_NOS_OR_DETAILS}''' If allocated, then the text from the allocation voucher's reference field appears here. If ~~unalloacted~~, then the details of the contra-line appears here		'''{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


	'''{INVOICE_NO}''' Picks up the supplier invoice number from the Reference field of the ~~alloacted~~ voucher		'''{INVOICE_NO}''' Picks up the supplier invoice number from the Reference field of the allocated voucher


	'''{INVOICE_NOS}''' Picks up the supplier invoice number from the Reference field of the ~~alloacted~~ 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		'''{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


	'''{INVOICE_ORIGINAL_AMOUNT}''' Picks up the ~~alloacted~~ amount from the allocation voucher file		'''{INVOICE_ORIGINAL_AMOUNT}''' Picks up the allocated amount from the allocation voucher file

Arya Mohandas: /* Cheque Design */

2014-08-27T12:20:11Z

Cheque Design

← Older revision		Revision as of 12:20, 27 August 2014
Line 32:		Line 32:


	'''Repeats:'''		'''Repeats:''' [[Cheque_Design_and_Printing#Avoiding_continuation_pages_on_remittance_advices.2Fcheque_printouts\|Refer here]]


Line 39:		Line 39:

	===List of Field Names===		===List of Field Names===
			<br>

	{ALL_INVOICE_NOS_OR DETAILS}		'''{ALL_INVOICE_NOS_OR DETAILS} '''

	~~{ACCOUNT_NO} Supplier account number~~

	{~~ALL_DETAILS~~} ~~Displays details of every line in the voucher, one below the other, in a single page.~~		'''{ACCOUNT_NO}''' Supplier account number

	~~{AMOUNT_PAID}~~

	{~~BANK_ACCOUNT_NAME~~} ~~Name~~ of the ~~bank account for which~~ the ~~cheque is printed~~		'''{ALL_DETAILS}''' Displays details of every line in the voucher, one below the other, in a single page.

	~~{BANK_ACCOUNT_NO} The account no. of the bank for which the cheque is printed~~

	{~~CHEQUE_AMOUNT~~} ~~The Total Amount entered in the journal entry~~		'''{AMOUNT_PAID} '''

	~~{CHEQUE_CURRENCY} The currency entered in the journal entry~~

	{~~CHEQUE_DATE~~} ~~Date mentioned in~~ the ~~journal entry~~		'''{BANK_ACCOUNT_NAME}''' Name of the bank account for which the cheque is printed

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

	{~~CHEQUE_PAYEE~~} ~~Details~~ of the ~~1st line in~~ the ~~voucher file~~		'''{BANK_ACCOUNT_NO}''' The account no. of the bank for which the cheque is printed

	~~{CHEQUE_WORDING} The cheque amount in words~~

	{~~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.~~		'''{CHEQUE_AMOUNT}''' The Total Amount entered in the journal entry

	~~{INVOICE_DATE} The date mentioned in the allocation voucher file~~

	{~~INVOICE_NOS_OR_DETAILS~~} ~~If allocated, then the text from the allocation voucher~~'~~s reference field appears here. If unalloacted, then the details of~~ the ~~contra-line appears here~~		'''{CHEQUE_CURRENCY}''' The currency entered in the journal entry

	~~{INVOICE_NO} Picks up the supplier invoice number from the Reference field of the alloacted voucher~~

	{~~INVOICE_NOS~~} ~~Picks up the supplier invoice number from the Reference field of~~ the ~~alloacted voucher, example INV#123. If {INVOICE_NO} is also one of the fields used in cheque design,~~		'''{CHEQUE_DATE}''' Date mentioned in the journal entry

	~~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~~		'''{CHEQUE_NO}''' The value entered in the cheque advice/remittance advice. Will have brackets around it, if the voucher is unposted.

	~~{INVOICE_ORIGINAL_AMOUNT} Picks up the alloacted amount from the allocation voucher file~~

	{~~INVOICE_OUTSTANDING_AMOUNT~~} ~~The outstanding amount for each~~ of the ~~invoices being paid.~~		'''{CHEQUE_PAYEE}''' Details of the 1st line in the voucher file

	~~{INVOICE_PAID} The allocated voucher number appears here~~

	{~~INVOICE_TYPE~~} ~~Gives the type of the allocated voucher. Eg. PUR, MPU etc.~~		'''{CHEQUE_WORDING}''' The cheque amount in words

	~~{NO_OF_PAGES}~~

	{PAGE_NO}		'''{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.


			'''{INVOICE_DATE}''' The date mentioned in the allocation voucher file


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


			'''{INVOICE_NO}''' Picks up the supplier invoice number from the Reference field of the alloacted voucher


			'''{INVOICE_NOS}''' Picks up the supplier invoice number from the Reference field of the alloacted 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


			'''{INVOICE_ORIGINAL_AMOUNT}''' Picks up the alloacted amount from the allocation voucher file


			'''{INVOICE_OUTSTANDING_AMOUNT}''' The outstanding amount for each of the invoices being paid.


			'''{INVOICE_PAID}''' The allocated voucher number appears here


			'''{INVOICE_TYPE}''' Gives the type of the allocated voucher. Eg. PUR, MPU etc.


			'''{NO_OF_PAGES}'''


			'''{PAGE_NO}'''


	{PAGE_X_OF_X}		'''{PAGE_X_OF_X}'''


			'''{PAYEE_ADDRESS}'''

	~~{PAYEE_ADDRESS}~~

	{VOUCHER_NO} The voucher for which the cheque is printed		'''{VOUCHER_NO}''' The voucher for which the cheque is printed

	== Printing Cheques ==		== Printing Cheques ==

Arya Mohandas: Created page with '==Cheque Design== '''Account Number:''' The bank account for which the cheque design is being configured '''Is Default:''' If ticked, then the system assumes this design to b…'

2014-08-27T12:06:37Z

Created page with '==Cheque Design== '''Account Number:''' The bank account for which the cheque design is being configured '''Is Default:''' If ticked, then the system assumes this design to b…'

New page

==Cheque Design==

'''Account Number:''' The bank account for which the cheque design is being configured

'''Is Default:''' If ticked, then the system assumes this design to be the default cheque design for all bank accounts that do not have a cheque design format for themselves.

'''Left Margin/ Top Margin:''' Specifies where the Left/Top Margin starts from.

'''Units:''' Select the unit for measuring the alignment

'''Preview Cheque Layout:''' Used for checking whether any of the fields are overlapping with each other or exceed the page limit

'''Field Name:''' The field names depend on the level selected. Refer here for the list of field names

'''Level:''' Used for defining whether the field is specific to a particular page or all pages.

'''Top/Left:''' Enter how many units from the top/left the field must begin

'''Width/Height:''' Enter the width and height of the field

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

'''Repeats:'''

'''Exclude:''' If ticked, the corresponding line will be omitted from the printout.

===List of Field Names===

{ALL_INVOICE_NOS_OR DETAILS}

{ACCOUNT_NO} Supplier account number

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

{AMOUNT_PAID}

{BANK_ACCOUNT_NAME} Name of the bank account for which the cheque is printed

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

{CHEQUE_AMOUNT} The Total Amount entered in the journal entry

{CHEQUE_CURRENCY} The currency entered in the journal entry

{CHEQUE_DATE} Date mentioned in the journal entry

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

{CHEQUE_PAYEE} Details of the 1st line in the voucher file

{CHEQUE_WORDING} The cheque amount in words

{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.

{INVOICE_DATE} The date mentioned in the allocation voucher file

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

{INVOICE_NO} Picks up the supplier invoice number from the Reference field of the alloacted voucher

{INVOICE_NOS} Picks up the supplier invoice number from the Reference field of the alloacted 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

{INVOICE_ORIGINAL_AMOUNT} Picks up the alloacted amount from the allocation voucher file

{INVOICE_OUTSTANDING_AMOUNT} The outstanding amount for each of the invoices being paid.

{INVOICE_PAID} The allocated voucher number appears here

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

{NO_OF_PAGES}

{PAGE_NO}

{PAGE_X_OF_X}

{PAYEE_ADDRESS}

{VOUCHER_NO} The voucher for which the cheque is printed

== 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.

=== 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

[[File:Chequeprintout.jpg]]

== 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.

=== 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.

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

In maintenance mode:

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

=== 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:

#(O) is optional and is required only if you are overwriting the target
#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.

=== 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.