Firstly,
We have 3 invoices 11113355, 11113356, 11113357.
Invoice 11113357 was created to hold retainage for the previous two invoices after we received payment and realized retainage should have been held but was not originally.
Therefore when we tried to apply the payment in Accounts Receivable we applied it to the negative invoice first (11113357). This has caused an issue and left an unapplied cash receipt. We've tried multiple times to unapply and reapply after realzing there was an unapplied cash receipt but it just keeps making the issue worse. Does anyone have a solution to this type of issue? I'm attaching what our AR Adjustment screen looks like. We use Sage300 CRE.
| Type | ID | Date | Amount | Retainage | Pmt/Adj |
| Invoice | 11113355 | 5/14/2021 | 87,592.00 | ||
| Invoice | 11113356 | 7/1/2021 | 347.00 | ||
| Invoice | 11113357 | 7/1/2021 | 4,396.95 | ||
| Cs cs rc | 100 | 7/26/2021 | 4396.95 | ||
| Cs cs rc | 100 | 7/26/2021 | (12,120.44) | ||
| Cs cs rc | 100 | 7/26/2021 | 4,396.95 | ||
| Cs cs rc | 100 | 7/26/2021 | 4,396.95 | ||
| Cs cs rc | 100 | 7/26/2021 | (4,396.95) | ||
| Cs cs rc | 100 | 7/26/2021 | 4,396.95 | ||
| Cs cs rc | 100 | 7/26/2021 | (7,723.49) | ||
| Cs cs rc | 100 | 7/26/2021 | (347.00) | ||
| Cs cs rc | 100 | 7/26/2021 | 4,396.95 | ||
| Cs cs rc | 100 | 7/26/2021 | 4,396.95 | ||
| Cs cs rc | 100 | 7/26/2021 | 4,396.95 | ||
| Cs cs rc | 100 | 7/26/2021 | 4,396.95 | ||
| Cs cs rc | 100 | 7/26/2021 | 4,396.95 | ||
| Cs cs rc | 100 | 7/26/2021 | 4,396.95 | ||
| Cs cs rc | 100 | 7/26/2021 | 4,396.95 | ||
| Cs cs rc | 100 | 7/26/2021 | 4,396.95 | ||
| Cs cs rc | 100 | 7/26/2021 | (4,396.95) | ||
| Cs cs rc | 100 | 7/26/2021 | (91,988.95) | ||
| Cs cs rc | 100 | 7/26/2021 | (2,979.54) | ||
| Cs cs rc | 100 | 7/26/2021 | (1,417.41) | ||
| Cs cs rc | 100 | 7/26/2021 | (1,793.82) | ||
| Cs cs rc | 100 | 7/26/2021 | (12,120.44) | ||
| Cs cs rc | 100 | 7/26/2021 | (347.00) |
