[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Problem with paid invoices appearing on the Aging AP and Overdue reports



On 05/08/2012 03:02, Chris Travers wrote:
Hi Nigel;

As discussed this is 1.2.21, right?

On Sat, Aug 4, 2012 at 8:41 AM, Nigel Titley <..hidden..> wrote:
As discussed on the irc list.

I have an AP invoice that is fully paid but which appears on the AP aging and Overdue reports.

The acc_trans ap lines are as follows:

Output from SQL command select * from "acc_trans" where ("trans_id" = 15699); ..

trans_id    chart_id    amount    transdate    source    cleared    fx_transaction    project_id    memo    invoice_id    entry_id   
15699 10023 -281.95 2009-06-04
0 0

2214 9546
15699 10023 -130.01 2009-06-04
0 0

2213 9547
15699 10043 411.96 2009-06-04
0 0


9548
15699 10023 -318.4 2009-03-31
0 0

2222 9618
15699 10023 -146.83 2009-03-31
0 0

2221 9619
15699 10043 465.23 2009-03-31
0 0


9620
15699 10043 -465.23 2009-06-12
0 0


10288
15699 13235 665.4 2009-06-12
0 0


10289
15699 13235 -260.6 2009-06-12
0 1


10290
15699 10087 60.43 2009-06-12
0 1


10291
<-  Return to execute SQL form  |  Return to table list  |  Return to database list

The ap table has

Could you provide a brief description of the accounts in question?  I am assuming 10023 is an inventory account, 10043 is AP, and 13235 is a cash account, right?  There are a couple things about the lines here that don't make sense to me and I am trying to narrow them down.

10023 is inventory control
10043 is Creditors Control
13235 is a cash account (actually my Forex trading account)

The first is the multiple AP lines.  It almost looks like the payment was reversed before it was applied.

Given that there are three different transaction dates there, can you provide a history of this transaction?  

It's a very long time ago and I can't really remember what happened. I know we were still getting the occasional crash on posting invoices at the time and this may be the residue. Also its entirely likely that I did something daft, but I wouldn't have molested the database directly, so whatever was done would have been through the web interface.
 
From the look of the transaction it was a payment of an AP invoice, in USD, from my forex account. On the screen it looks perfectly normal.

Nigel