Hi,
please help, I'm stucked...
I have a supplier that send me multiple invoices to be paid, at different dates.
Need to track the payments (as amounts) and in a separate page to see the invoices and if the payments closes them.
On columns from Sheet1 i also have some other informations, used in other sheets !!!!
On column A = date of invoice
Column B = invoice value
column C = date of payment (partial payment, or maybe more money, in this case must allocate themselves to next invoice)
Column D= amount paid
In Sheet 2 i have to recover from sheet1 only the invoices and payments:
column A = date of invoice
Column B = invoice value
Column C = date of payment
Column D = amount paid
Column E = message if the invoice is totally paid, or partially paid
One cell in column F = TOTAL Difference remaining to be paid for all invoices
I do not know how to allocate from amount paid the money to 2 invoices for example:
invoice 1 = 1000
invoice 2 = 1400
first payment = 600 (and shows me that invoice 1 is partially paid, invoice 2 is not paid)
second payment = 700 (and automatically allocate rest for payment at invoice 1, and remaining is putted at invoice 2) ---this i do NOT know how to do it...
Bookmarks