Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

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.

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

How to export the Sage 100 (fka MAS90) company code (sy_company) using Visual Integrator

December 9, 2012 by Wayne Schulz

Here’s a very interesting two step process to perform a task which at first seems impossible. A member of the Sage 100 ERP Linkedin Group asked:

 

Anyone know how to link SY_Company into VI Export so I can get the Company Code in an Export from AP?

 

The answer is a relatively easy change that you must make to Visual Integrator which includes adding a temp calculated field and then assigning that value to an unused standard Sage 100 field.

Apparently this is needed because Sage Visual Integrator won’t export temporary fields.

 

Read the entire solution here.

Filed Under: Sage 100 ERP Tagged With: linkedin group, mas200, Sage 100 ERP, visual integrator

Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 Newsletter

Sage 100 News

  • Shipment Tracking Functionality Restored to Sage 100
  • How To Edit 1099 Totals In Sage 100
  • How to Reconcile Sage 100 Accounts Payable Detail to the General ledger
  • Sage 100 Year-End 2022 Training Series
  • Minimum Sage 100 Versions for E-Filing for Tax Year 2022
  • What Are The Differences Between These Sage Fixed Asset Versions: Lite, Single-User, Network and Premier?
  • Sage 100 Paperless Email Electronic Delivery Failing With Rackspace
  • How To Check Sage 100 Compatibility with Avalara’s TLS 1.2 Requirement
  • Sage 100 TLS 1.2 Compliance Update ( Nov 2022)
  • What Are My Sage 100 Mobile Sales Options?

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

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