2.6.7.0 - 2.6.7.0

2.6.6 - Order Processor

More to Explore

The easiest way to look up anything in your system is with the Explorer tool. With this update, cost centers, locations, stations, and zones are included in the search function. Filter through any of these categories to see descriptions, rules, sizes, capacities, info fields, and much more.

Cycle 2 explorer sections

Workflows On/Off

Set up as many automated tasks as you like with Workflows. With the newly added on/off switch, you can easily toggle the ones you want activated and build processes for testing. The Workflow actions available to you will show only your connected apps.

Cycle 2 workflows switch

Variance Reporting with Epicor

For users of the Epicor integration, we've stepped up the capability to check for variances with PowerPick. The Mapping interface simplifies mapping field handles between systems.
Additionally, import/export for Epicor has been fixed, and when adding info in the connection settings, there is now a "test connection" button to make sure the input is correct.

Cycle 2 epicor mapping

New Features

- In order creation, add warehouse and pass locationId and locationName
- Allocation count is added to orders and order lines
- Workflows offer an on/off switch
- Cost centers, stations, zones, and locations are included in the Explorer
- Users are shown as active or deleted
- Advanced Epicor variance reporting is available
- Overall caching is added

Bugfixes

- Fixed mobile menu from overlapping
- Fixed Order Processor auto-selecting materials
- Fixed orderId sort for work order lines and added asc/desc to locations
- ItemPath warnings show properly, i.e. if license is less than one month from expiry
- The number of licensed warehouses is now checked
- Order processing hooks correctly into PPG web services
- If parameters are missing, SQL doesn't load
- The Workflow actions list only shows compatible apps
- PowerPick models in the Explorer show type descriptions instead of numbers
- Fixed Epicor import/export and added a "test connection" button

New Features

- Adds /api/batches filters
- Adds an /api/batches/delete endpoint
- Adds child storageUnits with names and ids to the /api/orders endpoint
- Adds a query feature if "all" is passed as a filter argument on an endpoint

Bugfixes

- Fixes /api/batches endpoint bug
- Fixes a default row value for creation dates (was assigning the value based on when the code compiled, not the accurate time)
- Fix missing settings/integration filters
- Fix slow queries on /api/work_order_lines
- Allows for no quantity when creating a count order
- Adds asc/desc to work_order_lines?locations
- Fixes mobile menu from overlapping past screen
- Fixes order processing auto selecting materials

New Features

- API and workflow logging now have expanded data
- /api/work_order_lines now can be sorted by locationName, locationId
- Adds a history record for workflows with logs

Bugfixes

- Cleans up User login and report errors
- Optimizes certain reports to run faster
- Fixes a user login bug when no users were found
- Fixes API calls from loading slowly

New Features

- storageUnitId parameter now available on /api/work_order_lines
- New filters for /api/work_order_lines ("name", "directionType", "locContentId", "quantity", "progressType", "orderLineId", "storageUnitId", "batchId", "orderId")

Bugfixes

- Priority parameter in POST /api/orders now accepts both a string and integer
- Report row counts now return correctly

New Features

- ItemPath.com cloud installations now use SSL

Bugfixes

- Connection information doesn't error out when a user isn't logged in

New Features

- Reports can now be deleted from the list of reports

- Explorer, Order Processor, Order Builder, and Report View disabled when Power Pick connections fail

