Customer Activities tab - Unprocessed Sales to include Job Costing invoices and other non inventory items

Problem

Job costing invoices and non inventory item sales were excluded from the Customer Activities tab in Debtors maintenance - 7.02.01 and earlier

Solution

SQL skills are required

A working knowledge of SQL Management Studio is required to complete this task.

Download and apply the SQL script to the relevant database(s)