You are currently viewing documentation for Linnworks Desktop, if you are looking for Linnworks.net documentation, click here.






Query data ChangeLog

Overview

This document details updates made to the reports that can be generated using Dashboards > Query Data

 

 July 2015

Query Title Description
Sold Stock Between Dates (by Location and Currency) Added a new report type. It is not grouped by source/subsource.
Sold Granular - Between Dates Will not be using inclusive endDate.
Sold Stock Between Dates (by Location and Source) Excluded unassigned/unknown rows due to merged orders and unlinked items.
IWOCA - Sales summary by weeks The report will now display more than a current week.
eBay Duplicate Listings Added a new report type.

eBay Inventory - Active

Added a new report type.

eBay Inventory - Pending

Added a new report type.
eBay Inventory - Ended

Added a new report type.

eBay listings logs

Added a new report type.

Order Split Packaging between dates

Added a new report type.

26 June 2015

Query Title Description
Order Details Between Dates

Added payment method column

16 June 2015

Query Title Description

Stock Consumption Pivoted search

Resolved the issue with more than one supplier per item.

Sold Stock between dates (by location and source)

Added a column Category.
All consumption reports Resolved the issue with DailyConsumption Rate for All Category option.

15 June 2015

Query Title Description
Customers

Added buyer phone number column.

22 April 2015

Query Title Description
Order details between dates

Added PostalService column.

9 April 2015

Query Title Description
Product Suppliers

Added PackSize column.

25 March 2015

Query Title Description
Sold Stock Between Dates (by Location and Source)

the report will no longer duplicate lines and will properly group.

13 January 2015

Query Title Description
Extended Properties

Extended Properties will now display variation parent ones as well.

22 December 2014

Query Title Description
Stock Movement

Stock movement has been optimised.

16 December 2014

Query Title Description
Stock items (with levels)

Item number and item title columns have switched order.

19 November 2014

Query Title Description
Financial Summary Negatives

Added a new report.

18 November 2014

Query Title Description
Variation Items by Parent

Added a new report.

11 November 2014

Query Title Description
Purchase Order Items

The report will now correctly work for paged version.

3 November 2014

Query Title Description
Product Images

The report will now include variation parents.

24 October 2014

Query Title Description
Purchase Order Items

The report will now include returned quantity.

23 October 2014

Query Title Description
Stock Item Sold Pivoted Monthly

The report will now be compatible with SQL Server 2005.

6 October 2014

Query Title Description
Stock Item Sold Pivoted Monthly

Resolved an issue where the report was incorrectly handling orders from first day of the month.

19 September 2014

Query Title Description
Sold Granular - Between Dates

Resolved an issue where the report was using processed date instead of received date.

27 August 2014

Query Title Description
Stock Item Sold Pivoted Monthly

Resolved an issue where the report was returning the following error "variable name @ location has already been declared"

19 August 2014

Query Title Description
Basic Finance Export (Between Dates) - No Returns

Resolved issue where return items were being include in report

Channel Information by Source

Resolved issue where items marked as deleted were still being included in the report

Refunds - Order Item Refunds

Resolved issue where some refunds were excluded due to null values when linking to tables for Stock Items and payment methods, where these are null the refund will be included in the report with empty data for the missing values

Stock Item Sold Pivoted Monthly

Resolved an issue where the report was returning the following error "An expression of non-boolean type specified in a context where a condition is expected" due to a date range of 1 year being defined

Stock Movement

Improved performace of query to resolve time out issue
Resolved issue where opening stock that has not change within the specified date range was not being included in the report

15 August 2014

Query Title Description
Refunds - Order Item Refunds (Actioned)

Added Source and SubSource as additional columns in the report

July 2014

Query Title Description
Sold Stock Between Dates (by Source)

Resolved issue where composite children were being double counted.