Problem
- Sales Listing report does not consolidate when Report Style "Summarised" is selected.
- The BO Qty/ Value column totals adds up all BO Deliveries instead of just the last current delivery.
- Sales Listing returns Comment lines from sales order lines.
- Columns are being duplicated when changing grouping levels.
Solution
SQL skills are required
SQL skills are required
A sound knowledge of SQL is required to complete this task.
Download and save the attached stored procedure and report and then
- Run the SQL script over the relevant database
- Login to the database
- System Settings > Report Configuration > Reports
- Click Refresh from Files
- Select the report to be imported and OK
- Message displays to indicate report has been successfully updated
Related articles
- DEV-5009Getting issue details... STATUS
- DEV-5958Getting issue details... STATUS
- DEV-6713Getting issue details... STATUS