Skip to main content
Solved

Staff members not assigned to appointments for a specific day

  • February 12, 2025
  • 5 replies
  • 144 views
  • Translate All

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

 

View original

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.

Translate

Forum|alt.badge.img

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

 

Translate

  • Freshman I
  • March 4, 2025

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

Translate

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

 

Translate

  • Freshman I
  • March 6, 2025

​@rethavanalphen11 , thanks a lot super helpful! 

Translate