[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