Problem with customer payment - it will not apply to an invoice when it should.

  • 1
  • Question
  • Updated 4 weeks ago
A customer payment has been entered for $10000 and applied against open invoices of exactly $10000. There are no short payments or overpayments. The amount of the payment matches the open invoice amounts perfectly in the payments screen. After saving, strangely, $10 shows as open on 1 invoice, and the payment of $10000 is showing that $10 is unapplied. We have tried deleting the payment and re-entering. We have tried opening the payment and typing the full open amount of the invoice in the payment screen and saving again. This doesn't help. The invoice still then shows as $10 unpaid and the payment transaction shows as $10 unapplied. Reporting is showing an open balance, it is not just in the customer transaction screen that this is showing.  Any ideas to fix?
Photo of Fleur

Fleur

  • 180 Points 100 badge 2x thumb
  • bemused

Posted 4 weeks ago

  • 1
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 7,502 Points 5k badge 2x thumb
Hi Fleur, can you show us a screen dump of the invoice?  what tax codes are being used on the various lines?  are there negative lines with negative tax amounts?  this is usually what causes this type of issue.
Photo of Fleur

Fleur

  • 180 Points 100 badge 2x thumb
Hi Linda,

Yes there are negative lines.

Please see the screen dump below -



Photo of Linda Putland

Linda Putland, Accredited Partner

  • 7,502 Points 5k badge 2x thumb
This will be the cause of the problem... first suggestion - re arrange the invoice so that the negative lines are after the positive lines - may or may not help?  But probably in the end you will need to put the negative lines on an Adjustment Note and leave the positive lines on the invoice - then apply the adjustment note to the invoice and that should resolve the problem... (you will need to reapply the payment)... cheers Linda
Linda is write there it may be the negatives, but it usually happens when a negative follows a different tax type.  say if the negative has gst and it follows a positive fre or inp.  Another user had the same issue last week, there is a knowledge base for this.

I often do what you do without a problem and I see all yours have gst, when I do mine I start with the negative quantity.

Are you running stock control?  You will need the negative quantity if you do.

If Linda's suggestion doesn't work.....

What effect has it had on the customer balance, does it show the $10.05 unpaid or paid?

Can you see any payment in the customer that shows $10.05 open balance not applied?

Can you do a screen shot of the cheque payment?