Hosea
4Penny.net
Points: 7650

2/7/2013 8:42:12 AM

Integration Manager - Converting the Credit Card Expiration Year

Recently I was involved in an Integration Manager integration that required SOP Payments, and some of those payments were credit cards. If they were credit cards there would be an expiration date; if cash or check there would be none

The challenge was converting '2013' to and integer value that would equate to the index of the dropdown box. There are about 10 items in the (GP2010) dropdown box, 1 = 2013, 2 = 2014, etc.

That realization alone took hours. This article is a short VBScript example of code that goes in the Expiration Year script that will make all this work .

4Penny.net
Version: GP 2010
Section: Integration Manager
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3