Payable Invoice Expense Line Items to Miscellaneous Adjustments (Legacy Mode)

Professional Services CloudERP Cloud
Note:

This page only applies if you are using PSA – Accounting Connector in legacyClosed mode. If you are using enhancedClosed mode, see Payable Invoice Expense Line Items to Miscellaneous Adjustments.

You can seamlessly create PSA miscellaneous adjustments from Accounting payable invoice expense line items. For example, if a payable invoice contains a line item related to a specific project, you can link the line item to the project. After selecting a transaction category, you can create a miscellaneous adjustment from the payable invoice expense line item. The Amount field on the miscellaneous adjustment is set to the total value of the line item, including tax.

For more information about these objects, see the following:

Which Payable Invoice Expense Line Items Are Eligible for Creating Miscellaneous Adjustments?

For a payable invoice expense line item to be passed to PSA, all of the following must be true:

  • It must be linked to a project. Depending on how your org is configured, this might be done using the Project lookup field or a text field, such as Analysis 1. For more information, see Project Source for Line Items (Legacy) and contact your administrator.
  • The Transaction Category field must be populated.
  • The Passed to PSA field must not be selected.
Note:

Your administrator might have configured additional requirements.

How Can I Create a Miscellaneous Adjustment from a Payable Invoice Expense Line Item?

You can create a miscellaneous adjustment from a payable invoice expense line item in several ways:

  • Manually, by selecting multiple records on the payable invoice expense line items list view and clicking Create Miscellaneous Adjustments. For more information, see Creating Miscellaneous Adjustments from Multiple Payable Invoice Expense Line Items.
  • Automatically, by scheduling a ClickLink job for the Payable Invoice Expense Line Item to PSA Miscellaneous Adjustment ClickLink rule. For more information, contact your administrator.

What Information is Passed from a Payable Invoice Expense Line Item to PSA?

The following table lists how fields on the Payable Invoice Expense Line Item object map to the relevant fields on the Miscellaneous Adjustment object. In some cases, PSA – Accounting Connector provides a static value.

Note:

Your administrator might have changed the default mappings or added custom mappings.

Default Mappings between Payable Invoice Expense Line Item Fields and Miscellaneous Adjustment Fields

Payable Invoice Expense Line Item Field

Static Value

Miscellaneous Adjustment Field

Company   Company
General Ledger Account   Miscellaneous Adjustment GLA Code
Gross Value   Amount
Invoice Currency   Currency
Invoice Date   Effective Date
Line Description   Description
Miscellaneous Adjustment Name   Miscellaneous Adjustment Name
Project   Project
Record ID   Payable Invoice Expense Line Item
Transaction Category   Transaction Category
  Selected (true) Passed to Accounting