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

Loading data using YTD_Input and Clearing opening Balance of next year with Rules.

edited Dec 2, 2019 10:52AM in Financial Consolidation and Close 7 comments

Summary

Loading data using YTD_Input and Clearing opening Balance of next year with Rules.

Content

Hi,

Im doing some testing by loading data using YTD_Input. Im getting YTD values correctly for the current year. But when I run consolidation for Next year and first period, closing balances for prior year is transferring to Opening balance. These balances belongs to Balance sheet accounts of Last year and For P&L accounts opening balance is not getting populated. So, I want to load YTD balances in first period and here data is getting doubled because of Opening balances. So, I have written a rule to clear the opening balances. Please see below rule.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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