[GNC] Issue with Balances and Phantom Transactions

[Grant Alexander]

This is my first post here.

I have been belting my head against a brick wall to trying to solve a
problem (presumably of my own making).

Background
Running Gnucash 2.6.17 on Linux (Fedora 24) using a MySQL database.   I
know stuff is a bit antiquated but this is to keep costs down as I am
keeping accounts for an incorporated society.

This issue presented itself when I was reviewing Receivables Aging.  
We invoice members once a year and receive payments in March/April.  
We offer a discount on membership if paid before 31 March and the
member can take that up by paying their dues $10 short.  I create a
credit note and apply it, along with their original invoice against the
bank account.   All good.  

However, I have sometimes messed up and an applied transactions to the
wrong date and then gone in and updated the dates in the Bank Account
which has then corrected the date in Accounts Receivable.  But the
Receivables Aging has then looked like the attached.  Selection_047.png

Somehow the transactions have become orphaned.   The AR is overstated.
  But the invoices have been credited, the Bank Account is correct.

I have also ended up with a similar scenario in Accounts Payable where
I posted a Bill that was supposed to be dated 31/12/2021 but ended up
31/12/2022.   I corrected the date in the AP transactional window and
then I ended up with Orphaned transactions.

I am happy to share my database with anyone who may be able to unravel
this.   I found there were records in "invoices" where owner_type=0
which accounted for these errant transactions.  I also found the
corresponding entries in entries and slots but I can't figure out how
to fix them or whether there are records elsewhere I need to locate
too.

Any help would be gratefully received.


-- 
Grant Alexander
Ngapouri Highlands
https://www.ngapourihighlands.co.nz
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Selection_047.png
Type: image/png
Size: 26686 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220422/4a00ee0c/attachment-0001.png>