If you have access to Supplier Reports in Back-office, you will be able to view report 402.
This report shows your suppliers' balances. It groups balances on number of days until due date relative to today's date.
1. In Advantage Back-office, click the left sidebar menu.
2. Open the Suppliers menu.
3. Click on Supplier Reports.
4. Select report 402 - Supplier Age Analysis, by clicking on it.
5. Click on the "Show Report" button.
6. You can change the report date that will reflect on the report.
7. Select an Accounting Period month and year from the drop-down lists.
8. When the "Show Supplier Details" checkbox has been ticked, the following supplier details will be displayed:
- Supplier Name
- Account Number
- Terms
- Contact
- Contact number
- Supplier bank
- Account Name
- Bank Account number
- Credit Limit
- Fax
- Branch
- Marked for payment amount
- Remaining balance amount
- Cellphone number
- Supplier code
9. If the "Print Zero Balances" option has been selected, all suppliers, including those with a 0 balance, will be displayed.
10. Click on the Fetch button.
11. This report can be exported to the following file formats: Microsoft Excel, Acrobat PDF and Text CSV.