UK .iif import quickbooks re Invoices - VAT & terms query

[VicPinnacle]

I am trying to create a simple template to upload lots of invoices on one supplier. The .iif sample file provided by quickbooks is too complicated. I have had moderate success with the template below however it is not picking up the VAT and making it Z as requested, it is creating it as 0 which I don't want. I am also making it 30 days net terms which is inputting correctly in the field but it is not actually amending the due date to 30 days. Any help gratefully received. Thank you.

!TRNS,TRNSTYPE,DATE,ACCNT,NAME,AMOUNT,DOCNUM,MEMO,CLEAR,TERMS
!SPL,TRNSTYPE,DATE,ACCNT,INVITEM,MEMO,VAT,AMOUNT
!ENDTRNS
TRNS,BILL,19/12/2017,Accounts Payable,Puma UK Ltd,-3,10101010,,N,Net 30
SPL,BILL,19/12/2017,Cost of Goods Sold:Teamwear,12859,Z,3
ENDTRNS