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)
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.
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?
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