SYSPRO Ribbon bar > Setup > Stationery Formats > Cash Book Check Format

Cash Book Check Format

You use this program to define the page layout for printing on-line checks and remittances for each bank in the Cash Book module.

You must define a check format for each bank from which checks are to be issued in the Cash Book module.

Cash Book Check Format

Field Description
Bank

Indicate the code of the bank for which you want to maintain the check format.

Bank codes are maintained using the Browse on Banks program.

Print method Select the method by which you want to print documents for the selected bank.
Standard document Select this to print your Cash Book checks and remittances for this bank using pre-printed stationery.
[Note]

Checks can only be printed using a Standard document. Checks cannot be printed using MS Word or SRS documents.

Word document Select this to print your Cash Book remittances for this bank using MS Word.

Refer to Word Printing for additional information about printing using MS Word.

SRS document Select this to print your Cash Book remittances for this bank using SRS Document Printing.

See SRS Document Printing Overview for additional information.

Format options

Indicate which section of the document you want to maintain. You highlight an option and then use the Change function to define the preferences and page layouts for your document.

[Note]

The options available vary according to the Print method you select.

Copy Format Select this to copy the check format from one bank to another bank.
Save

Select this to save the information you entered.

Alignment

Select this to print a test check or remittance to verify that the fields you have defined are correctly aligned.

Print

Select this to print the format information you entered and saved for cash book checks and remittances.

Close

Select this to exit the program and return to the menu.

Copy Format

The Copy Format function enables you to copy the check format from one bank to another bank. Additionally, you can copy the check format from a bank in another company to a bank in your current company.

Field Description
Company

This indicates the company in which you are currently working.

Copy from bank

Indicate the check format of the bank from which you want to copy field row and column settings.

The check format for the bank you enter here is copied to the bank you selected at the Bank field.

Change company

Select this to change to a different company from which you want to copy a cash book check format.

OK

Select this to copy the check format you selected to the check format for the current bank.

[Note]

This option does not save the format you copied for the current bank. To save the format you must select Save from the Cash Book Check Format screen which is displayed.

Cancel

Select this to exit the program without performing the copy.

Company

You use the Change Company function to change to a different company from which you want to copy a cash book check format.

Field Description
Copy from company

Indicate a valid company from which you want to copy a cash book check format.

OK

Select this to accept the company Id you entered at the previous prompt.

Cancel Select this to return to the Copy Format screen.

General

The options on this tab enable you to define the details to print and the layout of your checks and remittance advices.

Field Description
Format options

This displays the bank you entered and are maintaining.

Documents required

Specify which documents you want to maintain. The result is the same whether you first define the check format and then the remittance format or whether you define both at the same time.

Check only

Select this to maintain the print format for cash book checks only.

[Note]

Checks can only be printed using Standard document printing

Remittance only

Select this to maintain the print format for cash book remittances only.

Both check and remittance

Select this to maintain the print formats for both cash book checks and remittances.

Check sections / Remittance sections / Check and Remittance sections

The headings for these sections change according to your selection at the Documents required option (see Check / Remittance Sections).

Change

You use this function to maintain the highlighted section line (see Check / Remittance Sections).

Check / Remittance Sections

The headings for these sections change according to your selection at the Documents required option.

The following options are available depending on your selection of the documents required and the Print method selected:

Check Preferences

Field Description
Number of lines on a check

This indicates the number of lines available for printing on the check and depends on the physical size of the check. A maximum of 99 lines can be entered for this field.

Highest start column across page Indicate the maximum column number that can be specified when defining the column print positions for fields on the document.

This must be in the range 1-150.

See also Preference restrictions.

Check amount wording style

The wording style you select depends on the layout of the pre-printed check. For example, some checks have blocks into which the amount in words is printed or written, while others have lines on which the amount in words is printed or written.

[Note]

The wording for amounts greater than nine hundred and ninety nine million (999 999 999.00) is 'thousand million' and not 'billion.' The reason for this is that a billion in the USA represents a different value to a billion in the UK. Therefore, the amount in words for a value such as 1 200 000 000.00 is 'One thousand two hundred million.'

