In looking at the alternative to the TSO data file we spot a problem regarding the duty calculation. You currently give us the duty expression as a single string, e.g. “8.60 % + 20.20 EUR / 100 kg MAX 19.40 % + 9.40 EUR / 100 kg”
e.g. commodity 2105001000
You should give us the data in the same way that the TSO file used to:
- It separates the data fields out into separate elements. For example, the above would be expressed as
a. Ad valorum rate 1 = 8.60
b. Specific date 1 = 20.20
c. Ad valorum rate 2 = 19.40
d. Specific rate 2 = 9.40
e. Unit of quantity 1 = “per 100kg”
f. Unit of quantity 2 = “per 100kg”
- It gives us the Calculation formula = “16” meaning “Ad valorem plus specific subject to a maximum ad valorem plus specific”
Once we know formulae #16, and all the parameters’ values, we know how to apply the parameters to perform the calculation.
Receiving the duty expression as a string doesn’t allow that. We have a terrible job of chopping up the expression to extract the parameters, but we do not have information about the formulae.
Your JSON service does not list those data – which must be available to HMRC because they go into the TSO file.
Instead the JSON file sends back a human-readable block of text:
Yes, human-readable, even though this is supposed to be a computer-to-computer service.
So the service is not suitable as a replacement for the TSO file as it does not give us the data we need.
Please give us the duty expression as a set of parameterised fields.