AP Coming Due MC

Form ID: (AP631600)

Note: This form is available only if the Multicurrency Accounting feature is enabled on the Enable/Disable Features (CS100000) form.

This multicurrency report displays the list of vendors with outstanding balances. The overdue balances are displayed in the Past Due column, while the balances that are not overdue are arranged by days outstanding. The report can be shown in summary format or in detailed format with the documents that created the balance. The amounts are shown in the currency of the document and in the base currency.

See the following section for a description of each parameter on the Report Parameters tab of the report form. For more information about using other elements on the report form, see Reports.

Report Parameters

On the Report Parameters tab, you use the following parameters to select the information to be displayed on the report:

  • Report Format: The format of the report. Select one of the following options:
    • Detailed (default): To view outstanding documents on the selected aging date
    • Summary: To view outstanding balances on the selected aging date
  • Company/Branch: The company, branch, or company group for which you want to view information. By default, the current company or branch is selected. You can select another branch, company, or company group to which you have access or leave the box blank to view information about all companies in the tenant.

    This parameter is required if the Multiple Base Currencies feature is enabled on the Enable/Disable Features (CS100000) form.

  • Vendor Class: The vendor class whose vendors will be included in the report. Select a vendor class from the list of vendor classes, or make no selection to view information about all classes.
    If the Customer and Vendor Visibility Restriction feature is enabled on the Enable/Disable Features (CS100000) form, the list of vendor classes available for selection may be limited based on the roles assigned to the user account to which you are signed in. In this case, the Restrict Visibility To box appears on the General tab of the Vendor Classes (AP201000) form. With the feature enabled, a vendor class is available for selection if one of the following is true:
    • The Restrict Visibility To box is empty for the vendor class—that is, the vendor class’s visibility is not restricted.
    • A branch, company, or company group is specified in the Restrict Visibility To box for the vendor class, and your user account is assigned to the role specified in the Access Role box of the Configuration Settings section of one of the following: the Branch Details tab of the Branches (CS102000) form for the branch, or the Company Details tab of the Companies (CS101500) form for the company or a company within the company group.
  • Vendor: The vendor the report will cover. Select a vendor from the list of active vendors, or make no selection to view information about all vendors.
    The list of vendors available for selection may be limited based on the role or roles assigned to the user account to which you are signed in if the Customer and Vendor Visibility Restriction feature is enabled on the Enable/Disable Features (CS100000) form. In this case, the Restrict Visibility To box appears on the Financial tab of the Vendors (AP303000) form. With the feature enabled, a vendor is available for selection if one of the following is true:
    • The Restrict Visibility To box is empty for the vendor—that is, the vendor’s visibility is not restricted.
    • A branch, company, or a company group is specified in the Restrict Visibility To box for the vendor, and your user account has the role specified in the Access Role box of the Configuration Settings section of one of the following: the Branch Details tab of the Branches (CS102000) form for the selected branch, or the Company Details tab of the Companies (CS101500) form for the selected company or a company within the company group.
  • Date: The date the system will use to calculate the aging categories for the documents.

    By default, the current business date is selected.

    Note: If some documents do not have a due date specified, the system sets the due date for these documents to the Date value. The balances of documents that are due on the aging date of the report are included in the first aging period of the report.