A new customer for my company provides payments every two weeks with a remittance settlement report. This settlement includes payment for all the sales orders that have been paid against plus a reserve amount from the previous period, minus a reserve amount for the current period.
We are struggling with how to apply the payment. It is difficult for us to determine exactly which sales orders were held in reserve, and truthfully it doesn't always match to a specific set (the customer does not mark this). We would also desire to not have to attempt to split the previous settlement report and the current one to mark some invoices as paid and others as not. What is the best way to handle this?
We are considering treating the Reserve Amount as a deduction, then reporting it as received on the next settlement report, using the Post Dated Check functionality, implementing a clearing account, as well as simply continuing on with the manual time consuming process we currently have.
Is there a better solution? What is your recommendation?
*This post is locked for comments