[GNC] Trouble importing bills via csv

Alan Johnson alan at argentwolf.org
Sat Feb 24 11:15:33 EST 2024


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"

Thanks,

Alan 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: Image-LX0LJ2.png
Type: image/png
Size: 112990 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20240224/d1211c61/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5197 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20240224/d1211c61/attachment-0001.p7s>


More information about the gnucash-user mailing list