• mf51
  • New member
  • Offline
  • Registered: 03/05/2014
  • Posts: 3

Topic: payed invoices stay ind overdue list

Hi all,

I'm new to this forum and post here because I have a (small) problem:

Even I have registered customers payment I have an invoice staying in the list of overdue sales invoices on the sales-mainpage. The strange thing is, that the rest-payment is set correctly, to 0.
How can I remove this invoices from the list (except playing around manually in the database…)?

I'm using version 2.3.19 and this is how it happened:
- The customer had two open invoices and payed both in one payment.
- I went to customer payment where both invoices have been listed and used "All" to mark both of them.
- The total amount was shown correctly and after pressing "add payment" only the second invoice disappeared from the overdue sales invoices list.
- The first invoice stays in the list with 0 € left to pay.

Now I want to make this invoice disappearing from that list as well.

Any idea?

Thanks
Martin

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: payed invoices stay ind overdue list

Are there some rounding problems?

Joe

  • mf51
  • New member
  • Offline
  • Registered: 03/05/2014
  • Posts: 3

Re: payed invoices stay ind overdue list

I thought about that as well. The source for such rounded amounts could be the VAT…

But if I press "All" I expect that it it is taking ALL - even the rounded digits. I could follow that explanation if I would have entered an amount for the payment and would have assigned this payment to the invoices in a second step. Than it could happen that there stays a difference because of rounding. But I did that way that I marked both invoices as fully payed in one step.

How can I find out? Searching in the db-tables? Where?

Martin

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: payed invoices stay ind overdue list

Please look into the table X_debtor trans, where X is the client number. Look if the invoice total is equal to the allocated.

Joe

  • mf51
  • New member
  • Offline
  • Registered: 03/05/2014
  • Posts: 3

Re: payed invoices stay ind overdue list

The amount in in X_debtor_trans is the allocated one. In X_debtor_trans_details I notice that some items from that invoice have unit_tax-values with much more than just 2 digits, which are not rounded. But this is true for many other invoices too - and they don't cause that problems.

Martin

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: payed invoices stay ind overdue list

ok, thanks. I will investigate further.

/Joe