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
| Warning |
|---|
SQL skills are requiredSQL skills are required A sound knowledge of SQL is required to complete this task. |
| Panel | ||
|---|---|---|
| ||
Download and save the attached stored procedure and report and then
|
Related articles
| View file | ||
|---|---|---|
|
| View file | ||
|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Page Properties | ||
|---|---|---|
| ||
|