Our v9.0.1 Business is set up for Vat-inclusive products and shipping and, from the customers point of view, everything works fine. The orders have the vat calculated as expected.
Once the orders are downloaded we use the 're-export to files' function to import the resulting data into our third party mail order program.
We have a carriage charge of £4.99 including VAT. However, We are finding that the shipping charge is imported as in as VAT-exclusive (£4.99 ex-vat).
Looking at the Actinic generated 'orders.csv' file, the field 'Shipping Total Cost' contains the correct carriage charge (£4.99) but the field 'Shipping Tax Cost 1' has a 0 in it. If I change this to a '1' the order will import with a gross shipping charge (£4.99 including VAT).
My question, therefore, is how can I get the Actinic export to put a '1' in the 'Shipping Tax Cost 1' column thereby telling our software that the carriage charge is VAT inclusive?
Many thanks.
Waggers.
Once the orders are downloaded we use the 're-export to files' function to import the resulting data into our third party mail order program.
We have a carriage charge of £4.99 including VAT. However, We are finding that the shipping charge is imported as in as VAT-exclusive (£4.99 ex-vat).
Looking at the Actinic generated 'orders.csv' file, the field 'Shipping Total Cost' contains the correct carriage charge (£4.99) but the field 'Shipping Tax Cost 1' has a 0 in it. If I change this to a '1' the order will import with a gross shipping charge (£4.99 including VAT).
My question, therefore, is how can I get the Actinic export to put a '1' in the 'Shipping Tax Cost 1' column thereby telling our software that the carriage charge is VAT inclusive?
Many thanks.
Waggers.
Comment