How to set IsVisibleInReports using the Model

Kirsten_Greed · 2 March 2018 02:31

Click the Tools menu tab , then click the Edit Model icon on the toolbar
01Capture

Kirsten_Greed · 2 March 2018 02:34

Expand BOModel
Then Expand SBD.JobTal.Model.BusinessObjects
02Capture

Kirsten_Greed · 2 March 2018 02:36

Select SalesOrderLine and set IsVisibleInReports to True

Kirsten_Greed · 2 March 2018 02:37

When you exit the Model Editor you will be asked whether to save changes. ( Say yes to keep your changes)

Kirsten_Greed · 2 March 2018 02:38

Now when you add a Report you can use the Sales Order Lines Data Type
04Capture

Kirsten_Greed · 2 March 2018 02:39

Remember to set the criteria of the report up to exclude canceled orders!