Create Open Sales Order Saved Search to Display Sales Order Internal ID

Written by
Pattranit Lakhan
Published on
January 26, 2024 at 8:59:42 AM PST January 26, 2024 at 8:59:42 AM PSTth, January 26, 2024 at 8:59:42 AM PST

Scenario

Although standard Open Sales Orders report can be customized, the option to add column specifically with Sales Order Internal ID is not available at the moment. As a workaround or alternate solution might serve a Saved Search which results would be identical to Open Sales Order Report with additional column with internal ID of the transaction.

Solution

  1. Navigate toLists>Search>Saved Searches>New
  2. ClickTransaction
  3. Search Title:EnterTitle
  4. ClickCriteriatab
  5. ClickStandardsubtab
  6. Filter:
    • SelectType
      1. Type:Selectany of
      2. SelectSales Order
      3. ClickSet
    • SelectMain Line
      1. SelectYes
      2. ClickSet
    • SelectBilling Status
      1. SelectOpen
      2. ClickSet
  7. ClickResultstab
  8. Show Totals:EnterCheckmark
  9. ClickColumnssubtab
  10. ClickRemove all
  11. Field:
    Note:For every required field use the drop-down menu to select it and once adjusted click Add if needed. Add more fields as needed.
    • SelectInternal Id
    • SelectType
    • SelectDate
    • SelectDocument Number
    • SelectName
    • SelectAmount Unbilled
    • SelectStatus
  12. ClickSave & Run