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.
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?
Best Wishes,
Chris Travers