Skip to main content
Answer

Report Designer, CRLead, ownerID is Null

  • September 26, 2022
  • 3 replies
  • 48 views

Forum|alt.badge.img

Version 22.109.0023, was trying to print Lead from report designer by using CRLead, but seems that OwnerID, OwnerID_Descirption are not loading owner data properly, so where I should read Owner field then?

Best answer by woodyg84

We just upgrade from 21R1 to 22R1, so CRLead is new schema. Just figure out the issue. I will need to use leadcontactID to locate the record. don’t know [lead ID] pointing to, report designer does not have that field.

 

this can be closed now.

3 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • September 26, 2022

@woodyg84 Can you provide an example of what you’re looking for vs what the outcome currently is?
The owner field is a number and the description will likely only populate if the ownerID is also present, but I haven’t tested this recently.

If you can show what your end goal is and if possible to upload the report so we can look at it, this could make it easier to help.

To upload the report, open it in Report Designer and click File > Save As… and then upload the resulting .rpx file (make sure it is RPX and not RPS)


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • Answer
  • September 26, 2022

We just upgrade from 21R1 to 22R1, so CRLead is new schema. Just figure out the issue. I will need to use leadcontactID to locate the record. don’t know [lead ID] pointing to, report designer does not have that field.

 

this can be closed now.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • September 26, 2022

Thank you for sharing your solution with the community @woodyg84 !