Use this function to print records from the Payment register. Please refer to the
page for details of how to ensure this function complies with your requirements.
A printed payment form can be useful as documentation of the cheques you have issued from the program. If you write your cheques manually, this document can provide you with a valuable tool for reconciliation.
The Payment Form is unusual in that it will not necessarily be printed using the Form specified in the 'Form Definition' window as described here. If the Payment Mode quoted in the header of a Payment is one in which you have specified a Form in the Document field on flip B, this Form will be used instead.
You can also print a Payment Form from an individual Payment record by opening it and clicking the Printer icon in the Button Bar. This method of printing a Payment Form will behave as though the All and Payment per Supplier options are selected.If you print a Payment that has not been Ordered, the text "Test Printout" will be printed diagonally across the page as a watermark. If you do not want this watermark, use the No Test Printout option in the
If you use this document to print from a Payment record that contains payments issued to more than one Supplier and you use the Payment per Supplier option, separate documents will be printed for each Supplier. If you use this option, this document behaves in the same way as the Cheque Document: please refer to the description of that document for details about the fields you can include in the Form design. If you use the Payment option, a single page will be printed for each Payment so some fields will behave differently, as described below. As a result, you may need different Form designs if you are likely to use both options at different times.
Listed below are the fields you can use when design the Form to be used by the Payment Forms document when you print it using the Payment option. If you do not want to print the decimal places in numeric fields, choose the Cut Decimals option in the record in the Values in Text setting for the Language specified in the Company Info setting.
| Field in Form | Prints (from Payment record) |
| |
| The following fields will print information from the header of a Payment record: |
| |
| Bank Total | Sum of the Invoice Values from each Payment row, converted to Base Currency 1 using the Exchange Rate for the Trans. Date |
| Current User | Signature of the current user |
| Day | The day from the Trans. Date. For example, the day from 2/1/2013 will be printed as "2" |
| From Bank | Comment |
| From Bank Account | Own Bank A/C |
| Month | The month from the Trans. Date. For example, the month from 2/1/2013 will be printed as "1" |
| Month in words | The name of the month in the Trans. Date, taken from the record in the Days and Months setting in the System module for the Language of the Supplier or, if that is blank, the Language in the current user's Person record |
| Number of Invoices | Number of Purchase Invoices being paid |
| Payment Date | Payment Date |
| Payment Mode | Payment Mode |
| Payment Number | No. |
| Payment Number for Russia | Prints the No. of the Payment with the first three characters removed |
| Reference | Reference |
| Registration Date | Payment Date |
| Serial Number (Number Series) | No. |
| Transaction Date | Trans. Date |
| Year | The year from the Trans. Date. For example, the year from 2/1/2013 will be printed as "2013" |
| |
| Row Fields (these print once per Payment row, so remember to specify a Line Height and to set the Format to "Matrix"). The "...in Text" fields will print phrases constructed using the relevant record in the Values in Text setting for the Language of the Supplier or, if that is blank, the Language in the current user's Person record or in the Company Info setting: |
| |
| Amount | Invoice Value (from flip B) |
| Amount for Bielaussian Payment Form | Invoice Value, with an equal sign in place of the decimals and decimal separator (for example, 123.45 will be printed as 123=) |
| Amount for Russian Payment Form | Invoice Value, with a dash as the decimal separator |
| Amount in Text | Prints as a phrase the Invoice Value |
| Amount in Text, Cents | Prints as a phrase the digits after the decimal point in the Invoice Value |
| Amount in Text, Units | Prints as a phrase the first digit before the decimal point in the Invoice Value |
| Amount in Text, Tens | Prints as a phrase the second digit before the decimal point in the Invoice Value |
| Amount in Text, Hundreds | Prints as a phrase the third digit before the decimal point in the Invoice Value |
| Amount in Text, Thousands | Prints as a phrase the fourth digit before the decimal point in the Invoice Value |
| Amount in Text, 10 Thousands | Prints as a phrase the fifth digit before the decimal point in the Invoice Value |
| Amount in Text, 100 Thousands | Prints as a phrase the sixth digit before the decimal point in the Invoice Value |
| Amount in Text, Millions | Prints as a phrase the seventh digit before the decimal point in the Invoice Value |
| Amount in Text, 10 Millions | Prints as a phrase the eighth digit before the decimal point in the Invoice Value |
| Amount in Text, 100 Millions | Prints as a phrase the ninth digit before the decimal point in the Invoice Value |
| ANA Code | ANA Code from the Contact record for the Supplier |
| Bank Account | To Bank A/C (from flip H) |
| Bank Currency | B. Cur. (i.e. Bank Currency) |
| Bank Name | Bank Name from the Own Cheque record for the Cheque No. |
| Bank Value | Bank Amount |
| Cheque Number | Ser No. from the Own Cheque record for the Cheque No. |
| Cheques Serial Number | Cheque No. (from flip C) |
| Comment | Text |
| Comment 2 | Text |
| Currency | I. Cur (from flip B) |
| Customer Comment (speclev) | Comment from the Contact record for the Supplier ('Company' card) |
Customer Registration No. 1 | Reg. No. 1 from the Contact record for the Supplier | | Customer Registration No. 2 | Reg. No. 2 from the Contact record for the Supplier |
| Due Date |
| Delivery Address | Name (if you are using the Organisation Name option in the Form Settings setting) or first line of the Invoice Address from the Contact record for the Supplier |
| Delivery Address 2 | Name from the Contact record for the Supplier |
Due Date of the Purchase Invoice being paid | | Effective Date | Effect Date from the Own Cheque record for the Cheque No. |
| Invoice Date 2 | Invoice Date of the Purchase Invoice being paid |
| Invoice No. | No. of the Purchase Invoice being paid |
| Invoice Number 2 | Supp. Inv. No. of the Purchase Invoice being paid |
| Invoice Type (short) | Type of the Purchase Invoice being paid (prints "1" for an Invoice, "2" for a Cash Note or"3" for a Credit Note) |
| Open Invoice Value | Any value that is still outstanding against the Purchase Invoice being paid when you print the document |
|
| Our Customer Number | Their Customer Code from the Contact record for the Supplier |
|
| Our Reference | Reference Number (from flip G) |
| Our Reference (ourref) | Bank Reference (from flip H) |
| Payment Mode, row | Comment from the Payment Mode (from flip C or, if blank, from the header) |
| Prepayment Number | Prepayment No. (from flip D) |
| Received Currency | S. Cur. (i.e. Sent Currency) |
| Received Value | Sent Value |
| Reference (Invoice) | Reference from the Purchase Invoice being paid |
Registration Date | Reg. Date from the Own Cheque record for the Cheque No. | | Supplier | No. from the Contact record for the Supplier |
| Supplier Invoice Number | Supp. Inv. No. of the Purchase Invoice being paid |
| Supplier Name | Name from the Contact record for the Supplier |
| Supplier VAT Reg. Number | VAT Reg. No. from the Contact record for the Supplier |
| To Bank Account | To Bank A/C (from flip H) |
| To Pay | Invoice Value (from flip B). If this figure is less than zero, the word "Void" will be printed |
| To Pay in Text | Prints as a phrase the Invoice Value |
| To Pay in Base 1 | Invoice Value, converted to Base Currency 1 using the Exchange Rate for the Trans. Date |
| To Pay in Text in Base 1 | Prints as a phrase the Invoice Value, converted to Base Currency 1 using the Exchange Rate for the Trans. Date. |
| To Pay in Base 2 | Invoice Value, converted to Base Currency 2 using the Exchange Rate for the Trans. Date |
| To Pay Rus Payment Form | Invoice Value, with a dash as the decimal separator. If this figure is less than zero, the word "Void" will be printed |
| VAT | VAT Value (from flip E) |
| VAT for Russian Payment Form | VAT Value, with a dash as the decimal separator |
| VAT %, row | VAT percentage from the V-Cd (from flip E) (prints blank if the rate is 0%) |
| |
| These fields print information from the record in the Banks setting for the Account Operator specified in the Contact record for the Supplier (these print once per Payment row, so remember to specify a Line Height and to set the Format to "Matrix"): |
| |
| Bank Address 0 | First line of the Address |
| Bank Address 1 | Second line of the Address |
| Bank Address 2 | Third line of the Address |
| SWIFT | BIC (SWIFT) |
| To Bank | Name |
| To Bank 1 | Clearing |
| To Bank 2 | Account (IBAN) |
for details of the standard fields that you can also include in the Form.
Introduction to Documents in the Purchase Ledger
