Show TOC

Adding Columns to the Sales Order Item GridLocate this document in the navigation structure


The image below shows the SalesOrderItemCollection available in the metadata: salesorderitemcollection available in the metadata


  1. Select the dgvSalesOrderItem datagrid from the Properties view drop-down and, then click on the button in the row “Columns” to add columns to the grid as shown in the screenshot. dgv_columnadd
    The Edit Columns window appears.
  2. Click Add to add a new column.
    The Add Column window appears.
  3. Do the following in the Add Column window:
    1. Enter EPM_SalesOrder_ProductID in the Name field.
    2. Select DataGridViewTextBoxColumnin the Type field drop-down list.
    3. Enter Product ID in the Header Text field. Add Columns
    4. Click Add.
  4. Repeat the steps to add more columns for the following properties from the selected service:
    • ProductName
    • NetSum
    • Tax
    • TotalSum
    • CurrencyCodeDescription
    • Availability
    • SalesOrderItemKey
    • Note
    For ProductName, The Name field should be EPM_SalesOrder_ProductName, and the Header Text field should be ProductName.
    Note The column name provided in the example is derived from the GWDEMO service, you can provide any name depending on the selected service used to develop GWM project.
  5. Click on Closeonce the procedure of adding the columns in completed.
  6. Press the OK button to generate the grid. Generated_Columns