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.
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:
- Manually, by clicking Create Miscellaneous Adjustment on the journal line item record page. For more information, see Creating a Miscellaneous Adjustment from a Single Journal Line Item.
- Manually, by selecting multiple records on the journal line items list view and clicking Create Miscellaneous Adjustments. For more information, see Creating Miscellaneous Adjustments from Multiple Journal Line Items.
- Automatically, by scheduling a background process. For more information, see Managing Scheduled Jobs.
- Automatically, by selecting Automatically Pass to PSA on a journal line item record. More information is provided below.
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.
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.
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.