Skip to main content
Solved

Add User Defined Fields in report

  • 19 February 2021
  • 9 replies
  • 1638 views

KrunalDoshi
Freshman II

Hi,

I have created an User Defined Field in Sales Order form. I want to add the same in Sales Order printed form (SO641010). I am aware the value for User Defined Fields are stored in SOOrderKvExt but I do not see in Report Designer. I have even tried Build Schema > Load schema and Refresh/Refresh All, but still I am not able to get it.

Any suggestions?

I am using Acumatica version 20.208.0031.

Best answer by Naveen Boga

Hello Krunal,


In reports, the SOOrderKVExt table will NOT be shown and the User Defined Fields will be available in the SOOrder table. 

I just created User Defined Fields on the Sales Order screen and I can able to fetch the fields from the SOOrder table in Reports.

 

Please find the screenshots for reference.
 

 

 

 

 

Hope this helps!!

 

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

9 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • Answer
  • February 19, 2021

Hello Krunal,


In reports, the SOOrderKVExt table will NOT be shown and the User Defined Fields will be available in the SOOrder table. 

I just created User Defined Fields on the Sales Order screen and I can able to fetch the fields from the SOOrder table in Reports.

 

Please find the screenshots for reference.
 

 

 

 

 

Hope this helps!!

 


KrunalDoshi
Freshman II
  • Author
  • Freshman II
  • 10 replies
  • February 19, 2021

Exactly I was looking for. I remember for Attributes it is <AttributeName>_Attributes and for UDFs it is Attribute<UDFName>. But for some reason, it was not showing and now it is.

Thanks for our help.

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • February 19, 2021

@KrunalDoshi  You’re welcome.


Forum|alt.badge.img

hi @Naveen B !

I found this articule because I’m trying to do something similar. I added 3 UDF to the Invoice form and I wanted to be printed in the ARInvoice report. How do you manage to have avaialable the field “AttributeTESTFIELD” within the SOorder table?

Thanks!!


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • May 24, 2021

Nope, as you have added to the Invoices(SO303000) screen, In the report designer you can see all the Invoices screen UDF fields under the ARInvoice table, and when it comes to the database you can see it on the ARRegisterKVExt table.

Please find the screenshots for reference.

 

 

 


Forum|alt.badge.img

Ok, that's exactly my issue, I don't see the UDF within the table in the report designer, and I'm looking exactly as your image shows, do you know why?


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • May 24, 2021

Okay, I think you may have missed the below steps, please do and check.

  • Click on the Load Schema button, which we reload the tables in the report designer
  • Then click on the Refresh All button, this will refresh the tables and fields

After doing this activity, you will see the UDF fields under the ARInvoice table

 

 


Forum|alt.badge.img

Yes! That was missing!

Thanks a lot Naveen!


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • May 25, 2021

Wonderful :) Thanks for sharing an update


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