Although you should be able to have header row(s), perhaps remove it and
try again.
The Documentation for this is worded oddly, but the samples provided
don't show header info at all.
https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html
Regards,
Adrien
On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote:
Hello,
I'm having some issues importing a bill via CSV. I set up a trial run
and I'm getting the below errors. Vendor "000005" does not exist,
however that is the vendor ID for Amazon in my file. It says account
"Liabilities:Accounts Payable" does not exist (but it does). It says
the Expense account also does not exist (but it does) and then it
proceeds to ignore the line.
How do I correct this for proper import? I've had the same issue on the
Customer invoice import side as well.
This is on Ubuntu with Flatpak 5.5
Here is the raw CSV import:
"id";"date_opened";"owner_id";"billingid";"notes";"date";"desc";"action
";"account";"quantity";"price";"disc_type";"disc_how";"discount";"taxab
le";"taxincluded";"tax_table";"date_posted";"due_date";"account_posted"
;"memo_posted";"accu_splits"
"111-7425790-5888250";05/11/23;"000005";;;05/11/23;"Low Profile Fuse
Kit";;"Expenses:Auto:2016 Big
Country:BigCountryMaintenance";1;12;;;;;;;05/11/23;05/11/23;"Liabilitie
s:Accounts Payable";;"N"
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.
