David,
Actually, I misled you in my original post (due to my novice standing with the community). The document in question is actually a vendor bill (I now understand the difference between a bill and an invoice). However, I think you information below would still apply. I will continue to hunt for a solution, other than starting over on my database to get rid of this issue. There should be a better way. Thanks for your help. David Briggs dlbri...@cox.net <mailto:dlbri...@cox.net> 918 625 9170 From: David Cousens [mailto:davidcous...@bigpond.com] Sent: Monday, July 30, 2018 5:52 PM To: David Briggs <dlbri...@cox.net>; gnucash-user@gnucash.org Subject: Re: [GNC] Post invoice still wants to be paid David, I honestly don't know how an unposted invoice appears in the XML file. By default, the XML file is stored in a gzipped state. If you edit the preferences in the General tab there is a checkbox for Compress files. Unselect that and File->Save or -> SaveAs to get the uncompressed version. I have opened an uncompressed version of a test file I use for investigating how GnuCash functions. If you search for the tag <gnc:GncInvoice version="2.0.0"> you can locate the invoice records between that and the </gnc:GncInvoice> tag. If it is posted there will be a tag <invoice:posted> <ts:date>2018-07-20 00:00:00 +1000</ts:date> </invoice:posted> within that structure. There does not appear to be a link from this record to a payment - that is possibly elsewhere in the file . The invoice does contain links to the guid for the post transaction which may allow you to identify the payment transaction. It may not simply be a matter of changing that entry however to post and unpost an invoice as that action may also affect records elsewhere in the structure of the book. If you do attempt to edit it, keep an original copy you can restore. I would only use this to identify the invoice numbers, tag <invoice:id>000003</invoice:id>, for any invoices you think are a problem in the XML file and then use the Business->Customer->Find Invoice dialog to pull them up and make any modifications within GnuCash. If the payment has become separated , it is possibly easiest to delete the payment transaction and then unpost the invoice, repost it and enter the payment details using the Process Payment entry to assign the payment to the specific invoice. One of the main developers may be able to provided more help. Hope this helps David Cousens _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