Words in boxes

Select this to print the check amount in words in the blocks on the check.

Digits in boxes

Select this to print the check amount in digits in the blocks on the check.

Full wording

Select this to print the full wording of the check amount before the decimal in words and amounts after the decimal in digits. For example: $90.11 will print as Ninety Dollars 11 Cents.

Full wording with decimals

Select this to print the full wording of the check amount, including the currency denomination and decimal denomination. For example: $90.11 will print as Ninety Dollars Eleven Cents.

Print date format

Indicate the format in which you want to print dates on your stationery.

This can be based on your system date format or a user defined date format (i.e. Short date or long date). These formats are defined within the System Setup program on the Date Format tab.

Distance between digits/words

This field is displayed if you selected either Words in boxes or Digits in boxes at the Check amount wording style field.

This field indicates the length of each block (beginning of this block to the beginning of the next block) across the check.

Length of full wording per line

This field is displayed if you selected Full wording or Full wording with decimals at the Check amount wording style field.

You use this field to indicate the number of characters to allocate for the wording of the amount on the check.

You can allocate a maximum of 99 characters for the wording of the check amount.

[Note]

You must ensure that this field is wide enough to contain the full wording (i.e. that you have allocated enough characters in this field to print the full wording).

Number of digits to left of decimal

Indicate the maximum number of significant digits allowed for the check amount, or the number of blocks to be printed to the left of the decimal character on the check.

[Note]

Only the number of digits specified here is printed.

