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!!

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.

@KrunalDoshi  You’re welcome.

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!!

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.

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?

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

Yes! That was missing!

Thanks a lot Naveen!

Wonderful :) Thanks for sharing an update