Hi All,
Looking for some help on a workflow I made as a work around to credit card addresses not being stored with the credit card info.
I used ssario's solution here https://usergroup.netsuite.com/users/forum/product-areas/payment-processing/credit-card-processing/285324-is-card-billing-address-stored
with a workflow because I want it to auto fill the box, so I used a set field value action. I know that copy pasting the address may get forgotten so having it fill automatically is extra assurance.
Here's the process I did: [LIST=1]
[*]Create a custom entity field
- Setup > Customization > Entity Fields > New
- Label it accordingly. This is how the field will appear on forms. I used Credit Card Billing Street.
- Type = I suggest using a Free-Form Text (or any other text type field)
- Store value = Checked
- Applies to tab > check Customer box
- Display tab > Sub tab = Financial
- Display type > Preferably, set this to Normal so you can input the address on the field.
- SAVE.
[/LIST] Repeat the above steps to make another custom entity field, but label it Credit Card Billing Zip Code.
2. Create a custom transaction body field
- Setup > Customization > Transaction Body Fields > New
- Label can be copied from Step 1 (e.g. Credit Card Billing Street)
- Type = Free form text (suggestion)
- Store value = Checked
- Applies to tab > Check "Sale" and "Customer Payment"
- Display tab > Sub tab = Payment
- Display tab > Display type = Choose “hidden”
- Source List = Customer
- Source From = choose the custom field you created in #1. In my case, I selected "Credit card Billing Street" from the drop down.
Repeat the above steps to make another custom transaction body field, but label it Credit Card Billing Zip Code.
^the above step's thanks to ssario ^^
[LIST=1]
[*]The box for credit card billing street and zip now appears in the customer Financial tab, but it is hard to find and may get missed on future entries. I customized the customer form so that there is a Credit Card Information field group.
[/LIST]
Go to Customization>Forms>Entry Forms
Click edit on the form that needs editing.
Click on ‘Field Groups’ tab > ‘Financial’ tab
Add a new label “Credit Card Information” and click add
Click “Fields” tab > ‘Financial’ tab
Find our entities that we created Credit Card Billing Street and Credit Card Billing Zip. Change their ‘field group’ to Credit Card Information in the drop down.
If there are any other entities that do not have an assigned field group, either add them to the field group above ‘Credit Card Information’ or create a new field group to place them in because if you don’t they will incorrectly appear in our credit card Info group
Click save
Repeated for any other relevant forms.
[LIST=1]
[*]Creating the Workflow to auto populate customer payments when a credit card is the payment method.
[/LIST] Customize> Workflow>Workflows>New
Name: Auto Fill CC Billing Address
Record Type: Transaction
Sub Types: Cash Refund, Cash Sale, Customer Payment, Customer Refund, Invoice, Sales Order
Description: Auto populates the correct credit card billing address of a customer during payment.
Event Definition field-
On Create: True
Press Save.
Create a New Action>Set Field Value
Trigger on: After Field Edit
Triggering Client Fields: Credit Card Street
Under Paramters field-
Field: Credit Card Street
Under Value field-
Check ‘From Field”
Record: Current Record
Field: Credit Card Billing Street
Press Save
Create a New Action>Set Field Value
Trigger on: After Field Edit
Triggering Client Fields: Credit Card Zip Code
Under Parameters field-
Field: Credit Card Zip Code
Under Value field-
Check ‘From Field’
Record: Current Record
Field: Credit Card Billing Zip Code
Here's the error I'm getting: When doing a non cc deposit via check with a customer that doesn't have cc info in the custom cc street and cc zip entity fields, I get the error "line items don't match - examples include purchase orders and bills that don't match, etc". when I look at the cc street and zip code boxes when accepting customer payment, the cc street is blank (because the information on the entity field is blank) but the cc zip is filled with the default billing zip when it should also be blank. Also if I type in the customer and then try to click on payment method tab, it seems netsuite freezes up and won't change to that tab.
Is this happening because I put the two set field value action in the same state in my workflow? Do I need to do 2 different states for each box? When I was doing my testing I was only using one entity field so that's what I'm thinking is going on.