Hi,
Can anyone know how to add the table Order Notes from Order Entry in Report Studio ?
I would like to be able to create a report and see the note inside the order entry.
Here a picture to help you understand what I’m talking.
I want this column.
Here’s an example of how you can join this, however, note that you can have multiple notes per oe_hdr record so you may have to make a decision on which one to use.
select p21_view_oe_hdr.order_no, note_id, topic, note from p21_view_oe_hdr
left join oe_hdr_notepad on oe_hdr_notepad.order_no = p21_view_oe_hdr.order_no
where p21_view_oe_hdr.order_no = 1000001
I get this data from my db
| order_no | note_id | topic | note |
|---|---|---|---|
| 1000001 | 4 | ERP Transition Invoice | ERP Transition- Old Invoice # 01-123456 |
| 1000001 | 73 | tax | #1000-6881 |
| 1000001 | 74 | note | Original invoice # 01-123456A – Please use new invoice # to pay against |
HTH
Hi,
Thank you now I see more how it’s work.
What did I do wrong I copy/paste ? Test Status: TEST FAILED
And for my exemple I need to find every order who have into the note the world : promo
Should I replace : where p21_view_oe_hdr.order_no = 1000001
By
Contains p21_view_oe_hdr.note = promo
??
Thank again for your help 
Hey ! Can you send me a screenshot before you process the request ?
I have try so many thing all the night and nothing working…
I dont understand why the notepad are not by default here ?
They are so many thing we can select but not the notepad 
Did they have a magic trick that we can make appear by default into Report Studio ?
When we adding : Existing database column why the Table Name oe_hdr_salesrep appear and not oe_hdr_notepad ???
