- The recommended process is to post the cash receipt batch in Receivables Management and deposit the cash receipt in Cashbook Management. Then void the posted cash receipt in Receivables Management under Posted Transactions (Transactions | Sales | Posted Transactions). The void will flow back to Cashbook Management, and will be listed in the Transaction Enquiry/Void window as a negative amount, to serve as an offset to the deposit for the cash receipt in Cashbook Management. Both the negative amount and deposit will be listed in the Transaction Enquiry/Void window to offset each other. This is the intended design.
Note: In the Posted Transactions window, be sure to search under Payments. The Number will be the payment number assigned to it when it posted to Receivables. The Receipt number from Cashbook can be found in the lower left corner under the Check Number field with a slash preceding it. So look for the Check number field, and Original Amount. If you need help to find the Number, you can also drill back on it from the Receivables Transaction Enquiry window (Enquiry | Sales |Transaction by Customer), or even look directly in the RM20101 SQL table to find it by querying on the date and amount. With the Payment Number, you should be able to bring it up in the Posted Transactions window in Sales to void it.
- Now if you would delete the cash receipt batch in Receivables Management, then you do not have a way to void the cash receipt that is in Cashbook Management. If you deposit it in Cashbook Management and then try to void the deposit, you will get the message indicated above. At this point, the only way to remove the cash receipt from the Build Deposits window in Cashbook Management is to remove it from the following SQL tables (which is not a recommended or supported option):
CB990007 --this is the table that actually drops it off the Build Deposits window
Article ID: 3058407 - Last Review: Sep 28, 2016 - Revision: 1