AP Out of Balance - SI-39570 Cash Refund showing Negative in Payables Report

Issue No: AP-7195
Created 5/1/2019 9:04:53 AM
Type Bug
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 18.3, 19.1
Description 1. Customer Prepayment received on 2/11/2019. This created CPP-453/RCV-56518.   Note: Customer Prepayment does not make a journal entry until payment is posted. Every prepayment creates an RCV and CPP with only 1 journal entry.   2. Customer Prepayment debits the Cash Clearing and credits Customer Prepayment.   3. This updated Customer Aging Detail Report with negative value in prepayment column.   4. Created Cash Refund SI-39570 from Sales module for the customer prepayment.   5. This debits the Customer Prepayment and Credits AP account. Offsetting #2   6. This removed the Customer Prepayment from Customer Agind Detail Report. Ofsetting #3   7. This updated the Payables Report as Negative value.   8. This updated the Pay Voucher Details for the entity which will allow the user to write a check for the cash refund.   !http://jira.irelyserver.comnull/!   *ISSUE(S):*   1. The customer code is not searching in Open Payable Detail filter criteria under vendor id or vendor name.   *STEPS:*   * Ran Open Payables Detail and searched for Vendor Id "Morrow...". The search did not find the entity. * I ran the Open Payables Detail for all vendors, downloaded to PDF and then searched for the vendor "Morrow Country Grain Growers, Inc". Found the vendor in the report.   !pastedImage_d117043_1.png!   2. Since MCP owes this customer a refund, and the entry from SI-39570 was a credit to GL, this should have updated the open Payables Aging Report as a Positive Number. Currently, showing as negative.     *Additional verification on Sales/AR:*   * Customer Aging Detail Report 2/11/2019. The customer prepayment was created when the customer sent in a check for $13,500. Hit the deposit for the same amount BDEP-1635.   !pastedImage_d117043_2.png!   * Customer Aging Detail Report as of 3/11/2019. On this day, the cash refund was created. The Customer Aging Detail Report no longer show the customer prepayment. This is correct because now it is considered a payable to the MCP.   !pastedImage_d117043_3.png!   *ACCEPTANCE:*   Cash Refund should not show negative in Payables Report