Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Preparing a Opening Journal in Cloud from last period balances from EBS

edited Aug 28, 2018 5:09AM in Reporting and Analytics for ERP

Content

Team,

I need help in Preparing an Opening Journal in Cloud, I am using balances from EBS for last period.

I am trying to use GL_Balances Table, but I see lot of time the _BEW columns have zero OR null values.

What should I filter for Translated Flag column?

I need to prepare opening journal for example for Jan-2018 in cloud using ending balances as of DEC-2017 from EBS, this should be at detailed level balances with entire code combination. COA are same in EBS & Cloud

 

Any SQL would be helpful.

 

Thanks,

Animesh

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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