Journals
Discussion List
-
SQL Query to extract Journals in particular date rangeSummary: SQL Query to extract Journals in particular date range Content (required): Business wants to migrate Journals (Transactional data of all categories) from EBS to… -
GL Report with Beginning balance, Period Activity (all transaction in selection duration), End BalanSummary: GL Report with Beginning balance, Period Activity (all transaction in selection duration), End Balance Content (required): Business wants simple GL Report with …
-
GL Future Enterable Period set to 1Summary: GL Future Enterable Period set to 1 Content (required): Business set GL Future Enterable Period set to 1 in "Specify ledger option" and system is allowing to se…Kumar 57 381 views 6 comments 0 points Most recent by Venkata Kompella General Ledger & Intercompany
-
Loading Accruals at Month EndSummary: We have an issue at month end where we need to create receivables accruals for invoices that we will not load into Oracle until after month end, the invoices (b…Robert G Wilkinson 43 views 1 comment 0 points Most recent by Harry Zhu General Ledger & Intercompany -
Journal Upload template : ADFDI: Hide 'Reversal Date' fieldSummary: Journal Upload template : ADFDI: Hide 'Reversal Date' field Content (required): We would like to hide some of the fields like 'Reversal Date' in Journal Upload …Swaroop Mitta 32 views 1 comment 0 points Most recent by Haripriya-Oracle General Ledger & Intercompany
-
Import Journals fails for adjusting periodSummary: We want to load data into GL adjusting periods and I have found this excel: When running the Load Interface File I'm stuck with this error: What is causing the …Bo Tøpgaard 63 views 4 comments 0 points Most recent by Madalina R-Oracle General Ledger & Intercompany
-
How can i add new legal entity as Intercompany key flexfield?Summary: Newly created legal entity is not in the drop down list (key flexfield) in journal. Content (required): I am creating a legal entity with new ledger as well. Wh…Teodora Bulancea 41 views 2 comments 0 points Most recent by Madalina R-Oracle General Ledger & Intercompany
-
Restrict Natural Account value by Journal Category when entering manual journalsSummary: How can we restrict Natural Account segment values by Journal Category when entering manual journals? Content (required): Our client needs to restrict natural a… -
Transactions in draft mode in Accounting hubSummary: Content (required): Hi, How do we import transactions which is in draft mode from Accounting Hub to General ledger as journals ? Version (include the version yo…
-
Appovers Approving their own journalSummary Appovers Approving their own journalContent Does the upgrade for 20A, resolve the issue of preventing an approver from approving a journal that was created by hi…CraigX 83 views 15 comments 2 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Primary Ledger "Sequencing by Legal Entity" Enabled but field not available in ADFDI?Summary: We are currently looking to create LE specific sequencing for a single primary GL ledger. Via the UI, there is a field for "Legal Entity" that is available to b…David_Zachar 36 views 2 comments 0 points Most recent by Alex D-Oracle General Ledger & Intercompany
-
Requirement to freeze the corporate conversion rate type for foreign currency journalsSummary: Requirement to freeze the corporate conversion rate type for foreign currency journals Content (required): We have a requirement to freeze the corporate convers…Suresh Kumarasamy-Oracle 42 views 4 comments 0 points Most recent by Suresh Kumarasamy-Oracle General Ledger & Intercompany -
Some of dedicated Natural accounts should be accessible only secondary ledger.Summary: Some of dedicated Natural accounts should be accessible only secondary ledger. Content (required): Customer using secondary ledger for statutory reporting purpo…Suresh Kumarasamy-Oracle 32 views 2 comments 0 points Most recent by Suresh Kumarasamy-Oracle General Ledger & Intercompany
-
Revaluation Process QuerySummary: Revaluation Process Query Content (required): User submitted Revaluation process and system created Revaluation Journal based on AR/AP open Foreign Transactions…Kumar 57 84 views 1 comment 2 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Revaluation reportSummary: Revaluation report Content (required): User submits Revaluation process and its creates Revaluation journal based on AP/AR open transaction in GL module. Busine…Kumar 57 72 views 1 comment 1 point Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Where can I setup the first line number as 1 of Journal Ledger Report?Summary: I would like to set the first line of Journal Ledger Report as 1 instead of 10275 (see screenshot) Content (required): I would like to set the first line of Jou… -
Ledger > Legal Entity > Two entities assigned to LESummary: Ledger > Legal Entity > Two entities assigned to LE Content (required): Ledger > Legal Entity > Two entities assigned to LE. While creating journal system is al…Kumar 57 61 views 4 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Imbalance journals are submitting for approvalSummary: Imbalance journals are submitting for approval Content (required): Users are created imbalance journals and submitted for posting. Journal are triggered approva…Kumar 57 82 views 3 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Ledger SetSummary: Ledger Set Content (required): Created Ledger Set and assigned 5 Ledgers to Led Set. System automatically created Data Access set for the Led Set. I have assign…
-
User of Reference, Ref Date, Company Fields in Journal Entry PageSummary: User of Reference, Ref Date, Company Fields in Journal Entry Page Content (required): I just want know the significance of Reference, Ref Date, Company Fields i…Kumar 57 82 views 4 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Journal > MY Approval PageSummary: Journal > MY Approval Page Content (required): Business wants to add additional fields Journal > MY Approval Page . Do we have any feasibility to add additional…Kumar 57 42 views 1 comment 1 point Most recent by Vivek Mandowara-Oracle General Ledger & Intercompany
-
Intercompany entry with 2 BSV and 2 ledger with trial BalanceSummary: 10- Company 1 - Ledger 1 20- Company 2 - Ledger 2 when passing Journal entry of amount 1000 in Ledger 1 we take entries Dr - 10-xx-xx-xx-xx Cr - 20-xx-xx-xx-xx …Umer272 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Journal entry reportSummary: Journal entry report Content (required): Account analysis gives one leg of the entry and don't give another leg of the entry. Business wants to see both lines i…
-
How to default Ledger Name to Context Sensitive DFFsSummary: Defined Journal Line DFF with context as Ledger Name. Require the journal name to automatically be derived based on the journal header ledger name in Manual Jou…Venkata Kompella 93 views 1 comment 1 point Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Currency details not appearing in the Journal levelSummary: Hi Experts, We have created a journal and its in a complete and unposted state. The currency details are not visible in the journal level like other journals. H…Vipusha Chandrakumaran 42 views 2 comments 0 points Most recent by Vipusha Chandrakumaran General Ledger & Intercompany
-
I have some accounts that are not included in the Income Statement in year end closingSummary: I have some accounts that are not included in the Income Statement in year end closing when I run Create Income Statement Closing Journals Content (required): I…
-
Reversal of Accrual in Receipt AccountingActual we are proceeding with the accrual process in the receipt accounting module and at the beginning of the next month same is being reversed through the auto reverse… -
GL detail report with breakdown of consolidated linesHi All In GL various source lines are consolidated for a given code combination and date and other criteria. The users will need to drill down to see the individual line…Murthy Kodavati 22 views 1 comment 0 points Most recent by Murthy Kodavati General Ledger & Intercompany -
Tax Entry Repository Data Upload Interface - Account columnsHi All We are trying to Tax Entry Repository Data Upload Interface to import GL data as taxable journals. I see from the ZX_TER_IMPORT.xlsm that both Debit Account and C…
-
How to link a reclassification journal back to originating projectSummary: Query to link a reclassification journal with the original projects transaction. Content (required): I am trying to write a query to find the project number tha…