#352 Transaction Filter results in Payee_V1: 0 not found

1.0.0.0
closed-invalid
nobody
None
5
2014-03-30
2014-03-29
Anonymous
No

Transaction Filter selecting an existing Payee and nothing else. I get the filter report displayed and it look fine. But almost always I also bet this error: PAYEE_V1:314774 (or some other random number, the number varies even the filter and database are the same.

It fails on both 1.0.0.1 and 1.0.0.3 DEV:SVN-6230 (did not try it on other 1.0.0.X

Discussion

  • guanlisheng
    guanlisheng
    2014-03-30

    • status: open --> closed-invalid
     
  • guanlisheng
    guanlisheng
    2014-03-30

    It is caused by the dirty data in your database and we have some sample reports on forum as well. http://www.codelathe.com/forum/viewtopic.php?f=5&t=5454&hilit=dirty+records

    delete from checkingaccount_v1 where accountid = 314774 or toaccountid = 314774 ;
    delete from billsdeposits_v1 where accountid = 314774 or toaccountid = 314774 ;

     


Anonymous


Cancel   Add attachments