Transaction show total quantity exclude service itemⓔ

Overview:

Service item refer to stock code that doesn’t have physical quantity, mostly is use for services like installation, maintenance and so on.

Scenario:

Sales Invoice wants to show total quantity exclude service item

Solution:

1. Go to Task tab and click on Design to open sales invoice report designer

2. Create new format named as Sales Invoices without service item quantity, or double click on existing format to amend

3. Right click on Sales Invoice Details Collection and Add Calculated Field

4. Search for Calculated Field created, right click on it and Edit expression

5. Paste below expression and click Ok

Iif([Stock].[Stock Control]=False,0 ,[Qty] )

6. After that pull out calculated field and save the format.