Skip to main content
Question

Add AMProdOrdID to SO641010

  • April 24, 2023
  • 4 replies
  • 45 views

nathantrauscht
Semi-Pro II
Forum|alt.badge.img

I am trying to add the SOLine linked AMProdOrdID to SO641010. According to the DAC Schema Browser, this is within SOLine table. But, it’s not showing up in the available fields in report designer.

Anyone have any ideas?

4 replies

ThasinduRanasinghe61
Jr Varsity I
Forum|alt.badge.img

@nathantrauscht  which field are you referring to in Acumatica screen ?


nathantrauscht
Semi-Pro II
Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • April 25, 2023

@ThasinduRanasinghe61 I am referring to the field AMProdOrderID 

 

After looking at the DAC Schema, seems like I will need to join AMProdItem, or maybe a subreport is better.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • June 14, 2023

Hi @nathantrauscht were you able to find a solution? Thank you!


nathantrauscht
Semi-Pro II
Forum|alt.badge.img

@Chris Hackett yes I was able to sort this out, have not had time to post the solution unfortunately