Identifying payments for cash application
Hi Gurus,
Need your guidance in understanding industry best practices related to deposit creation and cash application in peoplesoft.
If we get payment information through lockbox file, we can get MICR, Item reference included in lockbox file so when the deposit is created we know the items or at least the customer for which the payment has been received.
However, if it is through ACH, manual check, we are facing difficulty in identifying the items or customer for which the payment needs to be applied.
The situation becomes tricky as even if we know the customer, we do various kinds of work (Grant related, ad-hoc lease related etc.) for the same customer so we do not know against which item(belonging to a particular type of work) should the payment be applied.