Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Warning
title

SQL skills are required

SQL skills are required

A sound knowledge of SQL is required to complete this task.

Panel
bgColor#fff

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

View file
nameSOINF082 - Sales Listing.rpt

...

View file
nameusp_Jiwa_SalesOrders_SalesListing.sql

...

Jira Legacy
serverJiwa Servicecolumnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolutionSystem Jira
serverIdf9231aec91fbcd9b-a65a5d0b-32ae3b97-94f3a585-7114fec5f2531a06ec62a231
keyDEV-5009

Jira Legacy
serverJiwa Servicecolumnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolutionSystem Jira
serverIdf9231aec91fbcd9b-a65a5d0b-32ae3b97-94f3a585-7114fec5f2531a06ec62a231
keyDEV-5958

Jira Legacy
serverJiwa Servicecolumnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolutionSystem Jira
serverIdf9231aec91fbcd9b-a65a5d0b-32ae3b97-94f3a585-7114fec5f2531a06ec62a231
keyDEV-6713

Page Properties
hiddentrue

Related issues