In the Sales and Billing Module - Undo an AR Cash Receipt payment and delete it. 

  1. Unpost RC trans from GL. 
  2. Look at ARCASH to get INV Trans # that was paid. 
  3. Go to ARINVLIN and pull up Trans of Invoice and take out the amount paid while noting the RECNO value. 
  4. Go to ARINVHDR for the Trans of step 3 and change amount paid and open amount. 
  5. Go to ARAPPLY and pull REF that is the same value of RECNO from step 3 and change amount paid. 
  6. Go to ARCASH and delete Trans # of cash receipt payment. 
  7. If the original RC (cash receipt) created a credit memo, you will need to delete the credit memo transaction from the arinvlin and arinvhdr tables.