10 April 2016
Sir, I have 50000 receivable from a customer against different bills (100bills). I got 2725 against some invoices (reference not available). Can I find out the possible combinations of invoices amounting 2725 by using excel or any other mathematical formula.
10 April 2016
If amount received is bill to bill clearance than you can try unmatched difference amount by combination, you can request the customer bill details for Payment. They will have record for which bills they have cleared payment.