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?
Answer
Generic Inquiry
Best answer by DConcannon
Hi
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.
+17Hi
Here is an export with inventory items on them for what you are looking for:
Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
+2Hi
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.