Sage 300

Hi all - A site that has their customers set to balance forward statements ran statements and said 'yes' to the 'printed ok' before making sure the dates were correct. Short of a restore, anyone have any tricks for resetting balance forward statement dates / amounts back to open? thank you!

@MarcCregan - you need to restore from back up otherwise you have to edit ARCUS (Date of last statement and Balance Forward fields), AROBL (date of last statement), and AROBP (date of last statement). The difficulty is making sure the Balance Forward fields in the ARCUS are correct before the statements were ran and this amount would need to be reconciled back to the AROBL and AROBP tables.

Ouch!! That is exactly the reason I hate balance forward.... Perhaps you could restore to a back up system and print from there. Unless of course they did a lot of entry work since the last back up or worst yet, don't have a backup. Maybe some awesome Crystal writer could come up with something for you?

Thanks @LloydSmith and @JeffSchwenk - looks we'll be doing a restore to dummy company and getting things back in line from there.