Payments not applied to correct Invoice Numbers

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.

6 Posts

Contributing User

6Posts

2Kudos

0Solutions

Send Message

We utilise Sales Invoice numbers with Alphanumerical numbers - both alpha numbers before and after a numerical number.

I have found that when importing payments to invoices, the payments are not applied to the exact match of the invoice number, but instead to an invoice with just similar numerical values.

ie. Payment for invoice number ABC1234AB is applied to ABC1234A as it only looks for the numerical values because the invoice numbers are different lengths?

I am assuming it looks for the match of the leading characters and if found applies payment to that invoice, but there is actually an invoice in the system with an exact match with an additional character at the end of the invoice?

How can we ensure that the payment is applied to the correct invoice with an exact match and rejects payment if it cannot find that?

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search

Get the conversation started and make a new post Start a Post