WhsName on Sales Order - not showing using Print Layout Designer
Show Warehouse Name on Sales Order; add data field to print layout design form.
Only the warehouse code can be shown using OWHS; WhsName does not populate the data field.
Beyond using OWHS, also tried using the "Location" field (which is populated with the same information as Warehouse Name). Other tables have been hit, but can only seem to find the code.
Thank you in advance,
Sweet Leaf Tea Co
Hamsa Gunaseelan replied
Let me repeat the steps (which I've tried out in my test database and works!) . Please reconfirm that you are following them exactly -
1. Create a database field - RDR1.WhsCode say Field_201. in the page header area of the PLD (I assume you want to show the warehouse name on the Page header - you can do the same in the rows as well. But both the fields should be in the same area).
2. Create another database field - OWHS.WhsName say Field_202 in the same area.
3. Now in Field_202, in the relate to field, link Field_201.
4. Hide Field_201.
The above steps will display the Warehouse name in field_202.
Hope this helps.