Anyone successfully imports invoices incl. auto-posting them?

[Buddha Buck]

It sounds like the CSV file wasn't set up for auto-posting.

Here's a line that I believe I've gotten to auto-post as an invoice:

FF-1407,2014-09-12,FF,,,2014-07-07,Basic membership for
2014-07-07,,Income:Membership
Dues,1,20.00,%,,0,,,,2014-07-07,2014-07-14,Assets:Accounts Receivable,,

It requires an Income account called "Income:Membership Dues", and a
customer with a customer ID of "FF"
It should have a posting date of 2014-07-07, a due sate of 2014-07-14, a
quantity of 1, a total cost of 20, 0% discount.


On Thu, Sep 11, 2014 at 10: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.
>