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.
Now I get: I’m sorry to be so dense, but I don’t understand what you mean by “check once.” My config now is:
Sorry, I got an error and the system switched them back without my noticing. That looks like it might be working now. THANKS SO MUCH!
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.
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. Naveen -- Thanks for your help!
Wow, thanks for the response, Deetz! That sure looks like it to me.
Nevermind. I found it. I knew that was going to happen as soon as I clicked send….
Thanks. I didn’t realize I could put a query in an Attribute tag like that.But I still get an error. When I do my Ctrl-Alt-Click, it says the field is SORefNbr in the FSAppointment DAC. Any idea why it isn’t finding it?Thanks.
Really? Is that all it was? Thanks so much!
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?
Thanks so much for the reply, Daryl. It gives multiple errors, mostly, I’m sure, because I have no idea what I’m doing:'PXFieldSelectingEventArgs' does not contain a definition for 'Cache' and no accessible extension method 'Cache' accepting a first argument of type 'PXFieldSelectingEventArgs' could be foundI don’t know enough about Acumatica to make it work. I was hoping there was something equivalent to the onPageLoad event in C# web development.But I really appreciate your effort to help me.David
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.