Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

How to void an AR type cash receipt in Cashbook Management in Microsoft Dynamics GP


View products that this article applies to.

Symptoms

This article explains how to void an 'AR' type cash receipt in Cashbook Bank Management using Microsoft Dynamics GP. The cash receipt is listed in the Build Deposits Entry window in Cashbook Management and there is no way to delete it in this window. If you deposit it in Cashbook Management and then try to delete this deposit in the Transaction Enquiry/Void window, you will get the message:


This deposit is an AR transaction and cannot be voided from the Bank Recon.


↑ Back to the top


Cause

By design.  Since it was an 'AR' type cash receipt and updated Receivables Management, the system now considers it to have originated from Receivables Management, and there is no functionality to void the cash receipt in Cashbook Management.

↑ Back to the top


Resolution

When you post a cash receipt in Cashbook Bank Management, it will create a cash receipt batch in Receivables Management. Depending on what you do with that cash receipt batch in Receivables Management, follow the appropriate method below for voiding the cash receipt:


  • 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): 

CB100000
CB100003
CB100011
CB330222
CB990007 --this is the table that actually drops it off the Build Deposits window
CB220210
CB600066



↑ Back to the top


Keywords: kbmbspartner, kbmbsmigrate, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 3058407
Revision : 1
Created on : 1/7/2017
Published on : 9/28/2016
Exists online : False
Views : 245