Question

Automate Matching of Customer Payments

  • 25 July 2023
  • 1 reply
  • 97 views
M
Rank
Userlevel 5
Badge +10

We have a request from The Business to automate matching of invoices for Customer Checks  - to match against the oldest ones first, or if it matches a months invoices (as the oldest one is in query) as a proposal before the payment is posted against the invoices.

I can see many functional issues with this - but at the moment I’m tasked with looking into the technical feasibility. I almost posted as an new user for this question.

I can see nothing in standard functionally - has anyone developed anything custom or been down this route before.

 

Thanks,

Matt

1 reply

P
Rank

Hello Matthew,
Maybe you can think about using Customer Offset Proposals for this purpose - it is a part of standard functionally.
You can find it there:
Financials\Accounts Receivable\Manual Payment\Customer Offset Proposals
It looks for open customer items and try to match them, also you can use Allowed difference there to find
more matches. I don't know if it uses checks also, but you can try. If not - it can be a base for a future customization.
Best Regards,
Pawel Dworzynski
 

Reply


Terms & ConditionsCookie settings