SOINF082 - Sales Listing Report
- Monica Holliday
- Mike Sheen
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-5009: SOINF082 - Sales Listing does not return data correctly in Summarised modePassed Testing
DEV-5958: SOINF082 - Sales Listing returns Comment lines from sales order linesPassed Testing