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