Client is reversing a payment from one customer and applying it to another. When they do this, the occasionally get something like below. In this case, check 0019538 was received on 3/15 and applied to customer LOCKBOX. Subsequently, on 3/17, the payment was reversed and applied to customer 0700696. If you look at just the records for check 0019538, everything cleared. However, the process also created a second RP record (391918) for LOCKBOX and a second PA record (391919) for customer 0700696. The refnbrs are being pulled from the ARSetup record, just like an IN, CM, or CM record would. We could get rid of the PA record by creating a DM that reverses is, but there is no way that I've found that will allow me to apply the second RP record to another N class record, or to apply a payment to it.
Has anyone else seen this? And, if so, how did you resolve it?
Version is 6.5SP1
custid refnbr doctype origdocamt docbal crtd_datetime
-------- ---------- ------- ------------------- -------------- ---------
0700696 0019538 PA 3598.57 3598.57 2010-03-17 00:00:00
0700696 391919 PA 3598.57 0.0 2010-03-17 00:00:00
LOCKBOX 0019538 PA 3598.57 0.0 2010-03-15 22:17:00
LOCKBOX 0019538 RP 3598.57 0.0 2010-03-17 00:00:00
LOCKBOX 391918 RP 3598.57 3598.57 2010-03-17 00:00:00
(5 row(s) affected)
Stuart Nottingham
*This post is locked for comments