Gl_balances vs gl_balances in consecutive periods
I am follow Inconsistent Balances Scripts [ID 101579.1].
3. Gl_balances vs gl_balances in consecutive periods
If you know or suspect the periods in which the corruption exists, you can obtain all the accounts with this problem.
This can only check periods within the same calendar year. It does not check translated balances
Select a.code_combination_id ccid, a.template_id,a.period_name,
a.BEGIN_BALANCE_DR - a.BEGIN_BALANCE_CR
+ a.PERIOD_NET_DR - a.PERIOD_NET_CR end_previous,
b.period_name,
b.BEGIN_BALANCE_DR - b.BEGIN_BALANCE_CR begin_next