Credit Card Import through Travel and Expense Management

(0) Share

Report

Posted on by Community Member

Hello,

I am looking into the possibility of using the credit card import functionality to manage our corporate credit cards. I have a couple of questions and would appreciate anyone with any experience of setting this up giving some input.

Firstly, in our system a user is worker record, then linked to a supplier (the workers bank details) and their AdID. If the card is linked to the worker record, how do you set this up so payment is made to the card provider - rather than the employee account the expenses would be paid into. I dont understand how this setup would work.

Secondly, does anyone have any experience of this upload working who could comment of how effieicnt the process actually is.

Does anyone have any experience of using this through Enterprise Portal. Not all of our users have access to the full client. Ideal we would be able to upload the card statements centrally and the users would be able to log into Enterprise Portal and view their card statements.

Any information on this would be greatly appriciated before I proceed with any more investigation.

Regards,

Bruce

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Credit Card Import through Travel and Expense Management

Hi Bruce,

Have you already checked out this video: www.youtube.com/watch

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Credit Card Import through Travel and Expense Management

Hi Ludwig,

I have watched the tutorial. However it shows only the part I understand. I've still yet to see how the credit card reports would look and work in Expense Reports or through enterprise portal or how the user would go about entering information onto this report.

I've since found the answer to my first concern as well. You just need to set up a payment method which pays the supplier rather than the worker when setting up the credit card.

The only outstanding issue i have is how the process actually works from a cardholder/user perspective.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Credit Card Import through Travel and Expense Management

Hello Bruce,

Once the credit Card Transactions are imported, users will see a pop up form in the Enterprise Portal at the time they record a new expense report. They can then select one or more of those imported transactions and copy them to their expense report where they can fill the rest.

That's basically the functionality behind. If you have a lot of credit Card Transactions for an employee, they can save some time from typing the different expense lines. Yet, if all of your employees have only 2-3 expense lines, they might be faster entering them manually.

Do you have a local MS contoso demo machine available? If so, try to log into the Enterprise Portal of Company USMF, which should have some pending credit card Transactions that can be selected if I remember it correctly.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Credit Card Import through Travel and Expense Management

Perfect, thanks for the detailed response.

The one question I have here is how does the system distinguish in this case between credit card expenses (for which payment should be made to the card provider) and employee expenses (where expenses should be paid to the worker). For example someone may have a corporate card, but also be able to claim mileage through travel and expense. How does the system differentiate between these transactions?

Thanks again for your input.

Bruce

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Credit Card Import through Travel and Expense Management

Hello Bruce,

That differentiation is made through the payment method where you can specify the 'owner' of that expense so that you know whether you need to pay your employee or whether the money is already deducted from the credit card.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Credit Card Import through Travel and Expense Management

Hi Ludwig,

I've got a further question. How do you know what data is required in the TrvPBSMainData import. We have the ability to create XML output documents from our bank so my plan was to build one which outputs all of the data required for the upload but I cant find any information as to what is required and in what format or order the import looks at the information.

Thanks,

Bruce

Was this reply helpful? Yes No
Suggested answer

nc_hwr 30 on at

Like (0)

Report

RE: Credit Card Import through Travel and Expense Management

Hi Bruce

Credit card import uses standard Document service, so you need to configure an Inbound port for TrvPBSMainData, Create action.

Below is a sample XML, you can ask your developer to know about other fields.

Please note, if bank can't provide this format then you have to write inbound transformation.

<Batch xmlns="schemas.microsoft.com/.../documents">
<Envelope xmlns="schemas.microsoft.com/.../Message">
<Header>
<Company>NZL1</Company>
<Action>schemas.microsoft.com/.../create</Action>
</Header>
<Body>
<MessageParts>
<TrvPBSMaindata xmlns="schemas.microsoft.com/.../TrvPBSMaindata">
<TrvPBSMaindata class="entity">
<_DocumentHash>String</_DocumentHash>
<AmountCurr>200</AmountCurr>
<AmountLocal>200</AmountLocal>
<BusinessName>NORTHWEST AIRLINES</BusinessName>
<CardNumber>111222333444555</CardNumber>
<CardNumberNIKS>111222333444555</CardNumberNIKS>
<CardType>AMEX</CardType>
<CatCode>Airline</CatCode>
<CatCodesDesc>Airline</CatCodesDesc>
<CCTransUniqueId />
<Country>NZL</Country>
<ExchCode>NZD</ExchCode>
<ExchCodeLocal>NZD</ExchCodeLocal>
<Name>Nishant Chauhan</Name>
<Paymethod>CC</Paymethod>
<Reference>185221</Reference>
<Town>aaaaaaaaaaaaa</Town>
<TransDate>2017-03-01</TransDate>
<UserField1>aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa</UserField1>
<UserField2>aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa</UserField2>
<UserField3>aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa</UserField3>
<UserField4>aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa</UserField4>
<UserField5>aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa</UserField5>
<UserField6>aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa</UserField6>
<UserField7>aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa</UserField7>
<UserField8>aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa</UserField8>
<UserField9>aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa</UserField9>
<UserFieldLong>aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa</UserFieldLong>
</TrvPBSMaindata>
</TrvPBSMaindata>
</MessageParts>
</Body>
</Envelope>
</Batch>

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Credit Card Import through Travel and Expense Management

I have encountered another problem with this process, have been working on other things for the last 6 weeks and finally got back to trying this.

I have got the statement into AX. Currently showing correctly in T+E> Periodic > Credit Cards > Credit Card Transactions.

However, when I go to create new expenses report i get an unhanded exception error in Enterprise Portal. when i delete the credit card transaction I get no error, and as soon as I re import the statement I get an error in EP.

Does anyone have any suggestions as to how this could be happening.

Regards,

Bruce

Was this reply helpful? Yes No