- The list of users can now be filtered by user group (#605)

- User group details can now be viewed and edited from the UI (#605)

- User groups can be created through the UI (#605)

Changes

- Base images now use most recent Alpine Linux version

Bugfixes

- The dashboard settings can now be edited on mobile devices

- Count orders now can be processed in PowerPick

- Order creation now shows an error in the API when there's no web service connection

New Features

  • Dashboard Widgets can now be resized vertically and horizontally
  • License Status now shown in the footer

Bugfixes

  • /api/orders/[id]/delete now uses PowerPick Rule engine
  • /api/order_lines and /api/orders now query properly when looking at a single object

2.5.4.0

New Features

  • PowerPick version now available through /api/status
  • Report Theme is now shown
  • Connection logs are now available through the API
  • Recovery key is now available in case of forgotten administrator passwords

Bugfixes

  • Improperly formatted IDs now send a correct error to the user through the API
  • Materials in the explorer now paginate properly (#544)
  • Fixed PowerPick 4.2.2 compatibility (#538)

2.5.2.1 - API fixes

2.5.2.0

2.5.1.1

New Features

  • (#504) Quantity is now shown for materials in the Explorer
  • (#506) Warning shown if no zones exist on Philips Hue Bridge
  • (#458) Partially picked order lines now show the picked amount in the API under quantityConfirmed
  • (#508) PowerPick and Web Services are now listed as Connections in ItemPath and the API
  • (#511) Locations now show on a Material in the Explorer
  • (#512) Stock indicators now show in the Order Builder

## New Features

- (#432) Display error message when the connection with the API fails

- (#457) An error is returned if the connection to PowerPick fails

- (#465) A user can be added to a group through the ItemPath user interface

- (#438) New Connections API endpoints are available

- (#442) Jobs App now available (adds compatibility with Kardex Jobs module)

- (#498) Philips Hue bridges can now be connected locally and remotely

## Bugfixes

- (#426) Fix productionDate column on reports

- (#423) Fix filtering orders by name when name is a number

- (#445) Fix proper DateTime values as function param default

- (#447) Changes to license now properly updates

- (#464) Invalid limit values are properly handled

- (#476) Transaction not existing returns 404

- (#495) Material Info4 now shows properly in reports

New Features

  • Passwords for ItemPath users can now be reset

Bugfixes

/api/transactions now filter correctly

  • Dynamic fields now show properly in the explorer when they have a space in their name

New Features

  • Explorer now searches across Dynamic Fields
  • Explorer now shows dynamic field data for orders and materials
  • /api/dynamic_fields filters are now available

Bugfixes

  • Fixes pagination when variance filters are applied
  • Report tabs now update numbers correctly
  • Reports now load around 50% faster

New Features

- (#363) The order of the columns in a report can now be set in the report view

- (#379) Reports can now be exported and imported as templates

Bugfixes

- (#377) Get /batches/:id endpoint now checks for authentication

- (#383) Reports now use the limit correctly

- (#387) Epicor app now passes 0 values instead of making them blank

## New Features

### API

- Adds /api/dynamic_fields endpoints

- Adds prefixes to arguments: [gt], [lt], [lte], [gte]. Prefixes are available for all date/number attributes

- Adds many more arguments to /api/locations, /api/order_lines

## Changes

- Deprecates createdBefore and CreatedAfter API arguments

## Bufixes

- Fixes LocationContent reports

- Sorting by date for order_lines no works correctly

2.1.1.0 - Count API

2.1.0.0

2.0.5.0 - Order Builder Updates

New Features

  • Log, Task Reports now available
  • Tasks now show for workflows and integrations
  • Tasks now have individual log files

Bugfixes

  • Logs now show properly for apps
  • Various Epicor app fixes

New Features

  • Materials now have netQuantity, putQuantity, and pickQuantity values in Reports and API
  • Variance Report App is now added

Changes

  • User login now provides feedback when bad data is given
  • ItemPath now works properly on mobile

Bugfixes

  • Material API endpoints are now much faster

New Features

  • Allows SSL certificates in data folder
  • Users tab is now available

Bugfixes

  • Epicor workflows now work for automatic export/import

New Features

  • Epicor App now available in workflows
  • Hourly and minute trigger times in workflows
  • New Explorer areas (orders, materials, bins, kits)

Bugfixes

  • Removed duplicate History creation date field from reports

New Features

  • Rename History records to Transaction records for future clarity
  • New API endpoints for /api/transactions
  • Transactions can be filtered by order, order line, other filters
  • Transaction export state type can be updated via API
  • Order Lines API endpoints now show child transaction records
  • History reports now have more Order and order line fields
  • Materials, Orders, other records are now available in Explorer
  • General search is available in Explorer for some types of data

Bugfixes

  • XLSX files now send in email workflows correctly
  • Epicor app setting to switch direction works properly now

2.0.2.0 - History/Transaction Records

2.0.1.0

2.0.0.0

New Features

  • Orders and Order Lines now have a new "Has Stock" field in the API and reports

Bugfixes

  • Order API endpoints now can display both queued and processed orders together correctly
  • Show Kit now returns correctly

New Features

  • Kit, Kit Line, Job, Job Line, and Client Reports are enabled
  • Users can now be created, deleted, and modified in ItemPath
  • Job, Kit endpoints are available in the API
  • Kit and Kit Lines now have a new "Has Stock" field in the API and reports

Bugfixes

  • Weird development error screens shouldn't show up in ItemPath
  • Workflows should show proper trigger time
  • CarrierId now in Shelf API endpoints
  • LocationId now in Location API endpoints

New Features

  • Widget data can be given a colour
  • Widgets can be given a name/renamed
  • Reports and Workflows now have search and sort
  • "Is" and "not" report filter can now be given multiple comma separated values
  • History reports now have Bin, Storage Unit, Zone, Carrier, Location, Shelf, and Warehouse fields
  • Report Columns can now be reordered
  • Order Line reports now have Line Number, Qualification, Quantity, and Serial fields

Bugfixes

  • Conclusion charts now show up properly on the Reports page
  • The Explorer now shows storage units and locations correctly
  • Dashboard charts now show X-axis values when more than 1 tick wide
  • User now stays logged in
  • Double warehouse field in Order reports has been removed

New Features

  • Dashboard widgets can now be added and customized on the main screen
  • Widgets can be resized, and dragged to reorder
  • Widgets can display conclusion data in bar, line, or number forms
  • Widgets can be customized to be either a historical or immediate dataset
  • Widgets can layer conclusions to have a multidimensional data set
  • Report metadata can now be exported for backup
  • Report metadata can be created via importing a backup file

Bugfixes

  • Login page now hides menu items and other information
  • Login page now prompts when username/password is incorrect
  • User authentication now checks correctly when loading pages other than the home page
  • Current user now displays in the header menu
  • Workflow monthly triggers now trigger on the correct day
  • Workflow trigger times now display correctly

New Features

  • Explorer tab now available, showing Storage Units
  • VLM storage units now show trays and fill levels
  • Locations now have fill level as a column in Reports

Bugfixes

  • History Line numbers now work in reports
  • Reports still run properly if a column is not configured right
  • Pagination in reports now works correctly
  • Reports and Workflow can now be renamed again

New Features

  • Reports now have conclusions, which are historical data snapshots
  • Report conclusions data can be grouped by a certain column
  • Report conclusions can count rows, sum or average columns
  • Report conclusions now can be graphed and charted on a report

Bugfixes

  • FIXED: Export to a file should not crash
  • FIXED: Background job processor should not memory leak with new stopping/starting
  • FIXED: MSSQL background memory leaks

New Features

  • Cost Center reports are now available
  • Cost Center data is now available in History reports
  • App listing now available

Bugfixes

  • Logged in user now shows in header
  • User login is more reliable

New Features

  • Workflows can now be created, edited and deleted
  • Workflows can now be triggered at a specific frequency
  • Workflows can now have criteria for when they will run
  • Workflows can have an output action to an App
  • Emails now have a configurable subject line
  • Workflows now can be named
  • Templates now can apply styling to PDF, XLSX reports

Bugfixes

  • Workflow actions now can be edited correctly
  • Log view now pulls proper data
  • Trigger time now functions correctly
  • Workflow actions don't copy across workflows

New Features

  • Apps can now be viewed on the Apps tab
  • Apps can have any number of integrations, which act as templates for how apps work
  • API endpoints for Order Lines are now enabled

Bugfixes

  • The dashboard now has accurate and live data (no charts yet)
  • Users now are logged in permanently unless the windows is closed
  • The dashboard now redirects properly if not logged in
  • Ordering on API endpoints now works correctly
  • Counting function on many API endpoints now works correctly
  • MasterOrder Station column now works correctly in Reports

New Features

  • Numbers in Reports can now be filtered by not equals
  • Location Content Breakdown is now an available base table, with Location, Shelf, Carrier, Storage Unit, and Warehouse data
  • Material and Location reports now have Permitted Value, Expected Value
  • Material reports can now have Supplement data
  • Order Line reports can now have Material, Job and Order data
  • Shelf and Location reports can now have Zone and Carrier data
  • Zone, Location, LocationContent, Shelf, Carrier, Storage Unit reports now have Warehouse data

Bugfixes

  • XLSX files now generate data correctly
  • Report Columns are now sorted alphabetically
  • Pagination now updates properly when new filters are added
  • Current Quantity columns in Reports now calculate much faster

New Features

  • Export now has the ability to output to an XLSX file
  • Export to CSV now has the ability to change the delimiter
  • Report API endpoint now supports asking and receiving CSV, XLSX files
  • New API endpoints created for sending and receiving files

Changes

  • Report listing now has smaller fonts
  • Cleaned up button and tables styles

Bugfixes

  • Report Columns with data from far away tables should now sort correctly
  • Title and Icon in web browser should show correctly instead of the default
  • Like, Starts, and Ends filters now work properly when on a joined table column
  • ConfirmedValue, DeviatedValue, and RequestedValue now should sort properly

New Features

  • Reports can now be sorted by clicking on the table column, either ascending or descending
  • Reports save sorting preferences
  • Reports now have an Export button, which will create a file to any of the enabled outputs
  • Reports can now be deleted from the Edit Report view
  • Report filters now have a Not Equal filter option
  • API logs now have a Clear button, which will remove all logs

Bugfixes

  • Reports now properly show an indicator when loading data
  • LocationContent / Count Date now works as a date
  • Storage Rules Report Max Bin field now works correctly
  • Starts with/ends with filters now work properly
  • Filters now only show greater than/less than when filtering on a number field
  • Login should now trigger properly from the dashboard
  • New Report form should now redirect properly to the report view
  • Users plaintext password should now be hidden in API logs
  • API logs paginate correctly
  • API logs now show the correct count
  • Report Columns now have the correct name when editing

1.2.0.0 - SCI Load Balancer