Skip to main content
Solved

Staff members not assigned to appointments for a specific day

  • February 12, 2025
  • 5 replies
  • 50 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

 

View original
Did this topic help you find an answer to your question?

5 replies

vdiaz
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Moderator
  • 93 replies
  • 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

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
  • 2 replies
  • 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
  • 2 replies
  • March 6, 2025

@rethavanalphen11 , thanks a lot super helpful! 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings