#176 Error while maintaining Payee List

1.0_and_below
closed-fixed
Stefano
6
2011-01-05
2010-03-21
Anonymous
No

While trying to maintain the payee list through "Organise Payee" option under "Tools", I'm getting an error "Payee is in use". However there is no transaction against that payee as I've changed the payee for that transaction while reconciling the transaction. This has happened for quite a few transactions. This is specifically true for the payments that I've done throu electronic fund transfers.

Discussion

  • Stefano

    Stefano - 2010-12-21
    • priority: 5 --> 6
    • assigned_to: nobody --> stef145g
    • status: open --> open-accepted
     
  • Stefano

    Stefano - 2010-12-21

    I have localised a problem because this happened to me: When I changed my transactions from deposits/withdrawls to transfers, clearing the links to payee, then attempted to delete the payee caused an error: Payee in use.

    This can be confirmed as follows: Make a copy of your database. With the copy,
    access the database direct, then execute the following SQL statement:-
    select * from checkingaccount_v1 where transcode = "Transfer" and payeeID > 0
    To these transactions, identify the payee, then manually set the payeeID to -1
    When this is complete, attempt to delete the payee in MMEX.

    If this fixes the problem and is the only problem, then I will issue the fix to this.

     
  • Stefano

    Stefano - 2011-01-05

    Fixed. Please see previous comment

     
  • Stefano

    Stefano - 2011-01-05
    • status: open-accepted --> closed-fixed
     


Anonymous

Cancel  Add attachments





Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks