Sunday, November 29, 2020
Setting up Control Accounts and Restricting GL Manual Journal Posting
One of the options to consider when setting up the nominal segment within your Chart of Accounts is what your Third Party Control Account values should be. Before doing this its critical to understand what options are available and the impact of selecting these. Hence, I thought I’d put together a brief post explaining these.
The image below depicts where within the value set you would select the appropriate option and is followed by an explanation of the resultant impact.
Third Party Control Account Options
General Ledger journals can be entered directly in that module or be received from a Subledger. Since control accounts should accurately reflect the movements in a related Subledger its ideal that we only allow postings to these that are sourced from the Subledger. Hence, minimising the number of manual postings to a control account is recommended and makes Subledger to General Ledger Control Account reconciliation a lot simpler.
Whichever option is chosen below will determine the allowed journal source for a GL nominal account and the level of restriction to be applied:
- Customer Control Account - only journal postings sourced from Accounts Receivable can be posted to this nominal.
- No - either this is not a control account or you want to allow any type of journal to be posted to this account.
- Restrict GL Manual Journals - journals with a source of Manual which are those entered directly into General Ledger will not be allowed. This provides more flexibility in that any Subledger can post to this account.
- Supplier Control Account - only allow journal postings sourced from Accounts Payable can be posted to this nominal.
- Third Party Control Account - only allow journal postings sourced from Accounts Receivable or Payables can be posted to this nominal.
Inherit Segment Values
Following any updates to a value set its important to point out that you should run the Inherit Segment Value Attributes program. This will propagate the attributes of a segment value to all account combinations that contain that segment value. Note that selecting the Create Execution Report option when running this program produces a report which lists each updated account for comparison including original and current attributes. Download an example of the Segment Value Inheritance Execution Report
e-mail this article • Modules • Finance • General Ledger • () Comments • Bookmark this to del.icio.us • Permalink
Saturday, November 28, 2020
Oracle Fusion Financials R13 - Reports and Analyses
Perhaps the most useful report listing I always have at my disposals is the one Oracle delivers for Financials. It lists all the reports currently available for the following modules: -
- Accounting Hub
- Advanced Collections
- Assets
- Budgetary Control
- Cash Management
- Expenses
- Financials for EMEA
- Financials for Asia/Pacific
- Financials for the Americas
- General Ledger
- Intercompany Accounting
- Payables
- Payments
- Receivables
- Revenue Management
- Tax
Furthermore it classifies the reports accounting to type, sub type and run type and provides catalogue location, description and report output samples.
Download the Oracle Financials Cloud Release 13 Reports and Analyses Listing which covers reports available from Release 12 up to R13.18A
e-mail this article • Administration • Reports • () Comments • Bookmark this to del.icio.us • Permalink
Wednesday, November 25, 2020
Oracle Fusion Procurement R13 - Reports and Analyses
With each major release Oracle produces a seeded listing of reports. Periodically with the quarterly updates one might see a a few new reports appear. I always find it quite useful to have this to hand when working with clients as it is searchable and you can filter by specific modules. Download the Oracle Procurement Cloud Release 13 Reports and Analyses Listing which outlines what’s available for Sourcing, Suppliers, Purchasing, Self Service Procurement and Purchasing.
e-mail this article • Administration • Reports • () Comments • Bookmark this to del.icio.us • Permalink