Skip to main content
Answer

Listing Jobs that have items from a particular warehouse

  • August 15, 2024
  • 3 replies
  • 39 views

Forum|alt.badge.img

Does anyone know of an iquiry that can give me a list of open service orders that have items on them from a specific warehouse? For example. I would like to list open/completed service orders that have items on them frome warehouse 03 within a specific time period.

Best answer by Kandy Beatty

Hi @lewisad 

The closest thing out of the box to what you are looking for may be the Service order details by Inventory Item

 

3 replies

iqraharrison
Captain II
Forum|alt.badge.img+8
  • Captain II
  • August 15, 2024

@lewisad in the sales demo, there is an inquiry called Storage Details by Item Warehouse Location

this is not set up to show anything related to service orders BUT i think it could be a good start.  You could create a copy and add the service order details table (i think specifically it’s the FSSODet table) and fill in the relations tab.

natively, i wasn’t seeing anything that would give me the details that you are looking for!

hope this helps!


Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Captain II
  • Answer
  • August 15, 2024

Hi @lewisad 

The closest thing out of the box to what you are looking for may be the Service order details by Inventory Item

 


Forum|alt.badge.img
  • Author
  • Freshman II
  • August 15, 2024

Will investigate and report back. Thanks for your replies.