Allocating amount with invoices customer wise

Hi,

In the attached workbook there is a sheet - "TEMP" in which I have 2 sets of data namely Data 1 - Invoices & Data 2 - Receipts.
I have a code which allocates all the receipts with the Invoices serial no. wise.
If a single receipt is not sufficient to adjust a Invoice, a row is inserted and in that row the remaining balance of invoice is adjusted against next receipt.

But this code works correctly only for one customer!

If there are multiple customers the receipts should be allocated with invoices customer wise.

If all the invoices of a customer (say "A") gets allocated then the next customer's ("B") invoices should be allocated using the receipts of Customer "B" only and not with the balance receipts of "A".

Thanks in advance!

Please Login or Register  to view this content.