How to Display Back Ordered Quantities on NetSuite Sales Orders?

While a standard 'Back Ordered' column may be available on the Sales Order form, its display behavior can vary, often showing quantities only after the Sales Order is saved and typically reflecting back orders specific to the current transaction. To achieve more comprehensive visibility, particularly for back ordered quantities prior to the current order, it is recommended to implement a custom transaction line field (custom column).

1. Navigate to Customization > Lists, Records, & Fields > Transaction Line Fields > New.

2. Configure the custom field with an appropriate label (e.g., 'Back Ordered - Pre-Order').

3. Set the 'Source From' field to 'Item' and select the 'Back Ordered' field from the Item record. Users should carefully validate the behavior of this sourcing, as NetSuite's complex backorder calculation logic and commitment status may affect how 'quantity back ordered before the order' is accurately reflected.

4. Apply this custom field to the relevant Sales Order forms.

   It is advisable to rename both the standard and custom columns on the Sales Order form to clearly distinguish their purpose. For instance:

   • Standard Column: 'Quantity Back Ordered on Current Order'
   • Custom Column: 'Quantity Back Ordered Before Order'

   This distinction provides a clearer understanding of the item's backorder status at different points in the order lifecycle.