Replies posted by Kishanptl
Hey all,I figured it out! The only thing I had to change was the links between SOOrder to CRRelation and CRRelation to CRCase. I changed the both “CRRelation.DocNoteID” to “CRRelation.RefNoteID” and it pulls the attribute from Cases and links them to the respective Sales Order!Thank you all for your assistance and patience on this case! I really appreciate it!
@vkumar and @BenjaminCrisman, Sorry! That was a typo, it does indeed read “refNoteID” but it still reads blank. I think the issue is that there is that I haven’t made the link between the Case and it’s Sales Order.For example, looking at Benjamin’s final screenshot of the list of cases, each Case should be linked to an SO. So let’s say SO-00001 is linked to case ID “000097”. I should see SO-00001 with case ID’s “000097” attribute. I apologize if I didn’t make that clear before! Should I consider rebuilding the GI?
Vijay, Thank you for the response! I tried what you mentioned and I might have missed something because it’s still not working quite like how I wanted it to.Here is what I did:Added the CSAnswers table to the GI Created a relation from CRCase to CSAnswers (Parent to Child) Added Data Field links CR.Case.NoteID = CSAnswers.RedNoteID I kept the attribute the same in the results grid so this could also be the issue? Object “CRCase” and Data Field is “Attribute I want to use.”When I go back to the results grid of the GI, the attribute I am trying to pull from is still showing up blank.
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.