Bryan,

I had a similar situation about 10 years ago but you need to know your system well. It happens, because people neglect CM and worry about the GL and Fin Statements. Some don't know that Sage 300 has certain rules i.e. all AP related transactions should go through AP, all AR through AR and Billing, all Cash through CM - like the control accounts. You have "Accountants" coming in and entering a number of AJEs to balance books or you have a module assigned to a person that has no idea how to manage it.

GL JOURNAL ENTRIES DO NOT POST TO CM.

You could turn off the interface between CM and GL (in CM) and do what you need to do in either CM or GL and then turn it back on. File\Company Settings\CM Settings\Posting & Interface settings. Then enter a CM entry with a certain date for the ($208K) under that bank account and you could use "clearing" account to offset. Make sure it is not carried over to GL ( I would have turned the GL posting to manual so that it stays in the NEW GL file and an option to rename it).  Then go to CM and open reconciliation and click the one transaction for the positive 208K and the bank balance will be zeroed out. GL should be fine as the transaction is not reflected there. You have to make sure that the date of the entry and reversal is the same to not mess up fin statements. Hope this helps.

Bryan,

I had a similar situation about 10 years ago but you need to know your system well. It happens, because people neglect CM and worry about the GL and Fin Statements. Some don't know that Sage 300 has certain rules i.e. all AP related transactions should go through AP, all AR through AR and Billing, all Cash through CM - like the control accounts. You have "Accountants" coming in and entering a number of AJEs to balance books or you have a module assigned to a person that has no idea how to manage it.

GL JOURNAL ENTRIES DO NOT POST TO CM.

You could turn off the interface between CM and GL (in CM) and do what you need to do in either CM or GL and then turn it back on. File\Company Settings\CM Settings\Posting & Interface settings. Then enter a CM entry with a certain date for the ($208K) under that bank account and you could use "clearing" account to offset. Make sure it is not carried over to GL ( I would have turned the GL posting to manual so that it stays in the NEW GL file and an option to rename it).  Then go to CM and open reconciliation and click the one transaction for the positive 208K and the bank balance will be zeroed out. GL should be fine as the transaction is not reflected there. You have to make sure that the date of the entry and reversal is the same to not mess up fin statements. Hope this helps.

Excellent advice Angel !

Thank you very much for the advice.  I think I am going to use our support plan for this one.  I'm still to new to Sage to attempt this one alone.  Going to be a learning experience.  Thanks again.