Hiding the Master kit item on a report

These steps are to hide the master of a kit on a report for the Sales invoice, quotes and other transaction reports.

 

  1. Navigate to the Form Reports module and select the report which you need to adjust.

  2. Open the report in the report designer and click on Transaction lines. E.g. Sales order/Quotes click on the Sales order lines. Once on the right-hand side, left-click on the Cog/gear icon

     

  3. Once the clicked, click the 3 dots on the Filter String to bring on a Filter string box

     

  4. Enter in the Filter String Box the following statement in the bottom section Not (Not IsNullOrEmpty([Bundle Line]) And [Product.Kit Items][])

  5. Once that is complete, save the change and test the report with a transaction that contains kit master and components. The components should appear but not the master on the report if successfully.