Receipts remain unapplied if the receipt amount exceeds the transaction balance

Summary:

Receipts remain wholly unapplied if the receipt amount exceeds the transaction balance of the transaction it reference.

Content (please ensure you mask any confidential information):

The transaction type for the Invoice is set to allow only Natural application . There is a Receipt application exception rule defined to treat overpayments greater than 24.99 and %1 to be treated as On Account. . These receipts are created using a spreadsheet. However, always when a receipt exceeds the invoice balance eg receipt amt is 1500 while Invoice amt is 1200, we find the entire receipt amount of 1500 remains as unapplied. It does not apply the receipt amount upto the balance of the transaction of 1200 and treat just the 300 as On-account. Rather, after running