This section describes the specifics of accessing and interpreting the Accounts Payable Open Bills report.
Opening Report
You can open the report from the CStoreOffice® main page in one of the following ways:
- Go to Reports > Accounting > Manage Accounts Payable > Accounts Payable Open Bills.
- Go to Vendors > Accounts Payable > Related Information > Accounts Payable Open Bills.
For more information, see Viewing Reports.
Viewing Report
The Accounts Payable Open Bills report displays the list of transactions with outstanding balance.
If you open the report from the Accounts Payable form, it opens by default for the company selected in this form.
In case no company is selected in the Accounts Payable form or you open the Accounts Payable Open Bills report from the Reports form, the report will open for the first company in the list of companies of the current account.
To generate the report for the other company, use the Company filter in the report. For details, see Filtering Report Data.
The report contains the following information:
- Date: The transaction date.
- Due Date: The debt payment date.
- Vendor The transaction vendor.
- Memo: The number of the invoice.
- From Account: The Accounts Payable (A/P) account.
- To Account: The account for payment.
- Amount: The total amount of payment.
- Due Amount: The debt balance.
Filtering Report Data
To get the exact information you need, you can apply filters to the report. To set up a filter, select one or more filtering options. Once the filter is set up, at the bottom of the filter section, click the Refresh button to display the report data by the filter criteria.
The report provides the following filtering and sorting options:
- Due Date: Select the due date to display all open bills with the Due Date value which is less than or equal to the selected date.
- Show all open payables: Select this option to display all open bills that meet all selected filtering criteria except for the Due Date value.
- Company: Select this filtering option and then select the company you want from the corresponding list.
- Classes: Select this filtering option and then select the class/station you want from the corresponding list.
- Vendor: Select this filtering option and then select the vendor you want from the corresponding list.
- Sort by: Select the order of the report columns you want. Select the Ascending or Descending option for the corresponding type of filtering.
- Subtotal by: Select this filtering option and the subtotal option if you want to break-down the report results further.
Press CTRL to select several items at a time.
Additional Actions
To reload the form, click Refresh.
To print the report, click Print Version.
To view the report in the Excel version, click Convert to Excel.
To open the Petrosoft University Portal, click Help.
To create a ticket, click Feedback.
To save the report to favorites, click the favorites icon next to the reports name.
For more information on additional report features, see Reports.
