Skip to main content
Answer

Staff members not assigned to appointments for a specific day

  • February 12, 2025
  • 5 replies
  • 92 views

Forum|alt.badge.img

The Staff Calendar board and Calendar board give a good illustration on Staff members not assigned to appointments for the day.

Appointment Summary provide information on Appointments and can be filtered per Staff member.

How do I get the field service staff members per day that has not been assigned to any appointments out in a GI

 

 

 

 

Best answer by rethavanalphen11

Hallo Thank you for the response. I have been able to create the GI to view per day the Employees on appointments and then the Employees per branch location not been allocated.  All resolved. Thank you Retha

 

5 replies

vdiaz
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Moderator
  • February 17, 2025

@rethavanalphen11 HI!

I see your point, and I understand how this could be useful for users. However, Acumatica does not have a built-in Generic Inquiry (GI) that does this.

You might try creating a GI using a left join between EPEmployee and FSAppointmentEmployee (which corresponds to the Staff tab on the Appointments form). Then, filter for employees who are not in FSAppointmentEmployee for the current date.

I haven’t tested this myself, but it could be a good starting point.


Forum|alt.badge.img
  • Author
  • Freshman II
  • Answer
  • February 17, 2025

Hallo Thank you for the response. I have been able to create the GI to view per day the Employees on appointments and then the Employees per branch location not been allocated.  All resolved. Thank you Retha

 


  • Freshman I
  • March 4, 2025

Hi ​@rethavanalphen11 , Would you be able to share which table relations you used for the GI? 


Forum|alt.badge.img

Daily Appointment Status Report

I will upload the GI’s

The first - Get the Daily appointments per Service branch and status for today

Second -to get the Staff members for a Service branch not linked to an appointment for the day

The DailyAppointments GI is used as a related GI by the DailyAppointmentTracking

Final as a result:

  1. I get the Daily Status on appointments per Geozone
  2. On as side panel I then display the employees not booked to an appointment per branch
  3. All Appointments where no Service Staff has been assigned

 


  • Freshman I
  • March 6, 2025

@rethavanalphen11 , thanks a lot super helpful!