Solved

Generic Inquiry Exports! How to show open service orders with no appointments? Or how to count # of appts in GI

  • 25 February 2021
  • 4 replies
  • 129 views

Userlevel 4
Badge +1

Looking for help from GI experts! It is very difficult to distinguish between open service orders that have appointments scheduled for the future and open service orders that have appointments that have past or no appointments at all. (In this case, appointment needed = false). 

I’m creating a custom GI called “Appointments on Open Service Orders” that shows me if there are future appointments for a service order or not. This appears to work--I can identify if there are no future appointments, therefore triggering review.

The only issue is it doesn’t show me open service orders that have no appointment at all. Generally, if the service order is open, no appointments are created and appt needed = false, it’s because there is nothing in the Details tab (to trigger appt needed). I can’t figure out how to create a way to catch this (because there are no appointments and no details, so what do you use for GI?).

So, I have two questions: 

  1. Does anybody know how to “catch” open service orders with no appointments? 
  2. Or, does anyone know how to count the number of appointments for a service order?

XML of the GI has been attached. 

 

Thank you!! 

icon

Best answer by gmercede 25 February 2021, 17:02

View original

4 replies

Userlevel 4
Badge +2

Sean,

 

Create a GI (the one you sent has too many tables) with service order and appointments joined.

Group by Service Order refnbr and aggregate Count by the result field appointment refnbr

 

See attached.  This will give you number of appointments

Userlevel 4
Badge +1

@gmercede Thank you! I was able to successfully count the number of appointments! The GI I sent I just copied from an existing and didn’t really change touch the tables, but makes sense to clean that up… 

Out of curiosity, would you happen to know if there’s an easy way to return the latest appointment schedule date? See screenshot below. This service order has 6 appts, but I want to know the scheduled start date of the sixth appointment. 

 

 

Userlevel 4
Badge +1

@gmercede never mind! I just used a MAX formula and it appears to work! 

Userlevel 4
Badge +2

Yup max is perfect way to do it!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved