Vendor Names

(0) Share

Report

Posted on by Community Member

We need to change all vendor names and vendor search names to use capital letters only. I hope that there is a way to do it through the database in bulk or somehow programmatically instead of doing it one by one through the application. I have this query:

select v.ACCOUNTNUM
, d.NAME --Vendor Name
, d.NAMEALIAS --Search name
, v.VENDGROUP
, v.DATAAREAID --Company
from [dbo].[DIRPARTYTABLE] d with (nolock)
inner join dbo.VENDTABLE v with (nolock) on d.recID = v.Party

which gives me all vendor names and search names but i wonder if there are other tables besides [DIRPARTYTABLE] that should be updated with the new values.

Thank you,

nothereyet

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (3)

Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report

You can update data in AX in bulk by writing an X++ job, or using the Data Import Export Framework.

Here is my article which explains why you should not touch data in SQL Server directly:

[View:https://www.daxrunbase.com/2017/06/13/update-ax-database-tables-from-sql/:320:50]

Also you should be more specific on what exactly would you like to update, since DirPartyTable is the global address book entry for parties, which is shared data for vendors, customers, etc.

Was this reply helpful? Yes No
Verified answer

Chaitanya Golla 17,225 on at

Like (0)

Report

Hi,

It's recommended performing the update through the application instead through SQL(as pointed by Vilmos).

DirOrganizationName is the other table which holds the Name and gets updated if we change the name for a vendor. (Refer code: \Data Dictionary\Tables\DirPartyTable\Methods\updateOrganizationName)

Thanks,

Chaitanya Golla

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I was trying to avoid record by record updates and do it in record set operation. If I use X++ code, is it going to scroll through all vendors and do change the names one by one or there is a way to avoid it?

Was this reply helpful? Yes No
Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report

AX supports set-based operations:

[View:https://msdn.microsoft.com/EN-US/library/aa673589.aspx:750:50]

Please forget touching AX database via SQL.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you everyone for replying to my question. It was very useful to me.

However, it looks like my task has shifted from updating vendors' names to all uppercase letters to updating vendors' names based on the supplied CSV file. If you could suggest a good article to read about this method, I would truly appreciate it.

Thank you in advance,

Nothereyet

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report

Hi,

Either you could make use of DIXF or x++ code to update vendor names from excel.

Refer following links:

Through DIXF:
(Using Excel to Import Customers and Vendors in Dynamics AX 2012)
community.dynamics.com/.../using-excel-to-import-customers-and-vendors-in-dynamics-ax-2012

Through X++:
(Vendor Import ( Insert/Update ) from Excel using X++)
axlogics.blogspot.com/.../vendor-import-insertupdate-using-x.html

Hope this information helps you.

Thanks,
Chaitanya Golla

Was this reply helpful? Yes No