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

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.


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.
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. 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. 
  • 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



More information
cbm cb cr gp
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Свойства

ИД на статията: 3058407 – Последен преглед: 04/20/2015 16:19:00 – Редакция: 2.0

Microsoft Dynamics GP 2015, Microsoft Dynamics GP 2013, Microsoft Dynamics GP 2010, Microsoft Dynamics GP 10.0

  • kbmbsmigrate kbsurveynew KB3058407
Обратна връзка