Miscellaneous Adjustments to Journals Integration

Using SRP, you can seamlessly create Accounting journals for the miscellaneous adjustments that you record in PSA. This allows you to keep journals up to date, without needing to enter the same data twice.

For more information about each of these objects, see the following:

Which Miscellaneous Adjustments Are Eligible for Creating Journals?

For a miscellaneous adjustment to be passed to Accounting, all of the following must be true:

  • The Approved field must be selected.
  • The Balancing GLA Code field must be populated.
  • The Company field must be populated.
  • The Include in Financials field must be selected.
  • The Miscellaneous Adjustment Currency field must be populated.
  • The Miscellaneous Adjustment GLA Code field must be populated.
  • The Passed to Accounting field must not be selected.
Note:

Your administrator might have configured additional requirements.

Which Fields Are Automatically Populated for a Miscellaneous Adjustment?

When you create a miscellaneous adjustment, SRP automatically populates the following fields:

  • Company: set from the related project. Depending on your configuration, the company is populated from the region, practice, or group related to the project.
  • Miscellaneous Adjustment Currency: set to the Accounting currency linked to the company that has the same ISO code as the Currency field on the miscellaneous adjustment.
  • Balancing GLA Code: set to a value defined by your administrator. For more information, see MA Default Balancing GLA.

How Can I Create a Journal from a Miscellaneous Adjustment?

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

How Does the Automatically Pass to Accounting Functionality Work?

When the Automatically Pass to Accounting field is selected for a miscellaneous adjustment, the record is passed to Accounting as soon as it becomes eligible. This means that you don't need to manually click Create Journal from the record's detail page or the list view, nor wait for the next execution of the scheduled job.

For example, a miscellaneous adjustment has an amount of $100 and has the Include in Financials field selected. With Automatically Pass to Accounting selected, as soon as the miscellaneous adjustment is approved, SRP creates a matching journal.

If multiple miscellaneous adjustments with the Automatically Pass to Accounting 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 miscellaneous adjustments that could not be passed to Accounting (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 Accounting 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 Accounting to control this behavior. For more information, see MA Auto Pass to Accounting Field and contact your administrator.

What Information is Passed from a Miscellaneous Adjustment to Accounting?

The following table lists how fields on the Miscellaneous Adjustment object map to the relevant fields on the Journal object. In some cases, SRP provides a static value for fields that are not present on the Miscellaneous Adjustment object.

Note:

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

Default Mappings between Miscellaneous Adjustment Fields and Journal Fields

Miscellaneous Adjustment Field

Static Value

Journal Field

Company   Company
Description   Journal Description
Effective Date   Journal Date
Miscellaneous Adjustment Currency   Journal Currency
Record ID   Miscellaneous Adjustment
  Deselected (false) Derive Currency
  Selected (true) Derive Period

When you pass a miscellaneous adjustment to Accounting, SRP creates a journal record with the type of "PSA Miscellaneous Adjustments Journal" and the status of "In Progress". The journal always contains two journal line items: a default line item and a balancing line item.

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

The following table lists how fields on the Miscellaneous Adjustment object map to the relevant fields on the Journal Line Item object. The target field on the Journal Line Item object is the same for the two line items. The source field on the Miscellaneous Adjustment object varies depending on the journal line item.

Default Mappings between Miscellaneous Adjustment Fields and Journal Line Item Fields

Miscellaneous Adjustment Field

Static Value

Journal Line Item Field

Default Journal Line Item

Balancing Journal Line Item

Miscellaneous Adjustment GLA Code Balancing GLA Code   General Ledger Account
Amount Balancing Amount   Value
    Selected (true) Derive Line Number
    "General Ledger Account" Line Type
    Selected (true) Passed to PSA