Replies posted by davidpoole21
Thanks to Greg Lang and Naveen B for the responses.Greg is right; I should have included more info. I didn’t see an AppointmentID in the ARTran table, so I couldn’t link them that way.Yes, Naveen, we’re using 2021 R1, so maybe that explains part of it, but when I tried your suggested join conditions, I got: Here is my setup: Any further help is greatly appreciated.
Hi @davidpoole21 Can you please try with the screen header view name ? As per the below screenshot, it should be ((ServiceOrderRecords.NoteText)). This didn’t work. Thanks for trying, though. Guess I’ll have to add it to my Generic Inquiry.
Hi @davidpoole21 Yes, As I indicated above, please join with NOTE table in your Generic Inquiry and add that field to Notification template and verify. I didn’t see a good way to join to the NOTE table from the Service Orders screen, but I found a way to add FSServiceOrder.NoteText to my GI. Not sure how many, if any, of these fields are unique to my installation, but on mine it goes like this:Service Orders page; click Customization > Edit Generic Inquiry Results Grid tab + Add a row Object = FSServiceOrder Click in the Data Field column to edit the field, but then click the Pencil icon, not the selector arrow (It’s not in the selector list). Click Fields in the popup, double-click [FSServiceOrder.NoteText] in right-hand pane Ok, Save Go to the Notification Template; position the cursor where you want the Note text Insert > Datafield > FSServiceOrder > =[FSServiceOrder.NoteText] It will insert a formula where the Note text will appear.
I tried using the suggested [PXDefault(typeof(Search<ParentTable.custPORefNbr, Where<ParentTable.ServiceOrderNbr, Equal<Current<ServiceOrderNbr>>>>))], but publishing the customization caused our server to reboot itself endlessly.This is the actual code from the Data Access FS.FSAppointment UsrRempCustPORefNbr nonPersistedField:[PXString(25)][PXUIField(DisplayName="Customer Order")][PXUnboundDefault(typeof(Search<FSServiceOrder.custPORefNbr, Where<FSServiceOrder.refNbr, Equal<Current<FSAppointment.soRefNbr>>>>))] What am I doing wrong? Anybody got another suggestion?
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.