When a customer orders new or additional products/parts, we create a sales order, which generates a work order for most items. However, we also add the sales order information to a list outside of NetSuite so that we can track whether it's been completed and do include other information. I want to eliminate the external list and use NetSuite. I want a report or saved search that can show the following for unfulfilled orders:
- Customer name
- Sales order #
- Date ordered
- Sales order status (i.e., packed, shipped, etc.)
- Shipping method on the sales order
- Expected ship date
- Item name/number
- Item display name/code (having a hard time getting this to show)
- Quantity of item
- Work order #
- Work order status (i.e., released, in progress, closed)
- Work order current task & quantity remaining or completed (not a big deal if can't get this to show)
Can anyone help me with this? I'm having the most issues getting it's work order information to show.