PDA

View Full Version : Allocating amount with invoices based on FIFO method



yogyata26
02-18-2019, 01:18 AM
​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
11-04-2019, 03:22 AM
HI, did you find any solution to this?, i also have the same challenge. Thanks in advance if you have something.