Skip to main content
Solved

Intercompany Sales Order Number not displaying on Purchase Order document

  • 29 January 2024
  • 3 replies
  • 66 views

Hi everyone.

I am encountering a layout error with a field that will not display when printing on a Purchase Order.

 

  1. I have created a PO and generated an intercompany Sales Order. under the “others” Tab of that purchase order there is a Related SO nbr which i need to display on my PO layout.

 

  1. In my Report Designer i have selected this field [POOrder.IntercompanySONbr]. It is standard in the Schema and did not need to be brought in via manual connecting.

 

 

  1. When i print this report the field is blank and does not show the related SO Nbr.

 

 

I have tried refreshing the Schema and refactoring but nothing has seemed to change.

Would anyone have an idea to what the issue could be here. 

Best answer by marilizevanzyl

@liam64 

You will most probably need to Left Join in the SOOrder table and join it as follows:

POOrder.OrderType to SOOrder.IntercompanyPOType

POOrder.OrderNbr to SOOrder.IntercompanyPONbr

 

Hope this helps.

Marilize

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

3 replies

Forum|alt.badge.img

Hi @liam64 

That is a virtual field, meaning it’s not a field in the Database on the POOrder table. Report Designer can only show fields that are located in the Database, not virtual fields.

 

You will need to see how the join looks that they are doing to create this and replicate it on you report.

Kind Regards

Marilize

 


Forum|alt.badge.img
  • Jr Varsity II
  • 51 replies
  • Answer
  • January 30, 2024

@liam64 

You will most probably need to Left Join in the SOOrder table and join it as follows:

POOrder.OrderType to SOOrder.IntercompanyPOType

POOrder.OrderNbr to SOOrder.IntercompanyPONbr

 

Hope this helps.

Marilize


  • Author
  • Freshman I
  • 4 replies
  • January 30, 2024

@marilizevanzyl 

Thank you very much this worked


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