Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SQL update SOP item de...
Microsoft Dynamics GP (Archived)

SQL update SOP item description - is it safe?

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

I have a report that relies on item descriptions in SOP - unfortunately, an invoice has been raised with an incorrect description and the transaction in question is not being reported correctly.

I need to run an update query to change the description to put it right but as I am new to GP I thought it best to ask some questions before jumping in!

The field in question is the description field that is visible on each line item in the 'Sales Transactions Enquiry Zoom' through the front end - I believe this is the ITEMDESC field in SOP30300. By default this is copied from Inventory but this one should have been modified before the invoice was posted.

I would like to know if,  a: This is the correct field? and, b: will it cause any problems with other tables if the field is updated on its own?

Are there any guides on updating tables via SQL?

thanks, 

Darren

*This post is locked for comments

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: SQL update SOP item description - is it safe?

    Nothing more valuable to add up to all, just keep in mind that changing the item description on the item card level will not roll back to associated SOP transaction (Open, Work and History). The same logic applies to changing the item description in the SOP tables, it will not affect master tables.

  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,957 Most Valuable Professional on at
    RE: SQL update SOP item description - is it safe?

    Hi Darren (Dazza)

    Jorge is correct.  You should be able to update the item description in the work or history Sales Transaction Amounts tables without any issues as this is purely a descriptive field and is not used as a key anywhere.

    David

  • Suggested answer
    coquisalsa Profile Picture
    coquisalsa 2,725 on at
    RE: SQL update SOP item description - is it safe?

    That's the correct field "ITEMDESC" and the correct table "SOP30300" (Sales Transaction Amounts History). It will not cause any problem if you change it using SQL, unless you are using a 3rd party customization which depends of it.

    It is always wise to do a backup before changing any data directly in SQL.

    The table SOP10200 (Sales Transaction Amounts Work) also contains the field ''ITEMDESC'', if your Sales Lines Items are here, you could amend the Item Descriptions using the "Sales Transaction Entry" window.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans