Finance | Project Operations, Human Resources, ...

File Concur import

(0) Share

Report

Posted on by Shaik Mushtaq

Hi There,

After importing file from concur to generate invoice Journal, batch is getting created however we are getting error message as vendor does not exists in MSD however the vendor is very much available kindly assist.

Thank you and have a great day.

Thanks & Regards

Shaik Mushtaq

I have the same question (0)

All responses (9)

Answers (0)

André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Shaik,

Can you tell us how you import the files from Concur? What exact batch are you referring to? Without knowing how you import the Concur details, we are not able to help you.

Was this reply helpful? Yes No
Shaik Mushtaq 25 on at

Like (0)

Report
Copy link

Link copied!

Hi Andre,

I am sorry to create a confusion here..

Accounts payable --> Periodic Task --> Concur Integration --> File concur import

We actually download expense reports from CONCUR and upload it in MSD. Under Periodic task there is one option called "File Concur Import".. once we click on this option we get a dialogue box to browse and select the file which has to be uploaded in MSD to create invoice journal.. we have around 17 entities, this option is working for all entities except for 2 entities.

This is a new profile for me and the person who was handling this has left the organization.

I have cross checked the expense report file which we download for other entities to upload in MSD with this entity expense report file, the fields are matching, and has correct information in all fields.

Accounts Payable--> Invoices--> Invoice Journal.

once we upload the file in MSD. a batch is getting created, however the line wise vouchers are not getting created, and we are getting a error message vendor does not exists, when I checked that vendor in MSD, the vendor code is available, possible some where integration is not happened or some missing link.

Appreciate your support in resolving this issue.

Thank you in advance and have a great day.

The excel file contains following headers. (38 columns)

DATE Employee ID Employee Last Name Employee First Name Report ID Employee Default Currency Alpha Code Report Submit Date Report Processing Payment Date Report Name Report Entry Expense Type Name Report Entry Transaction Date Report Entry Is Personal Flag Report Entry Description Report Entry Vendor Name Report Entry Vendor Description Report Entry Payment Code Code Report Entry Payment Code Name Report Payment Reimbursement Type Billed Credit Card Account Number Billed Credit Card Account Description Journal Payer Payment Code Name Journal Payee Payment Type Name Journal Amount Is Billable Journal Account Code Journal Debit Or Credit Payment Demand Company Cash Account Code Payment Demand Company Liability Account Code Estimated Payment Date Line of business MSD Vendor Legal Entity Department Batch ID File Sequence Number Report Entry Id Report Purpose Location

Thanks & Regards,

Shaik Mushtaq

Was this reply helpful? Yes No
Morgan Bazin 95 on at

Like (1)

Report
Copy link

Link copied!

Based on the path you're providing, I would make the assumption that this is a custom function that was provided by your partner or perhaps an ISV solution and not standard D365 functionality.

However, with that said - you should check the files you are importing to see if there are any hidden characters or spaces on the lines that may be causing an issue with the import.

Was this reply helpful? Yes No
André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi Shaik,

The import option for Concur via the AP menu is not a standard feature. Like Morgan mentioned, this should be a customization or third-party solution. I would suggest to contact your Dynamics 365 implementation partner for some help.

Was this reply helpful? Yes No
Ankit Life 681 on at

Like (1)

Report
Copy link

Link copied!

Hi,

As its customization, I am not sure if this is routing through expense module or directly creating employee as a vendor in AP. If it is using expense module then check if the employee and vendor relation has been set or not if default payment method offset account type is not Vendor (Human Resource > Employee - Go to Action Pane Expense > Employee mapping and per diem rates) or might by customization doing it auto, not sure.

Regards,

Ankit Arora

Was this reply helpful? Yes No
Shaik Mushtaq 25 on at

Like (0)

Report
Copy link

Link copied!

Hi All,

Thanks for your suggestions..

I was able to find the solution for the earlier issue based on your inputs, but I came across another issue

The solution I found for the earlier issue as below.

When I compared vendor number in other entities there was nothing prefixed for the vendor number, however for this entity "company code" and "Hyphen" was prefixed which I removed and executed it worked but instead of creating journals in AP module "Invoice Journal" it has created in GL module "General Journal"

Accounts Payable -->set up --> accounts payable parameters--Number Sequence-->vendor account-->Number sequence code--> I right clicked and selected view details-->under segments--> when I compared other entities format with this format I found there was company code and hyphen was added which I removed and tested in UAT environment it worked.

AP Module Invoice Journal Path: -

Modules-->Accounts Payable-->Invoices-->Invoice Journal

GL Module General Journal Path: -

Modules-->General Ledger--Journal Entries-->General Journal

Kindly advice how to instruct MSD to create the batch and line items in "AP Module Invoice Journal Path"

Appreciate your support

Have a wonderful day ahead.

Thanks & Regards,

Shaik Mushtaq

Was this reply helpful? Yes No
André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Shaik,

If you have another issue, please create a new question on the forum.

Was this reply helpful? Yes No
Shaik Mushtaq 25 on at

Like (0)

Report
Copy link

Link copied!

Hi Andre,

Good Morning,

This is related to same old issue, the journals should get generated under AP module-->Invoice Journal, however journals are getting created in

GL Module-->General Journals

Thank you in advance for your help

Thanks & Regards,

Shaik Mushtaq

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Shaik,

Your last question might be related to your Concur customization, but your initial question was about vendors which couldn't be found. You are now changing the topic to having journals imported in a wrong module.

As this is about a customization, you have to check with the developer which exact journal name is used for this periodic import job. The journal name determines in which module the journal will be visible. I don't know if this import job has an option to provide a journal name or that it is getting its journal name from a parameter setting.

Was this reply helpful? Yes No