Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers

Check a UK VAT Number

This new option allows you to validate the VAT Registration Number that you receive from UK customers and suppliers against HMRC records. Applicable for users who have registered their Datafile software application for the submission of VAT Form 100 details this new option allows you to key <F11-Validate> on the VAT Registration and shows the details the HMRC hold for that customer/supplier.


Installation

This option is available immediately on update.

However, an additional option, available for Diamond and Premier users, allows you to save a HMRC reference number to the record to indicate you have validated the VAT Registration for the customer / supplier.

Database Changes

Changes are required to the Sales/Purchase Accounts to record the check reference. To add these items, select Installation from the main menu followed by Application Manager and then Restructure a Database. Select the Sales/Purchase Ledger application and elect to update the Live Files and then select the appropriate application file.

To insert a new item press <Enter> against a blank entry, enter the title as required and press <Enter>, select the item type (using the drop-down list if required), and depending on item type select the size required.

File           Item Name           Type      Description

SLA/PLA    VAT-CHECK-NO     X (20)   Holds the HMRC VAT Check Reference.

Once the required items have been recorded press the <ESC> key and select the UPDATE button to save the database changes. When prompted respond ‘Y’ to the prompts to ‘Extract Existing Data to New Database Structure’ and, if appropriate, ‘Copy Table Entries from Old Database to New Database. Final prompts ask to ‘Remove (.OLD) Database’ and to ‘Carry Out the Same Restructure on the BASE File as well’ – respond as required. If you select to update the base file you need to manually insert the new items at the same data item positions as on the live file.

Set Database Profiles

The new reference item for the sales/purchase account are referenced via the Database Profiles. To update select Installation from the main menu followed by Application Manager and Set Database Profiles.


 

The new Tax Ref Check item is referenced on the Account Mandatory parameter screen.

Custom Fields
  • Release ID: 7.5
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Include Currency Accounts in Auto-Payment Procedures
Viewed 1752 times since Fri, May 27, 2016
Select Key Definition
Viewed 1839 times since Mon, Jul 2, 2012
Increased Number of Entries in Allocations
Viewed 1823 times since Fri, Jun 8, 2012
Extra Account Items on Aged Analysis Reports
Viewed 18668 times since Thu, Jun 7, 2012
Account Currency Turnover - Database Profiles
Viewed 2491 times since Mon, Jul 2, 2012
Contact Management - Copy Items from Activity to Accounts and Contacts
Viewed 4139 times since Tue, Mar 3, 2020
Disputed Transactions - Record Reason for Dispute
Viewed 2358 times since Fri, Jun 8, 2012
Account Optional 4 - Database Profiles
Viewed 2360 times since Mon, Jul 2, 2012
Increased Size of User-2 / User-3 Items
Viewed 1819 times since Wed, Jun 13, 2012
Save and Exit - Document Design Manager
Viewed 1832 times since Mon, Jul 2, 2012