SQL update SOP item description - is it safe?

(0) Share

Report

Posted on by Community Member

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

All responses (3)

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

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 ... 14,036 Most Valuable Professional on at

Like (0)

Report

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 2,725 on at

Like (0)

Report

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.