Merchant e-Solutions AVS Response Codes

Below are the Merchant e-Solutions AVS Response Codes:

 

Result Code	Response Message	Visa	MC	Amex	Response Definition
0	Approved	X	X	X	Address verification was not requested.
A	Address Match	X	X	X	Address match only.
B	Address Match	X			Street Address Match for international transaction Postal Code not verified because of incompatible formats (Acquirer sent both street and Postal Co
C	Service Unavailable	X			Street address and Postal Code not verified for international transaction because of incompatible formats (Acquirer sent both street and Postal Code)
D	Exact Match	X		X	Street address and postal code match for international transaction. AMEX only-Card Member Name incorrect, Postal Code Matches.
E				X	Card Member Name incorrect, Address and Postal Code match
F	UK Exact Match	X		X	Street address and postal code match. Applies to U.K. only. AMEX only-Card Member Name incorrect, Address Matches
G	Ver Unavailable	X			Non-US Issuer does not participate
I	Ver Unavailable	X			Address information not verified for international transaction
K				X	Card Member name matches
L				X	Card Member name and Postal Code match
M	Exact Match	X		X	Street Address match for international transaction AMEX only-Card Member Name, Address and Postal Code match
N	No Match	X	X	X	No address or ZIP/postal code match
O				X	Card Member Name and Address match
P	Postal Code Match	X			Postal code match. Acquirer sent both postal code and street address, but street address not verified due to incompatible formats
R	Retry	X	X	X	Issuer system unavailable, retry
S	AVS not supported	X	X	X	For Visa if present, may be replaced with ―U‖ for domestic or ―G‖ for International. MasterCard may not translate to another value. AMEX only-Amex Merchant ID (SE#) not allowed AAV function
U	Verification Unavailable	X	X	X	Address unavailable
W	Domestic and International 9 digit zip match		X	X	For Visa this code is not applicable, if a W returned Visa will replace with a Z for U.S. cards only. AMEX Only-No, Card Member name, address and postal code are all incorrect
X	Domestic and International 9 digit zip and address match		X		If this code is present in a response from Visa it will be replaced with a Y for Domestic cards only.
Y	Exact Match	X	X	X	Exact match, street address and postal code match
Z	Zip Match	X	X	X	5 digit zip match only

 

Enable Level 2 Processing Feature for Merchant e-Solutions

Solution:

•        No feature needs to be turned on both in Merchant e-Solutions and Netsuite as the credit card itself is the basis.

•         Netsuite automatically sends Merchant e-Solutions the required information for all credit card transactions for them to determine if a credit card is for Level 2 processing or not.

•         Merchant e-Solutions determines in their back-end if the transaction qualifies for the Level 2 processing rate.

•        Identified Merchant e-Solutions Level 2 card transactions have lower processing rate.

 

Immediately Display Shipping/Handling Cost for Multiple Item Fulfillments made for a Sales order.

Solution:
A. Create a saved search to show Shipping Items and their amounts.
1. Navigate to Transactions>Management>Saved Searches>New>Transaction.
2. Under the Criteria tab>Standard subtab:
>Type = Item Fulfillment.
>Shipping Lines = True.

3.  Under the Results tab>Columns subtab, mark the Show Totals check box and add the following:
>Item
>Created From

4. Under the Available Filters Tab:
>Select Created From fields..., then Internal Id.

5. Set a custom name for the search.
6. Mark the Result as Public and Available as Sublist View. 
7.  Save the Search.
 
B. Attach Shipping Search created to Sales Order via a Sublist.
1. Navigate to Setup>Customization>Sublists.
2. Under the Transactions Tab, select the Saved Search created.
3. Set a Label for the Sublist being created.
4. Select the tab you want top show this sublist in (for example "Related Records").
5. Mark the Sale checkbox to make it available on Sales Orders.
6. Hit Save.

Package Content Description will print only for international shipments in UPS Shipping Label

 

Solution:

 

Package Content Description is intended to be used for international shipments. Information entered on this field will be printed on the shipping label up to 30 characters. If you are using a domestic shipping service and entered information on this field, it will be saved in NetSuite but it will not be printed in the shipping label.

Using shipping method that charges per item on handling cost, why is there a Handling Cost calculated on an item with null handling cost on the item record?

Symptoms:
1) Item Record > Basic Tab > Handling cost is null.
2) Shipping item used is set to charge handling cost per item.

 

If the item record does not have a specific handling cost value or null value, then the shipping item used on the sales order will trigger the handling cost calculation.

If you do not want the item to calculate handling cost, enter zero as handling cost in the item record

Test AVS or CVV/CVC for processing Merchant eSolutions transactions

Address Verification Testing

The card associations have developed Address Verification as a tool to assist a merchant in processing a transaction based on information submitted that is compared to the credit card billing address. In order to test the variety of possible responses, the table below can be used. Defined input values will result in responses as described:

