Skip to main content
Answer

Service Order Generic inquiry is not pulling in values coming up as blank

  • March 12, 2025
  • 2 replies
  • 62 views

Forum|alt.badge.img

I am creating a Service Order Profitability report that allows the user to enter the billing customer ( We used parent/child so I want to be able to pull based on the parent which is the billing customer) and a date range and it shows description, Invoiced amount and Cost amount.

On the service order side when I do inspect element on the totals tab on the service order and hover over the cost total it says the data field is CuryEffectiveCostTotal. By when I add that to my report it’s coming up as blank for every line item.   I am definitely missing something. It jusr doesn’t want to pull that one field in. 

 

 

 

Best answer by eucciferri35

Nevermind I figured out my issue. I need to make sure I actually pull up the DAC table.  The field I was trying to use apparently was not existent in the database.  It was an application field only.

 

I ended up pulling in the appointments table and was able to pull in the cost from there and group by service order.

 

2 replies

Forum|alt.badge.img
  • Author
  • Varsity I
  • Answer
  • March 12, 2025

Nevermind I figured out my issue. I need to make sure I actually pull up the DAC table.  The field I was trying to use apparently was not existent in the database.  It was an application field only.

 

I ended up pulling in the appointments table and was able to pull in the cost from there and group by service order.

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • March 13, 2025

Thank you for sharing your solution with the community ​@eucciferri35!