[GNC] Post invoice still wants to be paid

[David Briggs]

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

dlbriggs at cox.net <mailto:dlbriggs at cox.net> 

918 625 9170

 

From: David Cousens [mailto:davidcousens at bigpond.com] 
Sent: Monday, July 30, 2018 5:52 PM
To: David Briggs <dlbriggs at cox.net>; gnucash-user at 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