Importing Expense Items from Credit Card Statements
The expense management within Dynamics allows the users to easily submit expense, but a lot of the time they are just copying information from corporate credit cards which the organization is already receiving summaries for. To save time, and also to make sure that some of the transactions don’t get lost, it’s a good idea to automatically import the transactions beforehand and then just get the employees to expense the unreconciled expenses.
Luckily Dynamics allows is to do that.
Before we start importing our credit card transactions we need to first set up the employee with a credit card that will be used to link the imported transactions to the employee record.
To do this open up the Employee record and then open up the Expense action panel. Then click on the Credit cards link.
This will open up the Credit Card maintenance form for the employee. Here we will just want to click on the + New button in the menu bar.
This will create a new record for us.
Now we just need to find the credit card number from the import file.
Once we have pated in the credit card number into new record we can update the Payment Method and set it to CreditCard.
We then can identify the credit card by updating the Description.
And then set the Card type – in this case AMEX.
Now we will want to import in all of the credit card transactions from the import file. To do this, just click on the Credit card transactions link within the Periodic tasks group of the Expense management menu.
When the Credit card transactions form is displayed, click on the Import transactions button within the menu bar.
This will open up the Data Management form.
All we have to do here is give our import a unique Name.
Then select the Source data format and set it to Package.
Then click on the Upload button and find the credit card import file that we want to use and then click on the Open button.
This will process the file and when it has finished, just click on the Import button within the menu bar.
This will kick off the import transaction.
After a bit the process will complete and you will see if any of the transactions failed to import.
When we return back to the Credit card transactions we will see that there are a number of new transactions that have been added.
How it works…
Now we can see the results of the import. To do this we will just open up the Employee Self Service workspace and then click on the New report option within the Expenses section.
We will just need to give our expense report a Purpose and a Location and then click on the OK button.
Rather than go straight to the expense report, since there are outstanding transactions, then the Add unreconciled expenses form will be displayed showing us all of the transactions that we just uploaded.
We can select any of the transactions that we want to add to our expense report, set the Expense Category for each of the transactions.
After we have done that we can click on the Continue button.
Now when the Expense report is displayed it will already have the imported transactions there for us.
Importing the transactions from the credit cards into Dynamics is a great timesaver. Also before importing the transactions we can also merge in information from other systems to speed up the process.
How cool is this.
About the Author
Murray Fife is an Author of over 25 books on Microsoft Dynamics AX including the Bare Bones Configuration Guide series of over 15 books which step the user through the setup of initial Dynamics AX instance, then through the Financial modules and then through the configuration of the more specialized modules like production, service management, and project accounting. You can find all of his books on Amazon at http://www.amazon.com/author/murrayfife.
Murray is also the curator of the Dynamics AX Companions (www.dynamicsaxcompanions.com) site which he built from the ground up as a resource for all of the Dynamics AX community where you can find walkthroughs and blueprints that he created since first being introduced to the Dynamics AX product.
Throughout his 25+ years of experience in the software industry he has worked in many different roles during his career, including as a developer, an implementation consultant, a trainer and a demo guy within the partner channel which gives him a great understanding of the requirements for both customers and partner’s perspective.
For more information on Murray, here is his contact information:
Mr. Fife tends to forget that a credit card statement never comes in an Excel file.
Here is what is really needed to import one: https://blogs.msdn.microsoft.com/dynamics-coe/2015/12/08/visa-vcf-plain-text-credit-card-statement-into-dynamics-ax-with-xslt/
Eugen, Of course you are right – I leave the real work on the integration to the experts 🙂
Great description of the process Murray:) Thank you!