HOME / COMMUNITY Switch to knowledge base

Purchase Invoice Import with multiple lines

#1

Hi, is it possible to import Purchase Invoices with separate items/categories as stated below to account for VAT and No VAT

E,g
Category Description Sub total VAT Rate VAT Total
Stock No VAT Food Supplies 143.38 20.00% 28.68 172.06
Stock [Asset] Food Supplies 318.77 0.00% 0.00 318.77

We buy products which are VAT and Non VAT on single purchases eg Food, non-food. Otherwise its a manual job to go in all invoices to amend which is a big job to do

Regards

#2

Looks like you asked the same question back in August:

http://community.quickfile.co.uk/t/import-sales-with-multiple-item-lines/3981

#3

Hi Glenn,

Similar but this time on purchases?

Can it be done

Regards

#4

The same applies to sales and purchase invoices, you can’t easily import this kind of structured data from a CSV file as you need parent and child rows. A CSV only has rows and columns (i.e. 2-dimensional data)

The only way to do this would be via the API using the Invoice_Create Method.

#5

Ok Glenn,

Do you have a sample one that I could use to test.

Regards

#6

Here’s an example of some XML you can use to create a new invoice:

http://www.quickfile.co.uk/WebServices/API/examples/invoices/invoice_create.xml

You can also test this yourself in our Sandbox area.

#7

Hi Glenn,

I’ll give this ago, thank you

one last thing which API would I use to Get a Purchase Invoice from a supplier to see what it entails

Regards

closed #8