Sage 100

Client on Sage 100 Advanced 4.30.0.7. Upgrading client to Version 2014. In testing 4.3 data Rebuild BR sort files hangs with message 'Rebuilding B/R bank Code sort files'. Can I go ahead with test migration or do I need to fix this? TIA

Try it anyway. They are just sort files that you will rebuild in v2014 anyway...

Thanks @JeffSchwenk! Will give it a try.

The BR Rebuild Sort File program doesn't use the old BRY sort file in 4.30. It first gets the bank code from GL_Bank and then goes through every single BR_Transaction for that bank code. Then repeats for the next bank code until done. So I would be inclined to Rebuild Key Files on BR_Transaction in 4.30.

thanks @AlnoorCassim! I rebuilt the BR key files without error before I tried to rebuild the sort files.

@AlnoorCassim I went back and rebuilt BR_Transaction and GL_Bank without errors but Rebuild B/R Sort Files still hangs.

Well that was interesting Ron. In the interest of sharing in case someone else runs into it: The issue was the BRZUZA program (Rebuild Sort File prog for B/R) was missing and instead of just telling you ""Error 12 File Not Found"" it was loading up the older legacy BRWUZA. But that guy has a bug where it goes into an endless loop where it can't advance pass the first BR_Transaction key. Double-whammy. I just had to give you the missing file. I also learned the specific purpose of B/R Rebuild Sorts is to be a recalc utility. For uncleared B/R transactions, it recalcs these fields in GL_Bank: OutstandingCheckTotal, NumberOutstandingChecks OutstandingDepositTotal, NoOutstandingDeposits OutstandingAdjustTotal, NumberOutstandingAdjust Ya know I should've just asked the king of Bank Rec @MarcosDeLuna It is rumored he knows more than anyone else about it :)

A Huge Thank You Alnoor!!!