Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

SQL Query to copy or move data from the Sub Description #3 field

Posted on by 245

Could someone provide a SQL Query to copy or move data in the Sub Description #3 field on the General Tab to the Reorder # field on the Suppliers tab of the item propertis window?

A customer has been using the Sub Description #3 field to track reorder numbers, rather than entering them on the suppliers tab in the reorder # field.

I would really appreciate it.

Thank You

*This post is locked for comments

  • Suggested answer
    Keith Sturch Profile Picture
    Keith Sturch 5 on at
    Re: SQL Query to copy or move data from the Sub Description #3 field

    UPDATE SL

    SET SL.[ReorderNumber] = I.[SubDescription3]

    FROM [SupplierList] SL

    JOIN [Item] I

    ON I.[SupplierID] = SL.[SupplierID]

    AND I.[ID] = SL.[ItemID]

    WHERE SL.[ReorderNumber] <> I.[SubDescription3]

    AND LEN(I.[SubDescription3]) > 0

    This is provided as is and I'm not responsible for any data problems etc etc - take a back-up first!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,316 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans