Skip to main content
Solved

Generic Inquiry

  • August 9, 2022
  • 3 replies
  • 118 views
  • Translate All

Forum|alt.badge.img

I am trying to make a generic inquiry to pull appointments that have inventory allocated to them. Does anyone know how to make this a generic inquiry?

Best answer by DConcannon

Hi @CAMORRISON 

The image contains the basic join. The allocations occur at the Service Order level, you can join to an Appointment table if you need appointment info on the GI.

 

 

View original

3 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+18

Hi @CAMORRISON 

Here is an export with inventory items on them for what you are looking for:

 

 

Translate

DConcannon
Varsity II
Forum|alt.badge.img+2
  • Varsity II
  • Answer
  • August 9, 2022

Hi @CAMORRISON 

The image contains the basic join. The allocations occur at the Service Order level, you can join to an Appointment table if you need appointment info on the GI.

 

 

Translate

Forum|alt.badge.img
  • Author
  • Freshman I
  • August 10, 2022

Thank you!

Translate