6.2-r1

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.)

Known Issues/Bugs

Unaddressed issues in JIRA

Issues

Issues that were addressed and fixed in this release

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

Client 6.2.1

• Workspaces - New features and workspaces are created using snake_case to prevent confusion for DB developers who are used to using snake case PR-949, DEV-1835
• Settings - Ability to show the settings default value in the system settings. PR-938, DEV-1826
• Workspaces - When new workspace is created from the system it is added under More dropdown in Navigation. PR-949, DEV-1835
• Workspaces - Add parameter to de_query route to improve debugging. PR-936, DEV-1824
• Grids - Fixing text cutting off in last row PR-937, DEV-1825
• Orders - fix: orders: active view caption saved in local storage PR-934, DEV-1776
• Scheduler - fix: restrict interval input when editing schedules PR-920, DEV-1779
• Grids - fix: grid. selected row not remembered PR-921, DEV-1770
• Execution List - Fix/execution list/close btn jumping PR-922, DEV-1773
• Scheduler - Fix: When a scheduled task had a schedule with a specific period (beginning) saved but then removed, you wouldn't see that the period was removed because the base date was set as the old period value. PR-924, DEV-1803
• Scheduler - Fix: no more displaying warning msg when deleting a row with unsaved changes in schedule. PR-916, DEV-1805
• Scheduler - fix: save as not working PR-913, DEV-1768
• Settings - System: Show default values PR-951, DEV-1826
• Workspaces - Advanced filter - hide error indication when empty PR-955, DEV-1753
• Workspaces - Series Tags - Make matching series case insensitive PR-952, DEV-1729
• Scheduler - Fix/scheduler/scheduled tasks/history sidebar needs more time PR-973, DEV-1721
• Scheduler - No text was shown when a task was run on schedule, now it indicates that it was run by the scheduler PR-970, DEV-1721
• Scheduler - Let scheduled tasks progress bar show 100% for feedback PR-972, DEV-1856
• Scheduler - move the autofocus from the closing button in the modal to the start from beginning button PR-974, DEV-1856
• Scheduler - fix: Creating task disabled creates it as enabled PR-985, DEV-1867
• Workspaces - Series Tags - Fix a bug that captured non-letters in the first and last words of serie names. PR-950, DEV-1796
• Reports - Report filters inaccessible when there are many columns in the report and item chart is open. PR-963, DEV-1790
• Scheduler - fix: Calendar seems interactive while read-only, and calculate_dates still access restricted when shouldn't PR-988, DEV-1871

API 6.2.1

• Scheduler - Fixing issues around the scheduler timing out too early when executing server side elements PR-971, DEV-1846
• Scheduler - The progress bar was not showing up for tasks that started by schedule PR-953, DEV-1721
• Scheduler - When a task was started manually the next run time would change to undefined, no matter the schedule of the task PR-918, DEV-1754
• Logging - Improved event-log for runs. Reduced number of lines, improved details to undefined, no matter the schedule of the task PR-982, DEV-1798
• Scheduler - Planned Order Executing forecasts with a server side element PR-969, DEV-1814

Databases 6.2.1

• STG - Fix: Navision standard erp tables contain required columns that do not exist in standard NAV PR-964, DEV-1807
• Sales Plans - Fixing initial load so it doesn't include outdated config properties PR-959, DEV-1789
• STG - Fixing issues around datatype mismatch in the dataflow PR-944, DEV-1828
• STG - Scripting of ERP tables failed if server or db have special characters like space. PR-945, DEV-1834
• STG - Fixing strange update of confidence factor in abc_calculate PR-940, DEV-1695
• STG - Fix excessive text logging PR-939, DEV-1827
• STG - Fixing location list issue in [inv].[itemmappopulate] PR-931, DEV-1813
• Orders - Fixed orderlogicsetting discrepancy PR-928, DEV-1811
• Logging - Fake old logging tables so that SysMon works for 6.2 PR-926, DEV-1324
• Reports - Add role back to standard reports initial load if the standard reports collide with custom reports PR-914, DEV-1537
• STG - Case sensitivity fixes PR-911, DEV-1794
• Item Card - Fix problem with crash in item chart that occurs if there are multiple expired entries in undelivered or stocks that have date < today PR-967, DEV-1793
• Orders - Obsolete forecast check improved PR-979, DEV-952
• Logging -Add identity to core event type so custom types don't collide with system types PR-977, DEV-1841
• STG - Adding foreign keys for stg framework PR-983, DEV-1806
• Connected Items - Relocation of connected items to inv schema and some name changes not to collide with the old consultant version PR-962, DEV-1675
• Logging - Improve index rebuild logging PR-989, DEV-1877
• Reports - Wrong usage of EOMONTH in standard reports advanced filter PR-991, DEV-1876
• Forecasts - Refactored variable selection from json config in dynamichistoriessimple_select to improve performance of dynamics forecasts PR-990, DEV-1875
• Inventory - Fix days covered calculations when using the "undelivered all today" setting PR-987, DEV-1288
• Inventory - Including promo and bridge stockout sale history in the sale formula PR-993, DEV-1859