Brian Dunning's FileMaker Custom Functions

PayRef ( reference )

European (structured) payment reference

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

Michael Bijnens   Michael Bijnens
freelance developer
/

Share on Facebook Share on Twitter

  Sample input:
PayRef ( 20130001 )
  Sample output:
+++002/0130/00176+++

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

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

This CF can only be used by European payment transfers !!!

I use this function for invoices or orders.

What do you need ?

1) A number field "number" with a generated number ( year & serial.. or something else )
2) A text field "payref" with auto calculation ( PayRef ( number ) ).

 

Comments

comment   comment, VR
Nov 26, 2013
What exactly is a "European payment transfer"? I cannot find any online resources mentioning it.


AFAIK, modulo-97 check digits are generated as follows:

SerialIncrement ( "00" ; 98 - Mod ( input ; 97 ) )

See, for example:
http://en.wikipedia.org/wiki/International_Bank_Account_Number#Generating_IBAN_check_digits

In your example using 20130001 as the input, the check digits would be calculated as "22" instead of "76".
 

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.