This is what we do:

When you pay for products or services using a credit card, the payment record in Sage 100 (formerly Sage MAS 90 and 200) history will show the credit card company, not the individuals vendors. However, you may still want to track the expense in your accounting software to the actual vendor for reporting purposes. To do this you can set up the credit card company as a Credit Card Vendor and then transfer the amounts paid to the vendor who actually provided the products or services. Here are the steps:

Open Vendor Maintenance and enter the vendor number used to pay the credit card company or add the vendor if it does not already exist.

On the Main tab in the lower-right corner, check the box for Credit Card Vendor and Accept.

Create the invoices that were paid by credit card on the vendor account by processing an Accounts Payable Invoice or Purchase Order Receipt of Goods with an invoice number or Receipt of Invoice.

Open Accounts Payable/Main/Invoice Data Entry, select the Credit Card Vendor account and enter an invoice number that you would like to create for payment on that account and enter the total amount you want to transfer.

On the Lines tab, click the Transfer Information button to open the Update Purchase Vendor window.

Select the vendor account in which the invoices were created and select the invoice to be paid.

The invoice date and balance will automatically be populated and the transfer amount will default to the full balance but can be overridden. Enter any discount amount and select the OK button. A detail line will be created for the Credit Card Vendors invoice. Select the OK button and you can select the transfer button again to complete the amount being transferred.

Accept the invoice and print the Invoice Register and update it.

VI is NOT your best option. Pulling data with either Excel of Access is faster and gives you greater control over the data.