Customize SOP Reports

[mtndew9]

We are running Great Plains 7.5sp4 and I want customize the Report, SOP Blank Order Form using Great Plains Report Writer. I want to display Inventory Item fields Short Description and Generic Description instead of Item Description. I do not see these feilds in any of the toolbox tables. Is this possible and if so how?

Thank you,

 

[Luvsql]

You will need to link the Item Master table to the report. To do this, print the report to the screen.
Click on Modify.
Close the report Layout.
Click on Tables.
Click on Sales Transaction Amount Work.
Click on New.
Select Item Master.
OKay.
Click on Layout.
Add new fields from Item Master.
Grant security to modified report.

 

[mtndew9]

Thank you for the post. I am new to Great Plains and Report Writer and I didn't want to play with the relationships to much. I figured I would mess up the rest of the report up. It was easy as you wrote. Again thank you for the reply.