6.1-r0

What's new?

Client

• Modular navigation, the navigation bar now supports a new presentation of the app to distinguish between modules (Inventory, Planning, Assortment). Each module has its own separate navigation bar.
• New date picker in workspace grids, used when selecting editable date values in cells.
• New searchable dropdown/lookup selector in workspace grids, used when selecting predefined values in editable cells.
• Paste functionality in workspace lookup filters. It is now possible to paste a list of values to select and filter on from within the lookup filter.

API & Forecast

• Ability to explicitly exclude items/locations from forecasts
• Sale on saturday/sunday settings are also available on item level (known issue in this release that these item level settings do not affect the workspace distribution when numbers are updated on weekly/monthly level and distributed to days)

Database

• Database minimum requirements updated to Microsoft SQL Server 2016.
• ~Dedicated value for image identification in item details.~
• Constrainer uses 5.4 order logic.
• Constrainer - new fillup type: DEV-882
• Debug option to batch_update as been added
• Change Lost Sale setting to a percentage value 0-100%
• 'Lost Sale' setting is now also available on item level in item_details

Database Update Scripts

• Check out the update reports (.html files) for prod and staging
• Prod - Patches
  • dbo.settings - order_logic_lost_sale_percentage setting added and run_in_parallel and order_logic_lost_sale settings removed
  • dbo.features - translation feature disabled and data_series, locations, purcahse_plans features removed
  • dbo.role_features - data_series, locations, purcahse_plans features removed
  • dbo.initial_load_translations - Executed to update translations
  • dbo.version_db - Update version number
• Stg - Patches
  • ctr.settings - Update prod database version compatability

Known Issues/Bugs

• Outstanding issues in 6.1 that we are working on a patch for
• New item level setting for sale on saturday/sunday do not affect the workspace distribution when numbers are updated on weekly/monthly level and distributed to days (We plan to address this in 6.2)

Issues

Issues that were addressed and fixed in this release

• See list on Jira
• See code changes on GitHub compare
• See list of pull requests involved in this update on GitHub

Client 6.1.0

• Workspaces - Fix refresh profile on row in data elements. DEV-907
• Users/Feature access - Remove deprecated features. DEV-1105
• Workspaces - Fix IndexedDB and improve flow of opening new Workspace with parent component, cancel ongoing requests etc. PR-168, PR-162
• Remove run in parallel setting from client code. Unused in 6.1. DEV-1068
• Navigation - Development and fixes of modular navigation. PR-37, PR-121, PR-144, PR-111, DEV-1011
• Workspace - Datepicker and lookup dropdown feature, development and fixes. DEV-1010, DEV-1040
• Add i18n/translations to datepickers in client. PR-8
• Workspace - Fix fromRow config on editable lookup column. DEV-1009
• Settings - Add lost sale percentage in client. DEV-902
• Dependencies - Update Ag-Grid minor version, 22.0 -> 22.1 and other dependencies. PR-96
• Workspace - Add paste functionality feature to lookup filters. DEV-983

API 6.1.0

• Forecast - Fix no default forecast type returned from the Database. DEV-1130
• Forecast - Move sale on Saturday/Sunday setting to item level. DEV-993
• Forecast - Explicitly exclude items/locations from forecasts. DEV-941
• Forecast - Don't get forecasts on Christmas, prevent forecast creation when exclude_from_forecast = true. DEV-946
• Forecast - Remove unused/redundant forecast setting forecast_upper_limit_to_forecast_ratio. DEV-969
• Forecast - Fix invalid cast when running Dynamic Forecast. DEV-1055

Databases 6.1.0

• Workspaces - Fix average distribution in de_update_batch_series. Total row of type avg not updating values proportionally. DEV-1131
• Scheduled Orders - Set description action moved to scheduled_orders_post_order_run. DEV-1145
• Remove deprecated features. DEV-1105
• Workspaces - Fix wrong calculation when overwriting data series in total/each week by percentage or sum. DEV-1033
• Staging v2 - Numerous improvements and work towards the next version of the staging database. Not yet released.
• Modules - Work towards future release of modules, e.g Financial Planner, Allocation etc.
• Updates and improvements to build script. PR-194
• Scheduled Orders - Display report name instead of schedule name in origin scheduled_orders_run. DEV-1119
• Order - Fix days covered committed when order quantity 0. DEV-1042
• Clean up purchase plan procedures. PR-173
• Chore - Update how database/modules version is maintained. PR-166
• Fix deleted columns in tables, should not beNULL. DEV-875
• Orders - Get user_id into orders_update_values procedure. Track user changes down to order line level. DEV-921, DEV-922
• Add support for NULL values in batch update, fn_de_qp_bu_values_and_filters. PR-130
• Settings - Remove forecast_api_route unused setting from initial_load. DEV-969
• Orders - Order logic, new order logic, rewrite constrainer, which logic is used. DEV-918, DEV-571, DEV-917
• Order - Fix days_cover- _committed, _on_hand, and days_until_stockout_committed. Wrong in mbe_statistics, not updated. DEV-936
• Item Card - Add dedicated item image url column to item details. DEV-931
• B&M - Module name changes for new modular navigation. PR-56, PR-58
• Add debug option to de_update_batch. DEV-1005
• Fix item group details, wrong column order in all_staging_to_ready procedure. PR-77
• Daily job - Disable service broker om_sales_and_intake_info while daily job. PR-51
• Daily job - Solve silent death/no error log - issues if dependent views fail in daily job. DEV-950