Anyone successfully imports invoices incl. auto-posting them?

[Nelson Handcock]

What version of Gnucash are you using? .

I actually haven't had a chance to use that file successfully myself (have
a look in the mailing list archives for the Thread "Import Bills not
working"). According to the response I had from "Mike" - You need to be on
2.6.3.

I've had to re-build my laptop recently, so I haven't had a chance to test
it myself. But I had a similar file successfully load and post invoices.

If you can find the bills for the Vendor, and manually post them, then
perhaps try changing the csv file to hold the name of that account....

Hopefully this weekend I'll be able to get back into it and I'll let you
know how I get on.




Thanks & Regards,

Nelson Handcock

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

On Fri, Sep 12, 2014 at 12:47 PM, Arnd Vehling <Arnd at vehling.com> wrote:

> Hello Nelson,
>
> thx for the csv file. I did create the vendor "foodconnect" and an account
> named "Stock Expenses" under "Expenses".
>
> The importer shows all fields correct in the preview although the date and
> number formats are different from the ones used on my system. After hitting
> "Ok" in the importer window the result window says "6 Imports, no errors
> etc". But the "Stock Expenses" Account is still empty. I can find the bills
> under "Business->Vendors->Find" Bills though.
>
> Does "Stock Expenses" be of type "Stock"? Its a normal "Expenses" account
> atm.
>
> regards,
>
>    Arnd
>
> On 12.09.2014 03:42, Nelson Handcock wrote:
>
>> Hi,
>>
>> I hope this helps....
>>
>> Attached is a sample csv file for importing Bills. I'm pretty sure it's
>> the same as for importing invoices - it's just the account names, vendor
>> ID, etc that change.
>>
>> Pretty sure that Columns R, S, T have to be filled for the invoice to
>> auto-post.
>>
>> Hope this helps!
>>
>>
>>
>> Thanks & Regards,
>>
>> Nelson Handcock
>>
>>
>> On Thu, Sep 11, 2014 at 4:47 PM, Arnd Vehling <Arnd at vehling.com
>> <mailto:Arnd at vehling.com>> wrote:
>>
>>     Hello,
>>
>>     i am looking for someone who can import invoices and auto-posts them
>>     and the memo-text shows up in the corresponding account.
>>
>>     If there is someone, could you send me 1-3 lines sample csv for
>> testing?
>>
>>     As already mentioned in another thread i have the problem that the
>>     invoice preview is correct but not part of the data seem to end up
>>     in gnucash.
>>
>>     thx,
>>
>>        Arnd
>>     _________________________________________________
>>     gnucash-user mailing list
>>     gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
>>     https://lists.gnucash.org/__mailman/listinfo/gnucash-user
>>     <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.
>>
>>
>>  _______________________________________________
> 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.
>