CheckVatBE ( vat )

Check if VAT number is correct ( BELGIUM )

Average rating: 4.2 (30 votes) Log in to vote

Michael Bijnens
freelance developer
/

Sample input:

CheckVatBE ( 456994120 )

Sample output:

IF CORRECT = 1
IF INCORRECT = 0

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/* ============================================
#
# Purpose:			check belgian VAT number ( BTW nummer )
#
# Arthor:				Michael Bijnens
# Creation date:		01/01/2014
#
# Note:				this version is only compatible for Belgian VAT numbers!
#
=============================================*/


Let (
	[
		vat = Filter ( vat ; "0123456789" ) ;
		vat = Right ( vat ; 9 ) ;
		control = Right ( vat ; 2 ) ;
		divisor = 97 ;
		number = Left ( vat ; 7 ) ;
		rest = Mod ( number ; divisor )
	] ;

	Case ( 
		
		divisor - rest = control ; 
		True ;
		False
	)

)

Michael Bijnens - Junior FileMaker Analyst / Programmer
---------------------------------------------------------------------

You can use this custom function to check belgian VAT numbers.

FIST you need another custom function " VatFormat " to correct the format of the vat input.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

CheckVatBE ( vat )

Comments

Support this website.

Support this website.