Vendor Payments List Report
Shows a list of the payments in a user-defined period. There are three predefined layouts available to display the amount, remaining amount, currency exchange rate, and posting information.
Options
| Field | Description |
|---|---|
Sorting |
Specifies the sort order. You can sort by vendor or chronologically. If you sort by vendor, you will see a subtotal for each vendor. If you sort chronologically, you will not see subtotals. |
Layout |
Specifies the layout of the report. If you select Standard, the report lists payments with amounts in your local currency. If you select FCY Amounts, amounts are in the appropriate foreign currencies. If you select Posting, the report includes information such as the posting group and the user who posted the document. |
Additional Information
If sorted by vendor, only the number and name of the vendor is displayed on the first line. If there is more than one entry per vendor, only the group total is displayed.
The number of payments processed is displayed in the page total and report total.
In the Status column, O = Open, PP = Partial Payment, C = Closed.
Only the Payment document type is shown.
If a foreign currency payment is applied to an invoice, the exchange rate equivalent is displayed in the vendor account. This occurs because invoice entries must be applied in both FCY and LCY. The invoice and payment total will be zero.
The Payment LCY column shows the equivalent for the payment currency and is derived from the Original Amt. (LCY) field of the vendor ledger entries. Amount LCY shows the equivalent for the invoice currency and is derived from the Amount (LCY) field.
The currency is calculated for three locations based on the relationship between Amt. FCY and Payment LCY.
When booking in local currency, the amounts in FCY, the exchange rate, and the payment amount LCY are excluded for simplicity.
Tip
For more information on how to work with reports, see Viewing Test Reports before Posting, How to: View and Print Reports and How to: Set Filters. For assistance in finding specific pages, see Search.
See Also
Tasks
How to: Print Vendor Payments List Reports