Integration Manager - VAT distribution error

[dweeze]

Heya,
I'm running an sales transaction integration. All works fine with my integration except when I try to include vat/ sales tax.

Installation is in Britain so the setup is VAT enabled. The line item I am entering is set to refer to debtor record. The debtor record I am entering has a Tax Schedule ID of 17.5% Sales, which corresponds with the Tax Detail ID of 17.5%S.

In the destination mapping I am setting the field, Sales Tax Detail Summary.Tax Detail Id to 17.5%S. All other fields in the Sales Tax Detail Summary are left to 'use Default' (I did this for debugging)
The Sales VAT Detail Summary, Line Item Taxes and Line Item VAT are set to use the 'Default' record source (ie not set to use the record source which holds the data to integrate) (again debugging).

When I try to run the integration it fails and throws the error "DOC 1 ERROR: Cannot integrate regular tax distributions when VAT is enabled."

Interestingly, I can put any value (except blank) into the Sales Tax Detail Summary.Tax Detail Id and it still generates the same error.

Can anyone please point me in the right direction to where this may be coming from.

Thanks

 

[baugie]

If you are using SQL Optimizer then VAT is not supported.

 

[dweeze]

No. Am using Integration Manager not SQL Optimiser. I figure that this is why its throwing the error. Somewhere along the line the logic layer is blocking it.