Invoice Importer

[Mike Evans]

On Mon, 20 Aug 2012 18:00:20 +0300
Reuben Cummings <reubano at gmail.com> wrote:

> On 8/20/12, Derek Atkins <warlord at mit.edu> wrote:
> > reubano <reubano at gmail.com> writes:
> >
> >> Mike Evans wrote
> >>>
> >>> On Sat, 3 Mar 2012 03:55:26 -0800 (PST)
> >>> reubano <reubano@> wrote:
> >>>
> >>>> I have successfully imported invoices but now there is a problem.
> >>>> After restarting gnucash, the invoices no longer show up in the
> >>>> "Find Invoice..." druid. Searching for all posted invoices only
> >>>> shows invoices not entered with the importer. Note: this only
> >>>> occurs after restarting gnucash. Before restarting, the newly
> >>>> imported invoices show up in the search results.
> >>>
> >>> Imported invoices are not posted by default.  Did you search for
> >>> ALL invoices.  Odd that a restart should lose data, I assume you
> >>> saved before restart.
> >>>
> >>>
> >>>>
> >>>> However, trying to edit the corresponding transaction in the
> >>>> asset account gives the following warning: "This transaction is
> >>>> marked read-only with the comment: 'Generated from an invoice.
> >>>> Try unposting the invoice.'"
> >>>>
> >>>> gnucash-2.4.10 built from source (applied row-skipping patch)
> >>>> with MacPorts 2.0.3 on MacOSX 10.7.2
> >>> The patch has now been applied to 2.4 branch and will be in the
> >>> next release.
> >>>
> >>> Mike Evans
> >>>
> >>
> >> I just tried using the importer on 2.4.11 and the same problem is
> >> occurring.
> >> Invoices and bills import just fine. But, after I post them and
> >> then restart
> >> gnucash, neither the new invoices nor bills show up in the druid.
> >> I'm using
> >> the mac binary.
> >
> > The patch he was referring to was for the "row-skipping" issue.
> >
> > The post/restart/not-showing is completely different.  Are you
> > using a SQL backend or XML?  And how do you "start" gnucash?
> >
> > -derek
> >
> 

I can reproduce this behaviour on linux too.  Obviously a bug.  On
reloading the sqlite file I see:

* 16:12:18  WARN <gnc.backend.sql> [load_invoice_guid()] Invoice ref
  '87c42b5bb338df5c665c49ce1d4422c4' not found
* 16:12:20  WARN <gnc.business.gnome> Can't find invoice
  87c42b5bb338df5c665c49ce1d4422c4 in current book.
* 16:12:20  WARN <gnc.business.gnome> Giving up on restoring 'Page 5'.
* 16:16:52  CRIT <gnc.backend.sql> gnc_sql_save_commodity: assertion
  `pCommodity != NULL' failed
* 16:16:52  CRIT <gnc.backend.sql> gnc_sql_save_commodity: assertion
  `pCommodity != NULL' failed

Please file a bug report for this. 

Note that the function works fine with the XML data storage.

Mike E

-- 
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.