references they would like to use for a journal line type.
Users use sources to set up supporting references. By providing additional business information about the subledger journal entry and balances of an account, supporting references are useful for accounting reconciliation and analysis.
Creating a Supporting Reference
The screenshots in the document attached display the Seeded journal line definitions (JLD). By default, users cannot edit seeded JLDs. This can only be done if profile option "SLA: Setup User Mode" is set to "Internal", and all such modifications will be overriden the next time the patch is taken.Instead of altering seeded JLD as shown in the screenshots, it is advised that you create a copy of the seeded Subledger Accounting Method (SLAM) to modify the JLD.
See attached document for an example.
3. Why are the supporting references not available in the LOV for the definition or journal lines?
Does this have anything to do with Chart of Accounts (COA) assignments?
Supporting references are not COA specific. Ensure that the supporting references detail have source assignments and the event class of the assigned source is the same as the event class in the Application Accounting Definition (AAD)
4. Can I make use of supporting references to reconcile late GL journals?
I would like to make use of the supporting reference information created by posting the journal on the GL reconcilation form.
Supporting references are stored in SLA accounting entries and are not transferred to GL. However, you can assign a source to the reconciliation reference accounting attributes for your journal line type. The value on the reconciliation reference will be transferred to GL.
5. Why does the Supporting Reference Balance show a value with the sign reversed?
For Example: For a specific journal entry like
GL Period: MAR-07
CCID: 1001.11210.3310100000.20020.15346.3111009.15.00000.00000
Accounted CR: 142308.00
Accounted DR: NULL
The Supporting Reference Period Activity shows the value as -142308.00
GL Period: Mar-07
1001.11210.3310100000.20020.15346.3111009.15.00000.00000
Accounted CR: NULL
Accounted DR: 43361.97
In this case, the Supporing Reference Period Activity shows the value as 43361.97
We are expecting to see the values as 142308.00 (for credit) and -43361.97 (for debit).
Supporting reference balances are displayed based on the side and not the account type. That means DR is always displayed as a positive number and CR is always displayed as a negative number. However, you can use a custom report to display the balance with proper signs based on the account type.
6. How do we add an Invoice distribution Flexfield to the Supporting References for a Journal Line Definition?
We are trying to include the supporting reference in the Journal Line Definition (JLD) for the Invoices. We are using the seeded subledger accounting method of Standard Accrual. This Subledger accounting method is using Accrual Application Accounting Definition (AAD), which uses Accrual JLDs..
Should we add one supporting reference to each of the following JLDs:
Accrual, Invoices All
Accrual, Debit Memos All
Accrual, Credit Memos All
Accrual, Prepayment Applications All
Accrual, Prepayments All
You will need to create new AMB components.. However, you can use the copy feature to copy from the seeded components--this will speed up the setup process. If your Supporting Reference does not maintain balances, then you can make the change in the middle of a month / GL period. If it maintains balances, then you may want to make the changes at the beginning of a GL period.
7. Where can I find the Supporting Reference that I created?
You should be able to view the supporting reference by querying the subledger journal in the UI.
If the supporting reference is assigned to the AAD, then it is at the journal header level.
If it is assigned in the JLD form, then the supporting reference is at the journal line level.
8. How do I view the Supporting Reference assigned to a Journal Line Type within AP?
Navigation: Created and assigned a supporting reference to a journal line type.
JLT : Liability, Basic
Supporting reference name : T_1000
Entered an Invoice and completed the create accounting
The supporting reference assigned does not appear at the line level.
Response:
1. Query the invoice in AP
2. Select view accounting events from the Tools menu
3. Select view journal entries
4. Go to the liability line. When you select the view icon in the supporting reference column, you will see the Supporting Reference.
9. What is the MAX limit on Supporting Reference Details?
The MAX Limit on Supporting Reference Details are as follows:
a) 50 Varchar2 Type Supporting Reference Details
b) 40 Number Type Supporting References Details
c) 10 Date Type Supporting References Details
9. What drives the MAX Limit for Supporting References?
In the data model, the xla_ae_lines_gt table used for Accounting only has ANC_ID_1 to ANC_ID_100. While on the Journal Entry Lines Search page, the search has been confined to 100 Supporting Reference Details only. So these are the restrictions that drive the MAX LIMIT that is supported.
No comments:
Post a Comment