Good day,
Would someone please explain how to apply a payment to customer invoices where the customer might short pay some invoices and fully pay others? Below is an example scenario:
Example:
For 'Customer A' I have the following three invoices open in my A/R:
- Invoice 101 - $100.00
- Invoice 102 - $150.00
- Invoice 103 - $200.00
'Customer A' sends me a payment on 7/14/2023 in the amount of $300.00 and below is the following remittance data sent by the customer showing what they are paying:
- Invoice 101 - $50.00
- Invoice 102 - $150.00
- Invoice 103 - $100.00
In essence, the customer is short-paying invoice 101 and 103 because of a dispute. Regardless of the outcome of the dispute, we need to ensure our records show that invoice 101 still has $50.00 remaining and invoice 103 has $100.00 remaining.
We need to create 1 customer payment in Odoo and allocate cash according to the remittance data sent by the customer. How can I do this? The only option I have when selecting Accounting > Customer > Customer Payment forces me to allocate the cash as follows:
- Invoice 101 - $100.00
- Invoice 102 - $150.00
- Invoice 103 - $50.00
This would be incorrect and would create major discrepancies between the customer's books and our own. How am I able to allocate the cash from the payments manually, without the system forcing me to leave the shortpay on 1 single invoice?