ledgersmb / LedgerSMB

Double-entry accounting & ERP for the web
https://ledgersmb.org
Other
408 stars 150 forks source link

Cannot import using existing headers into Chart of Accounts using CSV #8221

Closed lumberjacklv closed 3 weeks ago

lumberjacklv commented 3 months ago

Version

1.11.14

What browsers are you seeing the problem on?

This problem isn't browser related

What happened?

When attempting to upload a CSV with Accounts that reference an existing header, the import will fail with an error:

Unable to resolve heading 5000 to its id; available: at lib/LedgerSMB/Scripts/import_csv.pm line 378

What should have happened?

I am expecting that I should be able to reference existing Headers that are defined already when creating a Chart of Accounts upload.

neilt commented 1 month ago

Can you provide a 3 or 4 line example of the CSV file you are trying to import?

ehuelsmann commented 3 weeks ago

This is a duplicate of #7853 which includes a work-around export in the form of a query database query.