Macro to allocate receipt amount with invoices based on fifo method

[amandeep08]

Hi,

In my workbook I have customer wise data along with Document Number, receipts amount and invoice amount. I want the Macro that will provide the result as per below approach.

I need a code which would allocate customer wise 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. I am trying to look into this macro for the last 4 months but no one is able to help me out as of now.

I want this Macro because there are some 2K customers to whom i have to adjust the receipts every month manually.

Thanks in advance!