Payment Order Generation
A payment order is a settlement document containing an instruction from the bank’s payer to transfer the amount of funds specified in it from their account to the recipient’s account.
The payment order in the system is generated in the Bank Payment Journal, exported to a file in the appropriate format and transferred to the client bank system.
You can generate a payment order in the Bank Payment Journal in the following ways:
- create journal lines manually;
- create journal lines using the Suggest Vendor Payments feature;
- create journal lines from the Open Documents subform using the Create Payment feature.
Creating a payment order manually
To create a payment order manually, do the following:
- Click
to open Search, enter Bank Payment Journal, follow the link. Select the journal batch that corresponds to the required bank.
- In a new line, fill in all required fields:
- document date,
- document type – Payment or Refund (in case of a refund to the customer),
- document number – will be filled in automatically if a number series is configured for the journal batch,
- account type – Vendor or Customer (in case of the Refund document type),
- account number,
- amount,
- the recipient’s bank account,
- agreement number,
- payment assignment.
Note
The payment assignment field can be filled in automatically if the Payment Assignment field on the vendor or agreement card is filled in with the appropriate text using formulas. For example, Payment acc. to Agr. %1 dated %2, invoice No. %3 dated %4. Amount UAH %5, %6, where %1 – external vendor agreement number,
%2 – agreement validity start date,
%3 – vendor invoice number,
%4 – vendor invoice date,
%5 – total amount with VAT,
%6 - amount and VAT percentage. If in the lines of the document based on which the payment is created different VAT percentages are used, the VAT amount will be calculated according to percentages and reflected as the total amount.
The values of the vendor invoice number, vendor invoice date, the amount and the VAT percentage are filled in when the payment is applied to a vendor's transaction or document.
Creating a payment order with the Suggest Vendor Payments feature
To create payment lines with the Suggest Vendor Payments feature, do the following:
- From an empty journal line, click Prepare > Suggest Vendor Payments
- In the request window that appears, set the necessary parameters:
Field | Description |
---|---|
Last Payment Date | Indicates the last date before which the system will select open vendor entries to generate payments. |
Check Other Journal Batches | Enable this option to check other journal batches and avoid duplicate payments. |
Summarize per Vendor | If this option is enabled, one summing payment will be created for the vendor for each of the currencies for all open documents. |
Posting Date | Indicates the date on which the journal lines will be created. |
Starting Document No. | Specifies the document number for the first line created by the batch job. All subsequent lines will be numbered in order. |
Vendor No. filter | Select the vendor for which the journal lines will be generated. |
Payment Method Code filter | Select the payment method for which the journal lines will be generated. |
- Click OK. The system will find all open entries in the vendor ledger, as well as unposted purchase orders in the Pending Prepayment status (if this option is enabled), and create journal lines according to the specified parameters. For all payment lines created by the batch job, applications will be set to the transactions they were created from.
Note
When processing open vendor entries, the system analyzes the total vendor balance by agreements in order to avoid overpayments. For example, if the amount of open payments in the vendor’s entries is greater than the amount of open invoices, then the system will not offer these invoices for payment.
Creating a payment order with the Create Payment feature on the Open Documents subform
To display the subform of documents for payment in the Bank Payment Journal, do the following:
- on the Apply Documents FastTab in General Ledger Setup, select all the necessary documents to be displayed on the subform,
- on the Bank Payment Journal page, enable the Show Open Documents Subform feature.
To create a payment from the Open Documents subform, do the following:
- In the journal line, select Account Type and Number, according to which documents are displayed on the subform.
- Select the desired customer or vendor document.
- Click Create Payment.
- A journal line will be created with all the necessary details filled in and payment application to the vendor’s or customer’s document set.
Note
The informative field Remaining Prepayment Amount in the lines of documents for payment reflects the balance of the unpaid amount calculated as a prepayment for the order.
When applying a payment line to a posted or unposted document, the dimensions for the payment will be inherited from the document. If a dimension is set on the line prior to applying it and that dimension is not present in the document, the system will combine the dimensions of the line and the document.