{"id":137,"date":"2009-01-23T13:54:00","date_gmt":"2009-01-23T13:54:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagemas\/?p=137"},"modified":"2018-10-30T08:59:34","modified_gmt":"2018-10-30T08:59:34","slug":"adding-columns-to-the-sales-order-grid","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/01\/23\/adding-columns-to-the-sales-order-grid\/","title":{"rendered":"Adding columns to the Sales order grid"},"content":{"rendered":"

Adding columns to the Sales order grid on the ‘Enter Sales Order and Quotes’<\/b> screen in MAS 500 can be challenging work.<\/p>\n

\"\"<\/a><\/p>\n

Below we provide instructions and sample code of adding additional columns in the Sales order Grid on the \u2018Enter Sales Order and Quotes’ screen in MAS 500:<\/p>\n

You will need to add the ‘New Field’ coulmn to ‘tsoSOLine’ table and insert records in the following tables:<\/p>\n

    \n
  1. tsmString<\/li>\n
  2. tsmLocalString<\/li>\n
  3. tsmCustomGridField<\/li>\n
  4. tsmCustomGrid<\/li>\n<\/ol>\n

    You will also have add code in the source file of Sales Order Entry form.<\/p>\n

    Example:<\/big><\/b><\/p>\n

    Below is the SQL Code user needs to run in SQL Query analyzer against the MAS500 Database to add a column named ‘New Field’.<\/p>\n

      \n
    1. Adding the column to ‘tsoSOLine’ table.<\/b>
      \nALTER TABLE tsoSOLine
      \nADD NewField VARCHAR(30)<\/span><\/code><\/li>\n
    2. Inserting records in tsmString and tsmLocalString tables for the new field.<\/b>
      \nYou need to assign a StringNo to be used for the new field. In our example we shall use a variable called @_lStringNo.
      \nDECLARE @_lStringNo INT
      \nSELECT @_lStringNo = 1<\/span><\/code>
      \nINSERT INTO tsmString (StringNo, ConstantName) VALUES @_lStringNo, ‘kDDUser’+CONVERT (VARCHAR (10), @_lStringNo ))INSERT INTO tsmLocalString (StringNo, LanguageID, LocalText) VALUES (@_lStringNo , 1033,‘NewField’<\/strong>)where,\u2018LocalText\u2019 is the column name.<\/li>\n
    3. Inserting the records in tsmCustomGridField and tsmCustomGrid tables:<\/b>
      \nThe below code is for example purposes only.
      \nINSERT INTO tsmCustomGridField (CustomGridFieldKey, CustomGridFieldGroupKey, DisplayOnly, EnterInGridRequired, GridFieldDescStringNo, GridFieldSeqNo, HostFormFieldName, PrimaryCustomGridFieldKey)
      \nVALUES (@_lNextKey, 5, 0, 0, StringNo, 62,'NewField'<\/strong>, NULL)<\/span><\/code>INSERT INTO tsmCustomGrid (CustomGridKey, CompanyID, CustomGridFieldKey, CustomizationLevel, EnterInGrid, FreezeInGrid, GridSeqNo, UserGroupID, UserID)
      \nVALUES (@_lNextKey, NULL, @_lNextKey, 1, 0, 0, 62, NULL, NULL)<\/li>\n
    4. Coding in the Sales Order Form:<\/b>
      \nYou need to write the code into the following procedures.<\/li>\n<\/ol>\n