Integrating with Receivables

This chapter provides an overview of the integration process with Receivables and discusses how to integrate receivables adjustments.

Understanding Integration with Receivables

Integration with Receivables provides you with accounts receivable items and revenue-related adjustments. By gaining access to information on the progress of a project, such as outstanding revenue, project managers have financial control of the project.

Rows are eligible to distribute from Receivables to Project Costing if they have:

A Project Costing Distribution Status flag (PC_DISTRIB_STATUS) value of N (not distributed) in the Item Activity table (ITEM_ACTIVITY).
Values for project business unit, project, activity, and any other required project-related ChartField.

A Receivables entry type that relates to revenue adjustments.

This table lists the types of adjustments that Project Costing captures:

Receivables Entry Type	Description
FC-01	Create an overdue charge.
IT-01	Create an invoice/debit memo.
IT-02	Create a credit memo.
MT-03	Write off a debit.
MT-04	Create a new debit.
MT-07	Write off a remaining debit.
WS-02	Take earned discount.
WS-03	Take unearned discount.
WS-08	Create a deduction.
WS-09	Write off an item.
WS-11	Write off an underpayment.

Use the Receivables Adjustments Application Engine process (PC_AR_TO_PC) to move data from Receivables to Project Costing. This process copies the information into the Project Transaction table (PROJ_RESOURCE) in Project Costing, and updates the Project Costing Distribution Status flag to D (distributed) in the Item Activity table in Receivables.

Integrating Receivables Adjustments into Project Costing

This section discusses how to import receivables adjustment data into Project Costing.

Page Used to Integrate Receivables Adjustments into Project Costing

Page Name	Object Name	Navigation	Usage
Adjustments from Receivables	PC_AR_TO_PC	Project Costing, Revenue Collection, Adjustments from Receivables, Adjustments from Receivables	Run the Receivables to Project Costing process to import receivables adjustment data into Project Costing.

Adjusting Receivables

Access the Adjustments from Receivables page.

Option

Select to import transactions for all projects and activities, or for specific ones. Options are:

All: Processes all transactions that are associated with all activities.

Business Unit: Processes transactions for the selected business unit.

Business Unit/Project: Processes transactions for the selected business unit and project.

Business Unit/Project/Activity: Processes transactions for the selected business unit, project, and activity.

Transaction Detail

After the system successfully completes the Receivables to Project Costing process, click Transaction Detail to access the Transaction List page and view the latest receivables adjustments in the Project Transaction table.

Run

Click to initiate the request to move receivables data to the Project Transaction table. Receivables adjustments appear as transactions with the analysis type that is specified in the Installation Options - Project Costing Integration page for Receivables Adjustment.