Credit Card Reconciliation Creating a Debit Memo when Type used is Cash Deposit

Issue No: CCR-302
Created 2/15/2018 10:43:24 AM
Type Bug
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 17.3
Description This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-209450 - Citgo Credit cards hitting AP and Bank.|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-209450]       Version: 17.3.0129.267     Database: 01   Steps to Recreate:   1. Credit Card Reconciliation > Create a New record.   2. Vendor code CITGOEFT > AP Type "Cash Deposited".   3. Enter the rest of data (shown below).   4. Post.   5. Issue: Verify Voucher Grid, you will see that the posting created a Debit Memo for CitgoEFT. It should not created a Debit Memo when type was Cash Deposited, when the Site is Company Owned (non Pass Through). On this page [http://inet.irelyserver.com/display/CCR/Example] , you can see there should be no AR for this scenario.   !pastedImage_d92175_0.png|height=319,width=835!   6. Correct Behavior: Company Owned Site Non Pass Through, when AP Type = Cash Deposited, there is no AR, but only CM.   7. Verify Bank Transactions, it should have created a deposit.   *Requirements* :   1. DATA FIX: Remove all DM records created from Cash Deposited type Credit Card Recon Records along with the Journal Entries created with it. This is understating their Open Payables Balance. --> there is a Knapp LIVE backup in the Phils office that I gave to the MFT team. The backup was from mid Feb, so you should test the data fix in that DB first.   2. Fix program so it does not create DM when cash deposit type used. --> use the same DB to test and verify.     Additional requirement:   Test credit card recon type "Credit on Account". This should create a Debit Memo for the vendor and DOES NOT create a bank transaction.