Import Concur data via DIXF in R3

(0) Share

Report

Posted on by Community Member

Hi,

I need to import Concur file to AX 2012 R3 via DIXF. Has anyone done a similar implementation before? Please provide some direction on how to go about it.

Thanks in advance for the help!

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

Can you explain what a Concur file is? When I search on the internet it could be an expense management solution. Please provide more information. What is the file format and in which entity do you need to import data?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Andre,

Thank you for getting back to me so quickly. It contains invoices for travel expenses. I receive the file from Concur and import into the table after cleaning up the data. Below are all the fields in the table. I plan to configure DIXF to query this table and put it into R3. The functional team doesn't know what entity to use. So they leave it up to me to figure it out. Since it is for travel expense invoices, would you be able to suggest which entity I should use to get the data into R3?

[Date]

,[AccountType]

,[Account]

,[Invoice]

,[Amount]

,[Text]

,[Currency]

,[Channel]

,[CostCenter]

,[RetailStore]

,[ProductLine]

,[Season]

,[Country]

,[Customer]

,[Document]

,[DocumentDate]

,[Sequence]

,[MainSort]

,[Group]

,[AXComp]

Thanks,

Was this reply helpful? Yes No
Vamsi Pranith 682 on at

Like (0)

Report

I believe Concur files are header less meaning that the data that comes in is a direct flat file. For any data entity to work, we would need all the headers appropriately. However, I'm pretty sure that you might have figured that out. So to answer your question on which entity you would have to use, it depends on what kind of journal entry the business is expecting. Is the expense paid out of Concur or paid out of AX? In any case you would need custom entities created for LedgerJournalTable and LedgerJournalTrans which can solve both the requirements to have a normal ledger journal entry for the payments done out of Concur and/or vendor invoice entry for payments done out of AX. Hope this helps.

Was this reply helpful? Yes No