Street Address	Zip Code	AVS Result Code
123	55555	Y – street and postal code match
123	999991111	Y – street and postal code match (Visa)
		X – street and postal code match (MasterCard)
123	EH8 9ST	D - exact match, international
123	Other Zip	A - address match, zip mismatch
234	Any Zip	U - address unavailable
345	Any Zip	G - verification unavailable due to international issuer non-participation (Visa and MasterCard only)
456	Any Zip	R - issuer system unavailable, retry
Other Address	55555	Z - address mismatch, 5-digit zip match
Other Address	EH8 9ST	Z - address mismatch, international zip match
Other Address	999991111	Z- address mismatch, zip match (Visa)
		W- address mismatch, zip match (MasterCard
Other Address	Other Zip	N - address and zip mismatch

CVV, CVC, CID Testing

This table tests CVV, CVC, and CID which is the 3 or 4 digit code printed on the back of a card. This security feature assists merchants processing in a Card Not Present environment and receiving a positive response ensures the likely hood that the cardholder making the purchase is in physical possession of the card. Visa, MC, and Discover encode a 3 digit value on the cards and American Express encodes either a 3 or 4 digit value. Defined input values results in responses as described:

CVV / CVC Value	Result Code
123	M-Match
234	P-Not Processed
345	U-Issuer is not certified
else	N-No Match

This table will test American Express CID:

Reference: http://173.255.215.12/download/attachments/1411006/MeS_Gateway_v4+10_Oct+2013.pdf?version=1&modificationDate=1383236729166

 

Test Credit Card for Level 2 processing for Merchant eSolutions (MeS)

Test Card Numbers for Level 2 Processing:

The table below will generate as listed the commercial card response indicator for testing Business to Business transaction:

 

Reference: http://resources.merchante-solutions.com/download/attachments/1411006/MeS+Gateway+ver3.6+September+2010.pdf?version=1&modificationDate=1285017413967

Received Currency Type Not Accepted error when processing Multi-Currency transaction using Merchant eSolutions (MeS).

Received Currency Type Not Accepted error when processing Multi-Currency transaction using Merchant eSolutions (MeS). 

1. Payment Gateway profile is setup correctly in NetSuite to accept other currencies such as Euro.
2. Sales Order is on payment hold.
3. Payment Event details include Error Description: Currency Type Not Accepted 
 
Check if merchant account is set up for international process. Users can call their MeS Account Manager to help them with this. To process transactions in currencies other than USD: 
 
1. Users need to setup their merchant account with Merchant eSolution's international partner.
2. Users have to go through credit/risk approval process. 
3. Users need to have business presence and to be incorporated in European or other countries.  

Amount Driven Response Testing for Merchant e-Solutions

To enter amount on transactions gives several reason/description that can be used for testing purposes. In addition to testing for approval codes, this table allows testing for a wide variety of potential response codes:

Reference: http://173.255.215.12/download/attachments/1411006/MeS_Gateway_v4+10_Oct+2013.pdf?version=1&modificationDate=1383236729166?version=2&modificationDate=1344530752111

 

USPS Flat Rates packaging options are only available to Express Mail and Priority Mail Services.

USPS Flat Rates packaging options are only available to Express Mail and Priority Mail Services.  
Express Mail 
 
1. Flat Rate Envelope
2. Flat Rate Legal Envelope
 
Priority Mail
 
1. Parcel
2. Small Flat Rate Box
3. Medium Flat Rate Box
4. Large Flat Rate Box
5. Flat Rate Envelope
6. Flat Rate Legal Envelope
7. Flat Rate Padded Envelope
8. Flat Rate Gift Card Envelope
9. Flat Rate Window Envelope
10. Flat Rate Cardboard Envelope
11. Small Flat Rate Envelope
If you choose a Flat Rate option for services other than Express Mail and Priority Mail, you will get this warning message:
 

"The Carrier Packaging that you have selected is not valid for this item fulfillment. Usually this indicates the selected packaging cannot be used with the selected USPS shipping method, or the package weight is invalid. Please check the documentation for more details."

 
References:
http://www.usps.com/prices/priority-mail-prices.htm
http://www.usps.com/prices/express-mail-prices.htm
 

Compute For the Subtotal for Transaction Saved Searches

1. Navigate to Reports > Saved Searches > All Saved Searches > New.
2. Choose Transaction.
3. Under Criteria tab > Standard subtab, set Main Line = T.
4. Click the Results tab > Columns subtab, set the following:
    - Date
    - Name
    - Document Number
    - Formula (Currency) 
        Formula = {amount} - nvl({taxtotal},0) - nvl({shippingamount},0)
        Label = Subtotal
    - Amount (Tax Total)
    - Amount (Shipping)
    - Amount
5. Click Save & Run.
 
Note: The Subtotal is net of discount if added as line item.

Alternative for Formula (Currency):

    - Formula (Numeric) = nvl({totalamount},0)-nvl({discountamount},0)-nvl({taxtotal},0)-nvl({shippingamount},0)
        Label = Subtotal