Answered

Template Move rows from and Excel table to Dynamics AX Online Vendors - Error when uploading

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am trying to use the template to upload Vendors to D365 for Operations. I am getting the follow error when the flow runs:

"status": 400, "message": "An error has occurred. Write failed for table row of type 'VendVendorEntity'. Infolog: Error: Invalid party type name found: '', this party type does not exists in the system..",

I have tried creating the flow from scratch as well but it continues to fail at the create record step. My fields appear to be mapped correctly and I have created the necessary rows in the Excel Sheet.

Body

{ "VendorGroupId": "40", "PrimaryEmailAddress": "testemail@aol.com", "dataAreaId": "USMF", "VendorName": "Ray Supplies", "VendorAccountNumber": "797979" }

Has anyone used this template successfully? Any ideas on how to resolve the error?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

ashgupta Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Dave,

Without the complete excel file/ dyanmics table schema, its harder to say but based on the message, it seems its not able to find PartyType which may be an enum. I also dont see on the body.

Can you double check and share what values are there in CSV file?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Ashgupta,

Thanks for the reply! Here are the values on my Excel sheet:

DataGroupID     USMF
VendAcctNum   797979
VendorGroupID 40
Name                   Ray Supplies
Email                   testemail@aol.com
__PowerAppsId__ 7qlIz7gPVNM

It is formated as a regular table in Excel but I was having an issue inserting a screen shot. Thanks again for the help.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Ashgupta,

Thanks a lot for your pointing me in right direction. I added a party type field and was able to upload the file successfully.

Was this reply helpful? Yes No
ashgupta Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Perfect. thanks for your confirmation.

Was this reply helpful? Yes No
Sumeet 16 on at

Like (0)

Report
Copy link

Link copied!

did you create a party type field in AX?

Was this reply helpful? Yes No
Daiye 8 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

I had the same problem when importing vendors to D365, or rather when updating vendors through an import in Data management. Most importantly the error message was the same:
Error: Invalid party type name found: '', this party type does not exists in the system.."

What solved my issue was finding the Party, and then the party type, that the Vendor was built upon. There are two available party types for the Enum "DirPartyBaseType":
1. Person.
2. Organization.
(Name = Party type name)

Due to an import of the Vendor done through migration back in 2015 the Vendor Party Type was of type "Any". Either this was a valid party type back then or the value was forced into D365 in the migration. The import in Data Management finds the correct Vendor but when it tries to update the vendor in any way the Party type is still "Any" which causes the error.

My solution:
Navigate to Organization Administration -> Global address book -> Global address book.
Create a new party with the same name as your Party, save the form. Take note of the Party ID, something like "00000XXXX".
Navigate to your vendor. Accounts payable -> Vendors -> All vendors -> [Your vendor]
Click Change party association in the General tab.
Select your new party association that you just created (Party ID). Click Ok -> Ok.
Done.

Was this reply helpful? Yes No