How to set Description on A/R when importing invoices

Arnd Vehling Arnd at Vehling.Com
Fri Sep 12 01:37:11 EDT 2014


Hello Mike and thx again for your support,

On 08.09.2014 16:41, Mike Evans wrote:
> I mis-read your original mail and though you had written an importer in
> Python.  Having now read the rest of the thread I see the issue is with
> importing csv created by your python program.
>
> Have you set the fields, date_posted, due_date, account_posted as
> well as memo_posted?

i initially had date_posted empty because i assumed that it would set to 
the current date if empty but i have it set since a couple of days now.

> However having just tested it, it works on my system.  Try the
> following line to test the importer:
>
> MEC-0172,,000013,,,,34-0655 > PROTOBLOC 2 BREADBOARD,ea,Expenses:Materials General,1,4.39,,,,no,,,,,Assets:Accounts Receivable,Memo,y

i had to change 2 fields (Cust-ID and Price), did create 
"Expenses:Materials General", then i did import this:
--
MEC-0172,,GUEST,,,,34-0655 > PROTOBLOC 2 
BREADBOARD,ea,Expenses:Materials General,1,5,,,,no,,,,,Assets:Accounts 
Receivable,Memo,y
--

I get "1 Lines imported, 1 fixes, 0 ignored, 1 created"

Question: If i import to "Expenses:Something", shouldnt the  Post-To 
Account be "Liabilities:Accounts Payable" and if i sell something going 
to "Assets:Accounts Receivable"?

> You will probably have to change some fields to suite your account
> layout. Obviously don't use your production gnucash file.

I am working on a brand new test-account-template created with the 
wizard, 3 customers and 1 vendor. After one import i reload the template 
again and restart with empty accounts.

> After import
> view Assets:Accounts Receivable in double line mode and you should see
> "Memo" in the memo field.

Its set now. Importing this works:
--
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
--

thank you for your help!

cheers,

   Arnd


More information about the gnucash-user mailing list