NSC | “On Order” Column Showing Zero for Items on Open Purchase Orders

Scenario:
The user noticed that some items with open Purchase Orders were still showing 0 in the On Order column on the Order Items page. As a result, NetSuite appeared to recommend reordering items that were already on existing Purchase Orders.

Solution:
This issue commonly occurs when the Purchase Orders do not have the correct inventory location assigned.

The On Order quantity only updates properly when the Purchase Order location matches the inventory location being viewed.

To configure a default Purchase Order location:

1. Navigate to:
   Setup > Accounting > Preferences > Accounting Preferences
2. Open the Order Management subtab.
3. Locate the field:
   • Default Location for Purchase Orders