You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Create Intercompany Reconciliation Report on SmartView 11.1.2.5.720

edited Aug 2, 2018 2:36AM in Essbase 1 comment

Summary

Create Intercompany Reconciliation Report on SmartView 11.1.2.5.720

Content

Hello,

my customer wants to create a report that shows intercompany transaction balances on SmartView.

Under the conditions below, would it be possible to see intercompany transaction balances in terms of (1)own company and (2)contra company that has transactions related to the own company?

Also please take a look at the attached image, which describes what my customer wants to have in reports.

Conditions:

- SmartView version(11.1.2.5.720)

- Excel 2016

- Windows 10

- Oracle ERP Cloud R13

- Have three ledgers for HQ, Subsidiary A, Subsidiary B existing in a single Essbase cube

- Send transactions occurred among HQ, Subsidiary A and Subsidiary B to a single Essbase cube

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!