[GNC] Trouble importing bills via csv

[Adrien Monteleone]

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"