Summary
When trying to submit the first VAT return for a new company, the following error appeared;
Application Error
Table: VATFRMENTD FFED
Key: 0
No Current Records
Description
Cause
The VATFRMENTD table cannot populate without a valid VATID sequence number. This value was missing.
Resolution
CAUTION: Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.
Navigate to;
1. Development > Utilities > Miscellaneous > Sequence Number Values
2. In the Seq Counter field, add VATID and press enter
3. In the Next Value, if blank enter a value or if populated add the next number in the sequence
4. Click save and exit
5. Try submitting your return once more
Defect ID
X3-232847