Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
How to correct cumulative balances of financial reports?
Hi Gurus!
We are migrating historial data and we are uploading one year using not cumulative balances and in the middle of the next year using cumulative data, that means we have 2021 by month with an journal entry with the difference (activity) of that period and then in September of 2022 we have the data for the full amount of the account.
We need to "reverse" the amounts of the BALANCE accounts of 2021 so in September 2022 we don't have the older amounts but:
- If we close period for 2021, only P&L accounts will be tranfer (and we don't want that)
- If we reverse the monthly JE on september (so the balance account start in zero for that month) the 2022 P&L will be alterate (we don't want that)
0