When exporting the sales invoice info, is it possible to add columns to the data on the CSV file. At present when I export the data it only includes: Invoice, Date, Due Date, Client, Description. Total Amount and Satus.
I would also like to include the Item, quantity and VAT, is this possible?
It’s not possible practical to include line items when exporting invoices to CSV, as one invoice may have multiple invoice lines. CSVs are flat files and don’t do a great job at displaying such hierarchical data.
You could use the API instead, which will return the invoice data and line items as an XML document. You can use the API in sandbox mode for one-off testing but to really benefit from the API you would need to program your own interface, so it really depends on what you intended to do with the data and whether it’s worth developing such an interface.