You use this program to generate a report of amounts owed to all your suppliers or to suppliers in a specific Accounts Payable branch.
Transactions can be aged according to the transaction date or the financial period in which they were posted. The results from this report would typically be used as an input to your Cash Flow Statement.
| Field | Description |
|---|---|
| Report sequence | |
| Supplier | Select this to print the report in supplier sequence. |
| Short name | Select this to print the report in supplier short name sequence. |
| Report type | |
| Detail | Select this to print a report listing all invoices for each supplier. |
| Summary | Select this to print a report listing a list of the accumulated invoice amounts for each supplier on a single line. |
| Ageing method | |
| Financial month | Select this to age invoices according to the financial month in which they were posted. The program places invoices into aged buckets based on a comparison between the current period and the period in which they were posted. |
| Invoice date |
Select this to age invoices according to the invoice date. The program places invoices into aged buckets based on a comparison between the invoice date and the Accounts Payable period end dates (Accounts Payable Setup). |
| Date on report | Indicate which date you want to print on the report. |
| Invoice date | Select this to print the invoice date on the report. |
| Invoice due date | Select this to print the due date of the invoice on the report. |
| Report as of | |
| Current period | Select this to generate the report for the current period. |
| Previous period 1 | Select this to generate the report for the previous period. |
| Previous period 2 | Select this to generate the report for two periods ago. |
| Currency options | |
| Show values in | |
| Local currency | Select this to print foreign amounts in the local currency equivalent. |
| Foreign currency | Select this to print foreign amounts in the original currency. |
| Convert to local value at | These options are relevant only if you selected to Show values in Local currency. |
| At entry time | Select this to convert foreign amounts to local currency using the currency rate at the time of entry. |
| At current exchange rate | Select this to convert foreign amounts to local currency using the current exchange rate held in the Currencies program. |
These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).
Zero balance invoices are only printed if they became zero in the current month.
Future invoices are accumulated under the Current column on the report.
The journal number is zero against payments for invoices which were re-established during Accounts Payable payment processing.
The invoices for each supplier are analysed by invoice date/period from the current date/period, (extracted from the current system date or control record) backwards.
The invoice balance for an invoice dated for (or posted in) the current period and year is printed under the column headed: Current, while the balance for an invoice dated for (or posted in) the previous period is printed under the column headed: Prev 1. An invoice that is two periods old is printed under the next column, and any older invoices are listed under Before Prev 2.
See Coding considerations in Notes and warnings
Foreign currency supplier totals
When generating the report in Local currency, the amounts for a foreign currency supplier are displayed in the foreign currency, but the total for the foreign currency supplier is displayed in the local currency by default. The foreign amounts are converted to the local currency for the purposes of correctly displaying the ageing buckets in the totals at the end of the report.
If you want to display the totals for foreign currency suppliers in the foreign currency, then the ForCurrInvBal and Edited_ForCurrInvBal elements can be dragged onto the report using the Design Report function of the SYSPRO Reporting Services program. The elements are located in the Field Explorer - Database fields - GroupItems/SupplierItem section.