sla part 7 - creating journal line definition.pdf

Wednesday, 08 December 2010 00:00 Anil Passi

SLA Part 7 - Creating Journal Line Definition

User Rating: / 4

Poor Best RATE

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 following1. Journal Entry Description for journal line description2. Journal Line Type to mainly define credit or debit3. 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.

RELATED ITEMS

Forms Customization

Steps in Oracle

Applications

OA Framework R12

Extension Example

Oracle General Ledger

Overview

Oracle Payables

Overview - Functional

Document

Oracle Fixed Assets

Implementation Document

R12 New Functionality -

Differences with 11i

R12 SLA - Subledger

Accounting Explained

Part 1

R12 Cash Forecasting

Reconcile Bank

Statements in R12

R12 - Cash Pool In Cash

Management

R12 - Accounting Setup

Manager in Oracle

General Ledger

R12 Procurement

Features

R12 Inventory Features

R12 - Fixed Assets

Presentation

Oracle iProcurement in

R12

R12 New Features in

Oracle Payables

R12 - Oracle General

Ledger Features

R12 Oracle Receivables

Features

R12 Cash Management

APPS TO FUSION.......Our Journey from Apps To Fusion

Home Technical Articles Training Articles Receive Email for New Articles Contributors

Forum My Book Solutions

SLA Part 7 - Creating Journal Line Definition http://apps2fusion.com/apps-training/r12-functional-docu...

第1页共15页 2013/4/9 21:01

Go to a subledger like Payables and within the SLA menu as shown below, 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.

Features

R12 - Netting

Functionality Step By

Step

Oracle Apps Functional

Overview

Oracle Payables - Step

by Step functional in 11i -

PART 1


by Step functional in 11i

PART 2



PART 3

SLA Part 11 - Steps to

Customize of SLA -

Subledger Accounting

Control or Third Party

Accounts in R12 General

Ledger

E Business Tax R12 -

EBiz Tax Implementation

Steps

EBiz Tax - Part 1

SLA Part 1 - Why SLA

SLA Part 3 - Journal Line

Definition

SLA Part 2 Entities -

Event Class - Event

Types



PART 4

SLA - Account Analysis

Report - Out of memory

error

Generate BACS File in

R12 Payables for

Payment run

PO to AP to Fixed Assets

Order to Cash - Technical

Flow in R12

Steps for Closing Period

in R12 Financials - Part 1

- USE FIREFOX

Steps for Closing Period

in R12 Financials - Part 2

Global Consolidation R12

SLA Part 4 - Application

Accounting Definitions

SLA Part 5 - Subledger

Accounting Methods


第2页共15页 2013/4/9 21:01

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.

SLA Part 6 - Overall SLA

Diagram

Financials Notes

R12 - Create Banks and

Bank Accounts in Oracle

Apps R12

SLA Part 8 - Creating

Application Accounting

Definition - AAD

SLA Part 9 - Create

Subledger Accounting

Method

SLA Part 10 - Testing and

explaination of SLA

Config

SEARCHAPPS2FUSION


第3页共15页 2013/4/9 21:01

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 abcdELSE 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.


第4页共15页 2013/4/9 21:01

Specify the Transfer to GL in Summary or Detail mode. Also specify Merge, as explain in image below


第5页共15页 2013/4/9 21:01

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.


第6页共15页 2013/4/9 21:01

You can for example also build a condition based on Invoice Distribution type as shown below.

Next we need to define the Account Derivation Rule


第7页共15页 2013/4/9 21:01

Here 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.


第8页共15页 2013/4/9 21:01

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.

As below, 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.


第9页共15页 2013/4/9 21:01

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.


第10页共15页 2013/4/9 21:01

Finally we create a Journal Line Definition.

Here everything hangs together, JLTJLD,ADR=Journal Line Defnition

As shown below, we are saying that the CCID for the Credit Line of the journal will be calculated from ANIL_LIABILITY_ADR


第11页共15页 2013/4/9 21:01

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


第12页共15页 2013/4/9 21:01

Comments (8)Subscribe to this comment's feed

Set as favoriteBookmarkEmail ThisHits: 25653

report abusevote downvote up

Thanks a lot

written by Nawfal , December 08, 2010

Dear Anil,

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

Naoufel MAMI, STC Saudi Arabia

Votes: -1


...

written by Anil Passi- , December 08, 2010

Hi Naofel

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.

Thanks,

Anil Passi

Votes: +0


Keep it up

written by Joy , December 08, 2010

Hi Anil

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

Votes: +0


...

written by Anil Passi- , December 08, 2010

Please wait for the next few articles in the sequence, this will be explained in details to you.

Votes: +1

very nice explain

written by sreevasu , March 12, 2011

hi,it is very nice explain ,

can i speak to u

sreenivas


第13页共15页 2013/4/9 21:01

Write comment


8088613338

Votes: +0


Custom SLA for Bank Account Created and Bank Account Cancelled

written by Budiwishnu , July 28, 2011

Hi Anil,

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,

Budiwishnu

Votes: +0


Question regarding assigning custom Journal Entry Description to custom Journal Line

Defintions

written by Zakia Khan , November 04, 2011

Hi Anil,

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

Votes: +0


ORACLE ERP

written by Joaquim Amado , January 03, 2012

Hello,

Thanks so much for information.

very nice explain the best.Congratulations!!!!

Hugs

Joaquim Amado

Votes: +0

Name

Email

Title

Comment


第14页共15页 2013/4/9 21:01

Last Updated ( Sunday, 28 November 2010 08:44 )

smaller | bigger

Subscribe via email (Registered users only)

Write the displayed characters


第15页共15页 2013/4/9 21:01

sla part 7 - creating journal line definition.pdf

Documents

journal line description2

journal line type

journal line definition

journal linedefinitionsla

journal linetherefore

credit line

new journal entry description

new jed