Journal Line Items to Miscellaneous Adjustments

You can seamlessly create PSA miscellaneous adjustments from Accounting journal line items. For example, if a journal 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 journal line item.

For more information about these objects, see the following:

Which Journal Line Items Are Eligible for Creating Miscellaneous Adjustments?

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

  • The Project field must be populated.
  • The Transaction Category field must be populated.
  • The Send to PSA field must be selected.
  • 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 Journal Line Item?

You can create a miscellaneous adjustment from a journal line item in several ways:

How Does the Automatically Pass to PSA Functionality Work?

When the Automatically Pass to PSA field is selected for a journal line item, the record is passed to PSA as soon as it becomes eligible. This means that you don't need to manually click Create Miscellaneous Adjustments from the list view, nor wait for the next execution of the scheduled job.

For example, you might create a journal with three line items. You want to record one of the line items as a miscellaneous adjustment in PSA. While creating the journal, you specify the project and transaction category for the line item and select Automatically Pass to PSA. After posting the journal, you can amend it and select Send to PSA for the journal line item. As soon as you save the changes, PSA – Accounting Connector creates a miscellaneous adjustment that matches the journal line item.

If multiple journal line items with the Automatically Pass to PSA field selected become eligible at the same time, they are processed in a background job. Once the process finishes, an email notification is sent to the user who triggered the changes that made the records eligible. The email is also sent to any additional email addresses defined by your administrator (see Additional Notification Recipients). The email contains the number of successfully processed records and the number of journal line items that could not be passed to PSA (if any). The email also has a link to the relevant process run record. The process run contains log entries for each record that was processed.

Notes:

Depending on how your org is set up, the following might apply:

  • The Automatically Pass to PSA field might be selected automatically, by a background process.
  • A different field, such as a custom field, might be used instead of Automatically Pass to PSA to control this behavior. For more information, see JLI Auto Pass to PSA Field and contact your administrator.

What Information is Passed from a Journal Line Item to PSA?

The following table lists how fields on the Journal 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 Journal Line Item Fields and Miscellaneous Adjustment Fields

Journal Line Item Field

Static Value

Miscellaneous Adjustment Field

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

Once a miscellaneous adjustment is created from a journal line item, the Passed to PSA field is automatically selected on the journal line item.