Skip to main content
Solved

External Reference field not working on report


  • Freshman II
  • 4 replies

Noob question, I apologise in advance.

On a sales order I have these two fields that I am trying to add to a report.
 

I reference the first field in a report with

=[SOOrder.CustomerOrderNbr]

and it works perfectly.

However, I reference the 2nd field in a report with

=[SOOrder.ExtRefNbr]

and it produces an empty column.

If that field isn’t ExtRefNbr, how can I determine the field ID?

thanks.

Best answer by Naveen Boga

Hi @Arran  No problem at all!

 

For the External Reference field, we should use the [SOOrder.CustomerRefNbr]. Can you please try and check once?

If you wanted to know any field ID, then you can do like below.

Click on the Customization → Inspect Element → Then click on the field, which you wanted to know the ID. Please find the screenshots for reference.

 

 

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

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3375 replies
  • Answer
  • June 14, 2023

Hi @Arran  No problem at all!

 

For the External Reference field, we should use the [SOOrder.CustomerRefNbr]. Can you please try and check once?

If you wanted to know any field ID, then you can do like below.

Click on the Customization → Inspect Element → Then click on the field, which you wanted to know the ID. Please find the screenshots for reference.

 

 


  • Author
  • Freshman II
  • 4 replies
  • June 15, 2023

Fantastic, thank you.  Customization isn’t available to me presently, I’ve asked for that permission to be added.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3375 replies
  • June 15, 2023

Hi @Arran  Sure. You can see the Inspect Element if you have Customizer ROLE for your user account.

 

 

 


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