x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 2 replies
  • Subscribers 138 subscribers
  • Views 2761 views
  • Users 0 members are here
Browse Forums
Announcements
237
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
210
topics
416
replies
Sage Intelligence Reporting
121
topics
322
replies
TJunction

Any considerations before running Account Balance or Dimension Balance Resynchronization?

Posted By

I've run Balance and Ledger Verifications in Account Balance (RECBAL) and Dimension Balance (RECBLA) functions and issues have been found.

Are there any considerations I should make before I run the Recovery?

Should I do this after hours?

Is this a risky operation? 

Will this add or change the General Ledger / Journal Entries in any way?  

Are there any horror stories that I should be aware of?

  • 0

    I would always make sure that I had a backup and ideally try on a test folder first. I prefer to be cautious. Read the help file to see what it does and doesn't do. But, what kind of issues did you find? What version and patch level are you on?

  • 0 in reply to pnightingale

    The issues reported by the verification log were very standard in nature- just a whole bunch of mismatches between balances and sum of credits and debits in GL.

    I used a SQL query to verify and understand the verification log and understand what the help file was trying to say.

    In the end I was satisfied that the Recover process was only going to update rows in BALANCE and BALANA tables based on the sum of debits and credits in GL by company/account/site.

    I ran the Recovery and all good.

    Haven't done it yet, but SEI cube will probably need to be refreshed too.

*Community Hub is the new name for Sage City