Sage 100

Does anyone know if there is a way to get the first four numbers of a credit card for reporting purposes? I need to sort by card type and they aren't always set up correctly in the system, e.g. the type might be Visa but it is actually an AMEX card. You can figure out the type by the first characters of the card number and while you can see the whole card number in invoice history inquiry (v4.3), it is not available in Crystal.

Dang!!!

I am sure @AlnoorCassim might be able to provide some data dictionary guidance to make this pipe dream report a reality!!!!

Can a script access the first four at entry time and then set the type based on that?

Wasn't there a way which required signing some type of form with Sage -- or maybe that was to get them to un-encrypt and fully display. My guess is that this is going to be tough in light of all credit card fraud issues.

Good thought @WayneSchulz - I am guessing that if @ThereseLogeais can get the field exposed in the data dictionary, her second issue will be the encryption display. Perhaps the encryption algorithm is such that the first garbled characters will be the same.......

I doubt it helps, but you really only need the first character to define type: 3 = A, 4=V,5=M, 6=D.

Any new news?

Jeff on my 4.30 it's not a dictionary issue. Rather the field stores the encrypted card number only. So one would need to have a way to decrypt the card then get the 1st four numbers.

An update: Turns out, this was due to the Website Pipeline integration passing the wrong card type. Emailed Brian Nunes who responded in three minutes and 20 minutes later, it was fixed. +1 for WSP!!

+100 for the power of 90 Minds....