Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to 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)