NetSuite - How to customize the Open Sales Order Report to show the details of the Back Order Report. Below are the steps to the report:

1. Navigate to Reports > Order Management > Open Sales Orders Report > Customize

2. Under Edit Columns add the following fields:

  a. Expand Open Sales Orders folder > expand Item Folder > choose Name (Grouped)

  b. Expand Open Sales Orders folder > choose Description

  c. Expand Open Sales Orders folder > choose Quantity (Column Label field = option to rename the column to Quantity Ordered)

  d. Expand Open Sales Orders folder > choose Quantity Shipped (Column Label field = option to rename the column to Quantity Fulfilled)

  e. Expand Open Sales Orders folder > expand Item Folder > choose Current Quantity On Hand (Column Label field = option to rename the column)

  f. Expand Open Sales Orders folder > expand Item Folder > choose Current Quantity On Order (Column Label field = option to rename the column)

  g. Expand Open Sales Orders folder > choose Back Ordered

  h. Expand Open Sales Orders folder > choose Memo

   i. Expand Open Sales Orders folder > choose Reference Number

  g. Sales Order Number, Date, Customer Name and Status of the sales order are already available under Edit Columns so there’s no need to add the fields in the report

3. Under Filters > add the following:

  a. Expand Open Sales Order folder > choose Sold as Kit/Assembly Member > Filter = Equal to False

  b. Expand Open Sales Order folder > choose Quantity Open > Filter = Greater thank or Equal to > Value = 1