lexi0088
Technical User
- Sep 7, 2004
- 49
We accidently imported checks this month into the wrong company. We import the checks into the Bank transaction Entry screen (financial-bank transaction entry).
What I did was delete all these imported checks from the CM20100 and CM20200 table in SQL Query Analyzer. After I did this I ran check links for financial and I checked in inquiry-financial-checkbook register and the checks were gone. I thought everything was fine until we went to do the bank rec in the bank rec module. After we had thought we balanced, it said that we had a difference of the exact total of the integrated checks I had deleted.
So my question is... Does anyone know what table I missed? There has to be another table that the information is stored in. Thank you for your help.
What I did was delete all these imported checks from the CM20100 and CM20200 table in SQL Query Analyzer. After I did this I ran check links for financial and I checked in inquiry-financial-checkbook register and the checks were gone. I thought everything was fine until we went to do the bank rec in the bank rec module. After we had thought we balanced, it said that we had a difference of the exact total of the integrated checks I had deleted.
So my question is... Does anyone know what table I missed? There has to be another table that the information is stored in. Thank you for your help.