Create Open Sales Order Saved Search to Display Sales Order Internal ID
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
- Navigate toLists>Search>Saved Searches>New
- ClickTransaction
- Search Title:EnterTitle
- ClickCriteriatab
- ClickStandardsubtab
- Filter:
- SelectType
- Type:Selectany of
- SelectSales Order
- ClickSet
- SelectMain Line
- SelectYes
- ClickSet
- SelectBilling Status
- SelectOpen
- ClickSet
- SelectType
- ClickResultstab
- Show Totals:EnterCheckmark
- ClickColumnssubtab
- ClickRemove all
- 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
- ClickSave & Run