VAT per line - Journal upload into NetSuite

HuwFinance Expensify Customer Posts: 2 Expensify Newcomer

Morning all

Hoping someone can assist - with the law changing and HMRC becoming a link to our ERP system and VAT returns becoming a linked affair. I am looking to ensure expenses are posted to the correct box in the VAT return automatically. We (royal we) use NetSuite and the journal upload calculates the total VAT amount and then posts as one line, instead of per line of the expense. I.e. using a tax code per journal line. Does anyone know how to change the journal upload so that the tax code is per journal line not a total at the end of the journal?