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.
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:
- Manually, by clicking Create Journal on the miscellaneous adjustments record page. For more information, see Creating a Journal from a Single Miscellaneous Adjustment.
- Manually, by selecting multiple records on the miscellaneous adjustments list view and clicking Create Journals. For more information, see Creating Journals from Multiple Miscellaneous Adjustments.
- Automatically, by scheduling a background process. For more information, see Managing Scheduled Jobs.
- Automatically, by selecting Automatically Pass to Accounting on a miscellaneous adjustment record. More information is provided below.
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.
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.
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.
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 |