web

You’re offline. This is a read only version of the page.

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

I have the same question (0)

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.

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans