Request assistance for importing invoice/bill payments

[Nelson Handcock]

Hello Geert,

Thanks for responding. As per my screenshots on my dropbox (refer to my
original email). - I am successfully importing Bills and Invoices using the
importer tool, and I'd like to do similar with payments for the
transactions.

When I import Bills and Invoices, they immediately show up on the
Customer/Vendor Reports, but the test transactions I imported (qif
importer) as payments did not show up.
I figured out this is likely because the transaction is not linked to the
invoice - the "Ref" and "Action" fields were not filled, unlike others that
are processed manually when I use the ""Pay Invoice..." option. As you say
- it doesn't know about Invoices so that's fair enough.


The "Assign as Payment..." does literally nothing. I am in the list of
transactions for the Expenses:Accounts Receivable account - I highlight a
transaction and choose the option from the RH mouse button menu. And I see
nothing else at all. I was expecting at least a pop-up window to allow me
to update the Invoice number and the Action fields, or something...

I've done some googling and searching on the Tutorial Guide - I admit I'm
not sure if my expectation is reasonable or not. I can find some references
to the option being used, but I can't see anything to show me what should
be happening, or indeed whether I'm using it correctly.

I'm using Gnucash 2.6.3 - Build 166cbb7+ April 2014. I found a reference to
a bug dated Feb 2014 - not sure if this is telling me there is an issue or
there was an issue... :-)
http://lists.gnucash.org/pipermail/gnucash-patches/2014-February/028582.html


I have indeed thought about using the CSV transaction importer, but I was
hoping I would not need it, but I can have a closer look at it.

When I used the qif importer it automatically creates entries in the
Expenses and Income accounts. With the csv transaction importer I expect I
will have to build both these transactions separately, and maybe even have
them in separate import files (one for each account).
So at this stage the qif importer looked to be the better tool (2
transactions based on a single data source - no mucking around getting the
data into the correct columns, etc).

I've exported transactions into a csv file and I imagine I'd have to build
a csv file that has the same layout to use for imports. I'm happy to
explore the transaction importer approach more, if that's going to be the
best thing to do.

Your advice will be appreciated...



Thanks & Regards,

Nelson Handcock


<http://www.linkedin.com/in/nelsonhandcockaustralia>

On Sat, Sep 27, 2014 at 6:22 PM, Geert Janssens <geert.gnucash at kobaltwit.be>
wrote:

> Hi Nelson,
>
> That's an interesting approach you are trying there.
>
> The qif importer unfortunately does not know anything about invoices or
> payments. It only understands transactions.
>
> To get to your final goal of linking payments with invoices/bills I see
> two options
>
> - either you forget about the qif importer altogether and instead
> experiment with the csv invoice importer. I have no experience with it
> myself though, so perhaps this is not a reasonable approach.
>
> - or you can effectively use the "Assign as payment" option. You say it
> doesn't do anything which is not my experience.
> What did you try, what happened and what were you expecting ?
>
> Geert
>
> On Saturday 27 September 2014 08:56:46 Nelson Handcock wrote:
> > Bump
> >
> > Thanks & Regards,
> >
> > Nelson Handcock
> > 0409 149919
> >
> > http://www.linkedin.com/in/nelsonhandcockaustralia
> >
> > On Sat, Sep 20, 2014 at 10:12 AM, Nelson Handcock
> > <nelson.handcock at gmail.com
> > > wrote:
> > >
> > > Hi,
> > >
> > > Could someone please advise on how best to import transactions into
> > > Gnucash, so that invoices are paid?
> > >
> > > I'm running Version 2.6.3, Windows 8.1, Asus Laptop
> > >
> > >
> > > I have documented the procedure that I followed to import the QIF
> > > file that was generated from the bank transactions - they are
> > > imported successfully into the nominated accounts, but they are not
> > > associated as payments to the invoices and I can't see how to get
> > > this to occur.
> > >
> > > When I run a customer report, the transactions do not appear - I
> > > assume this is because they are not considered as payments, and I'm
> > > trying to get this to occur.
> > >
> > >
> > > A copy of the QIF file I used as a test is here...
> > > https://www.dropbox.com/sh/rr5nlo3qleaqnps/AAA7brNX4loV-B5nX_LgYIYKa
> > > ?dl=0
> > >
> > > A copy of screenshots of the import and the results is here...(Word
> > > 2007)
> > > https://www.dropbox.com/sh/rr5nlo3qleaqnps/AAA7brNX4loV-B5nX_LgYIYK
> > > a?dl=0
> > >
> > > When I look at the imported transactions, there does not appear to
> > > be any way to change the "Ref" or the "Action" columns. (The
> > > transactions in the screenshot that do have these columns set were
> > > processed manually)
> > >
> > > There seems to be a menu option "Assign as Payment..." but this does
> > > not appear to do anything. I think this may be listed as a problem
> > > already.
> > >
> > >
> > > Any advice would be appreciated!
> > >
> > >
> > > Thanks & Regards,
> > >
> > > Nelson Handcock
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
>