In Reconcile Bank Statement ,How to remove the defrences from SQL table?
Actually I did ,reconcile and check links for finacial,sales modulles.But it dosnt help..
Somebody please help..
Ahhhh, more clues in the mystery come into focus now. Yes, you can remove the receipt from SQL, but you need to be very familiar with the table structure to make sure you remove it from all the tables. Do you have a GP Partner that could assist you with this or are you on your own? I'm still confused as to how the Voided Receipt shows in Bank Reconciliation when it was never posted there to begin with.
That being said, you'll need to find the transaction(s) in the following tables and remove them, then run Check Links and Reconcile to repair any broken table links and restore the correct balances in your AR inquiry screens. Also, make sure you test this in a test company before doing it in production and do a backup of production first also.
RM Open File RM_OPEN RM20101
RM Apply Open File RM_Applied_OPEN RM20201
RM History File RM_HISTORY RM30101
RM Apply History File RM_Applied_History RM30201
Receivables GL Distribution History RM_Distribution_History RM30301
I would also verify that no elements of the receipt remain in the following tables:
RM Cash Receipts Work File RM_Cash_WORK RM10201
CM Deposit Work CM_Deposit_WORK CM10100
CM Deposit Work Totals CM_Deposit_Work_Totals CM10101
CM Receipt CM_Receipt CM20300
CM Distribution CM_Distribution CM20400
The physical table names are in Bold.
Frank E. Hamelly, MCP, MCITP, MCT, MVP
http://gp2themax.blogspot.com/
If your reconciliation doesn't balance to zero, you probably have a transaction issue, not a SQL table issue. Are there adjustments like bank fees and service charges that need to be entered to reconcile the checkbook? You need to be sure all transactions have been entered properly, and that you don't have transactions that affected the GL account and not the checkbook (such as a journal entry) before considering making changes in the tables.
Thank you very much for your response Mr. Frank Hamelly,
Actually one sales receipt entry was gone wrongly and posted with errors. And it was not reached in bank deposit window. So we void that receipt and re-entered it with the same amount. New entry is there in bank reconciliation window. And void entry shows zero...But the same amount shows as difference in bank reconcile window...
So Belraj, you're saying that
1. a Cash Receipt was posted, but it had errors in it, so you voided that receipt.
2. That cash receipt was not posted to the checkbook as a deposit
3. You re-entered another cash receipt and it was posted to the checkbook as a deposit
4. The original cash receipt appears in the checkbook, but with a zero amount?
5. Your reconciliation is off by the amount of the second cash receipt?
1 ) yes.
2) Yes.It was not seen in Bank Deposit window.
3) yes
4) No. The voided receipt is display with zero amount.
5) Actually the amount are same for both voided and original receipt. The same amount shows as difference.
Okay, I'm curious how the voided receipt shows up in the checkbook (reconciliation) if it was never posted as a deposit. I'm speculating that it was posted as a deposit and perhaps when it was voided, the void date was not the same as the original transaction date (posted in one period and voided in another) and the difference you're seeing is the result of a timing issue.
Mr.Frank Hamelly,
Thank you very much for your responses...
Actually, we were not able to post the batch which was includes this receipt from series post. The batch was able to post, after disabling the payment document management. The batch was containing around 60 entries. And many of them not reached in bank deposit even the AA there is a setting that NOT allows Cash Receipts to be deposited immediately to the Checkbook ID...Is it possible to remove entire receipt from SQL? or any othe solution? Plse help me...
please help me..
Thank you very much Mr.Frank Hamelly for your support
Let me try this..