Posts

Showing posts from 2021

Reporting Tools in Oracle Fusion/Cloud

Fusion Financials provides various types of reporting methods that work off the same standard and multi-dimensional balances. Now because all of the reporting and analytic tools leverage the same source of truth, it ensures that all the roles in your company regardless of the type of report they need will be on the same page. Financial Reporting Studio OTBI (Oracle Transactional BI) BI Publisher Smartview Account Monitor Account Inspector Financial Reporting Studio Financial Reporting Studio is the report designer tool or a report repository. It is Oracle’s best client based report authoring tool. It enables users to create customize and view income statements and balance sheet reports. Business users do not have to run the report, all they got to do is open it and real-time balances are shown automatically. Users can then drilldown from reports to subledger transactions, as well as publish reports in a variety of formats (MS Excel, PDF, MS Word, MS Powerpoint, etc.). ...

Automatic Offset in Oracle Payables

Image
When an AP invoice is entered, there may be multiple expense/ distribution accounts and the corresponding liability account generally booked is the default account picked from the Supplier site or the one defaulted at Invoice header level. However, there may be scenarios where a business entity is using the same Operating Unit to make purchases against multiple balancing segments. In such cases, it would be imperative to have different liability accounts booked against each of the different distribution accounts. For example, consider an AP Invoice with a default liability account and two different distribution accounts. Liability is an offset account. We can offset liabilities in three ways i.e None Balance Account If you enable Automatic Offsets, Payables automatically balances invoice and payment distributions that cross balancing segments by creating offsetting entries for each balancing segment. Automatic Offsets is a powerful feature that greatly affects processing th...

P2P Journal Entries in Fusion

1. Purchase Requisition no JE 2. Request for Quotation no JE 3. We prepare a Purchase Order against best RFQ no JE 4. Goods Receipt(You receive the goods enter a  Goods Received Note (GRN)  in Oracle Purchasing)                Receiving Inventory A/c…………….Debit (Picks from Receipt Accounting options )                AP Accrual A/C………Credit (Picks from Accrual Account of PO-TAB/TAD ) 5. When we are moving the Goods from Staging area to Sub-Inv or Delivery happens/ Put Away                Material A/C..............Debit (Picks from Charge Account of PO-TAB / Cost Accounting Options )                Receiving Inventory A/C......Credit (Picks from Receipt Accounting options ) 6. While Creating the...

Key features of Oracle Financials Cloud

Centralized Setup using FSM: Centralized implementation experience using FSM. Central place to enter all setups across products like Financials, SCM, PPM. Revenue Recognition Compliance: Centralized and automated revenue management to address revenue as per ASC 606 and IFRS 15 accounting standard with ability to recognize revenue independent of billing Multi-dimensional reporting . This is a key feature for general ledger. General ledger in the Financials Cloud integrates with Essbase, a multidimensional database that can generate financial statement reports. You can use the data from Essbase using Oracle Financial Studio reports, using Smart View, a spreadsheet tool so accountants can retrieve these reports in a very familiar environment, in Microsoft Excel. File Based Data Import: Seeded functionality to upload high volumes of data. Data conversion can be done using FBDI templates in Cloud without any technical knowledge. Extensive spreadsheet integration . You can create q...