Hello,
I can get the site ID (location code) to appear on the SOP order form. However, how can I get the Site ID Description value to appear on the SOP order form? I tried adding a table in report writer but do not see the ability to link to the location code master table. Any tips ?
Thanks,
*This post is locked for comments
Other option is to add 'IV_Location_SETP' (Site Setup) table as a relationship table to the report table from where you are adding the Location Code field (I see 2 tables with Location Code) . Then 'Site Setup' table (table IV_Location_SETP) will be available in report writer to add.
Hi Jay,
You can created a calculated field to get Site ID description by using the report writer function 'RW_GetSiteDesc'. Below are the steps to create and add the calculated field to your SOP Blank Order form.
1. Open your report layout.
2. In the Tool box, select Calculated Fields and Click on New to open the 'Calculated Field Definition' window.
3. Give a 'Name' to the Calculated field (say, Calc_SiteIdDesc) and set 'Result Type' to String.
4. Select 'Functions' tab (below the Result Type dropdown) and choose 'User Defined' option. Select 'Inventory' in the 'Core' dropdown and 'RW_GetSiteDesc' in the 'Function Dropdown'. Click on Add button.
5. Now select 'Fields' tab, in Resources dropdown, choose the table from where you added the 'Location Code' to your report. Select 'Location Code' from the 'Field' dropdown. Click on Add to add 'Location Code' as a parameter to the RW function we added in step 4.
6. Click OK to save the Calculated field definition. You can see the new calculated field in the tool box under calculated fields.
7. Add this to the report in the section where you added the 'Location Code'.
Hope this helps.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (