Navigating the Project A/P – A/R Details Page

You can view more details about the payable and receivable transactions for each project from the Project A/P – A/R Details page. From this page, you can also navigate to the Bill Payment page where you can pay all bills associated with a vendor or pay each vendor bill.

Refer to the following image and table to know more about the Project A/P – A/R Details page.

Project A/P – A/R Details page.

 

Field/Section/Tab

Description

1

Subsidiary

This field lets you select a subsidiary.

If you arrived at this page from the Project A/P – A/R Summary page, this field is populated with the subsidiary of the project from the Project A/P – A/R Summary page.

2

Project

This field lets you select a project in the subsidiary.

If you arrived at this page from the Project A/P – A/R Summary page, this field is populated with the project from the Project A/P – A/R Summary page.

3

Customer

This field displays the customer associated with the project.

4

Currency

This field displays the currency of the subsidiary.

This field is only available if the Multiple Currencies feature is enabled. For more information on the Multiple Currencies feature, see Multiple Currencies.

5

Department

This field lets you select a department associated with the chosen subsidiary. The default selection is all departments.

Note:

This search criteria is only applicable for A/R transactions.

6

Location

This field lets you select a location associated with the chosen subsidiary. The default selection is all locations.

Note:

This search criteria is only applicable for A/R transactions.

7

Class

This field lets you select a class associated with the chosen subsidiary. The default selection is all classes.

Note:

This search criteria is only applicable for A/R transactions.

8

Summary

This section summarizes the total A/P balance, A/R balance, total received amounts, and total payments for the project. All transaction for the project are included in the calculation, including closed transactions. All amounts are in the currency of the subsidiary.

This section has the following fields:

  • A/P Balance – This field displays the total payable balance for the project.

  • A/R Balance – This field displays the total receivable balance for the project.

  • Receipts – This field displays the total amount received for the project to date. The amount is not tied to any fiscal year and is computed at the start of the project until the present. All received amounts are included in the calculation, including those from closed transactions.

  • Payments – This field displays the total amount paid for the project to date. The amount is not tied to any fiscal year and is computed at the start of the project until the present. All paid amounts are included in the calculation, including those from closed transactions.

9

Bank Information

This section lets you display the available balance in the selected bank account.

You can only select from bank accounts available in the selected subsidiary.

Note:

The available balance in the bank account is always displayed in the currency of the subsidiary, regardless of the bank account currency.

10

A/P Transactions

This subtab shows all open A/P transactions for the project and displays the total amount on the subtab.

You can select a vendor from the Vendor list to filter the search results by vendor. Filtering the results by vendor optimizes the results table display.

Note:

The results include only vendor bills that have a status of Open as well as unapplied vendor credits.

This subtab contains a results table that has the following columns:

  • Vendor & Bill – This column shows all the vendors associated with the project that have payable balances. You can do the following from this column:

    • Click the expand icon beside the vendor name to show vendor bills and bill credits created for the project.

    • Click the vendor name to open the vendor record in a new tab.

    • Click the vendor bill to open the vendor bill record in a new tab.

    • Click the bill credit to open the bill credit record in a new tab.

  • Cur. – This column shows the currency of the subsidiary.

    Note:

    Transaction amounts in other currencies are automatically converted and are shown in the currency of the subsidiary.

    This column is only available if the Multiple Currencies feature is enabled. For more information on the Multiple Currencies feature, see Multiple Currencies.

  • A/P Balance – This column shows the A/P balance per vendor. The A/P balance can be narrowed down per vendor bill or bill credit. You can do the following from this column:

    • Click the expand icon beside the vendor name to show the vendor bills and bill credits under it. This also shows the A/P balances for each vendor bill or bill credit in the A/P Balance column. The amount shown in bold font at the vendor level in the A/P Balance column is the total A/P balance of all vendor bills and bill credits for that vendor.

    • Click the A/P balance amount next to the vendor name to open the Bill Payment page in a new tab. You can pay all bills associated with the vendor from the Bill Payment page.

    • Click the A/P balance amount next to the vendor bill or bill credit record to open the Bill Payment page in a new tab. You can pay that particular vendor bill or bill credit from the Bill Payment page.

  • Trans. Amount – This column shows the transaction amount of each vendor bill or bill credit. You must click the expand icon beside the vendor name to view the transaction amount of each vendor bill or bill credit.

    Bill credits are always shown as negative amounts in this column and are deducted from the total payable balance.

  • Type – This column shows the A/P transaction type. Supported transaction types are vendor bill and bill credit.

  • Trans. Date – This column shows the transaction date.

Note:

The number of collapsed rows shown on the search results table is dependent on the Number Of Rows In List Segments user preference. For more information on setting the preference, see General Personal Preferences. You can display a maximum of 25 collapsed rows per page.

11

A/R Transactions

This subtab shows all open A/R transactions for the project and displays the total amount on the subtab. A/R transactions for the project include customer invoices and credit memos.

Note:

The results include only customer invoices that have a status of Open as well as applied, partially applied, and partially refunded credit memos.

This subtab contains a results table that has the following columns:

  • Trans. ID – This column shows the ID of the transaction. Click the transaction ID to open the customer invoice or credit memo in a new tab.

  • Cur. – This column shows the currency of the subsidiary.

    Note:

    Transaction amounts in other currencies are automatically converted and are shown in the currency of the subsidiary.

    This column is only available if the Multiple Currencies feature is enabled. For more information on the Multiple Currencies feature, see Multiple Currencies.

  • A/R Balance – This column shows the receivable balance for each customer invoice or credit memo.

  • Trans. Amount – This column shows the transaction amount of each customer invoice or credit memo.

    Credit memos are always shown as negative amounts in this column and are deducted from the total receivable balance.

  • Type – This column shows the transaction type. Supported transaction types are invoice and credit memo.

  • Trans. Date – This column shows the transaction date.

Note:

The number of collapsed rows shown on the search results table is dependent on the Number Of Rows In List Segments user preference. For more information on setting the preference, see General Personal Preferences. You can display a maximum of 25 collapsed rows per page.

Related Topics

Using Sequential Liability
Viewing the Project A/P – A/R Summary
Navigating the Project A/P – A/R Summary Page
Viewing the Project A/P – A/R Details
Viewing A/P – A/R Details from the Project Record
Setting Up the Sequential Liability Custom Portlet

General Notices