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

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

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

Output from SQL command select * from ap where invnumber like '13735'; ..

id    invnumber    transdate    vendor_id    taxincluded    amount    netamount    paid    datepaid    duedate    invoice    ordnumber    curr    notes    employee_id    till    quonumber    intnotes    department_id    shipvia    language_code    ponumber    shippingpoint    terms   
15699 13735 2009-03-31 10217 0 465.23 465.23 465.23 2009-06-12 2009-04-15 1 1044 USD Please charge shipping to our UPS account and ship express. 10203


0



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

The transaction appears in the AP aging report and the AP overdue report. In the overdue report it shows with a total of 465.23 and a paid of 404.80

I can dig out more data if needed.

Nigel