For example, if the Number of digits to left of decimal is set to 4 and the check amount is 15123.12 then the amount printed on the check will be 5123.12 (i.e. 10'000 less than what it should be).

Currency  
Denomination symbol

A maximum of three characters can be entered here to represent the denomination symbol of the bank.

For foreign suppliers paid in a foreign currency, the entry made here is overwritten by the currency of the payment.

Denomination (English)

If you are printing the Full wording or the Full wording with decimals of the check amount, then you can enter up to 10 characters representing the currency denomination for the bank (e.g. Pounds, dollars).

Decimal denomination (English)

If you are printing the Full wording or the Full wording with decimals of the check amount, then you can enter up to 10 characters representing the decimal denomination for the bank (e.g. Pence, cents).

Other Languages

Select this to set up different languages in which you want to print checks for this bank.

[Note]

This function is available only if your Check amount wording style is defined as Full wording or Full wording with decimals.

Pad payee name on check

Select this to be able to assign a specific character to fill the blank spaces after the supplier's name when printing your checks.

Padding character to be used

Indicate the specific character you want to use to fill the blank spaces after the supplier's name.

Wingding characters can be used by selecting the Alt key together with a number above 128.

Length of payee name (including padding)

Indicate the number of characters across the check that you want to be taken up by the payee name together with the selected padding character.

Your entry here cannot exceed 60 and cannot be less than 50.

Comma separator for check amount

Select this to print check amounts using a 1000 comma separator, where applicable.

Format is 6.1 compatible This applies to stationery formats defined in the SYSPRO 6.1 SP1 version of the software and is enabled by default for stationery formats defined in that version.

When enabled, the document is printed in the format specified in the SYSPRO 6.1 SP1 version of the software providing no presentation lengths are changed (Set Key Information).

Date Format Select this to define the separator (e.g. None, Spaces, /, \ , - or .) to use when printing the date on your Cash Book checks.

The date remains in the presentation format defined against the system (or the company), but the separator character within the format changes.

Close

Select this to return to the Edit Format screen.

To save the preferences you entered, you must select Save from the Cash Book Check Format screen.

Check Date Format

You use the Date Format function to define the separators (e.g. / , -) to use when printing the date on your supplier checks.

[Note]

The order in which the day, month and year are printed is defined either at system level (System Setup) or at company level (Company Maintenance).

Field Description
Date presentation format  
Overwrite date formats

Select this to define the separators for the check dates.

If you do not select this option, then the separators defined in the date formats you selected at company level (Company Maintenance) are used. If these are not defined at company level, then the separators defined at system level (System Setup) are used.

Date separator

Select the separator you require between the day, month and year of the date.

Once you have selected a separator and you press the Tab key, the dates are displayed in the fields below, using the separator you selected. This enables you to confirm that you have correctly configured your check date.

The following separators are available:

  • None
  • Space
  • /
  • \
  • -
  • .
No of spaces

Indicate the number of spaces you want to use as the date separator.

This field is only enabled if you selected the Date separator: Space in the previous field.

Date normal This displays how the check date will be printed when using the short version of the date for the separator you selected.
Date short This displays how the check date will be printed when using the short version of the date for the separator you selected.
Date long This displays how the check date will be printed when using the long version of the date for the separator you selected.
Close Select this to return to the previous screen.

Other Languages

You use the Other Languages option to set up different languages in which you want to print checks for this bank.

This function is available only if your Check amount wording style is defined as Full wording or Full wording with decimals.

When printing on-line checks from within the Deposits and Withdrawals program, you can indicate the language to use for the check from the Supplier details screen. The denomination wording associated with the language selected on the supplier details screen is used to determine the language to use when printing the check.

You only need to define the denominations for other languages once per bank as these settings are used for all SYSPRO companies.

Field Description
Language

Select a language for which you want to configure the denomination and decimal denomination wording to use.

Available languages include: French, Spanish, Portuguese and German.

Denomination

Enter the denomination wording you want to assign to the selected language for this bank.

When printing on-line checks from within the Deposits and Withdrawals program, you can indicate the language to use for the check from the Supplier details screen. The denomination wording associated with the language selected on the supplier details screen is used to determine the language to use when printing the check.

Decimal denomination

Enter the decimal denomination wording you want to assign to the selected language for this bank.

Save

Select this to save the Other language details you entered.

Close

Select this to close this window without saving your selections for the other language.

Check Detail Section

You use the Check Detail Section option to define the row and column at which you want to print each of the fields on the check.

The row refers to the vertical (top to bottom) position on the check, while the column refers to the horizontal (left to right) position on the check.

Field Description
Field

This indicates the fields that are available for printing on your checks.

Row

This indicates the row number on which the corresponding field must be printed.

A zero indicates that the field is not printed.

Column

This indicates the column number in which the corresponding field must be printed.

A zero indicates that the field is not printed.

Change

Select this to maintain the row and column print positions for the highlighted field.

Close

Select this to close the current window and return to the previous window.

You save the changes you made to the format at the time of exiting the program.

Positions

You use the Change function to maintain the row and column print positions for the highlighted field.

Field Description
Positions

All measurements are based from the top left hand corner of the page.

To assist you in positioning the fields correctly, select the Print Mask for Document Alignment to print a grid of the required columns and lines. Ensure that the layout mask is output to the printer on which you will be printing your checks and/or remittances.

Row

This indicates the vertical position (i.e. Top to bottom) at which you want to print the highlighted field.

The row specification for any field cannot exceed 65.

Column

This indicates the horizontal position (i.e. Left to right) at which you want to print the highlighted field.

The column specification for any field cannot exceed 120.

OK

Select this to accept the print positions you entered.

Cancel

Select this to ignore the print position you entered and to return to the previous screen.

Fields

The following table lists the fields you can print in the Check Detail section:

Field Origin/Comment
Company name  
Address lines 1-3  
Supplier name  
Supplier address lines 1-5  
Supplier postal/zip code  
Check number  
Payment date  
Full payment amount  
Full payment amount wording This field can only be defined if you selected Full wording at the Check amount wording style option in the Check Preferences.

The length of this field is determined by your entry at the Length of full wording per line field.

Digits to left of decimal This field can only be defined if you selected Words in boxes or Digits in boxes at the Check amount wording style option in the Check Preferences.
Digits to right of decimal  
Currency denomination symbol  
Remittance name  
Tax registration number  
Company registration number  

Remittance Preferences

Field Description
Number of lines on a remittance

Indicate the number of lines available for printing on the remittance advice and depends on the physical size of the remittance advice.

A maximum of 99 lines can be entered for a remittance.

Highest start column across page Indicate the maximum column number that can be specified when defining the column print positions for fields on the document.

This must be in the range 1-150.

See also Preference restrictions.

First invoice line starts on row

Indicate where the first invoice detail line must be printed on the remittance.

This cannot be greater than the number of lines on the remittance and cannot exceed 65.

Last invoice line ends on row

Indicate where the last invoice detail line must be printed on the remittance.

This cannot be greater than the number of lines on the remittance and cannot exceed 65. In addition, this cannot be less than the row for the first invoice line.

Start column for remittance text

Print date format

Indicate the format in which you want to print dates on your remittance. This can be based on your system date format or a user defined date format (i.e. Short date or long date).

These formats are defined within the System Setup program.

Use 1000 separator on values

Select this to print remittance values with 1000 separators, where applicable.

The separator character used is the one defined against your Company Maintenance - Options tab.

Format is 6.1 compatible This applies to stationery formats defined in the SYSPRO 6.1 SP1 version of the software and is enabled by default for stationery formats defined in that version.

When enabled, the document is printed in the format specified in the SYSPRO 6.1 SP1 version of the software providing no presentation lengths are changed (Set Key Information).

Bitmap Forms

Select this to indicate a bitmap image to print on your remittance advices.

See Bitmap Forms.

Close

Select this to close the current window and return to the previous window.

You save the changes you made to the format at the time of exiting the program.

Bitmap Forms

You use the Bitmap Forms function to select a bitmap to print on your remittance advices.

Field Description
Bitmap for printing Indicate the bitmap image you want to print on the remittance advice.
Bitmap width Indicate the width of the bitmap image that you want to print on the document and the measurement factor to use (i.e. inches or millimeters).

The bitmap is scaled automatically according to the specifications entered, retaining the aspect ratio (i.e. width to height).

Close

Select this to close the current window and return to the previous window.

You save the changes you made to the format at the time of exiting the program.

Remittance Heading Section

You use the Remittance Heading Section option to define the row and column at which you want to print each of the supplier fields on the remittance.

The row refers to the vertical (top to bottom) position on the remittance, while the column refers to the horizontal (left to right) position on the remittance.

Field Description
Field

This indicates the fields that are available for printing in the header section of your remittance advices.

Row

Indicate the row number on which the corresponding field must be printed.

A zero indicates that the field is not printed.

Column

Indicate the column number in which the corresponding field must be printed.

A zero indicates that the field is not printed.

Clear Row/Column

Delete the row and column print positions for the highlighted field.

When you select this function, the print positions for the highlighted field are set to zero, which means the field is not printed.

Change

Select this to maintain the row and column print positions for the highlighted field.

Close

Select this to close the current window and return to the previous window.

You save the changes you made to the format at the time of exiting the program.

Change

You use the Change function to maintain the row and column print positions for the highlighted field.

Field Description
Positions

All measurements are based from the top left hand corner of the page.

To assist you in positioning the fields correctly, select the Print Mask for Document Alignment to print a grid of the required columns and lines. Ensure that the layout mask is output to the printer on which you will be printing your checks and/or remittances.

Row

Indicate the vertical position (i.e. Top to bottom) at which you want to print the highlighted field.

The row specification for any field cannot exceed 65.

Column

Indicate the horizontal position (i.e. Left to right) at which you want to print the highlighted field.

The column specification for any field cannot exceed 120.

OK

Select this to accept the print positions you entered.

Cancel

Select this to ignore the print position you entered and to return to the previous screen.

Fields

The following table lists the fields you can print in the Remittance Heading section:

Field Origin/Comment
Supplier name  
Supplier address lines 1-5  
Supplier postal/zip code  
Payment date  
Page number  
Bank  
Bank name  
Company name  
Company address lines 1-3  
Foreign currency description  
Company registration number  
Tax registration number  
Remittance name  
Remittance address lines 1-5  
Remittance postal/zip code  

Remittance Detail Section

You use the Remittance Detail Section option to define the column at which you want to print each of the invoice fields on the remittance.

The column refers to the horizontal (left to right) position on the remittance.

[Note]

There are no row specifications as the row is taken from your entry at the First invoice line starts on row field as indicated on the Remittance preferences screen.

Field Description
Field

This indicates the fields available for printing in the detail section of your remittance advices.

Column

Indicate the column number in which the corresponding field must be printed.

A zero indicates that the field is not printed.

Clear Column

Delete the column print position for the highlighted field.

The print position for the highlighted field is set to zero, which means the field is not printed.

Change

Select this to maintain the row and column print positions for the highlighted field.

Close

Select this to close the current window and return to the previous window.

You save the changes you made to the format at the time of exiting the program.

Change

You use the Change function to maintain the column print positions for the highlighted field.

[Note]

There are no row specifications as the row is calculated from your entry at the First invoice line starts on row field as indicated on the Remittance preferences screen.

Field Description
Positions

All measurements are based from the top left hand corner of the page.

To assist you in positioning the fields correctly, select the Print Mask for Document Alignment to print a grid of the required columns and lines. Ensure that the layout mask is output to the printer on which you will be printing your checks and/or remittances.

Column

This indicates the horizontal position (i.e. Left to right) at which you want to print the highlighted field.

The column specification for any field cannot exceed 120.

OK

Select this to accept the print positions you entered.

Cancel

Select this to ignore the print position you entered and to return to the previous screen.

Fields

The following table lists the fields you can print in the Remittance Detail section:

Field Origin/Comment
Invoice  
Invoice date  
Invoice amount  

Remittance Total Section

You use the Remittance Total Section function to define the row and column at which you want to print each of the supplier totals on the remittance.

The row refers to the vertical (top to bottom) position on the remittance, while the column refers to the horizontal (left to right) position on the remittance.

Field Description
Field

This indicates the fields available for printing in the total section of your remittance advices.

Row

Indicate the row number on which the corresponding field must be printed.

A zero indicates that the field is not printed.

Column

Indicate the column number in which the corresponding field must be printed.

A zero indicates that the field is not printed.

Clear Row/Column

Delete the row and column print positions for the highlighted field.

When you select this function, the print positions for the highlighted field are set to zero, which means the field is not printed.

Change

Select this to maintain the row and column print positions for the highlighted field.

Close

Select this to close the current window and return to the previous window.

You save the changes you made to the format at the time of exiting the program.

Change

You use the Change function to maintain the row and column print positions for the highlighted field.

Field Description
Positions

All measurements are based from the top left hand corner of the page.

To assist you in positioning the fields correctly, select the Print Mask for Document Alignment to print a grid of the required columns and lines. Ensure that the layout mask is output to the printer on which you will be printing your checks and/or remittances.

Row

Indicate the vertical position (i.e. Top to bottom) at which you want to print the highlighted field.

The row specification for any field cannot exceed 65.

Column

Indicate the horizontal position (i.e. Left to right) at which you want to print the highlighted field.

The column specification for any field cannot exceed 120.

OK

Select this to accept the print positions you entered.

Cancel

Select this to ignore the print position you entered and to return to the previous screen.

Fields

The following table lists the fields you can print in the Remittance Total section:

Field Origin/Comment
Supplier name  
Check number  
Bank  
Remittance advice amount  
Remittance name  

MS Word Options

As an alternative to printing your remittance advices on pre-printed stationery, you can configure SYSPRO to allow you to print remittances using Microsoft Word.

Refer to Word Printing for additional information about printing using MS Word.

Design Template

You use the Design Template function to open the applicable Word template and insert the fields that you want to print on your stationery.

Refer to Design Template for additional information.

Define a check format

  1. From the Cash Book Check Format program enter the bank for which you want to define the check format.

  2. Select the Edit Format function.

  3. Select Check only.

    [Note]

    If you want to define the remittance format at the same time as defining the check format, then you can select Both check and remittance from the Documents required options.

    Refer to the task Define a remittance format for the remittance format sections you need to define.

  4. From the Check sections list, highlight Check preferences.

  5. Select the Change function

  6. Enter the details for the check preferences.

  7. Select Close to return to the Edit Format screen.

  8. From the Check sections list, highlight Check detail section.

  9. Select the Change function.

  10. Enter the details for the Check detail section.

  11. Select Close.

  12. Optionally select Alignment to print a check using test characters. This enables you to view the print positions you selected for the fields on the check.

  13. Select Save from the Edit Format screen to save the all information you entered.

  14. Select Close to return to the Cash Book setup menu or enter another bank for which you want to define a check format.

Define a remittance format

  1. From the Cash Book Check Format program enter the bank for which you want to define the remittance format.

  2. Select the Edit Format function.

  3. Select Remittance only.

    [Note]

    If you want to define the check format at the same time as defining the remittance format, than you can select Both check and remittance from the Documents required options.

    Refer to the task Define a check format for the check format sections you need to define.

  4. From the Remittance sections list, highlight Remittance preferences.

  5. Select the Change function.

  6. Enter the details for the remittance preferences.

  7. Select Close to return to the Edit Format screen.

  8. From the Remittance sections list, highlight Remittance heading section.

  9. Select the Change function.

  10. Enter the details for the remittance heading.

  11. Select Close.

  12. From the Remittance sections list, highlight Remittance detail section.

  13. Select the Change function.

  14. Enter the details for the remittance details.

  15. Select Close.

  16. From the Remittance sections list, highlight Remittance total section.

  17. Select the Change function.

  18. Enter the details for the remittance totals.

  19. Select Close.

  20. Optionally select Alignment to print a remittance using test characters. This enables you to view the print positions you selected for the fields on the remittance.

  21. Select Save from the Edit Format screen to save the all information you entered.

  22. Select Close to return to the Cash Book setup menu or enter another bank for which you want to define a remittance format.

Change a check format

  1. From the Cash Book Check Format program enter the bank for which you want to change the check format.

  2. Select the Edit Format function.

  3. Select Check only.

    [Note]

    If you want to change the remittance format at the same time as changing the check format, then you can select Both check and remittance from the Document required options.

    Refer to the task Change a remittance format for changing the remittance format.

  4. From the Check sections list, highlight section you want to change.

  5. Select the Change function.

  6. Enter the changes to the section you selected.

  7. Select Close to return to the Edit Format screen.

  8. Select Save to save your changes or, from the Check sections list, highlight another section to change.

Change a remittance format

  1. From the Cash Book Check Format program enter the bank for which you want to change the remittance format.

  2. Select the Edit Format function.

  3. Select Remittance only.

    [Note]

    If you want to change the check format at the same time as changing the remittance format, then you can select Both check and remittance from the Document required options.

    Refer to the task Change a check format for changing the check format.

  4. From the Remittance sections list, highlight section you want to change.

  5. Select the Change function.

  6. Enter the changes to the section you selected.

  7. Select Close to return to the Edit Format screen.

  8. Select Save to save your changes or, from the Remittance sections list, highlight another section to change.

Copy a check format

  1. From the Cash Book Check Format program enter the bank to which you want to copy a check format.

  2. Enter the bank from which you want to copy the format.

  3. Optionally select the Change Company function if the bank you want to copy the format from is in another company.

  4. Select OK to copy the format you selected or Cancel to return to the Cash Book Check Format screen without copying the format.

  5. You can optionally edit the format you created via the Copy function.

  6. Select Save to save the format you created using the Copy function as well as the changes you made to the format (if any).

    If you select Cancel, then the format you created using the Copy function as well as the changes you made to that format (if any) are not saved.