Hi,
when I tag invoices and credits to be paid in QF against a statement it matches until I get to the make a lump sum payment.
The total is correct when I select all invoices/credits to be paid. When I go to make a lump sum payment QF untags the credits so my total is too high. I’ve previously asked how to ensure this does not occur so my total matches the supplier’s statement I was advised to upload credits notes and apply them as credits against the original invoice, not as separate credits. I’ve been doing this for a couple of months now and I still have the same problem.
I’ve created a few dummy invoices to try and replicate what you’re experiencing.
I have 3 invoices, and partially credited one of them, so I have the following (for the purpose of this explanation, I have shown the original, and the credited invoice with the pink arrows):
In this case, it’s unchecked my credit note - as expected. So, I’m left with 3 unpaid invoices. Ticking them will show the full balance due, because at this point the system doesn’t take into consideration any partially paid invoices.
However, when I go to pay them, the amount changes:
Hi,
thanks for trying, but I wonder if you would try again but with invoices over a two month period. Them add a credit generated in the 2nd month for an invoice for the first month. I think you will then reproduce my issue.
regards
Sue
Are you able to confirm the invoice numbers and the credit note number from your account please, and hopefully I can see the exact issue you are seeing?
This is for Plumbase April dated invoices and credits. Combined should total £1885.99 and does total this when I select them all invoices and credits. Then when I say pay in a lump sum, QF untags the credits (stating already paid) and total ,so it shows a total payment of £2334.86. My boss thinks I have allocated credit payments on the supplier’s account in QF and that this may be the issue? I have already tried to delete the payment and start again matching necessary invoices and credits, but this total payment now seems to be locked.
If you have credit held on account then try logging a payment against one of the invoices and you should see an “apply from credit” option. Once you’ve applied the credit to part-pay that invoice then the remaining balance for the month should be the amount you think you owe.
