New Features:

• Report Columns now have a type: "Column" or "Comparison"
  • Comparison columns can be used to find the difference between two columns. Finding the difference is currently the only available operation.
• A "Warehouse Material Quantity" column is now available for Material reports and is a custom In order for it to work properly, a filter value must be added to the report column. This can be done by editing the report column once it's been created. This filter value should be the name of the warehouse to filter the quantity by
• For Data Pull using SQL:
  • Comparators can be used in integration filters. The syntax for these comparators is the same as comparators in an API query — supported comparators are lt, gt, lte, gte, not, eq. (If no comparator is provided, eq will be used.)
  • Filters on text fields now support datetime filtering. To use this, the syntax is {lastDay} or {lastWeek}.

Patch 2.9.11.1

Bugfixes:

• When a PowerPick connection was lost, a recently-added query to get the number of PowerPick warehouses was causing ItemPath to be inaccessible.
  
  
  

Patch 2.9.11.2

Bugfixes:

• Continued fix for the issue in 2.9.10.2.

Patch 2.9.11.3

New Features:

• Data Push integrations have a setting controlling the HTTP method used when pushing data. The default is still POST, but PATCH is also available.
  

Bugfixes:

• Fixes various SQL Data Pull bugs.

Patch 2.9.11.4

New Features:

• The History Master Order report now has a "Modified Date" column, which enables filtering by recent date ranges for Dashboard widgets. The "Modified Date" is the most recent date of a transaction from the order.
• Log reports now have an "Integration ID" column for filtering and reporting on Data Pull integration logs.

Bugfixes:

• Users without a set timezone would have an error when exporting reports with date columns, but now the default system timezone is used.
• Updating the number of an order line was done using the "name" key instead of "number". This has been fixed and validates that it is a unique line number.

Patch 2.9.11.5

New Features:

• The GET /transactions endpoints (both LIST and SHOW) now return "stationName", "rank", and "materialInfo1".

Patch 2.9.11.6

Bugfixes:

• If an order was being created with Data Pull or the API, but ItemPath wasn't able to connect to PowerPick Web Services, that error wasn't being caught. ItemPath was returning a false confirmation that the order has been successfully created, but will now return an error message saying it couldn't connect or "Web Services is not installed."

Patch 2.9.11.7

Bugfixes:

• Improves how often Data Pull jobs run.

Patch 2.9.11.8

Bugfixes:

• Helps Data Pull avoid re-running jobs that have already run, and improved requeuing tasks.

Patch 2.9.11.9

Bugfixes:

• Increases the performance of querying logs and tasks, especially for Data Pull.