How to use the FIFO concept in maintaining the payments received from the customers?
In case if there are 4 line items for an invoice and the customer pays money for it partially. I need to assign the partially paid amount line item wise.
For example, 4 line items costs $500 each (Total $2,000). The customer pays $1,250 (Balance= $750).
I have a column named "Amount due". In this column, the first and second line items has to be marked $0 since the amount paid is greater than the individual line item. And the third line item has to be $250 and the forth has to be $500.
Please look at the attached image for reference. The last column "Amount Sue" has to be automatically calculated.
How to achieve this? Please help me.
Bookmarks