# PayRef ( reference )

European (structured) payment reference

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

Michael Bijnens freelance developer / |

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, 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". |
||

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