harshitjain
New Member
we have two tables 1 table includes payment date payment number payment vendor name and payment amount
and second table has bills date bill number bill vendor name and bill amount
we need to a allocate the payment to the bills On FIFO Basis in Excel
we have three bills scenario
first one is multiple payments to a single bill
second is single payment to single bill
and third is single payment to multiple bills
give me solution with sample data
i want to have a additional column in payments named as amount allocated with the amounts and beside it the column for bill numbers of the allocated amount
and second table has bills date bill number bill vendor name and bill amount
we need to a allocate the payment to the bills On FIFO Basis in Excel
we have three bills scenario
first one is multiple payments to a single bill
second is single payment to single bill
and third is single payment to multiple bills
give me solution with sample data
i want to have a additional column in payments named as amount allocated with the amounts and beside it the column for bill numbers of the allocated amount
