I need to forecast receipts from individual key clients, each having different credit terms. I'm looking for a formula to place the cash receipt into the the right period based on the period of the ...