VAT error: The input tax for this range hasn’t been entered

In Dynamics GP, the following messageĀ came up when I tried to calculate the VAT report: “The input tax for this range hasn’t been entered. Do you want to continue calculating?”

To fix the error, I ran the following SQL script against the company database to find earliest transaction date on the return:

selectmin(Docdate) from TX30000 where Included_On_Return = 0


IĀ found that the effective date needed to be set back to 30 Nov 2017 so that it pre-dated the earliest date included on the return. It appears that the VAT return was not run for Dec. 2017, so I ran it for both Dec. 2017 and Jan. 2018, and it completed without errors.