Allocating amount with invoices based on FIFO method

[yogyata26]

​Hi,

In my workbook I have 2 sheets - 1st sheet has the case and 2nd has the solution of how the case should look like after running the macro.

In sheet - "CASE" I have 2 sets of data namely Data 1 - Invoices & Data 2 - Receipts.

I need a code which would allocate 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.

Thanks in advance!

[Sniper]

HI, did you find any solution to this?, i also have the same challenge. Thanks in advance if you have something.