Hi All,
I want to display the appointment nbr in SO detail TAB so I have added and I want to display the list the appointment nbr. what should I add in the code to pull the respective appointment nbr?
Best answer by Anacarina Calvo
View originalHi All,
I want to display the appointment nbr in SO detail TAB so I have added and I want to display the list the appointment nbr. what should I add in the code to pull the respective appointment nbr?
Best answer by Anacarina Calvo
View originalTo get the Appointment Nbr, you need to join the below tables.
First Join:
SODet (SrvOrderType, RefNbr, SODetID) Join with FSAppointmentDet (SrvOrderType, OrigSrvOrdNbr, SODetID)
Second Join:
FSAppointmentDet (SrvOrderType, RefNbr, AppointmentID) Join with FSAppointment (SrvOrderType, RefNbr,AppointmentID)
From the FSAppointment table, you will get the Appointment Number, and you can assign it to SODet table.
Hope this helps!
Thank you
I would highly recommend you to go through the T series - certification, you will get good knowledge and then work on the customizations.
Hi
The Last Reference column is available out of the box and will show the link to the last appointment in which the line was included. Keep in mind that one line could be in multiple appointments at the same time.
You can expose the column, using the Column Configuration, on the Details tab.
Thankyou so much for your help
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.