Skip to main content
Solved

Report Writer Struggles - Value appears in Acumatica but I can't insert it into a Report


I’m struggling with an issue with the report writer currently. There is a value that exists within Acumatica that I’d like to display (see “Desiredproperty_Values” for its examine element screen) but despite the category of AMProdMatl being populated by my schema builder (see Schema Builder) it does not appear in the list of values I can assign to appear in a text box. it should have all the same properties as the previous value that appears in the field that I’d like to change from (see Currentproperty_Values) so by my understanding when I use the schema builder to populate my report, that value should also be grabbed.

What am I missing here, folks? Why would populating AMProdMatl pull 1 variable but not another?

Best answer by lauraj46

HI @smechler1 ,

In the Schema Builder, highlight the AMProdMatl table and then click the “Refresh” button.  I tested this in demo data and after that the TotalQtyRequired field was available.

Laura

View original
Did this topic help you find an answer to your question?

4 replies

  • Author
  • Freshman I
  • 2 replies
  • January 16, 2023

My attachments appear to have some problem - these are the intended 4 attachments.


Forum|alt.badge.img
  • Freshman I
  • 26 replies
  • January 16, 2023

Hi @smechler1 

If you change the 2nd from bottom AND on the 4th picture (from the Table Relations) to OR, does that  return any data? 


lauraj46
Captain II
Forum|alt.badge.img+7
  • Captain II
  • 511 replies
  • Answer
  • January 16, 2023

HI @smechler1 ,

In the Schema Builder, highlight the AMProdMatl table and then click the “Refresh” button.  I tested this in demo data and after that the TotalQtyRequired field was available.

Laura


  • Author
  • Freshman I
  • 2 replies
  • January 17, 2023

Refreshing AMProdMatl in the list of available data worked. This property must have been added in the time since we first made this template. Which is probably why I set up the quantity value using the property I did originally.

Thank you @lauraj46 !


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings