AGR Logo
6.1-r10 master 2020-10-09T12:32:47Z 6.1.10 6.1.7 6.1.6 4 / 21 6.1-r10.zip6.1-r10.zip

6.1-r10

What's new?

  • About Modal - Add additional info to the about modal which indicates the language and locale settings, client timezone and server timezone setting and warns if the server timezone setting is not set up properly. PR-699, DEV-1588
  • Workspaces - Add support for setting drilldown options when transferring to another view as a result of an action. Action results can return a transferView property as well as a drilldowns property with a list of drilldowns and values to set in the target view (transferView). PR-806, DEV-1650
  • Workspaces - Add row selection checkboxes for column only workspaces. The selected rows are passed as filters to action parameters so that actions that require it only execute for selected rows. PR-780, DEV-1592
  • Workspaces - Enable links in workspace cells that route to another view to have different source and target columns to read and update drilldown values from. PR-772, DEV-1649

Database Update Scripts

  • Check out the update reports for updating and patching in the dbscripts\comparereports folder of the release zip file. (Note that all schema changes listed in the patch reports are applied every time you patch the databases, so please check the report and see if you have any customisations in the objects listed there.)

  • Prod - data migration

    • DB 6.1.6
    • Stock history chart element to fn_chart_elements_by_item_id DEV-1585
    • DB 6.1.5
    • Parallel forecast new setting DEV-1558
    • DB 6.1.1
    • Add max fraction digits format DEV-1257
    • DB 6.1.0
    • Add order_logic_lost_sale_percentage setting DEV-886
    • Disable translations feature DEV-1105
    • Remove deprecated features from dbo.features and dbo.role_features DEV-1105
    • Remove run in parallel setting DEV-1067
    • Run initial_load_translations
  • Stg - data migration
    • DB 6.1.0
    • No change

Known Issues/Bugs

Unaddressed issues in JIRA

Issues

Issues that were addressed and fixed in this release

Client 6.1.10

  • About Modal - Add additional info to the about modal which indicates the language and locale settings, client timezone and server timezone setting and warns if the server timezone setting is not set up properly. PR-699, DEV-1588
  • Execution List - Fix custom actions in the execution list dropdown. Fix the execution URL and display the name of the custom actions as they are being run. PR-792, DEV-1609
  • Grids - Fix issue where it wasn’t possible to deselect all selected rows in grouped grids, e.g Orders-grid. PR-762, DEV-1603
  • Item Card - Refresh all series in chart after editing the sales history. It was an issue that only the forecasted sale was updated and new estimated stock and safety stock was missing. PR-766, DEV-1644
  • Item Card - Hide columns in the Item Card Grid that don’t contain any values. This is how it was done in AGR v5.4 PR-694, DEV-1590
  • Orders - Set My Orders filter as default when opening orders for the first time (no state saved locally). Warn users when potentially deleting orders created by another user. PR-794, DEV-1616
  • Workspaces - Fix so that empty strings appear as null in the database instaed of 0. Done by leaving empty fields out so the insert/update procedure treats them as null. PR-783, DEV-1622
  • Workspaces - Add support for setting drilldown options when transferring to another view as a result of an action. Action results can return a transferView property as well as a drilldowns property with a list of drilldowns and values to set in the target view (transferView). PR-806, DEV-1650
  • Workspaces - Fix: Editing the column config of calculated columns not working in the web client (not updating the database). Editing data_element_calc_columns not working in the web client. PR-805, DEV-1580
  • Workspaces - Add row selection checkboxes for column only workspaces. The selected rows are passed as filters to action parameters so that actions that require it only execute for selected rows. PR-780, DEV-1592
  • Workspaces - Fix runtime error when trying to edit names/description of workspaces from the workspace list. PR-774, DEV-1583
  • Workspaces - Fix issue where grid state (e.g. column width) in views was lost when navigation between views. PR-764, DEV-1629
  • Workspaces - Fix issue where editing couldn’t continue in the next cell after pressing TAB to finish cell editing. This error was happening in client calculated series where the whole row was locked after editing one cell. Grid focus was lost entirely when trying to edit locked cell. PR-776 DEV-1647
  • Workspaces - Enable links in workspace cells that route to another view to have different source and target columns to read and update drilldown values from. PR-772, DEV-1649
  • Workspaces - Fix Period Filter so that just 1 month/week or day can be selected when working with fixed periods. PR-692, DEV-1598
  • Workspaces - Fix issue when grouping rows on column values in grid. Issue caused columns that contained values of type other than string to show no values instead of a distinct aggregated indication. PR-705, DEV-1587

API 6.1.7

  • Forecast - For troubleshooting purposes log the confidence factor in the forecast table. Useful to find forecasts that need to be recreated. PR-750, DEV-1619, DEV-1432
  • Reports/Items - Improve upon issue where errors were occuring when editing views in reports/items. PR-720, DEV-1533

Databases 6.1.6

  • Item Card - Fix chart so that stock history series is always shown even though last sale is not included in the period. PR-729 DEV-1585
  • Orders - When item is inactive but still in orders user access filters out the whole order.. If item no was changed to inactive before order is confirmed (e.g. order sitting in AGR system for 3 days) the user access select removes the whole order from the user that is restricted to location. PR-718, DEV-1455
  • Update Script - Update Script now checking for compatibility mode instead of SQL version to see if we are running on SQL 2016 like required DEV-1458