I have opened a case with MS to correct a wrong labelling that we are experiencing in D365 F&O when we are using appointment scheduling inside the transportation management module, but MS claimed that it is not a bug, it is by design that label.
The system is calling "Late on Check-in" as the status of the appointment when the appointment duration has been exceeded even thought the driver was check-in earlier than the planned start time. This is creating confusion and a potential mischarge for late fee to a customer due to wrong name for the status.
Comments
There are 2 tables: driver log (TMSDriverLog: as far as I see 1 record per appointment) and appointment history (TMSApptHistory: multiple records per appointment)
Purpose is to see all late check ins and all late check outs separately (because late check in is usually caused by transport company, and late check out is often caused by internal picking and loading work force)
Proposed solution:
Appointment notifications should insert in the appointment history a record with reason code Late check in when:
Driver check in required and
Driver not checked in and
Appointment start time has passed and
No appointment history record for this appointment for Late check in exists
Appointment notifications should update the driver check in / out details (driver log) with alert = Late check in when:
Driver check in required and
Driver not checked in and
Appointment start time has passed and
No appointment history record for this appointment for Late check in exists
Appointment notifications should insert in the appointment history a record with reason code Late check out when:
Driver check in required and
Driver has checked in and
Appointment end time has passed and
No appointment history record for this appointment for Late check out exists
Appointment notifications should update the driver check in / out details (driver log) with alert = Late check out when:
Driver check in required and
Driver has checked in and
Appointment end time has passed and
No appointment history record for this appointment for Late check out exists
Category: Transportation Management
Administrator
Hello,
Please check below information of appointment status with your scenario.
Sincerely, Roger Sa PM, Microsoft