Schulz Consulting 833-724-3100

Sage 100cloud Consulting

  • Home
  • Services
  • Find A Local Sage Consultant
  • Contact Us
You are here: Home / Sage 100 ERP / How To Import Credit Card Numbers to Sage 100 ERP V2013+

How To Import Credit Card Numbers to Sage 100 ERP V2013+

June 5, 2014 by Wayne Schulz

credit cards_800

Often when migrating from one accounting system to Sage 100 ERP there are different types of data which you’d like to import. Most of that data such as customer and vendor master information is fairly straightforward. Sage has a great tool called Visual Integrator (pdf) which is used for importing from a source file (we recommend CSV or Comma Separated Value formatted file) into virtually any Sage 100 ERP data table.

There are however some trickier items that require added thought to develop an import routine. One such data import is the process of pulling in customer credit cards. Usually if you’re accepting credit card payment from your customers you’ve also accumulated quite a file of “on hand” numbers for regular customers who ask that you simply charge their latest order to the card you keep on file.

In order to get that initial credit card information imported to Sage 100 you’ll need to follow some basic steps:

  1. Open Visual Integrator, Main, Import Job Maintenance
  2. Create new import into AR_CustomerCreditCard table
  3. Click Perform button and enter the following information:
  • Perform Type = After Assign
  • File Type = Standard
  • Table Name = AR_CustomerCreditCard
  • Column Name = CustomerNo
  • Sequence = 001
  • Command = coBusiness’ARCreditCard’AddNewCreditCard(Temp001$,Temp002$,Temp003$,Temp004$,Temp005$)
  • Click Accept button
  • Import File: browse to soucefile to be imported
  • Select Data Tab and enter the following fields:

Click Add Temp Field button to create Temp001
Data Type = String
Operation = Replace from column in sourcefile that contains the credit card payment type
Assign Temp On = Key Assigns Only
Select Clear on each Record checkbox
Click Add Temp Field button to create Temp002
Data Type = String
Operation = Replace from column in sourcefile that contains the full credit card number
Assign Temp On = Key Assigns Only
Select Clear on each Record checkbox
Click Add Temp Field button to create Temp003
Data Type = String
Operation = Replace from column in sourcefile that contains the expiration year
Assign Temp On = Key Assigns Only
Select Clear on each Record checkbox
Click Add Temp Field button to create Temp004
Data Type = String
Operation = Replace from column in sourcefile that contains the expiration month
Assign Temp On = Key Assigns Only
Select Clear on each Record checkbox
Payment Type
Operation = Replace from column in sourcefile that contains the credit card payment type

CreditCardGUID
Operation = Calculated
Calculation = Temp005$

CreditCardID
Operation: Replace from column in sourcefile that contains the Card ID6

 

For more information login to the Sage KB and navigate to this Sage Article.

Share this:

  • Twitter
  • Facebook
  • Email
  • LinkedIn

Filed Under: Sage 100 ERP, slider Tagged With: credit card, visual integrator

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 and Sage 100cloud ( Formerly Sage MAS 90 and MAS 200) since 1986 and provides advanced Sage 100 technical support to companies located in Connecticut, Massachusetts, Rhode Island, New York and throughout the United States. If you are experiencing an issue with Sage 100, and would like to schedule a support session - please request assistance here or call 833-724-3100.

Search Our Site

Sage 100cloud Latest News

  • Sage Summit San Diego 2019 Wrap-Up February 15, 2019
  • Is Sage 100 cloud hosting right for you? February 12, 2019
  • What is Sage 100cloud Multi-Bin Management, and do I need it? February 5, 2019

Our sponsors

  • APS Payments

    Integrated credit card and ACH payment processing for Sage 100 and Sage 100cloud

  • ScanForce

    Industry-leading barcode scanning and mobile warehouse & sales automation solution for Sage 100 / Sage 100cloud software.

  • Summit Hosting

    Secure cloud hosting for Sage 100 and Sage 100cloud.

Contact Us

Schulz Consulting
160 Oak Street
Glastonbury, CT 06033
Phone: 833.724.3100
Email Us
Locally serving all of Connecticut, Massachusetts, Rhode Island, Vermont,
New York, New Jersey. Available remotely nationwide. We are a local affiliate of DSD Business Systems.

Copyright © 2019 · Parallax Pro Theme on Genesis Framework · WordPress · Log in

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.