AP Aged Period-Sensitive by Project

Report ID: (AP630600)

You use this report to determine the state of the open documents at the end of a particular financial period. This report shows the documents that are outstanding at the end of the particular financial period, grouped by projects, and broken down by aging periods. The documents are listed by project (that is, the project assigned to the AP documents) and by vendor. The balances are arranged by days past due on the last day of the specified period or by document dates. All the amounts are shown 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-Specific Parameters

You use the following parameters to select the information to be displayed on the report:

  • Report Format: The format to be used for the report. Select one of the following options:
    • Detailed: To view outstanding documents for the selected period
    • Summary: To view outstanding balances for the selected period
  • 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.

  • Financial Period: The financial period the system will use to calculate the aging categories for the documents.

    By default, the current financial period is used.

  • Project: The project whose documents will be included in the report. Either select a project from the list or leave the box blank to view information for all projects.
  • Project Manager: The employee who is responsible for the implementation of the project whose documents will be included in the report. Either select a project manager from the list or leave the box blank to view information for all project managers. You do not have to specify the parameter; if the box is left blank, the report shows the documents or balances associated with all the projects (including projects for which no project manager is specified).
  • Vendor Class: The vendor class for which past due balances will be listed. 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.
  • Use Master Calendar: A check box that you select to use the financial period from the master calendar. If the check box is cleared, the report will show data for the company calendar.

    This check box appears on the form only if the Multiple Calendar Support feature is enabled on the Enable/Disable Features form.

    For details on running consolidated reports and inquiries, see Consolidated Reports for Companies with Different Calendars.

Documents That Cannot Be Aged by Project

In MYOB Acumatica, some documents cannot be grouped under a specific project for reasons described in this section.

When creating a bill on the Bills and Adjustments (AP301000) form, a user can select the Pay by Line check box, which indicates that for the selected document, payments can be applied to individual document lines. If the check box is cleared, payments can be applied only to the outstanding balance of the entire document.

If the user clears the Pay by Line check box on the Bills and Adjustments form when entering the bill and all the lines of the document have a single project code, in report, the documents can be grouped under a particular project.

However, the documents will be displayed under the Project X in report, and a warning message indicating that the documents cannot be aged by project appears in the footer of the report if the Pay by Line check box is cleared for these documents and the documents meet either of the following criteria:

  • The documents are associated with multiple projects.
  • The documents have the Under Reclassification status.