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

Adrien Monteleone adrien.monteleone at lusfiber.net
Mon Jul 8 15:37:00 EDT 2024


Verify that Preferences > Business > General > 'Accumulate splits on 
post' is checked.

While you are indicating to do so in the import, the posting code might 
be reading the preference and overriding your column.

If the devs intended that column to work the otherway and override the 
preference, then yes, I'd say it is a bug.

If you have that preference check, then definitely a bug.

Regards,
Adrien

On 7/8/24 2:53 AM, GNUCash wrote:
> 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?



More information about the gnucash-user mailing list