SLA configuration for Journal Description Changes

Issue -When accounting details flow from sub ledger (Payroll) to General ledger and journal got created in GL, financial users are not able to identify the element name and accounting Date against which the entries flow from Payroll to GL, so Accountants are looking for some meaningful descriptions. By default lines getting created with description of “Journal Import Created”. As shown in below screenshot.

Requirement– Add the description on journal lines created for entry flown from Payroll to SLA and finally to GL.

By Default system have few oracle provided templates which is getting used in SLA (Sub Ledger Accounting) while sending data to Journal Ledger.
For any custom requirement, we can always make a copy of the existing seeded configuration and attached the custom object to fulfill the requirement.

Step1– First we have to check the Sub ledger Accounting Method set at the GL Primary Ledger. For that we can go to Setup and Maintenance > Financial > General Ledger > Specify Ledger Option.

Please make sure you select the scope by selecting the primary ledger.
Post clicking on highlighted task we can check the accounting method attached at the sub ledger section.

Step-2 – Now to customize the SLA configuration we have to copy the accounting method by copying the one we got from step1.

To copy that setup we have to go to Implementation Project > Workforce Deployment > Define Payroll > Define Payroll Costing > Define Subledger Accounting Rules > Define Subledger Accounting Methods > Manage Accounting Methods

Now choose the seeded one and click on copy and give custom name and go to the application for which we wanted to do the customization. In my case we are doing for Payroll.
Once we created the custom Accounting Method, go to the GL Ledger and change the accounting method by choosing the custom one from LOV.
From above screenshot we can check the event class and rule set attached to it. Copy the rule set where we wanted to use the custom rule set. In my case we wanted to do for all the journal getting created by Payroll Run.

Step-3 – To create custom rule set we have to go to to Implementation Project > Workforce Deployment > Define Payroll > Define Payroll Costing > Define Sub ledger Accounting Rules > Define Sub ledger Accounting Methods > Manage Sub ledger Journal Entry Rule Sets

We can select the seeded Rule Set and make a copy of it, double check the event class before you are copying the seeded rule set assigned to event class.
Once we have created the custom rule set, go to accounting method shown in screenshot2 and choose the custom rule set in place of seeded.
Copy the seeded line description rule which we have to customize to get the custom description we wanted to show in journal lines.

Step-4 – To create custom description we have to go to Implementation Project > Workforce Deployment > Define Payroll > Define Payroll Costing > Define Sub ledger Accounting Rules > Define Sub ledger Accounting Methods > Manage Description Rules

To do this we can copy the existing description rules and make a copy of it, and we can make a description using static and dynamic values by clicking on the source button. In this document we are using Payroll Element Name and Accounting Date to prepare the description.

Once we done with creation of custom description need to attach to the rule set by selecting the custom description from LOV.

Step-5 – As a final step we have to change the setting at SLA Accounting Option, to do that we can go to the Implementation Project > Workforce Deployment > Define Payroll > Define Payroll Costing > Define Sub ledger Accounting Rules > Define Sub ledger Accounting Methods > Manage Sub ledger Accounting Options

Step-5 – As a final step we have to change the setting at SLA Accounting Option, to do that we can go to the Implementation Project > Workforce Deployment > Define Payroll > Define Payroll Costing > Define Sub ledger Accounting Rules > Define Sub ledger Accounting Methods > Manage Sub ledger Accounting Options

  • 1. Group by General Ledge Dated
  • 2. Group by General Ledge Perio

Step6– Once done with all the steps we have to validate the configuration as while doing the changes the status of all the object become incomplete. To validate we can run the process from Implementation Project > Workforce Deployment > Define Payroll > Define Payroll Costing > Define Sub ledger Accounting Rules > Define Sub ledger Accounting Methods > Activate Sub ledger Journal Entry Rule Set Assignments

Once process completed normal we are done with the configuration, now do the transaction and transfer the entries from Payroll to GL, description will populate in journal lines.

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.
You need to agree with the terms to proceed

Menu