Prepayments are defined in QF as ‘Unassigned funds…’. But when I assign those funds to supplier’s invoices, the amount of Prepayments doesn’t decrease. It seems incongruent with the definition of prepayments, as well as with the equation Invoice Balance - Prepayments = Total
Are you able to give an example where you’re seeing this please? If you could provide me with the last 3 digits of your account number and invoice, I can find the supplier from there and take a look.
It looks like in some cases the transaction was imported, and other times it was created manually from the ‘Log Payment’ option on the invoice screen. This would override the duplicate checker.
It would be tricky. The duplicate checker also checks the description of the transaction. In some cases, you could be charging £5.00 on the same day to 10 customers, each same date and same value, but different description.
When you tag a payment from your invoice, the description will be pre-set by the system (similar to “Payment to Supplier Ltd”) which wouldn’t match up with the existing one on the statement.
I came up with the following scenario for the duplicate checker:
When I am tagging a payment from the bank account, the checker flags existing payments to the same supplier with the same date and the same amount.
If there was a way to display side-by side both:
the description of the NEW bank account transaction and
the Supplier Reference number of the invoice that the EXISTING payment is matched to —
then I could determine whether the two payments are identical. The reason is that I always have Supplier Invoice Ref Nos as a description of a bank transaction.
I guess it is rather convoluted and is probably difficult to pull off. Also, I’m not sure how many people have the same problem.
Is this candidate for a feature request or should we just drop it?
If you go to your bank statement view and search for a specific date when you know a payment was made, you should be able to see the duplicates on the bank. I recall from checking earlier an instance where one of the payments originated from a feed/CSV and the other was added manually.
On the bank statement view there will be an icon to indicate how the transaction was entered.
Do you remember how you lodged the prepayment, was it from the supplier detail screen? An event does get lodged here, although it’s referred to as a “credit” rather than a “prepayment” (which we will change).