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.
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.
|
||||
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.
|
||||
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. |
||||
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. |
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.
|
||||
Cancel |
Select this to exit the program without performing the copy. |
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. |
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.
|
||||
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). |
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 (see Check Preferences)
Check detail section (see Check Detail Section)
Remittance preferences (see Remittance Preferences)
Remittance heading section (see Remittance Heading Section)
Remittance detail section (see Remittance Detail Section)
Remittance total section (see Remittance Total Section)
MS Word options (see MS Word Options)
SRS options (see SRS Document Print Setup and SRS Document Template)
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.
|
||||
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.
|
||||
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.
|
||||
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.
|
||||
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. |
You use the Date Format function to define the separators (e.g. / , -) to use when printing the date on your supplier checks.
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:
|
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. |
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. |
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. |
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. |
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 |
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. |
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. |
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. |
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. |
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 |
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.
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. |
You use the Change function to maintain the column print positions for the highlighted field.
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. |
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. |
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. |
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.
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
From the Cash Book Check Format program enter the bank for which you want to define the check format.
Select the Edit Format function.
Select Check only.
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. |
From the Check sections list, highlight Check preferences.
Select the Change function
Enter the details for the check preferences.
Select Close to return to the Edit Format screen.
From the Check sections list, highlight Check detail section.
Select the Change function.
Enter the details for the Check detail section.
Select Close.
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.
Select Save from the Edit Format screen to save the all information you entered.
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
From the Cash Book Check Format program enter the bank for which you want to define the remittance format.
Select the Edit Format function.
Select Remittance only.
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. |
From the Remittance sections list, highlight Remittance preferences.
Select the Change function.
Enter the details for the remittance preferences.
Select Close to return to the Edit Format screen.
From the Remittance sections list, highlight Remittance heading section.
Select the Change function.
Enter the details for the remittance heading.
Select Close.
From the Remittance sections list, highlight Remittance detail section.
Select the Change function.
Enter the details for the remittance details.
Select Close.
From the Remittance sections list, highlight Remittance total section.
Select the Change function.
Enter the details for the remittance totals.
Select Close.
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.
Select Save from the Edit Format screen to save the all information you entered.
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
From the Cash Book Check Format program enter the bank for which you want to change the check format.
Select the Edit Format function.
Select Check only.
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. |
From the Check sections list, highlight section you want to change.
Select the Change function.
Enter the changes to the section you selected.
Select Close to return to the Edit Format screen.
Select Save to save your changes or, from the Check sections list, highlight another section to change.
Change a remittance format
From the Cash Book Check Format program enter the bank for which you want to change the remittance format.
Select the Edit Format function.
Select Remittance only.
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. |
From the Remittance sections list, highlight section you want to change.
Select the Change function.
Enter the changes to the section you selected.
Select Close to return to the Edit Format screen.
Select Save to save your changes or, from the Remittance sections list, highlight another section to change.
Copy a check format
From the Cash Book Check Format program enter the bank to which you want to copy a check format.
Enter the bank from which you want to copy the format.
Optionally select the Change Company function if the bank you want to copy the format from is in another company.
Select OK to copy the format you selected or Cancel to return to the Cash Book Check Format screen without copying the format.
You can optionally edit the format you created via the Copy function.
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.