SOINF082 - Sales Listing Report

Owned by Monica Holliday
Last updated: Oct 24, 2024
1 min read

Problem

  1. Sales Listing report does not consolidate when Report Style "Summarised" is selected.

  2. The BO Qty/Value column totals adds up all BO Deliveries instead of just the last current delivery.

  3. Sales Listing returns Comment lines from sales order lines.

  4. 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

  1. Run the SQL script over the relevant database

  2. Login to the database

  3. System Settings > Report Configuration > Reports

  4. Click Refresh from Files

  5. Select the report to be imported and OK

  6. 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

DEV-6713: SOINF082 Sales Listing report does not consolidate when Report Style 'Summarised' is selectedPassed Testing