Anyone successfully imports invoices incl. auto-posting them?

Arnd Vehling Arnd at Vehling.Com
Fri Sep 12 01:33:36 EDT 2014


Hello Nelson,

i did create a new chart of accounts with the wizard, setup 
test-customers and the "foodconnect" vendor as well as an 
"Expenses:Stock purchased" account and it works now.

Based on your csv file ive created a new invoice csv test import like 
this (see also attachment)
--
104;19/06/2014;GUEST;;;19/06/2014;Room 
Rent;;Income:Rentals;1;891,23;;;;y;;;19/06/2014;26/06/2014;Assets:Accounts 
Receivable;Rental Invoice No 5;y
--

Which also works as expected.

I need to use ";" instead of "," because i am using "," as decimal 
seperator. Part of the problem seems to root in my using european 
formatting for date and numbers.

The only differences to my old import format, which didnt import 
correctly, which are see are that

- i used EU date format, i.e. "19.6.14" and
- EU number format, i.e. "125,11" instead of "125.11"
- the last field in my format was always empty instead of "y"

When i tried to import Nelsons data as ";" seperated and left the number 
format at "####.##" it worked but only the integer part would be 
imported without creating ANY error messages. Which i consider highly 
dangerous for an accounting program.

In my opinion there should be a BIG Huge Warning on the top of this doc 
page
http://www.gnucash.org/docs/v2.4/C/gnucash-guide/python-import-invoices.html
that the preview is not accurate and if you can see something correct in 
the preview it doesnt mean its imported correctly although there are no 
errors reported!

Also it should be noted that the preview doesnt do any consistency 
checks he could do, like checking for an compatible date and number format.

@Mike, in case you are reading this, where would one need to add the 
missing validation to the importer? Maybe i can look into this. Should 
one alter the regexp? That should be enough for at least basic 
consistency checks, right.

thx for the help guys!

cheers,

   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.
>
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test_customer1.csv
Type: text/csv
Size: 901 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20140912/e779fdaa/attachment.csv>


More information about the gnucash-user mailing list