Payment Worksheet
Using the recipient payment worksheet is one of the methods for creating payment proposal lines. The worksheet contains all open recipient ledger entries that are necessary for creating payment proposal lines.
This article describes the following payment worksheets:
- Vendor Ledger Worksheet (legacy);
- Employee Ledger Worksheet;
- Customer Ledger Worksheet.
Important
It is recommended to use the Vendor Payment Worksheet tool. The Vendor Payment Worksheet (legacy) functionality will not be available after the transition period finishes.
In addition to the standard information that is displayed in ledger entries, the worksheet contains the following fields:
- Transfer Amount - Specifies the transfer amount entered by a user for this entry.
- Amount in Bank Transfers - Specifies the total transfer amount for the entry in payment proposals that are not exported.
- Amount in Electr. Bank. Reg. - Specifies the total transfer amount for the entry in the electronic banking register. The positive amount means that bank transfers have been exported for this entry, but they have not been applied in the system. For more details, see Electronic Banking Register.
Tip
The list of fields that is available within the payment worksheet functionality can vary depending on the applications installed in Electronic Banking Extensions. For more details, see Local functionality ind Interfaces.
Create Payment Proposal Lines
To create payment proposal lines on the Payment Worksheet page:
- Choose the icon, and enter Payment Proposals and then select a related link.
- On the action bar choose the Payment Worksheet action.
- Enter the values in the Transfer Amount field.
The transfer amount entered by the user in the Transfer Amount field must not be greater than the calculated outstanding transfer amount. The outstanding transfer amount can be calculated by adding the following values:
Remaining Amount + Amount in Bank Transfers + Amount in Electr. Bank. Reg.
The outstanding amount of the transfer can be calculated and entered automatically by using the Assign Transfer Amount action. The outstanding amount of the transfer can be changed manually.
Note
The outstanding transfer amount is decreased by the payment discount amount.
Important
If the value entered is greater than the outstanding transfer amount, a warning will be displayed in the worksheet. This is not an error (the user can process the payment proposal further), however conflicts may occur when other transfer or bank statement commands are processed.
Note
The summary in the Total Assigned Amount field contains the sum of the Transfer Amount column in the currency of a sender’s bank account. The amount is denominated in the sender’s bank account currency according based on the currency exchange rate set in Dynamics 365 Business Central.
- When you fill in all required fields in the entry, use the Create Transfers action.
- If any errors occur (such as invalid amounts), a list of these errors is displayed. Otherwise, the transfer amounts are set to zero and new lines are created in the payment proposal.
Note
If you do not apply the amounts before you close the worksheet, the values in the Transfer Amount field are retained and they are displayed when you reopen the worksheet. The amounts can be viewed by all electronic banking users that use the payment worksheet.
See Also
Detailed Payment Proposal Lines