News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) Inserting Item through...

Microsoft Dynamics RMS (Archived)

Inserting Item through SQL and setting Supplier List Table Data

(0) Share

Report

Report

Posted on by Community Member

Hello-

I am trying to insert items through SQL using INSERT INTO Queries.

Inserting into the ITEM table is no problem...I got that..

Inserting into the SupplierList table is a bit challenging currently I am doing the following..

1)

insert into Item (ItemLookupCode, random other fields) values (888899991, random other fields)

I then lookup the itemID and get 105501 then do the following

2)

insert into SupplierList ( itemid, Cost, ReorderNumber) values ( 105501, 3.3, '343-34')

Is this a correct way to do this? I am new to SQL

thanks

joseph

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Trent Bourgois on at

Like (0)

Report

Re: Inserting Item through SQL and setting Supplier List Table Data

Hello Joseph,

Thank you for your questions.

The correct way to do this is to create the items in the front-end with Store Operations Manager.

We do not reccomend inserting items into the item table with SQL queries.

Let us know if you have any other questions.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,430 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans