FrontAccounting forum — Supplier invoice shows overdue

Re: Supplier invoice shows overdue

null@example.com (dz) — Sat, 28 May 2022 05:11:40 +0000

What is the GL entry of your Payment?(petty cash one)

Re: Supplier invoice shows overdue

null@example.com (maksud07) — Tue, 24 May 2022 17:25:52 +0000

Hello,

I have paid the supplier invoice but still, it shows credit 10590 and in account payable in the balance sheet also showing ap payable.

It is supposed to be no account payable. we paid it from petty cash.

Re: Supplier invoice shows overdue

null@example.com (dz) — Thu, 21 Apr 2022 15:21:22 +0000

Is the payment properly allocated to the invoice? kindly check the allocations.
In the DB you can further check in the debtor_trans table and see if the alloc column is filled
secondly supp_allocations table deals with the allocation of payment with the invoices

Re: Supplier invoice shows overdue

null@example.com (rafat) — Wed, 20 Apr 2022 18:18:56 +0000

It must be a date entry related issue. IMHO
Are you sure you entered the right invoice date..sorry I could be wrong. Also what version of FA you are running?
Please don't mess up with editing the DB directly. You will never get around it..one will end up with a messy business overall.

Re: Supplier invoice shows overdue

null@example.com (baxterdmutt) — Wed, 20 Apr 2022 00:40:53 +0000

To update, I tried going to setup and delete transaction. That got rid of the transaction but when I re-entered it and paid the invoice, it says it’s overdue again!!!

Supplier invoice shows overdue

null@example.com (baxterdmutt) — Tue, 19 Apr 2022 20:35:46 +0000

This is probably my fault but I have a suppliers invoice that shows overdue. The invoice is paid and the bank has had a credit entry. Everything is correct except the erroneous overdue marking. Can I just go into phpmyadmin and edit the database to remove the overdue. Where would I find that.
Just so you know this is probably an error I created editing another thing directly in the database.
Thanks.