Skip to main content
Solved

Listing Jobs that have items from a particular warehouse


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

 

View original

iqraharrison
Captain II
Forum|alt.badge.img+8

@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+16

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
  • Freshman I
  • August 15, 2024

Will investigate and report back. Thanks for your replies.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings