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 <[email protected]
<mailto:[email protected]>> 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<https://woden.titley.com:10000/postgresql/exec.cgi#>*
*chart_id<https://woden.titley.com:10000/postgresql/exec.cgi#>*
*amount<https://woden.titley.com:10000/postgresql/exec.cgi#>*
*transdate<https://woden.titley.com:10000/postgresql/exec.cgi#>*
*source<https://woden.titley.com:10000/postgresql/exec.cgi#>*
*cleared<https://woden.titley.com:10000/postgresql/exec.cgi#>*
*fx_transaction<https://woden.titley.com:10000/postgresql/exec.cgi#>*
*project_id<https://woden.titley.com:10000/postgresql/exec.cgi#>*
*memo<https://woden.titley.com:10000/postgresql/exec.cgi#>*
*invoice_id<https://woden.titley.com:10000/postgresql/exec.cgi#>*
*entry_id<https://woden.titley.com:10000/postgresql/exec.cgi#>*
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
<-
<https://woden.titley.com:10000/postgresql/exec_form.cgi?db=homechip>
Return to execute SQL form
<https://woden.titley.com:10000/postgresql/exec_form.cgi?db=homechip>
| Return to table list
<https://woden.titley.com:10000/postgresql/edit_dbase.cgi?db=homechip>
| Return to database list
<https://woden.titley.com:10000/postgresql/index.cgi>
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
------------------------------------------------------------------------------
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
