Issue -- Receipt spreadsheet does not give any error for the CM with 0 balance

Issue: Receipt spreadsheet Reference value column accepts credit memos with zero value balance

Navigation -> Accounts Receivable -> Create Receipts in Spreadsheet -> Launch the spreadsheet -> Receipt spreadsheet Reference value column accepts credit memos with zero value balance.

Issue Description:

Credit memos with zero amount balance provided in reference value column does not give any warning or error when they get applied on the receipts that the credit note was already used/applied against different invoice or receipt and in present having the zero-amount balance. 

Business reported that when they add a used credit note on the oracle receipt spreadsheet, the system doesn't give us any errors. Therefore, they think that the payment went through with the credit note but it didn't.

What the system does is to match the payment “receipt” with the invoices that covers the amount we received and for the receipt that needs to be matched with the credit note the amount will be 0.00.

Analysis:

In the spreadsheet 'Reference Value' is free text field and Oracle does not validate the transaction number entered in it. however when you run the process to auto match, system will not match that Credit memo to that receipt as that is already used.

User must enter the transaction number carefully and has to ensure that credit memo is not already used before. And after entering the correct credit memo number and receipt is uploaded using spreadsheet then business have to run the following process in scheduled processes

'Apply Receipts Using AutoMatch' => This process will match the receipt with credit memo/ invoice.