[Ledger-smb-devel] Problem with paid invoices appearing on the Aging AP and Overdue reports

Sat, 04 Aug 2012 08:44:29 -0700

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

 





------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Ledger-smb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

Reply via email to