[GNC] accumulate split with import Invoices CSV doesn't work

GNUCash gnucash at boeziek.nl
Mon Jul 8 03:53:39 EDT 2024


Hello,

I import Invoices using CSV files; created using python.
When an Invoice has multiple items/lines and accu_split is set as “X” in the CSV file, it doesn’t use the accumulation. The importer recognises the accumulate split column, so everything is in the correct column.

I need to manually unpost and repost that invoice for the accumulate split to function.

See part of a CSV: Order ending with 1114 is 1 Invoice after the import with 3 lines. The X-es for tax do work fine.


id	date_opened	owner_id	billing_id	notes	date	desc	action	account	quantity	price	disc_type	disc_how	discount	taxable	tax_included	tax_table	date_posted	due_date	account_posted	memo_posted	accu_splits
#202111115	2024-06-15	000001	#202111115	Order #202111115	2024-06-15	Order #202111115	Material	Income:Revenue	1	100				X	X	VAT	2024-06-15	2024-06-15	Assets:Debiteuren	Order #202111115	X
#202111114	2024-06-10	000001	#202111114	Order #202111114	2024-06-10	Order #202111114	Material	Income:Revenue	2	25	

X	X	VAT	2024-06-10	2024-06-10	Assets:Debiteuren	Order #202111114	X
#202111114	2024-06-10	000001	#202111114	Order #202111114	2024-06-10	Order #202111114	Material	Income:Revenue	1	50				X	X	VAT	2024-06-10	2024-06-10	Assets:Debiteuren	Order #202111114	X
#202111114	2024-06-10	000001	#202111114	Order #202111114	2024-06-10	Order #202111114	Material	Income:Revenue	1	150				X	X	VAT	2024-06-10	2024-06-10	Assets:Debiteuren	Order #202111114	X

Thanks for any suggestion, perhaps it is a bug?

Best,
Etienne



More information about the gnucash-user mailing list