Hi Nigel;
As discussed this is 1.2.21, right?
On Sat, Aug 4, 2012 at 8:41 AM, Nigel Titley <[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 [image:
> <-]<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.
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
------------------------------------------------------------------------------
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
