In this article we will create a Journal Line Definition. You will basically apply the steps learnt thus far into practical implementation.
However to create a Journal Line Definition, we need to create the following
1. Journal Entry Description for journal line description
2. Journal Line Type to mainly define credit or debit
3. Account Derivation Rules for CCID used in journal line
Therefore typically, two set of JED,JLT and ADR’s are required, with one set each for Credit line, and the other set for the debit line.
In this article, we will create these three components.
Go to a subledger like Payables and within the SLA menu , you can open the Journal Enty Description screen. Click on New to create a new JED.
However to create a Journal Line Definition, we need to create the following
1. Journal Entry Description for journal line description
2. Journal Line Type to mainly define credit or debit
3. Account Derivation Rules for CCID used in journal line
Therefore typically, two set of JED,JLT and ADR’s are required, with one set each for Credit line, and the other set for the debit line.
In this article, we will create these three components.
Go to a subledger like Payables and within the SLA menu , you can open the Journal Enty Description screen. Click on New to create a new JED.
Create a new Journal Entry Description named ANIL_JED. We will use this for generating the Journal Line Description for both the credit and the debit lines.
The journal line description can be constructed by clicking on Details button. The description of the journal line can be a static text or dynamic text based on database sources within SLA or the combination of the two.
Here we are using the Supplier Name to construct the journal line description.
In addition to the dynamic journal line text, SLA allows you to put conditions.
For example
IF CONDITION1=TRUE, then Journal Line Description should be abcd
ELSE IF CONDITION2=TRUE, then Journal Line Description should be defg
Click on condition button to define the condition
After defining the Journal Entry description, now we can create Journal Line Type named ANIL_JLT_CREDIT for the credit line of the journal.
Specify the Transfer to GL in Summary or Detail mode. Also specify Merge, as explain in image below
Use the Payables setup option as source to build condition for JLT
In this example, we want to build a condition for “Journal Line Type” eligibility depending upon whether in the Payables Options Screen has Automatic Offset Method is set to None or Balancing or Account. In the above condition, we have placed an OR condition & then Save.
You can for example also build a condition based on Invoice Distribution type.
Next we need to define the Account Derivation Rule
Then we are creating an account derivation rule for the credit line.
An ADR can either return a full CCID or a specific segment. The values can be sourced either statically or from existing seeded dynamic sources in SLA. These seeded sources are mapped to database tables.
We are stating that this specific ADR named ANIL_LIABILITY_ADR will return a constant value in company segment
In the above image you will see that the value for Company segment can be derived from the corresponding value set.
It is also possible for the specific ADR to return a full segment combination. In fact you can specify conditions within an ADR. When CONDITION1=TRUE then segment combonation a.b.c.d is returned or when CONDITION2=TRUE then d.e.f.g combination is returned for your account
For the debit side, we are saying that the Account segment must always be 7450
The conditions can be defined. But conditions as evaluated as per the priority.
Finally we create a Journal Line Definition.
Here everything hangs together, JLTJLD,ADR=Journal Line Defnition
we are saying that the CCID for the Credit Line of the journal will be calculated from ANIL_LIABILITY_ADR
And the CCID for the debit line will be calculated by the CCID value in Invoice Distribution line, with the specific segment from Account segment being replaced as per ANIL_EXPENSE_ADR.
For example, if the CCID in AP_INVOICE_DISTRIBUTION equates A.B.C.D.E.F then your journal line debit entry will be A.B.7450.D.E.F
Comments
I would like to give you my special thanks for this post.
I have learned a lot about SLA.
May I have ask a question, for inventory where I can implement such SLA if it exists?
Rgds
N aoufel MAMI, STC Saudi Arabia
In that case you must customize the AAD for Inventory.
This article is an example to explain steps and concepts, because in real life, you will be modifying the standard SLA definition.
Th anks,
Anil Passi
Thanks for the article. I was able to able to generate custom SLA entries using custom SLAM. I have a small question though , in your previous reply , you have said "because in real life, you will be modifying the standard SLA definition" .
Does that mean we should directly update standard SLAM or should we create custom SLAM and then customize ?
Thanks
Joy
can i speak to u
sreenivas
80 88613338
Is there any possibility to custom Bank Account Transfer Created event when the bank account transfer reaches the Settled status? Also SLA customization if the bank account transfer is canceled? Since i tried so many times to custom it, but it will give no journal created while doing create accounting.
Thank,
Budiwi shnu
I was hoping you could help me out with one issue I am having. I successfully created a custom Journal Entry Description. When I am creating a custom Journal Lines Definition I want to attach the custom Journal Entry Description in the Line Description field (in the Line Assignments section ) but in the LOV my custom Journal Entry Description is not listed. Only seeded ones are listed. What am I doing wrong?
- Zakia
Thanks so much for information.
v ery nice explain the best.Congratula tions!!!!
Hugs
Joaquim Amado
RSS feed for comments to this post