CSV Import > Update Credit Charge Transactions

Scenario

In a credit card transaction, user wants to update the following fields via csv import:

• Vendor
• CCC Account
• Transaction Date
• Expense Account
• Expense Amount
• Department on sublist

Solution

I. Create a CSV file consist of the ff column

• Internal Id
• Vendor
• CCC Account
• Transaction Date
• Expense Account
• Expense Amount
• Department on sublist

II. CSV import.

1. Go to Setup > Import/Export > Import CSV Reords
2. Step 1. Scan & Upload CSV File
• Import Type = Transactions
• Record Type = Credit Card Charge
• CSV file = One file to upload = True
• Select a filed
3. Step 2. Import Options
•  Data Handling = Update
• On Advanced Options, set Overwrite Sublists = True
• Note: Overwrite Sublists preference set to True is part of the steps provided. Be reminded to be careful with the Overwrite Sublists preference before proceeding with the steps on updating credit card transactions through import.
  We want to emphasize being cautious about this preference under CSV's Advanced Options as this means that it is as if we are re-writing the whole Credit Card Charge. So everything needs to be mapped in the import. To reiterate, it needs to be present in the csv file.
  For example, the Credit Card Charge has 3 lines on Expense tab. then on your CSV file you want to update only one line. Upon the import with this preference set to true, the Credit Card Charge will be set based on the CSV file set up with one line on the expense tab and remove other lines. Since there are 3 lines on the Credit Card Charge so your CSV file will also consist those 3 lines including the update/change.
4. Step 4. Field Mapping
• Internal Id <--> Credit Card Charge : Internal ID
• Vendor <--> Credit Card Charge : Vendor
• CCC Account <--> Credit Card Charge : Account
• Transaction Date <--> Credit Card Charge : Account
• Expense Account <--> Credit Card Charge Expenses : Account
• Expense Amount <--> Credit Card Charge Expenses : Account
• Department on sublist <--> Credit Card Charge Expenses : Account
• If you used Internal Id, click pencil icon on the field and Choose Reference Type = Internal Id
5. Step 5. Set the Import Map Name > Click Save & Run

Expected Results: It will update the Credit Card Charge.