Sage 100

I need to fix some bad records in the Sales Order History Detail file where they have a blank for the .ExtendedDescriptionKey field.  The client is on v2018 Premium.  How can I modify a VI Import job to open or make available the SO_SalesOrderHistoryDetail.ExtendedDescriptionKey field?  Using the Providex.ddf and Providex.dde is not an option since it is Premium.  Thank you in advance.

------------------------------
Madeline Stefanou
RKL eSolutions, LLC
------------------------------

Since it is Premium, you have a better option!

In SQL Management studio,
New Query to backup SO_SalesOrderHistoryDetail to a new table called SO_SalesOrderHistoryDetail_bak:
USE MAS_XXX; -- change to your company code
Select * into SO_SalesOrderHistoryDetail_bak from SO_SalesOrderHistoryDetail

New Query:
SELECT SalesOrderNo,SequenceNo,ExtendedDescriptionKey
FROM MAS_XXX.dbo.SO_SalesOrderHistoryDetail
WHERE ExtendedDescriptionKey = '' OR ExtendedDescriptionKey IS null
Execute
In the results pane, highlight all and choose Copy With Headers
Paste the results into Excel
Fill in ExtendedDescriptionKey column
In the first column after ExtendedDescriptionKey:
=CONCATENATE("UPDATE SO_SalesOrderHistoryDetail SET ExtendedDescriptionKey = '",C2,"' WHERE SalesOrderNo = '",A2,"' AND SequenceNo = '",B2,"'")
copy that down the entire column D
Copy just column D and paste it into a new query window and Execute it

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5
------------------------------