AGR Releases

All tagged AGR releases from the AGR repository since Jan 2020.

This page is built dynamically from the contents at github /agr/releases. The latest/relevant releases for each minor version is specifically highlighted in the list. You can also find this page on the world wide web at releases.agrdynamics.com/


6.3-r32	release/6.3.x	2025-02-25T14:58:43Z	6.3.22	6.3.32	6.3.32	0 / 0	6.3-r32.zip 6.3-r32.zip
6.3-r32 Release notes - AGR Development - 6.3-r32 Task DEV-9457 6.3. Adding the Insight columns to order view (grid/info) DEV-9741 Use BIGINT for item_order_routes.id DEV-9865 Table cleanup for order_line_runs_lists and order_item_lists DEV-9945 Change schedule task name "Monthly forecast" to "Forecast all items" DEV-9951 Fix filtered PRIMARY_CHK index on raw.PRODUCT_PURCHASE/TRANSFER_INFO DEV-9959 Connected Items: Forecast not re-calculated when scale is changed DEV-10034 Planned order - transferred planned orders still showed in the chart DEV-10043 Use GETDATE instead of old today function DEV-10055 Error in order_view_recreate if space in column_name_in_table DEV-10069 Not use NOLOCK in order_view_recreate / v_order_master_view DEV-10106 Hack core.event concept to deal with bad core_trigger_data_factory logging DEV-10208 constrained_order_validate_data called with order-run-id instead of order-constraint-run-id DEV-10214 Use core.setting_xxx functions in hard core objects DEV-10239 demand_processing_calc_run, use MERGE for demand_from_stores DEV-10254 Use forecast_number_of_days in order logic @days_to_calc DEV-10256 Performance issue in v_stocks_today and v_undelivered_today after function stg.date_for_daily_run DEV-10557 inv.abc_calculate, remove obsolete DEV-462 update DEV-10564 Parallel forecast skip zero rows DEV-10763 tb.batches_report DEV-10765 Drop obsolete log_api table DEV-10771 ex views 2025-01 DEV-10973 Order archive, handle planned orders and updated order lines Bug DEV-6097 6.3. Item order routes extra info - Bug DEV-10863 6.3 Sale Forecast and Estimated Stock not being displayed correctly and consistently DEV-11083 Plus 6.3. Item card chart shifting "to the left" for data series (JYSK Canada) DEV-11172 Fix item chart - double november - no march in chart
6.3-r31	release/6.3.x	2024-09-17T13:52:14Z	6.3.21	6.3.31	6.3.31	0 / 0	6.3-r31.zip 6.3-r31.zip
6.3-r31 Release notes - AGR Development - 6.3-r31 Task DEV-9627 Parallel forecast using SWITCH DEV-9827 order_view_columns.order_view_table_id = NULL for exception_list after upgrading from 6.2 to 6.3 DEV-9847 Change setting forecast_number_of_days from 380 to 366 DEV-9855 Implement mixed login, user-pass + SSO in 6.3 Bug DEV-9772 inv.de_act_connected_item_add not logging datetime in created/update_at
6.3-r30	release/6.3.x	2024-08-09T11:20:23Z	6.3.21	6.3.29	6.3.30	0 / 0	6.3-r30.zip 6.3-r30.zip
6.3-r30 Release notes - AGR Development - 6.3-r30 Task DEV-7659 Bom demand should be standard in the demand calculation DEV-8720 Upload 6.3 images to Amicis container registry DEV-8986 Stockout smoothing, stockout_stop_bridging_after_days not working correctly DEV-9049 Allocation improvements DEV-9101 Add column mbe_item_statistics.stock_total DEV-9108 Change create db scripts DEV-9113 Add column mbe_item_statistics.undelivered_total DEV-9133 Demand series, when forecast + demand from stores then sum both default DEV-9137 mbe_columns.skip_lookup_join + location_groups_populate DEV-9168 tb.enable/disable_mbe_column DEV-9187 inv_run_demand changes after testing at Nille DEV-9269 Run sale and stock history further on weekends, make it easier DEV-9355 Support starting daily before midnight DEV-9441 Performance problems in prep.v_product_item_sku DEV-9442 More xxx_cus options DEV-9581 Make de_query sql more readable DEV-9600 stg/prod.info 'settings not default' DEV-9604 Add scheduled orders tables to audit DEV-9659 Index maintenance improvements Bug DEV-8969 Orders. Date picker retains previously selected date for Coverage Days, even if deleted, and sends it in DEV-8999 Parallel collate issues in demand calculations DEV-9505 BOM improvements DEV-9577 Estimated Stock Series configured incorrectly DEV-9665 6.3. Weekly forecast profiles not working
6.3-r29	release/6.3.x	2024-04-18T11:00:32Z	6.3.21	6.3.28	6.3.29	0 / 0	6.3-r29.zip 6.3-r29.zip
6.3-r29 Release notes - AGR Development - 6.3-r29 Task DEV-7878 demand_processing_calc_run_schedule_check not using #item_id_list to limit rows DEV-8069 Change inv.v_histories_sale to skip value = 0 rows DEV-8639 Log order status changes to table orders_status_log DEV-8673 tb.bom_info DEV-8713 Change raw views: point to element + column names left justified DEV-8787 Bad migration script in 6.3.0 updating over order_view_columns 66-68 DEV-8790 Add filter on "forecasted demand > 1" in standard report "1.01 Urgent Order Required" DEV-8932 demand_processing_calc_run, drop table #item_scheduled_order_dates_with_reports DEV-8960 Connected items workspace, clear date button not working DEV-8967 prod.info: order matrix multiple order_date to single order_period_date DEV-8982 items_dx_populate slow at PetValu Bug DEV-8816 Days cover until SS wrong DEV-8829 Item card. Query issue when opening an item card (Critical)
6.3-r28	release/6.3.x	2024-03-07T12:56:08Z	6.3.20	6.3.28	6.3.28	0 / 0	6.3-r28.zip 6.3-r28.zip
6.3-r28 Release notes - AGR Development - 6.3-r28 Task DEV-8310 Helper objects 2024-02 DEV-8386 Customization checker improvement DEV-8389 scheduler_pulse showing if scheduler was alive at the time DEV-8412 scheduled_tasks_log DEV-8434 DB code cleanup 2024-02 DEV-8563 Order exception cleanup DEV-8567 Use CONNECTIONPROPERTY('client_net_address') instead of zys.my_ip DEV-8579 Indexes 2024-03 Bug DEV-8427 Scheduled task (f.ex daily job) run 2x in row. DEV-8450 Problem with endpoint /api/orders/status DEV-8472 Scheduled Task issue zys db stats -execution_status and next_run_time fixed
6.3-r27	release/6.3.x	2024-02-12T14:45:33Z	6.3.20	6.3.26	6.3.27	0 / 0	6.3-r27.zip 6.3-r27.zip
6.3-r27 Release notes - AGR Development - 6.3-r27 Task DEV-8286 Missing index/columns in demand_processing_calc_run_results after migration script 25 DEV-8287 demand_from_stores usage not correct after SWITCH
6.3-r26	release/6.3.x	2024-02-08T12:24:55Z	6.3.20	6.3.26	6.3.26	0 / 0	6.3-r26.zip 6.3-r26.zip
6.3-r26 Release notes - AGR Development - 6.3-r26 Task DEV-6363 demand_processing_calc_run - save the list of items causing error in demand to a table DEV-7538 Scheduled orders - list fetched via a procedure Release Notes Scheduler uses proc instead of sql query to get scheduled tasks DEV-7746 Change setting days_cover_calc_stock_days_type to be DEFAULT 3 for new setups Release Notes Now uses demand calc results to populated days cover values but fills up with estimates for items that are not included in demand calculations DEV-7747 Change ABC to have scaling default off for new setups DEV-7786 Change to new logo in AGR on plus DEV-7796 Denormalize items master data to table items_dx Release Notes Denormalized table makes it easier to query item data by reducing the number of joins needed DEV-7798 Forecast 6.3: Outlier detection not working when running it from the item card DEV-7821 demand_processing_calc_run not using #item_id_list for "Adding from the store order matrix" part DEV-7826 Performance improvements - Index tuning DEV-7880 Change index maintenance to reindex tables with 200+ pages DEV-7881 Allow index maintenance on different days for stg and prod databases DEV-7893 Change scheduled_orders_post to scheduled_order_post_batch_custom Release Notes For improved customizability, improved naming of scheduled order post procedures DEV-7963 Change index maintenance to use default 15/45 % for reorganize/rebuild DEV-7977 Demand parallel execution options as standard Release Notes Adding a standardized way to execute demand parallel run. This can be useful for larger customers where the demand run takes hours DEV-8068 Change raw.v_SALE_HISTORY to use Quantity <> 0 DEV-8168 Performance fix in mbe_item_statistics_populat DEV-8208 Use cursor variable in demand_processing_calc_run DEV-8209 Clustered index on demand_processing_calc_run_results.item_id to avoid full scans DEV-8210 DROP INDEX IX_ItemLedgerEntry á nav/erp/erp_bc_sql.ItemLedgerEntry DEV-8211 Change designated little override procs to have Author AGR DEV-8235 Forecast stays on the item after connection in connected Items is deleted DEV-8236 Calculation "Forecast missing" on dashboard error DEV-8274 Helper objects 2024-01 Bug DEV-6122 Closed items that should get forecast will not have forecast when item card is opened until Forecast Service is restarted. DEV-6140 Forecast 6.3: When confidence factor is set to 0% in item card the forecast is not removed. DEV-6933 Update Order Status always logged on system user DEV-7570 Forecast and Demand randomly disappears from item chart when recalculating forecast with forecast profiles DEV-7669 Scheduler - Tasks - run 2x at same time DEV-7914 Item details read only bug - users not seeing updated values
6.3-r25	release/6.3.x	2023-11-17T11:29:23Z	6.3.19	6.3.23	6.3.25	0 / 0	6.3-r25.zip 6.3-r25.zip
6.3-r25 Release notes - AGR Development - 6.3-r25 Task DEV-7692 Make sure SWITCH tables have columns in same order
6.3-r24	release/6.3.x	2023-11-15T16:46:35Z	6.3.19	6.3.23	6.3.24	0 / 0	6.3-r24.zip 6.3-r24.zip
6.3-r24 Release notes - AGR Development - 6.3-r24 Task DEV-6571 Improve stockout smoothing code DEV-6819 Hide data series from promotion module in Sales Plan by default and not have standard Promotions with "Old" in caption Promotion data series in Sales Plan that are coming from Promotion module are now hidden by default (as these series are not configured into standard demand calculations) and the standard empty promotion series in Sales Plan now has the caption "Promotions" instead of "Promotions (Old)". See more details in the jira issue how to make Promotion Series from Promotional tool unhidden. This change is only made for new 6.3 setups. DEV-7527 Columns ORIGINAL_NO and original_item_no should be NVARCHAR(255) DEV-7538 6.3 ping sql to procedure Proc scheduler_get_tasks_runs has been added DEV-7552 Log days_back to core.event in daily We want to log setting core_days_back_to_retrieve_data so that we can see in the log if days back can explain slow running elements DEV-7553 Use SWITCH for heavy daily prod elements so system can be used while running DEV-7603 Change view v_mbe_item_statistics_abc to use lookup table Change view v_mbe_item_statistics_abc to use lookup table DEV-7635 Helper objects 2023-11 Release Notes Fix zys.info server/database to work on azure Change zys.debug_info.info_text to NULL column
6.3-r23	release/6.3.x	2023-11-01T11:00:16Z	6.3.19	6.3.23	6.3.23	0 / 0	6.3-r23.zip 6.3-r23.zip
6.3-r23 Release notes - AGR Development - 6.3-r23 Task DEV-7214 tb.events 0 as default Release Notes tb.events 0 as default DEV-7257 Master Item Id not updating when item is closed Release Notes Fix: Item id linked to master item is closed and the master item item id does not jump to the next open item. Causes Items to be missing from planner. DEV-7266 inv_cus.item_order_routes_populate DEV-7289 Decrease location info logging Decrease location info logging DEV-7294 Have alloc disabled in new setups Have allocation disabled in new setups DEV-7346 Estimated future stock is now logged into Plus if activated in settings Estimated future stock is now logged into Plus if activated in settings: populateestimatedstockindemand DEV-7350 inv.order_exception_check causing deadlocks DEV-7426 Timeout at PetValu for filter_order_master_view on single order_line_id and user_id DEV-7436 Improve performance for single order line update in orders_update_values Improve performance for single order line update in orders_update_values DEV-7460 API should not send system settings to client Fix: Settings having no “group_key” should not be sent to client. Those settings are not relveant for client and in some cases security risk, eg. “zys_jwt_secret”. DEV-7464 inv.v_items should take weight/volume from prep.product_item_sku Fix: Data mapping: inv.v_items should take weight/volume from prep.product_item_sku
6.3-r22	release/6.3.x	2023-09-21T15:14:30Z	6.3.19	6.3.22	6.3.22	0 / 0	6.3-r22.zip 6.3-r22.zip
6.3-r22 Release notes - AGR Development - 6.3-r22 Task DEV-5331 Let system users/support users change the timezone of scheduled tasks in client Release Notes Let system users/support users change the timezone of scheduled tasks in client DEV-6999 Helper objects 2023-08 DEV-7078 Show info about cus_pre/post_sql in tb.run_info Release Notes We want consultants to see in tb.run_info if columns cus_pre/post_sql are used DEV-7151 ex views 2023-09 DEV-7183 demand_processing_calc_run_items Release Notes Better way to customize demand_processing_calc_run_items DEV-7215 ordercleanup_retentiondays default 30 for new setups Release Notes Consultants asking for this to be changed from 365 to 30, but only for new setups. Bug DEV-7001 Master Item [inv].[v_master_items] DEV-7047 MBE "Demand for order period" & "Forecast for order period" is not correct. Release Notes “Forecast for order period” and "Demand for order period" should not also take into consideration the “Order coverage days” DEV-7080 Unnecessary client timezone adjustments after .NET Core update Release Notes Item Card data is on the wrong date if the client is behind the server, (further west). DEV-7104 Timeout errors when calling/polling Data Factory Release Notes Fix: Timeout errors when calling/polling Data Factory
6.3-r21	release/6.3.x	2023-08-18T11:33:18Z	6.3.18	6.3.21	6.3.21	0 / 0	6.3-r21.zip 6.3-r21.zip
6.3-r21 What's Changed Release notes - AGR Development - 6.3-r21 Task DEV-5426 Improve Data Factory Trigger in API for Enterprise Hosted Setups
6.3-r20	release/6.3.x	2023-07-11T13:13:50Z	6.3.18	6.3.20	6.3.20	0 / 0	6.3-r20.zip 6.3-r20.zip
6.3-r20 What's Changed DEV-6757 changing caption of Skip Forecast to Date to First Sale Date Into Forecast by @fanndis in https://github.com/agrinventory/agr/pull/4048 DEV-6801 Editable columns should be editable when moving from confirmed to in process by @fridjon in https://github.com/agrinventory/agr/pull/4049 Full Changelog: https://github.com/agrinventory/agr/compare/6.3-r19...6.3-r20
6.3-r19	release/6.3.x	2023-06-27T10:24:40Z	6.3.17	6.3.19	6.3.19	0 / 0	6.3-r19.zip 6.3-r19.zip
6.3-r19 Client: 6.3.17 ⬆️ API: 6.3.19 ⬆️ Databases: 6.3.19 ⬆️ Release notes - AGR Development - 6.3-r19 Task DEV-6659 tb.execmultierpsql Release Notes Toolbox proc to: Execute DDL script for ALL multierpschemasuffix in core.erpdbinfo Massive help at Dansk Cater which has 11 erp systems Bug DEV-6574 Add @userid to dbo.fnchartelementsbyitemid Release Notes In some cases we would like to limit what some users can see in the item chart and today it is not possible to have different chart to different roles.
6.3-r18	release/6.3.x	2023-06-07T14:39:42Z	6.3.17	6.3.18	6.3.18	0 / 0	6.3-r18.zip 6.3-r18.zip
6.3-r18 Release notes - AGR Development - 6.3-r18 Task DEV-5546 core.scheduled_task_execution_history abusing the core.event thingie core.scheduled_task_execution_history calling to many times to the core.event DEV-6179 Stop using bad views in mbe_item_period_calc_populate DEV-6525 tb.workspace_info Release Notes Helper proc to show info about workspace DEV-6550 Stop using IDENT_CURRENT in scheduled_order_pre_run Stop using IDENT_CURRENT in scheduled_order_pre_run DEV-6564 Fix itemCard feature migration (hard coded on id = 34) Fix itemCard feature migration (hard coded on id = 34) Bug DEV-6378 Data factory error handling Fix: the break on error logic in the core.stg_element table, doesn’t seem to work for the core_trigger_data_factory stg element. DEV-6455 migration problem with item card feature
6.3-r17	release/6.3.x	2023-05-08T11:40:26Z	6.3.17	6.3.17	6.3.17	0 / 0	6.3-r17.zip 6.3-r17.zip
6.3-r17 Release notes - AGR Development - 6.3-r17 Task DEV-6139 inv.connected_item_validation not valid after new connected items code inv.connected_item_validation not valid after new connected items code DEV-6248 ex views 2023-03 Improving ex views DEV-6362 Prevent index maintenance on office hours Prevent index maintenance on office hours DEV-6369 Allow daily_run without errors on fresh other-erp install Allow daily_run without errors on fresh other-erp install DEV-6371 Avoid bad effects of mbe_item_statistics_populate RAISERROR DEV-6377 Log slow chart_item_select calls in core.dynamic_query_log DEV-6379 Add column mapping procedure for bc rest DEV-6427 Cleanup in other-erp raw views Bug DEV-6224 Workspaces: When switching fast between different views - the grid settings are not always refreshed Fixed: Workspaces - When switching fast between different views the grid settings are not always refreshed. DEV-6306 Optimal stock is calculated wrongly Improvements on how optimal stock is calculated DEV-6310 Forecast: "New" items that do not start selling on a monday and have very few data points can result in no forecast Items with very few sale points and weekly forecast where sometimes not getting forecast. This has been fixed and now it should only require one sale point to get weekly forecast.
6.3-r16	release/6.3.x	2023-04-03T11:46:06Z	6.3.16	6.3.16	6.3.16	0 / 0	6.3-r16.zip 6.3-r16.zip
6.3-r16 Release notes - AGR Development - 6.3-r16 Bug DEV-6171 6.3: ABC Value CA not allowing an overwrite in the matrix ABC Value CA not allowing an overwrite in the matrix DEV-6301 Scheduler calculates next-run-time incorrectly in timezones behind UTC Scheduler calculates next-run-time incorrectly in timezones behind UTC DEV-6307 Add item card as feature in user management in 6.3
6.3-r15	release/6.3.x	2023-03-17T11:24:03Z	6.3.14	6.3.13	6.3.15	0 / 0	6.3-r15.zip 6.3-r15.zip
6.3-r15 What's Changed DEV-6107 6.3 Log sessionid and processid in core.event by @jorundursv1 in https://github.com/agrinventory/agr/pull/4010 DEV-6141 6.3 Fix fnmbewhereclauseflat to work with uncode strings by @jorundursv1 in https://github.com/agrinventory/agr/pull/4012 DEV-6167 6.3 demandprocessingcalc_run, do 3 updates in 1 sweep by @jorundursv1 in https://github.com/agrinventory/agr/pull/4013 DEV-6042 6.3 housekeepingordercleanup slow by @jorundursv1 in https://github.com/agrinventory/agr/pull/4014 DEV-5990 6.3 Improve performance in mbeitemperiodcalcpopulate by @jorundursv1 in https://github.com/agrinventory/agr/pull/4015 DEV-6120 too many items with very little history get seasonal label by @fanndis in https://github.com/agrinventory/agr/pull/4011 DEV-6191 6.3 Set qty_pallet for some items in dev build by @jorundursv1 in https://github.com/agrinventory/agr/pull/4016 DEV-6233 Sunday forecast run broken by @fanndis in https://github.com/agrinventory/agr/pull/4018 Full Changelog: https://github.com/agrinventory/agr/compare/6.3-r14...6.3-r15
6.3-r14	release/6.3.x	2023-02-22T16:18:44Z	6.3.14	6.3.12	6.3.14	0 / 0	6.3-r14.zip 6.3-r14.zip
6.3-r14 Release notes - AGR Development - 6.3-r14 Task DEV-5771 ex views 2023-01 ex views showing translation text Also a few minor toolbox object changes DEV-5815 SQL Server error at Kjell when running procs through core.execute_stg_element_sp SQL Server error when running procs through core.execute_stg_element_sp DEV-5844 Add inv.abc_items to make ABC customization easier Add inv.abc_items to make ABC customization easier DEV-5851 Add inv.abc_confidence_factor to make ABC customization easier Add inv.abc_confidence_factor to make ABC customization easier DEV-5869 tb.report_info Add toolbox proc showing info from all report tables + showing report sql DEV-5904 Add inv_cus.abc_calculate_post make ABC customization easier Add inv_cus.abc_calculate_post make ABC customization easier DEV-5905 Log and show diff in @@SERVERNAME and SERVERPROPERTY('servername') Log and show diff in @@SERVERNAME and SERVERPROPERTY('servername') DEV-5992 Connected items view slow because of v_item_no_lookup Connected items view slow because of v_item_no_lookup DEV-5996 Log more info in scheduled_order_run_execute Log more info in scheduled_order_run_execute DEV-6043 Log count for orders and order_lines in order_run_populate_orders_and_lines Log count for orders and order_lines in order_run_populate_orders_and_lines DEV-6076 Change orders_to_transfer_json_bc to the "correct" version Change orders_to_transfer_json_bc to the "correct" version Bug DEV-4497 ABC analysis on number of sales lines for connected items is not inherited Fix: ABC analysis on number of sales lines for connected items is not inherited DEV-5069 Item card - Grid - columns revert back to default Fix: Item card - Grid - reverting back as how it is on 6.2 and 6.1.The way this works in 6.2 and 6.1 was is that you can decide the order of columns but you can’t force a column to be visible or invisble. This behavior is similar to the chart in the sense that you only see columns/series that have any data. DEV-5788 Critical: Split by Constraint erroring when using Fill-up on days Fix: Split by Constraint erroring when using Fill-up on days DEV-5876 order view changes when moving between proposal and transferred orders order view changes when moving between proposal and transferred orders DEV-6036 Orderlines losing focus when older lines finish updating
6.3-r13	release/6.3.x	2023-01-17T09:55:54Z	6.3.13	6.3.12	6.3.13	0 / 0	6.3-r13.zip 6.3-r13.zip
6.3-r13 Release notes - AGR Development - 6.3-r13 Task DEV-5552 Add cus_pre/post_sql to core.stg_element We want to allow consultants to be able to execute stuff before/after element. Currently we have data_merge_pre/post_sql but that only applies to merge elements and its also used for standard things meaning if consultants use it there is a risk of it being overwritten in patch scripts. Columns cus_pre/post_sql will allow executing stuff before/after merge and proc elements and will never be overwritten in patch scripts. Note that the sql would not be bundled inside a merge statement like data_merge_pre/post_sql, the sql is executed before/after the proc/merge sql. DEV-5731 Update translations for updated Overstock (now considering safety stock) Overstock label: specifically mention that safety stock is included in the overstock calculations. DEV-5771 ex views 2023-01 ex views showing translation text Also a few minor toolbox object changes Bug DEV-5740 Migration error due to dependency in core.stg_element Migration error due to dependency in core.stg_element
6.3-r12	release/6.3.x	2023-01-09T20:09:07Z	6.3.12	6.3.12	6.3.12	0 / 0	6.3-r12.zip 6.3-r12.zip
6.3-r12 Release notes - AGR Development - 6.3-r12 Task DEV-5552 Add cus_pre/post_sql to core.stg_element We want to allow consultants to be able to execute stuff before/after element. Currently we have data_merge_pre/post_sql but that only applies to merge elements and its also used for standard things meaning if consultants use it there is a risk of it being overwritten in patch scripts. Columns cus_pre/post_sql will allow executing stuff before/after merge and proc elements and will never be overwritten in patch scripts. Note that the sql would not be bundled inside a merge statement like data_merge_pre/post_sql, the sql is executed before/after the proc/merge sql. DEV-3220 Safety Stock warehouse when using demand from stores Order logic calculation: now you can overwrite the Safety stock on warehouse when using demand from stores calculations DEV-5636 ABC group by location option ABC improvements: Setting abc_group_by_location, which is default off, allows abc to be calculated for warehouses and stores separately. DEV-5683 Not possible to increase timeout from default 30 seconds Fix: Timeout on recalculate purchase plan: Make the demand-recalculate action use extended command timeout (PR-3983) Bug DEV-5553 Overstocked label - include Safety Stock in the calculation Improve overstock Label: safety stock is now considered in overstock calculation i.e. stock units > ( (multiplier * demand) + safety stock)? DEV-5673 User gets logged out on refresh when using O365 Fix; User gets logged out on refresh when using O365 DEV-5713 Order view agg columns Order view: Add aggregations to order view columns (avg - avgNz, Min)
6.3-r11	release/6.3.x	2022-12-30T12:53:14Z	6.3.11	6.3.11	6.3.11	0 / 0	6.3-r11.zip 6.3-r11.zip
6.3-r11 Release notes - AGR Development - 6.3-r11 Task DEV-5637 inv.stockout/promo_items in bridge_stockouts/promos Bug DEV-5069 Item card - Grid - columns revert back to default DEV-5654 TimeZone bug in single-sign-on Full Changelog: https://github.com/agrinventory/agr/compare/6.3-r10...6.3-r11
6.3-r10	release/6.3.x	2022-12-19T15:38:21Z	6.3.10	6.3.10	6.3.10	0 / 0	6.3-r10.zip 6.3-r10.zip
6.3-r10 Release notes - AGR Development - 6.3-r10 Task DEV-5285 Improve label and order exception custom info procedures Improve label and order exception custom info procedures DEV-5556 API should be configurable if scheduler should be enabled or not Fix: It must be possible to disable scheduler in one of the instances to avoid conflicting. DEV-5605 Improve order of elements in daily run Improve order of elements in daily run DEV-5607 Missing indexes DEC 2022 Fix: Missing indexes DEC 2022 DEV-5615 Add variant code to dbo.v_orders_to_transfer Fix: Add variant code to dbo.v_orders_to_transfer Bug DEV-5520 Remove editability in future for the Sale data series Sale data series now only editable in the past (was editable in the future as well). This fix was not added to migration as the series is often customized. DEV-5555 Connected items: Sales/stock history and stock level still connected after deleting connection Fix: Connected items: Sales/stock history and stock level still connected after deleting connection DEV-5557 Single-sign-on, error in redirect URI Fix: When AGR is installed on default ports and using single-sign-on the redirect URI adds : (colon character) into the URI. The colon character is followed by blank port number and causes the URI to be invalid.
6.3-r9	release/6.3.x	2022-12-07T09:58:07Z	6.3.9	6.3.5	6.3.9	0 / 0	6.3-r9.zip 6.3-r9.zip
6.3-r9 What's Changed DEV-5246 allow offest parameter in parallel forecast by @fanndis in https://github.com/agrinventory/agr/pull/3906 DEV-5298 - 6.3 - Add a safeguard for data elements addons by @agustorn in https://github.com/agrinventory/agr/pull/3916 DEV-5478 - 6.3 - ABC debug improvements by @agustorn in https://github.com/agrinventory/agr/pull/3934 DEV-5445 - 6.3 - Re-enable audit database trigger by @agustorn in https://github.com/agrinventory/agr/pull/3931 DEV-4540 - 6.3 - ABC sale price missing safeguard by @agustorn in https://github.com/agrinventory/agr/pull/3937 DEV-5484 - 6.3 - Planned order fix by @agustorn in https://github.com/agrinventory/agr/pull/3936 DEV-5379 6.3 item-card/expiring-stock-empty-when-undeliv-is-null by @agr-asta in https://github.com/agrinventory/agr/pull/3933 DEV-5475 6.3 Elements invhistoriesbridgedsale/promoreadytoprod not merging everything to prod after first run by @jorundursv1 in https://github.com/agrinventory/agr/pull/3938 DEV-5427 6.3 core.eventbatch.appservertask_started not updated for partial run by @jorundursv1 in https://github.com/agrinventory/agr/pull/3939 DEV-5568 6.3 tb.trace_table max recursion error by @jorundursv1 in https://github.com/agrinventory/agr/pull/3940 Full Changelog: https://github.com/agrinventory/agr/compare/6.3-r8...6.3-r9
6.3-r8	release/6.3.x	2022-11-17T10:19:15Z	6.3.8	6.3.5	6.3.8	0 / 0	6.3-r8.zip 6.3-r8.zip
6.3-r8 What's Changed DEV-5295 6.3 reports: fix missing labels after edit by @jafetbjarkar in https://github.com/agrinventory/agr/pull/3919 DEV-5282 6.3 New setup with coreloglevel default 2 (location info logging) by @jorundursv1 in https://github.com/agrinventory/agr/pull/3913 DEV-5325 6.3 Stop using LEFT JOIN and ISNULL(xxx, 0) in mbeitemstatistics/periodcalcspopulate by @jorundursv1 in https://github.com/agrinventory/agr/pull/3924 DEV-5363 6.3 Change new connected items code to update fewer rows in inv.stocks/undelivered by @jorundursv1 in https://github.com/agrinventory/agr/pull/3915 DEV-5367 6.3 zys.info 'tempdb tables with rows' by @jorundursv1 in https://github.com/agrinventory/agr/pull/3920 DEV-5281 6.3 Remove weird sys.columns sql in ordersupdatestatus and ordersupdatevalues by @jorundursv1 in https://github.com/agrinventory/agr/pull/3922 DEV-5358 6.3 settings/abc/abc-was-reversed by @agr-asta in https://github.com/agrinventory/agr/pull/3927 Full Changelog: https://github.com/agrinventory/agr/compare/6.3-r7...6.3-r8
6.3-r7	release/6.3.x	2022-11-04T14:48:27Z	6.3.7	6.3.5	6.3.7	4 / 0	6.3-r7.zip 6.3-r7.zip
6.3-r7 What's new? Database Update Scripts Check out db_scripts\compare_reports for the update reports for updating and patching (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 customizations in the objects listed there.) Release notes See list on Jira See list of pull requests involved in this update on GitHub `Maintainance` DB Maintenance procedure producing error when logging DEV-5352 `ABC` ABC scaling causing strange behavior DEV-5350 `STG` Change initialloadmbe_reports to suit consultants better DEV-5312 `Core` Bug in Custom Actions DEV-5067
6.3-r6	release/6.3.x	2022-10-26T10:54:24Z	6.3.6	6.3.5	6.3.6	14 / 0	6.3-r6.zip 6.3-r6.zip
6.3-r6 What's new? Database Update Scripts Check out db_scripts\compare_reports for the update reports for updating and patching (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 customizations in the objects listed there.) Release notes See list on Jira See list of pull requests involved in this update on GitHub `STG` Fix: raw views need to use GROUP BY ISNULL([Variant Code], '') because of mixed data DEV-5223 `STG` Fix: Stop copying active=0 rows from prep layer to core.product tables DEV-5201 `Reports` Fix: the column order sometimes was reset even after saving the report. DEV-5203 `Forecasts` Fix: Forecasts: When all items have same forecast type in large setup it can cause slow delete loop DEV-5200 `Orders` Fix: Sometimes Deadlocks in inv.orderexceptionline_link DEV-5195 `Item Card` - Fix: Item Card - Details: custom/other columns do not show up in the item card. DEV-5192 `Item Card` Fix: Traffic Light system on Undelivered Orders is not being correctly applied DEV-5191 `MBE` Fix: Estimated Stock on Next Delivery Date column not calculated correctly DEV-5185 `Item Card` Fix: The item card grid doesn't update automatically when you update a column in the item details sidebar DEV-5168 `Constraints` Fix: The box under Constraints in the Order Constraint modal does not resize according to the selected value. DEV-5083 `Orders` FiX: Min MAX can not be the same value. DEV-5071 `MBE` Fix: Duplicates in dbo.mbeitemstatistics_populate DEV-5068 `Core` Cleanup old excessive logging from core.text DEV-5000 `Connected Items` Fix: Connected items, change method to handle more cases and run faster DEV-4820
6.3-r5	release/6.3.x	2022-10-07T09:07:11Z	6.3.5	6.3.5	6.3.5	29 / 0	6.3-r5.zip 6.3-r5.zip
6.3-r5 What's new? Database Update Scripts Check out db_scripts\compare_reports for the update reports for updating and patching (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 customizations in the objects listed there.) Release notes See list on Jira See list of pull requests involved in this update on GitHub `User management` Users cannot create a scheduled order if they don't have access to user management DEV-5093 `Reports/Items` Fix: Error Messages popping up when trying to create an Advanced Filter DEV-4618 `Performance` DB performance improvements :done_dunsc needs a better escape clause DEV-5084 `Data Mapping` Add SourceTokenEndpoint to core.datamappinggetdfsettings for BC public cloud DEV-4848 `Scheduled Orders` - fix: scheduled order timeout - when running “invscheduledorders” server side element with a partial run from the client. DEV-4846 `Data Mapping` Fix: The proc [inv].[orderrouteprepare] raise a error when there are not any location type Store in the table inv.orderroutelocation_group, DEV-4621 `Item Card` Fix: Item card - Grid - columns revert back to default (llocal storage) DEV-5069 `Orders` Fix: Copy-paste from Excel to order grid clears out column below selection DEV-2680 `Reports/Items` Fix: when a filter is added to Items - no auto refresh / no blue button appeared. See issue: DEV-4990 DEV-4223 `Item Card` Fix: Expiry Stock info in item details showing both undelivered and stock and stock expiry on default(null) date should be ignored DEV-5117 `Forecast` Fix: Parallel Forecast does not support running all items if both monthly and weekly is being used DEV-4643 `Grids` Add "Clear all filters" in column drop-down. Add the filtered number of items to left corner. DEV-5066 `Item Card` Details about undelivered orders can now be seen in the Item Details sidebar after having been removed in a previous version. DEV-4783 `Login` Fix bug where the microsoft code url parameter is lost before the login component gets hold of it DEV-5020 `Audit` Cleanup old excessive audit logging DEV-4572 `Core` A loading indicator has been added to the AGR app. It only appears when you open the app (not when navigating between pages). DEV-4844 `Grids` fix: Last lines of ag-grid are inactive DEV-4994 `Reorts/Items` Fix: Sync in data when chancing columns / filters in items tab DEV-4987 `Reports/Items` fix: Opening a report does not respect the 'sync button lower' and 'sync button upper' limit values DEV-4643 `STG` minor improvement: adding print on stg elements in add extra info if execute = 0 and restrict types in order route to store, warehouse or vendor DEV-4838 `Orders` fix: floatingorderfrequency_days = 0 (in data mapping) messes up orders DEV-4755 `Orders` Fix: Order coverage overrides when manual order to cover demand until a certain date. DEV-4581 `STG` Fix: stg element execute sp collation fail - If stg and prod are not in the same collation, you will get a collation error DEV-4837 `Forecast` Fix: Forecast: tb.runforecastforitem and tb.runforecastforlocation not working as expected DEV-4853 `Installer` Fix: When upgrading to 6.3 some installation files are sometimes missing when copying them over to the server DEV-4825 `STG` Fix: stg element execute sp collation fail - If stg and prod are not in the same collation, you will get a collation error DEV-4837 `Reports/Items` Add number of sales lines as MBE column DEV-4125 `STG` Fix: stg element execute sp collation fail - If stg and prod are not in the same collation, you will get a collation error DEV-4837 `Workspaces` Fix: escaping datepicker causes error DEV-5133
6.3-r4	release/6.3.x	2022-08-30T10:20:21Z	6.3.4	6.3.4	6.3.4	7 / 0	6.3-r4.zip 6.3-r4.zip
6.3-r4 What's new? `item-card` Added the ability to edit custom chart element by dragging the bar in the chart. It is not recommended to use this functionality since the updated values are only distributed equally to lower levels but not proportionally as it is in the planner. . DEV-4502 `install` We now have a seperate installer for patch upgrades to reduce manual work when upgrading. DEV-4825 Database Update Scripts Check out db_scripts\compare_reports for the update reports for updating and patching (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 customizations in the objects listed there.) Release notes See list on Jira See list of pull requests involved in this update on GitHub `item-card` Added the ability to edit custom chart element by dragging the bar in the chart. It is not recommended to use this functionality since the updated values are only distributed equally to lower levels but not proportionally as it is in the planner. . DEV-4502 `Core` fix: Extended events available on cloud hosting DEV-4740 `Schedules` fix: Can't modify existing schedules if type is 'specific dates' DEV-4832 `Orders` new db objects to support order transfer via rest DEV-4256 `Login` - Fix incorrect error handling after failed login attempt with `refresh token` which should redirect to the login page. This bug caused users to end up with a blank page and having to refresh the app. DEV-4574 `System Health` Fixed: System Health check doesn't take global skip forc to date into account DEV-4404 `Forecast` fix: Closed items get forecast if item card is opened up DEV-4635 *' `install` We now have a seperate installer for patch upgrades to reduce manual work when upgrading. DEV-4825
6.3-r3	release/6.3.x	2022-07-04T15:39:42Z	6.3.3	6.3.3	6.3.3	10 / 0	6.3-r3.zip 6.3-r3.zip
6.3-r3 What's new? `item-card` Fix bulk update load too much data issue. DEV-4519 Important To Know For Upgrade For Now Updating with the installer does not work so when patching you will need to remove the old installation before reinstalling using the following steps. 1. Open Internet Information Services (IIS) Manager and delete the AGR web. 2. Open Services and stop the AGR service, usually named AGR63_service 3. Delete the AGR service in command line using "sc delete AGR63_service" (change AGR63_service if the client is setup differently) Database Update Scripts Check out db_scripts\compare_reports for the update reports for updating and patching (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 customizations in the objects listed there.) Release notes See list on Jira See list of pull requests involved in this update on GitHub `item-card` Fix bulk update load too much data issue, Update item-card-details.service.ts, Update dashboard-chart-widget-overstocked.cy.ts DEV-4519 `Forecasts, item-card` Fixed: When a user excludes item from forecast - all future data becomes hidden from item card. DEV-4479 `login / authentication` Fixed: JWT Secret is not in cache when database is new DEV-4457 `Forecasts` Fixed: Timeout/deadlock forecast errors when using parallel forecast. DEV-4312 `abc` Fixed: inv.abc_calculate not correct using DECIMAL(18,4) and FLOAT DEV-4531 `Forecasts` Skip Forecast to Date from item details should always overrule global skip forecast to date. DEV-4522 `item-card` Add the ability to edit custom chart element by dragging the bar in the chart. It is not requirement to use this functionality since the updated values are only distributed equally to lower levels but not proportionally as it is in the planner. DEV-4502 `orders` Fix excessive logging in planned_orders procs DEV-4458
6.3-r2	release/6.3.x	2022-06-23T15:56:59Z	6.3.2	6.3.2	6.3.2	11 / 0	6.3-r2.zip 6.3-r2.zip
6.3-r2 What's new? Important To Know For Upgrade For Now Updating with the installer does not work so when patching you will need to remove the old installation before reinstalling using the following steps. 1. Open Internet Information Services (IIS) Manager and delete the AGR web. 2. Open Services and stop the AGR service, usually named AGR63_service 3. Delete the AGR service in command line using "sc delete AGR63_service" (change AGR63_service if the client is setup differently) Database Update Scripts Check out db_scripts\compare_reports for the update reports for updating and patching (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 customizations in the objects listed there.) Release notes See list on Jira See list of pull requests involved in this update on GitHub `scheduler` * Fixed how scheduler selects next job to run. * Issue with updating "Next Run Time" in different timezones fixed. * Code change how to get version info from assembly. DEV-4430 `Forecasts` Fixed: Custom calendar events not working. DEV-4391 `Forecasts` Fixed: When forecast from date is used and has become a date in the past, the forecast returns error. DEV-4388 `item-card` Fixed: No data display message was duplicated. Now removed. DEV-4320 `Forecasts` Fixed: Timeout/deadlock forecast errors when using parallel forecast. DEV-4312 `stg` Fixed: Multiple "not matched by source" fields. It only worked for one. DEV-3778 `BC-datamapping` Change BC and NAV data mapping for undelivered: Look at Outstanding Qty (Base) instead of Quantity (base) DEV-4381 `core, label/inventory-insights, order-exceptions` Enhancing order exception info texts DEV-4285 `documentation` Verified DEV-4146
6.3-r1	release/6.3.x	2022-06-07T16:36:25Z	6.3.1	6.3.1	6.3.1	7 / 0	6.3-r1.zip 6.3-r1.zip
6.3-r1 What's new? Important To Know For Upgrade For Now Updating with the installer does not work so when patching you will need to remove the old installation before reinstalling using the following steps. 1. Open Internet Information Services (IIS) Manager and delete the AGR web. 2. Open Services and stop the AGR service, usually named AGR63_service 3. Delete the AGR service in command line using "sc delete AGR63_service" (change AGR63_service if the client is setup differently) Database Update Scripts Check out dbscripts\comparereports for the update reports for updating and patching (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 customizations in the objects listed there.) Release notes See list on Jira See list of pull requests involved in this update on GitHub `orders` When sorted by Qty the grid would resort the grid after editing a cell in the qty column DEV-4349 `stg` fix: Executing sp stg elements by hand without loging parameters cause error in core.executestgelement_sp DEV-4344 `setup` Undelivered from Source location not showing up in ERP Setup UI DEV-4341 `label/inventory-insights` fix: Items with seasonality should not also have high forecast uncertainty label. DEV-3873 `label/inventory-insights` Enhancing order exception info texts. DEV-4285
6.3-r0	master	2022-05-31T14:11:27Z	6.3.0	6.3.0	6.3.0	17 / 13	6.3-r0.zip 6.3-r0.zip
6.3-r0 What's new? `Inventory Insights` - Introducing a set of preconfigured filters to AGR that can be configured centrally in the settings page and applied across reports by all users. Inventory Insights User documentation `Labels` - Introducing labels to the item card. This highly improves the aesthetics of the system as well as provides users with insights into the key areas of their business that they should consider focusing on, enabling users to make more informed decisions. Labels in Item Card, User Documentation `ABC Settings` - Users will be able to configure the ABC calculations from within the system themselves. They will be able to choose from six different proven metrics and apply service levels accordingly – or trust the AGR default values if they feel overwhelmed. ABC Settings, User Documentation `Order Exceptions` - We are bringing the manage by exception functionality to the order review process not only to highlight anomalies in order proposals but also to suggest ways to handle those exceptions appropriately. Having this overview of the order exceptions allows users to utilize the data better and priorities your time more efficiently. Order Exceptions, User Documentation `Order Breakdown Chart` - Order calculations broken down visually in a chart in the order grid info tab. Order Breakdown Chart, User documentation `Reports` - Reports: Users are able to share reports with everyone, specific users, or by user roles either as read-only or editable. AGR also introduces locked standard reports. `Bulk Update` - The ability to bulk edit forecast and order logic settings for multiple items directly from items and reports. Bulk Update, User Documentation `Custom fields in the item card` - now introducing the ability to add custom fields to the Item Card. The standard columns have also being reviewed, bringing more editable setting columns to the user interface. `Column Descriptions` - Column descriptions will be added to every column in the system giving users more detail for informational purposes. `Manual Orders` - The ability to create more accurate manual orders by selecting to cover demand until a certain day. `Item Card`- Total demand series now visible in the Item Chart. `Settings`- A complete overhaul of the Settings pages, giving users more control of their setup and better explanations about the settings they are configuring, effectively handing further tools to users to manage their inventory. `Forecasts` - New forecast overwrite rule has been implemented to tackle extreme downward trend which in earlier versions resulted in no forecast at all. In cases where we have some sale in past three months but almost no forecast in the next 6 months, the original forecast will be overwritten with simple moving average forecast based on past 6 months. 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 Known Issues/Bugs Unaddressed issues in JIRA `Settings` - New Global setting for Skip Forecast to Date so that it doesn't have to be data-mapped for every setup. DEV-3016 `Item Card` - Hide negative values by default and change "Hide Negative Values" to "Show Negative Values". DEV-2933 `Scheduler`- Ability to set up a server side element to execute command line code. DEV-2655 `Staging` - New raw layer entry and data-mapping to receive Legacy Sale History. DEV-2259 `Scheduled Orders` - Ability to setup scheduled order for another user. DEV-2126 `Item Card` - Stocks expired data in item card. `Workspaces` - Make view links across workspaces possible. DEV-1311 `Staging` - Adding an "action center" table to log when consultant need to take action to ensure the correctness of customized objects. DEV-3819 `Orders` - Floating Order Frequency was renamed for clarity and is now called Order Coverage Days. DEV-4068 `Forecasts` - Three forecast setting descriptions have been changed and will be available from 6.3 and onwards. These forecast setting fields are all accessible in the item card. The following changes have been made: Skip Forecast To date => First Historical Sale Date, Forecast From Date => Forecast Start Date, Forecast End Date => Forecast End Date. DEV-4133 `Workspaces` - Workspace Types have been renamed to Table sets both in the database and in the workspace feature in the UI. The term “Workspace Type” is inaccurate and unhelpful. It should actually be called something like “Table Set” since this is not part of workspaces but of how de-query determines what columns to use. In other words, Workspaces use de-query as a feature, but Workspace Types (or actually Table Sets) are more a part of de-query than workspaces. DEV-2725 `Scheduler` - Improvements to Scheduler to make display and running times consistent across timezones. DEV-3257 `Reports/Items` `User-management` - We will make the change so that owner of a report can change the owner. We will not add the feature “reportManagement” since a user with that feature would have to be able to see all reports (in addition to being able to change the owner. The issue if the owner of a report quits, should be handled by resetting their password, logging in and changing the owner as that owner. DEV-4138
6.2-r21	release/6.2.x	2022-09-19T12:58:56Z	6.2.18	6.2.19	6.2.21	9 / 0	6.2-r21.zip 6.2-r21.zip
6.2-r21 What's new? Important To Know For Upgrade Database Update Scripts Check out db_scripts\compare_reports for the update reports for updating and patching (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 customizations in the objects listed there.) Release notes See list on Jira See list of pull requests involved in this update on github `login` - Remove switch case for `TokenValidityState.no` which redirects to login losing the microsoft `code` parameter. DEV-5020 `STG` - minor improvement: adding print on stg elements in add extra info if execute = 0 and restrict types in order route to store, warehouse or vendor DEV-4838 `Grids` - fix: Last lines of ag-grid are inactive DEV-4994 `Reports` - fix: Opening a report does not respect the 'sync button lower' and 'sync button upper' limit values DEV-4990 `Audit` - Cleanup old excessive audit logging DEV-4572 `Data Mapping` - fix: floatingorderfrequency_days = 0 (in data mapping) messes up orders DEV-4775
6.2-r20	release/6.2.x	2022-08-25T15:01:47Z	6.2.17	6.2.19	6.2.20	7 / 0	6.2-r20.zip 6.2-r20.zip
6.2-r20 What's new? Important To Know For Upgrade Database Update Scripts Check out db_scripts\compare_reports for the update reports for updating and patching (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 customizations in the objects listed there.) Release notes See list on Jira See list of pull requests involved in this update on github `Core` - .Net framework updated to 4.8 removing the reliance on TLS 1.2, other outdated packages also updated DEV-4608,DEV-3215 `Login` - Fix incorrect error handling after failed login attempt with `refresh token` which should redirect to the login page. This bug caused users to end up with a blank page and having to refresh the app. DEV-4574, PR-3648 `Forecasts` - Skip Forecast to Date from item details should always overrule global skip forecast to date. DEV-4532 `Logging` - Fix excessive logging in planned orders procs DEV-4458
6.2-r19	release/6.2.x	2022-06-23T13:37:52Z	6.2.16	6.2.18	6.2.19	10 / 0	6.2-r19.zip 6.2-r19.zip
6.2-r19 What's new? Important To Know For Upgrade Database Update Scripts Check out db_scripts\compare_reports for the update reports for updating and patching (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 customizations in the objects listed there.) Release notes See list on Jira See list of pull requests involved in this update on [https://github.com/agrinventory/agr/pulls?q=is%3Apr+base%3Arelease%2F6.3.x+sort%3Aupdated-desc++is%3Amerged+closed%3A2022-05-13T13%3A00%3A00..2022-06-22T17%3A00%3A00+-label%3A%22Exclude+Release%22+) `Forecasts` Fixed: Timeout/deadlock forecast errors when using parallel forecast. DEV-4312 `item-card` Fixed. NOLOCK hints from chart query generator removed. DEV-4216 `stg` Allow empty string in "datamergecolumnvalues" field in core.stgelement. DEV-4204 `BC-datamapping` Use Outstanding Qty instead of Qty in purchase orders. DEV-4067 `item-card` Fixed: Safetystock for order coverage days items was showing too high safetystock. DEV-4011 `stg` Fixed: Automated merge not working when using multiple "not matched by source" fields. It only worked for one. DEV-3778 `item-card` Add the ability to edit custom chart element by dragging the bar in the chart. It is not requirement to use this functionality since the updated values are only distributed equally to lower levels but not proportionally as it is in the planner. DEV-4377
6.2-r18	release/6.2.x	2022-05-12T15:01:19Z	6.2.15	6.2.17	6.2.18	7 / 0	6.2-r18.zip 6.2-r18.zip
6.2-r18 What's new? Important To Know For Upgrade `Orders` Order grid loading performance improvements. Introducing a way to better utilize the network socket and compressing the json data by not sending the order lines as object but values. DEV-4171 “RunForecasts.exe doesn’t come with the installer so that needs to be copied from previous patch release” Database Update Scripts Check out db_scripts\compare_reports for the update reports for updating and patching (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 customizations in the objects listed there.) Release notes See list on Jira See list of pull requests involved in this update on GitHub `Orders` Order grid loading performance improvements. Introducing a way to better utilize the network socket and compressing the json data by not sending the order lines as object but values. DEV-4171 `Orders` Change format on order view columns weight and volume to float:2. DEV-4115
6.2-r17	release/6.2.x	2022-05-05T10:56:24Z	6.2.14	6.2.16	6.2.17	0 / 0	6.2-r17.zip 6.2-r17.zip
6.2-r17 Important To Know For Upgrade `stg` Fixed: inv.v_stocks does not produce duplicate records. DEV-3891 `stg` Toolbox improvements: New tb.create_procedure to create a skeleton procedure. New tb.add_synonym to add synonyms. Better error handling in lock/unlock schema. Improved error logging in merge procedure. Audit list showing initial status of object. Improved intelligence for stg element type in tb.add_element. Adding migration DEV-3886 Database Update Scripts Check out db_scripts\compare_reports for the update reports for updating and patching (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 customizations in the objects listed there.) Release notes See list on Jira See list of pull requests involved in this update on GitHub Bugs `stg` Fix inv._ex views and changed to tb DEV-4087 `item-card` Aggregate/sum values over period for series that are marked as aggregated_over_period = false AND aggregation_calc_func = 'sum' so that they are visible in the Item Card Grid. DEV-4065 `Forecasts` Fix Settings Cache: When applied demand on Saturdays in global settings it didn't work on item level when rerun forcast DEV-3967 `stg` Making sure all raw stg elements and included when the system is installed and using "other erp" DEV-3915 `reports/Item` Fixing safetystock bug for floating order frequency items. DEV-4009 `stg` Fixed: inv.v_stocks does not produce duplicate records. DEV-3891 `reports/items` Make report list refresh after group is edited DEV-3858 `Forecasts` Number of Christmas/Easter Weeks Required for Custom Day Distribution to settings table and forecast code added. DEV-3833 `orders` Change the primary key of item_order_routes_extra_info tables to match the item_order_routes table (a requirement for extra info database trigger to function properly) DEV-3723 `Forecasts` Settings Cache now works on item level when demand on Saturdays is applied in global setting when forecast is rerun. DEV-3595 `Forecasts, orders` Altering batch_id in forecast_processes table to use sequence instead of non-threadsafe select max + 1 method DEV-3242 `reports/items` fix: Cannot remove columns from report after changing language DEV-2809 `translations` Wrong Icelandic translations in column filters DEV-2308 Tasks `user-management` Prompt users who sign in using their Microsoft account for account selection DEV-4100 `user-management` fix: SSO - Refresh token not used when authentication token is expired DEV-4116 `core` tb.events improvements - printing help in the message tabs and returning partial data DEV-3914 `stg` tb.batch_info improvements DEV-3897 `stg` Toolbox improvements: New tb.create_procedure to create a skeleton procedure. New tb.add_synonym to add synonyms. Better error handling in lock/unlock schema. Improved error logging in merge procedure. Audit list showing initial status of object. Improved intelligence for stg element type in tb.add_element. Adding migration DEV-3886 `datafactory, stg` Adding the ability to run one db setups through datafactory DEV-3882 `stg` Add tb.run_info and tb.run_list DEV-3849 `stg` Moving the create extra info helper from core to tb schema DEV-3658 `item-card` Client: Show undelivered orders sorted by date, such that those that are expected to be delivered first are on top. DEV-2189
6.2-r16	release/6.2.x	2022-03-17T15:17:34Z	6.2.13	6.2.15	6.2.16	1 / 30	6.2-r16.zip 6.2-r16.zip
6.2-r16 What's new? In this patch we are releasing several improvements to STG2 with the aim to simplify implementations, see further detail below. Database Update Scripts Check out the update reports for updating and patching in the db_scripts\compare_reports 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 customizations 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 # Release Notes - Version 6.2-r16 Tasks `stg` - Unnecessary prep and raw tables and views removed, simplifying the data mapping since data doesn't need to go through both prep and inv layers. DEV-3702 `stg` - Location setup improved, see further details in the technical manual DEV-3535 `stg` - Data transfer pipeline shorter for extra info data. Now only needed to ALTER one view and run two stg elements DEV-3701 `Forecasts` - Fixes to avoid forecast errors while running scheduled orders. Passing the error from the exe to the AppService where it logs the error DEV-3636 `core` - Adding toolbox proc to display cus objects and source object if cus object is an override DEV-3631 `core` - Now logging AppServer task started/completed/stopped/error in core.event_batch DEV-3616 `stg` - Adding an "action center" table to log when consultant need to take action to ensure the correctness of customized objects. DEV-3506 `core` - tb.create_erp_table replacing tb.script_erp_table and core.create_erp_table DEV-3136 `core` - Added nest_level filter in tb.events + log_merge_rows/maxdop in core.stg_element DEV-3722 `scheduler` - Creating a server side element that can trigger a data factory build DEV-2793 `scheduler` - fixing stability issues where certain kind of exceptions (errors) in app-service can cause the worker in scheduler to stop working. DEV-3550 `allocation` - allowing filtering of items independent from inventory DEV-3754 `allocation` - With changes, when user deletes an allocation proposal it is not deleted from table alloc.allocation_proposal, instead column deleted is update to deleted=1. DEV-3474 Bugs `core` - fix: authData.requiresRefresh property is not set when logged in as O365. This caused caused slowness in loading workspaces in the client. DEV-3780 `orders` - fixing issues in demand calculation where worker table switching causes day old data to be used for DC level DEV-3714 `Forecasts` - Fix: the forecast is now using the setting key forecast_safety_stock_pow_max in stead of safety_stock_pow_max DEV-3662 `Forecasts` - Global skip forecast to date is added to core.settings table to fix AIS-679. Note that if you want to use the whole sales history for forecasting you might need to expand the global setting field (by default it is set to 36 months (3 years)). DEV-3637 `allocation` - When negative minimum allocation quantity is inserted by user it is changed to 0. DEV-3614 `promotional Planner` - Changes in dbo.data_element_ref_tables that promo_cus tables use id column [id] and not [promotion_id] and [promotion_line_id]. Also remove column [promo_location_k_group_name] from view 'Select Items into Promotion'. DEV-3608 `core` - Now when you navigate to / you will be redirected to the login page instead of the dashboard. The login page then uses the nav.homepage property to redirect you to the correct page. DEV-3607 `item-card` - Fix ignoring zeros issue in item card grid stock history DEV-3572 `orders` - Data sanity check in demand calculations. Checking if you have multiple order routes for an item DEV-3568 `Forecasts` - Fixing outlier detection cache issue + not going into forecast_outliers table DEV-3566 `orders` - Fixing demand formula (again), promo not being added on top of everything DEV-3560 `allocation` - Use dbo.v_stock_select instead of dbo.stocks in Allocation module, it was causing duplicate error when creating allocation proposal. DEV-3557 `scheduler` - fixing stability issues where certain kind of exceptions (errors) in app-service can cause the worker in scheduler to stop working. DEV-3550 `reports/items` - Enabling the MOQ days mbe column so that report 4.03 will function properly DEV-3510 `reports/items` - Changing column aggregation of the Stock Units column to sum DEV-3576 `workspaces` - Fix bug where drill-down was loaded incorrectly when using transferView and refreshGridAfterAction at the same time DEV-3502 `allocation` - Remove Days filter from Allocation view "Incoming PO". Data serie alloc_product_group_per_location_act_fcst changed so history_sale taken into account before the forecast in the coalesce. Column updated_at updated when alloc.purchase_order table is changed. DEV-3037
6.2-r15	release/6.2.x	2022-02-16T10:47:39Z	6.2.12	6.2.14	6.2.15	0 / 0	6.2-r15.zip 6.2-r15.zip
6.2-r15 Database Update Scripts Check out the update reports for updating and patching in the db_scripts\compare_reports 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 customizations 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 Bugs `Migration`- Remove est_available_date from order view. DEV-3494 `Custom Actions` - fix: Custom action parameter name can not contain a dot character DEV-3483 `Orders` - Removing duplicate >0 filter in order master view DEV-3472 `Orders` - fix: Floating order frequency fails in demand for certain combinations of lead time and order frequency DEV-3457 `Orders` - fix: Translation key visible when saving system view as DEV-2595 `Workspaces` - fix: read only users can run workspace actions DEV-3461 `Workspaces` - fix: checkbox series not protected for read only users DEV-3460 `Workspaces` - fix: Locked Drill-down in a view doesn't work when coming into the view with the "excluded" state from another view DEV-3445 `Workspaces` - Make sure correct column is shown in filters if there are two columns matching the same id. DEV-3444 `Workspaces` - fix: conditional editing doesn't work when the condition column has NULL values DEV-3443 `Demand Calculations` - Order logic performance improvement after 6.2-r13 causing calculations to take longer than before DEV-3436 `Item Card` - extending the timeout when pressing the recalculate button. Now we are using the "extended sql command timeout” DEV-3431 `Allocation`- fix issues with items that don't have any stock value are not available in the "Create Allocation Proposal" view DEV-3422 `Allocation` - Now making sure only active and open items are used for finding Order Multiple. Using average of Order frequency days for all locations per Product group, when calculating the product group mix. DEV-3421 `STG2` - fix: procedure [inv].[item_map_populate] skips the locations with type_id = 6, so locations with that type_id are not included in the inv.item_map and do not get any sales or stock data. DEV-3414 Tasks `Demand` - Extra logging of dates and days remaining to better see the progress when doing large demand calculations DEV-3435 `Helper Objects` - Adding tb.help proc to give simple/clear overview of Toolbox objects DEV-3365 `Allocation` - Let stg_element for the dynamic forecast_run break on error." DEV-3212
6.2-r14	release/6.2.x	2022-01-21T10:00:25Z	6.2.11	6.2.13	6.2.14	1 / 24	6.2-r14.zip 6.2-r14.zip
6.2-r14 What's new? In this patch we are releasing several improvements to STG2 with the aim to simplify implementations, see further detail below. 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 customizations 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 Api 6.2.13 `Scheduler` - fix issues with not being able to stop a task when end date is in the same week as the start date. DEV-3317 `System Health` - fixes to avoid datatype conversion errors when opening the dashboard. DEV-3281 Databases 6.2.14 `Helper Tools` - New procedure [tb].[trace_table] to help consultants trace what elements need to be executed to update a certain table . DEV-3380 `STG2` - New setting in stg_element table to allow users to skip the delete part of a merge. Useful for incremental merging. DEV-3354 `STG2` - Remove No from prep.product_item_sku, support multi company in raw schema in STG2 and removing prep.product_assortment and merge it with prep.product_item_sku. DEV-3206 `Scheduled Orders` - Improve logging to be able to track from which report id the order is originated. DEV-3204 `Connected Items` - now we have a new action available in the workspace that users can run instead of waiting for the daily job. DEV-3203 `STG2` - Remove Product Article from the product hierarchy. DEV-2968 `STG2` - Fixes to avoid duplication errors when having orders routes with primary = 1 in both raw.purchase_order_routes and raw.transfer_order_routes tables. DEV-2967 `STG2` - Take out duplicated tables from the Allocation module and use inv tables instead. DEV-2965 `Reports` - fix so that you can use the fields from the new core.product_item_sku_extra_info in the advanced filter. DEV-3386 `STG2` - fix: datatype issues in [inv].[connected_items] procedure. DEV-3362 `Orders` - Rollbacking previous changes to estimated delivery date, it is now calculated based on Additional lead time + lead time. DEV-3307 `Workspaces` - fix: Serie distribution incorrect w/respect to days when no db rows exist. DEV-3301 `Forecast Logging` - When item had only zero sale history it caused divide by zero error when inserting into forecast logging waterfall table since some forecast accuracy calculations do not allow zero in history. This is fixed by setting the calculation value to NULL when this happens. DEV-3300 `STG2` - In prep.v_transfer_order_routes the order_multiple can not be null and the fallback is set to 1. DEV-3282 `STG2` - Fixing duplicates in the prep.v_product, by adding in DISTINCT in the view. DEV-3244 `System Health` - Missing Only forecast run should not affect the system health lights. DEV-3243 `STG2` - minor fixes to location mapping for Inventory to avoid duplications. DEV-3198 `Dynamic Forecast` - fix to merge procedures in allocation dynamic forecast. DEV-3162 `STG2` - Including closed vendors in the datamapping because they are causing problems because the vendor is not found in the locations table and thus breaking some queries when creating orders and also it can be difficult filtering on the primary vendor or order from location. DEV-3020 `Installations` - Removing unnecessary commands from db install scripts that required elevated permissions. DEV-2941 `STG2` - Removing product article out of the product structure. DEV-3179 `Allocation` - Three columns, userid, createdat, updatedat, added to table alloc.allocationproposal to help consultants to debug allocation proposal process. DEV-3072
6.2-r13	release/6.2.x	2021-11-26T13:30:40Z	6.2.11	6.2.12	6.2.13	9 / 55	6.2-r13.zip 6.2-r13.zip
6.2-r13 What's new? `Forecast` - When the product is seasonal and with many zeros override the expert selection with the salt forecast model DEV-2945 , PR-2258 `Forecast` - Include trend column in forecasts table for more detailed breakdown column DEV-2969, PR-2258 `Forecast` - Model description logged in the forecast table DEV-3018, PR-2258 `Forecast` - If skip forecast to date is set then the "removing leading zeros" functionality will be ignored, i.e. zero sales in the beginning of sale history are included in forecast calculations DEV-2360, PR-2258 `Forecast` - New forecast log and accuracy tracking, can be found in a new workspace called Forecast Accuracy Tracking and is only accessible to a system user. DEV-2632, PR-2378 `Demand calculations` - Adding origin trace so you can see from which block of demand the items came and also adding a customizable order matrix that can be used to populate a custom demand matrix DEV-2740, PR-2403 `Orders` - Floating Order Frequency: This solution introduces a new field for floating order frequency. It is applied in the following manner: Using the standard order logic, AGR checks if it should order an item, and if so, it calculates the quantity using the floating order frequency to achieve a longer order period. PR-2463, DEV-1993 `Orders` - Special Order Items: New column introduced that can be used to mark special order items (either through data mapping or a workspace). Another type of order logic runs for the items that are marked as special order items that utilize a new demand formula only designated for these items. These items would ignore the global order logic settings (min/max or default) and always just order the demand based on this formula. By default, the special order demand formula is Sales Orders +Promotions but that can be configured in the database. PR-2463, DEV-2319 `Orders` - Introducing thresholds (Minimum order multiple threshold) into the order logic. Calculated order quantity in an order proposal must exceed the percentage of the order multiple to be rounded up. Can be configured globally or for individual items. (Example: An item has order multiple = 10 and calculated quantity = 14 units, thus 40% of the next order multiple. With a 30% threshold, AGR will suggest 20 units but with a 50% threshold AGR will round down to 10 units) PR-2463, DEV-2983 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 customizations 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.10 `Item Card` - Remove the series data description on the tooltip in the Item Card chart. This description would only appear in the tooltip if it existed and there was only a single series (point) in the tooltip (on the x axis). DEV-2651, PR-2118 `Workspaces` - Fix: Move to next cell after TAB in insert action. DEV-2413, PR-2151 `Grids / Reports` - Fix the formatting of grouped date columns. The sorting of grouped columns (which this issue is part of) had already been fixed by @agr-asta but the formatting of grouped date columns required a slight fix. DEV-2400, PR-2115 `Workspaces` - fix: calculated columns should not have any aggregation options available in view settings. DEV-2749, PR-2122 `Grids` - Add `Autosize This Column (Skip Header)`, `Autosize All Columns (Skip Header)` and `Size To Fit` options to the grid column menu in the Item Card Grid, Reports Grid, Report List Grid and Orders Grid. The autosize option calculate the minimum width required to display column dat, the `skip header` option does the same but ignores the size of the column header. Size to fit utilises the horizontal space available for the grid to display the columns. DEV-1994, PR-2111 `Login` - Fix: login redirecting directly to dashboard even though the user doesn't have access to it resulting in ugly error DEV-2723, PR-2145 `Scheduler` - Fix: issue with schedule object was not saved correctly with scheduled tasks DEV-2802, PR-2211 `Grids` - Fix the sorting when columns are grouped and the user tries to sort on multiple columns. DEV-2987, PR-2261 `Error Message` - Change error message pages and removing the cat references DEV-2381, PR-2290 `Grids` - Fix position of column menu when it is far right on the screen (< 300 px from the right edge of the browser window). This was a problem after the width of the menu grew when adding new auto sizing options for the columns. DEV-1994, PR-2287 `Workspaces` - Increase the queried range of period filter options to -100, +100 years. This is an extreme upper/lower range limit, the actual limit is determined by the available values in the database date table. PR-2296, DEV-2316 `Reports/Items` - Fix issues with not being able to remove columns from reports when two columns have the same name but different id's PR-2342, DEV-3031 `Workspaces` - Fix a filter and sorting bug in Workspaces PR-2346, DEV-3032 `Reports/Items` - Fix: Lead time and additional lead time, in filters, are displayed as text in items and reports PR-2385, DEV-3038 `Orders` - Fix: Orders views look "unsaved" after adding a column to orderviewcolumns + sidebar PR-2404, DEV-2951 `Workspaces` - Adding config options for links within workspaces to be able to open a linked view in another tab and apply conditions for what lines should display links. This change also adds the ability to link between workspaces. PR-2435, DEV-3063, DEV-3062 Api 6.2.11 `Scheduler` - Use AGR scheduler instead of SQL Agent for db stats save DEV-2615, PR-2128 `Forecast` - Fix issues with the parallel process: The hanging of the parallel process and Removed the need for the /type parameter, it will be optional now. If not supplied it will be read from the forecast_type setting in the db DEV-2663, PR-2177 `Forecast` - Capture std-error output from forecast executables DEV-2531, PR-2143 `Forecast` - When the product is seasonal and with many zeros override the expert selection with the salt forecast model DEV-2945 , PR-2258 `Forecast` - Include trend column in forecasts table for more detailed breakdown column DEV-2969, PR-2258 `Forecast` - Model description logged in the forecast table DEV-3018, PR-2258 `Forecast` - If skip forecast to date is set then the "removing leading zeros" functionality is ignored DEV-2360, PR-2258 Databases 6.2.12 `Allocation` - Allocation module stabilization DEV-2774, DEV-2986, PR-2120, PR-2498, DEV-2356, `Promotions` - Promotions module stabilization DEV-2782, DEV-2771, DEV-2412, PR-2124, PR-2125, PR-2979 `Item Card` - Item Chart performance improvements: Precalculating stocks and undelivered today, introducing caching mechanism DEV-2709, DEV-2944, PR-2047, PR-2195 `Scheduler` - Use AGR scheduler instead of SQL Agent for db stats save DEV-2615, PR-2128 `MBE` - fix: The standard MBE fields MAPE and MAPE CATEGORY retain outdated values DEV-2800, PR-2166 `Connected items` - fix: an error happened when opening the calendar for "Connect from" / "Connect to" and then clicking the "x" button. DEV-2830, PR-2175 `db stats` - Incorporate disk latency stats into the zys.stats concept DEV-2707, PR-2169 `Data transfer` - Using system tables to get column info instead of information_schema due to poor performance DEV-2929, PR-2186 `Split Orders` - fix: Case sensitive error in ordersplitcalculate DEV-2927, PR-2196 `Data transfer` - Cleanup of elements that were accidentally copied into 6.2 but should only be in 6.3 and a migration to delete those elements DEV-2835, PR-2223 `Demand formula` - Fixing demand formula, moving planner promo out of the coalesce DEV-2841, PR-2224 `Data Mapping` - Adding a Document Type filtering for sales orders for nav and bc data mapping DEV-3004, PR-2302 `Data transfer` - Adding a way to run a single layer of staging elements and also adding a debug to get execute statements to run manually DEV-2948, PR-2295 `Data transfer` - Improvements of `create_erp_table` procedure DEV-2990, PR-2298 `Data transfer` - Adding inv cus item details populate procedure for an already existing stg element and fixing stg element parameters DEV-3017, PR-2326 `MBE` - remove obsolete columns `days_until_stockout` and `days_in_stock` from MBE DEV-2847, PR-2292 `Data transfer` - Adding the concept of a virtual location, allowing users to have locations that will not show up in prod but be available in stg for mapping of transactions, undelivered etc. DEV-2666, PR-2345 `Data mapping` - Removing vendor lead time from transfer order lead time coalesce in raw datamapping DEV-2966, PR-2370 `Forecast` - Removing forecast foreign keys DEV-3027, PR-2362 `Data mapping` - Adding responsible column to product assortment to use on sku level DEV-3001, PR-2372 `Forecast` - New forecast log and accuracy tracking, can be found in a new workspace called Forecast Accuracy Tracking and is only accessible to a system user. DEV-2632, PR-2378 `Forecast` - Performance improvements - speed improvements by reducing item set DEV-2663, PR-2365 `Workspaces` - Log slow dynamic update queries DEV-2977, PR-2387 `Forecast` - Standard stg elements included with setup to help with forecast configurations DEV-2721, PR-2365 `Data Mapping` - Remove those prep and raw tables and views that only belong to the LFP, and add them to the LFP project DEV-3013, PR-2377 `Dynamic Forecasts` - fixing dynamic forecast timeout bug + initialize dynamic forc with trend + model description. Also fixing item group histories sale not merging correctly in dynamic forecast run group DEV-2706, PR-2389 `Demand calculations` - Adding origin trace so you can see from which block of demand the items came and also adding a customizable order matrix that can be used to populate a custom demand matrix DEV-2740, PR-2403 `Data Mapping` - Preventing duplicate primary routes between transfer order routes and purchase order routes. If duplicates are found, the transfer order route will prevail. PR-2409, DEV-2967 `Orders` - Fixing datatype of cost price for accuracy purposes. PR-2466, DEV-3112 `Orders` - Floating Order Frequency: This solution introduces a new field for floating order frequency. It is applied in the following manner: Using the standard order logic, AGR checks if it should order an item, and if so, it calculates the quantity using the floating order frequency to achieve a longer order period. PR-2463, DEV-1993 `Orders` - Special Order Items: New column introduced that can be used to mark special order items (either through data mapping or a workspace). Another type of order logic runs for the items that are marked as special order items that utilize a new demand formula only designated for these items. These items would ignore the global order logic settings (min/max or default) and always just order the demand based on this formula. By default, the special order demand formula is Sales Orders +Promotions but that can be configured in the database. PR-2463, DEV-2319 `Orders` - Introducing thresholds (Minimum order multiple threshold) into the order logic. Calculated order quantity in an order proposal must exceed the percentage of the order multiple to be rounded up. Can be configured globally or for individual items. (Example: An item has order multiple = 10 and calculated quantity = 14 units, thus 40% of the next order multiple. With a 30% threshold, AGR will suggest 20 units but with a 50% threshold AGR will round down to 10 units) PR-2463, DEV-2983
6.2-r12	release/6.2.x	2021-09-29T10:17:06Z	6.2.10	6.2.11	6.2.12	0 / 14	6.2-r12.zip 6.2-r12.zip
6.2-r12 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 customizations 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.10 `Workspaces` - Fixes an issue in workspaces where paste skips all empty lines (when paste region is one column in width). DEV-2681, PR-2006 `Planned Orders` - Make schedule in planned orders creation larger DEV-2711, PR-2045 `Workspaces` - Add to lookupConfig in column config setting to turn on/off caching DEV-2538, PR-2044 `Item Card` - Prevent unnecessary refresh of Item Card. DEV-2703, PR-2057 `Order Constraints` - Make sure we have space for new translations in order constraints modal DEV-1764, PR-2078 `Workspaces` - Enable the save view button (detect changes) when locking or unlocking filters. DEV-2528, PR-2068 `Reports` - Reports grouping by field with date field ungrouped causes error sometimes DEV-2606, PR-2084 Api 6.2.11 `Forecasts` - Make sure we delete forecasts when there is no sale history DEV-2717, PR-2086 Databases 6.2.12 `Promotions` - Promotion module stabilization DEV-2535, DEV-2553, DEV-2673, DEV-2656, DEV-2658, DEV-2659, DEV-2447, DEV-2656, DEV-2673, PR-2008, PR-2012, PR-2016, PR-2014, PR-2027, PR-2019, PR-2021, PR-2059, PR-2069, PR-2016, PR-2072 `Promotions` - new data series for planned Promotion Margin & Turnover DEV-2451, PR-2023 `Connected Items` -fix: nvarchar(20) too short for item_no DEV-2665, PR-2025 `Helper Tools` - Add toolbox proc to give core.event report DEV-2567, PR-2018 `Logging` - Fixing procs abusing the fixed_text concept DEV-2683, PR-2032 `Forecasts` - fix: [dbo].[orderruncheck_forecasts] not using values from settings DEV-2700, PR-2053 `Demand / Orders` - Running demand, mbe and order analysis procedures directly in prod instead of running through shell procedures in stg DEV-2644, PR-1972
6.2-r11	master	2021-09-15T17:34:38Z	6.2.9	6.2.10	6.2.11	2 / 58	6.2-r11.zip 6.2-r11.zip
6.2-r11 What's new? The Allocation Module and Promotion Module are now a part of the standard setup. Customer setups where these modules have been installed as stand alone modules on to 6.2, will have to manually make changes to convert the allocation or promotion modules to the standard setup. Please contact the dev team before starting an upgrade to this patch. `Workspaces / Item Card` - Include the Order Qty (Order Selected) series in the item card when viewing the Item Card from within a workspace view by making an orderId column available in the view and setting the `itemCard.orderIdColumn` property in the workspace view config. DEV-2677, PR-1993 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 customizations 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.9 `Workspace` - Use week and month captions from database in workspace period filters. DEV-2186, PR-1792 `Item Card` - Fix/item-card/chart/Adjusting sale does not work when for new items. DEV-2520, PR-1815 `Grids` - fixing group aggregation for date columns DEV-2400, PR-1828, PR-1882 `Grids` - Update data grids style (orders, reports) so that a shadowed/gray line is shown one every other row in child-rows when data is grouped. This is common in the order grid (grouped by order id). Grouped rows (aggregated row) is empasized for numbers and text in child rows is slightly indented. The column header text was slightly emphasized with bold and darker color. DEV-2363, PR-1905 `Dashboard` - Prevent dashboard chart from disappearing DEV-2617, PR-1916 `Item Card` - Add loading indicator to chart while it is loading, so users don't misunderstand which Item is visible in the chart when going between items. DEV-2411, PR-1924 `Item Card` - Fix load delay when selecting an item to load in the Item Card. Debounce timer now resolves immediately and queues consecutive requests until no new item has been selected for 400ms. DEV-2645, PR-1934 `Item Card` - Make sure data in data series that are marked as `aggregated_over_period = true` are displayed in the grid when viewing data on the montly or weekly level (aggregated levels). With this change, rows are included that might not fit on the otherwise aggregated dates, i.e. Monthly used to show only rows on the 1st of every month and weekly the 1st of every week. The most common side effect to this is that a row for Today is always visible and thus we decided to highlight this row, this is a similar effect to the forecast period background in the chart. DEV-2601, DEV-2679, PR-1988 `Workspaces / Item Card` - Include the Order Qty (Order Selected) series in the item card when viewing the Item Card from within a workspace view by making an orderId column available in the view and setting the `itemCard.orderIdColumn` property in the workspace view config. DEV-2677, PR-1993 `Orders` - Fix paste from windows excel into order grid always clearing the cell after last pasted cell DEV-2680, PR-2004 Api 6.2.10 `Scheduler` - Prevent the scheduler to run the same scheduled task at the same time. DEV-2489, PR-1766 `Scheduler` - fix: When scheduled-task is disabled in client it is disabled in database but shows enabled on next refresh. DEV-2530, PR-1825 `Forecasts` - fix: day distribution not working for Easter and Christmas weeks DEV-2431, PR-1773 `Notifications` - Corrected error handling for create-orders and create-planned-orders to make sure "error" notification is not overridden by success notification after procedure errrors. DEV-2470, PR-1880 `Reports` - Fix/update report changes owner DEV-2600, PR-1915 `Logging` - Fix/wrong use of fixed text event logging DEV-2511, PR-1921 `Advanced filter` - Fixing error using advanced filter with mbe column with letter including ø / å. Also fixes an issue where whitespace in front of , in expression list (for example [id] NOT IN (1 , 2 , 3 , 4) caused validation errors. DEV-2569, PR-1911 `Notifications` - Stop sending notifications when getting translations from pool/cloud DEV-2671, PR-1994 `Forecasts` - Making sure when we calculate forecast from the item card that the period isn't shorter then the period in global settings DEV-2668, PR-1995 Databases 6.2.11 `Allocation` - Allocation module added to standard setups DEV-2393, DEV-2440, DEV-2438, DEV-2443, DEV-2515, DEV-2550,DEV-2542, DEV-2540,PR-1714, PR-1767, PR-1770, PR-1768, PR-1843, PR-1846, PR-1855 `Promotion Tool` - Promotion Tool module added to standard setup. By default the feature is turned off. DEV-2395, DEV-2534, PR-1771, PR-1852 `Stockout Smoothing` - Delete implemented DEV-2366, PR-1751 `Connected Items` - Added a vendor filter to the location lookup views for connected items DEV-2499, PR-1796 `Corrolated&Similar Items` - Added to navigation bar DEV-2474, PR-1800 `Helper Tools` - ex views causing error on install DEV-2488, PR-1799 `Performance` - fix: Procs doing RETURN and leaving an open transactions DEV-2505, PR-1802 `Helper Tools` - tb.scriptlookup needs to update column xxx in mbecolumns to be xxx_id DEV-2507, PR-1801 `Datamapping` -Remove origin column in inv.historiesadjustedsale on stg DEV-2480, PR-1806 `Datamapping` - ABC control table populated with default values after install DEV-2475, PR-1803 `Datamapping` - Change the product/item datamapping so that if a product is marked closed in the raw.product_assortment table it will appear in agr as closed DEV-2421, PR-1804 `Forecasts` - fix: The forecasteventvalues empty after initial load DEV-2407, PR-1805 `General` - Collation and case sensitivity fixes DEV-2481, DEV-2558, PR-1811, PR-1861, PR-1876 `Helper Tools` - Move more helper procs to the toolbox schema DEV-2514, PR-1812, PR-1863 `General` - fix: v6.2 r10 patch script error due to FKcorestggroupelementcorestgelementname DEV-2527, PR-1794 `General` - Exclude mbe-item-custom table changes in patches DEV-2420, PR-1836 `Data Mapping` - fix: inv.bom_component not linking on locations DEV-2551, PR-1848 `Data Mapping` - better support for multi erp DEV-2552, PR-1854 `Split Orders` - fix: errors when splitting orders by delivery date DEV-2559, PR-1865 `Demand Calculations` - removing obsolete parameters when calculating for one item DEV-2568, PR-1872 `MBE calculations` - removing obsolete known demand view and mbe columns DEV-919, PR-1869 `Workspaces` - Fix precision in series update. Should provide better precision when updating values for avg series DEV-2468, PR-1835 `Data Mapping` - Adding standard data mapping for location groups DEV-2148, PR-1899 `Logging` - fix: Wrong usage of core.event @fixed_text. Improves quality of forecast error logging DEV-2511, PR-1910 `Data Mapping` - fix: error in data mapping merge generations when using linked server DEV-2608, PR-1888 `Audit` - fix: auditing permission problems. Audit was causing errors if the user did not have proper permissions, added a check to prevent this DEV-2612, PR-1901 `Workspaces` - Connect productitemskuextrainfo and items in dataelementreftablesconnections DEV-2610, PR-1896 `MBE Calculations` - cap days cover estimates by the same number of days as demand calculations DEV-2422, PR-1892 `Item Card` - Adding stickyTracking on for forecast and adjusted sale in chart. DEV-2467, PR-1821 `Helper Tools` - Add toolbox item info proc DEV-2602, PR-1932 `Helper Tools` - Add toolbox tb.event proc DEV-2567, PR-1932 `Update Scripts` - Using IIF in calculated column causes sql compare problems DEV-2649, PR-1947 `Data Mapping` - Undelivered datamapping: Changing the primary key of transfer order and purchase order to include delivery date. Also using delivery date from lines instead of header in both tables DEV-2639, PR-1944 `Data Mapping` - Adding datamapping for reserved: inv.v_reserved --> inv.reserved --> dbo.reserved DEV-2648, PR-1950 `Data Mapping` - Fixing sales history datamapping: Adding a ISNULL to transfer and markdown in sale history to prevent errors because prep layer does not accept nulls DEV-2646, PR-1960 `MBE` - Fixing demand for next 30 days so it does not include dates < today DEV-2613, PR-1958 `Logging` - Log dynamic queries from dequery and runmbereportdn DEV-2642, PR-1953 `Dashboard` - fix: dashboard chart not working when user access is turned on DEV-2653, PR-1966 `Item Card` - Make sure a correct value for the stock history series is displayed for every interval when viewing the Item Card Grid. This is especially helpful when viewing the grid on a weekly or monthly level. DEV-1048, DEV-1207, PR-1997
6.2-r10	master	2021-06-24T13:14:52Z	6.2.8	6.2.9	6.2.10	1 / 15	6.2-r10.zip 6.2-r10.zip
6.2-r10 What's new? `Scheduler` - Tasks are now run simultaneously in scheduler and do not queue up DEV-2424, PR-1729 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 customizations 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.8 Api 6.2.9 `Scheduler` - Tasks are now run simultaneously in scheduler and do not queue up DEV-2424, PR-1729 `Advanced filter` - fix TSQL validation for AND/OR DEV-2391, PR-1679 Databases 6.2.10 `Workspaces` - Fix user access ref table id cast error DEV-2368, PR-1674 `Similar&Corrolated Items` - Moving nav and raw stg elements DEV-2396, PR-1673 `Similar&Corrolated Items` - Change the structure of view raw.vSALETRANSACTION so it is formatted like the other raw views DEV-2396, PR-1673 `Similar&Corrolated Items` - Schema changes DEV-2428, PR-1724 `Data mapping` - Remove product information master (only used for MFP) MFP-165, PR-1670 `Update Script` - Adding a lot of custom objects to migration because they don't come automatically with our upgrade scripts DEV-2147, PR-1695 `General` - A fix to disable scalar udf inlining in one function which is causing a huge performance problem when using SQL2019 CU11 DEV-2434, PR-1738 `Demand Calculations` - Fix for error caused by lead time = 0 in demand calculations DEV-2418, PR-1721 `Reports` -Add foreign key to check if user id exists for mbe reports DEV-2423, PR-1710 `Install` - fix:Error on install of new system on agrstgstep3initialloadothererp DEV-2469, PR-1741 `Scheduled Orders` - fix: Scheduled order id was not feeding through properly causing scheduled orders to be calculated as regular order DEV-2466, PR-1734 `Stg` - fix: Merge performance improvement by applying a filter to avoid unnecessary updates when using the not matched by columns DEV-2464, PR-1736 `Orders` - Planned orders now also listening to the split orders by est. delivery date setting DEV-2035, PR-1740
6.2-r9	master	2021-05-27T16:57:32Z	6.2.8	6.2.8	6.2.9	3 / 33	6.2-r9.zip 6.2-r9.zip
6.2-r9 What's new? The new beta installer has been removed for now until we make it more stable. `Data Element Editor` - Data element editor workspace for series (consultant feature to help with creating data elements) - Note that there is still some unresolved performance issues with opening some of the views which will be addressed in future patches DEV-1287, PR-1645, PR-1664 `Correlated and Similar Items Workspace` - New machine learning functionality to calculate correlated and similar items. Also a workspace to manage and analyze the results. DEV-2396, PR-1663 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 customizations 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.8 `Workspaces` - fix: Workspace column config for fixed options not working. DEV-2186, PR-1545 Api 6.2.8 `Orders` - Make order creation independent of the queue in app-service. Orders will be executed as .net task and do not wait while scheduled tasks and other queued tasks are processed. Orders will also not wait until other orders are created. DEV-2384, PR-1656 `Reports` - Fix advanced filter in reports not able to handle columns from a table with a schema other than dbo DEV-2386, PR-1658, PR-1659 `Workspaces` - Fix recursive cleanup of workspace view config causing performance issues in views with complicated configs DEV-2387, PR-1659 Databases 6.2.9 `Data mapping` - Fix stock markdown data mapping for MFP MFP-111, PR-1538 `Orders` - fix: ordersupdatevalues and ordersupdatevalues_custom not able to handle long strings DEV-2325, PR-1555 `Data mapping` -add extra info synonym to core.synonyms DEV-2327, PR-1553 `System Health` - improve the system health logs from legacy stg DEV-2330, PR-1557 `Update Script` -Add migration for new extra info. Adding staging elements and adding elements to groups DEV-2337, PR-1565 `Workspaces` - fix: without date series update not working DEV-2342, PR-1577 `Data mapping` -Fix/datatype discrepancy in data mapping MFP-87, PR-1583 `Order Analysis` - fix: Order Analysis workspace was only available for system users DEV-2340, PR-1578 `Orders` - skip archiving computed columns in orderlinecalc_results DEV-2323, PR-1566 `Data Mapping` - standard datamapping for sales orders DEV-2195, PR-1607 `Data Mapping` - Add datamapping for navision ItemVariant table DEV-2318, PR-1602 `Data Mapping` - Fixing one join in item extra info datamapping DEV-2371, PR-1634 `Logging` - Removing excessive logging for manual order create DEV-2324, PR-1602 `MBE` - Move parameters from mbeitemstatistics_populate to settings DEV-2073, PR-1602 `MBE` - Remove commented out code from mbeitemcustom standard template DEV-2181, PR-1602 `Tool Box` - Adding tb.script_module to help script out workspace modules and a script that autogenerates lookup filters DEV-2196 PR-1602 `Data Mapping - Returns mapping for MFP MFP-94, PR-1615 `Update Script` - remove order view recreate DEV-2349, PR-1608 `Item Card` - Changed the default chart settings to turn off sticky tracking (only applies to new setups) DEV-2190, PR-1627 `Connected Items` - Fix scaling issue for connected sale DEV-2372, PR-1632 `Orders` - global temp table cleanup DEV-2369, PR-1639 `Workspaces` - Clear table interaction cache when altering data elements DEV-2361, PR-1637 `Data Element Editor` - Data element editor workspace for series DEV-1287, PR-1645 `Data Mapping` - Add BOM standard data mapping DEV-2380, PR-1651 `Data Mapping` - Include inv_cus schema in prod database as a part of standard setup DEV-2377, PR-1657 `Stockout Smoothing` - fix: error in first sale average period DEV-2335, PR-1660 `Dynamic Forecasts` - fix: Dynamic forecast using same id column name for different tables DEV-2390, PR-1661 `Data Element Editor` - Data element editor workspace for series (consultant feature to help with creating data elements) - Note that there is still some unresolved performance issues with opening some of the views which will be addressed in future patches DEV-1287, PR-1645, PR-1664 `Correlated and Similar Items Workspace` - New machine learning functionality to calculate correlated and similar items. Also a workspace to manage and analyze the results. DEV-2396, PR-1663
6.2-r8	master	2021-04-21T20:20:47Z	6.2.7	6.2.7	6.2.8	2 / 9	6.2-r8.zip 6.2-r8.zip
6.2-r8 What's new? New audit functionality that is integrated into the prod and stg databases A beta version of a brand new installer comes with this patch that should be more reliable than the old one. Please test it out if you have a change and report any issues to us. 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 customizations 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 Api 6.2.7 `Forecasts` - Adding data mapping for exclude from forecast in item details and making sure to force invalid forecast if values change and system lights are updated accordingly DEV-2219, PR-1525 Databases 6.2.8 `Update Scripts` - fixing errors that cause Error in dbo.ordersupdatevalues with the sequence seqorderlinerunid. DEV-2250, PR-1382 `Workspaces` - The data element series config (db) update_action has no effect. DEV-2254, PR-1476 `Data Mapping` - Restructuring stg element types: remove Run Excections and App Server stageing elements types and create predatatransfer and postdatatransfer instead DEV-2301, PR-1502 `Data Mapping` - Extra info fix and improvements: Fixing problem with primary key mismatch in product extra info. Also adding improved error checks and automatic schema locking exceptions for the prod objects, also making sure core tables can be added to reports and ordergrid. DEV-2310, DEV-2305, DEV-2304,PR-1500, PR-1515 `Audit` - New audit functionality that is integrated into the prod and stg databases DEV-2234, DEV-2140, PR-1498, PR-1518, PR-1527 `STG2` - Fixing space sensitivity in the setup of stg elements DEV-2298, PR-1512, PR-1519 `Logging` - Batch id seeded with the max of old log id to continue where the old logging left off DEV-2306, PR-1511 `Forecasts` - Adding data mapping for exclude from forecast in item details and making sure to force invalid forecast if values change and system lights are updated accordingly DEV-2219, PR-1525
6.2-r7	master	2021-04-07T15:07:58Z	6.2.7	6.2.6	6.2.7	2 / 25	6.2-r7.zip 6.2-r7.zip
6.2-r7 What's new? A beta version of a brand new installer comes with this patch that should be more reliable than the old one. Please test it out if you have a change and report any issues to us. `Data Flow` - New STG customization framework to make customizing the data flow easier. See documentation in the [Techincal Manual] (https://docs.agrdynamics.com/6.2/technical/core/data-flow/#customisation). If you have installed the system using a version before this patch release, please review the dataflow and change it to use the new extra info dataflow. Note that the itemextrainfo dataflow will be deleted in this patch and replaced by productitemextrainfo and productitemskuextra_info. This code needs to be manually migrated in this patch update and the old code will be lost. DEV-2168, PR-1445 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 When installing 6.2 the table tracking in the audit db is not initialized. This means that we are not automatically tracking table changes. We are hoping to release an improved audit functionality with the next patch 6.2-r8 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.7 `Workspaces` - exclude drill down doesn't work when using same column as clicking. DEV-2158, PR-1382 `Workspaces` - Workspace lookup fields - add support for fixed options. DEV-2186, PR-1386 `Workspaces` - Fix unnecessary reloads og grid data in workspaces for every drilldown that is populated. This fix makes sure to only load grid once after all drilldowns have been populated. DEV-2217, PR-1420 `Orders` - Order grid update slow when order has thousands of lines DEV-2215, PR-1423 `Orders` - Update order info sidebar aggregated columns when order is edited DEV-2206, PR-1428 `Orders` - Value aggregations update when you paste into grid DEV-2226, PR-1440 `Workspaces` - send correct workspace action when editing aggregation DEV-2182, PR-1434 `Users` - fix users grid breaking when access groups are active DEV-2221, PR-1442 `Advanced Filter` - Minor fix of on issue that prevented NOT IN (also NOT BETWEEN and NOT LIKE ) from working in advanced filters. DEV-2239, PR-1453 API 6.2.6 `Scheduler` - Adds error text when scheduler runs task with staging run that does not exist or has no elements. DEV-2174, PR-1370 `Reports` - Added more functions to Advanced Filter DEV-2138, PR-1380 `Forecasts` Fix forecast error handling and weekly forecast issues when there is not one week of sale available. DEV-1832, PR-1376 Databases 6.2.7 `Data Flow` - New STG customization framework to make customizing the data flow easier. See documentation in the [Techincal Manual] (https://docs.agrdynamics.com/6.2/technical/core/data-flow/#customisation). If you have installed the system using a version before this patch release, please review the dataflow and change it to use the new extra info dataflow. Note that the itemextrainfo dataflow will be deleted in this patch and replaced by productitemextrainfo and productitemskuextra_info. This code needs to be manually migrated in this patch update and the old code will be lost. DEV-2168, PR-1445 `Update Script` - fix: Update script creating a forecast stg run name with wrong name DEV-2173, PR-1357, PR-1368 `Update Script` - Making sure historyelementid column is removed from the adjusted-sale table on stg so that the datatransfer won't break DEV-2144, PR-1357, PR-1421 `Update Script` - Making sure temp reports fro the Items feature are created if they don't exist DEV-2236, PR-1357, PR-1448 `Update Script` - Making sure the order master view is recreated to prevent errors when opening the Order Grid DEV-2209, PR-1357, PR-1421 `Bridge Stockout` - Improve bridge_stockouts proc to handle sales inside stockout period DEV-2153, PR-1361 `Workspaces` - fix errors in dataseries update when global weekend distribution settings are turned on DEV-2172, PR-1367 `Constrainer` - fix errors with constraining by days DEV-2176, PR-1373 `Data Mapping` - Fixing wrong insert order into temp table in item map populate DEV-2207, PR-1410 `Data Mapping` - Add active filter when using core.executestgrun to run groups DEV-2203, PR-1396 `Orders` - Planned Orders should use order frequency based on scheduled order settings DEV-2180, PR-1391 `Promo Smoothing` - Promo Smoothing code refactored to be more like the stockout smoothing code DEV-1663, PR-1421 `System Health` - Fixes to system health to ensure SysMon is working with 6.2 and stg1 bridge DEV-2214, PR-1455, PR-1463
6.2-r6	master	2021-03-09T14:20:38Z	6.2.6	6.2.5	6.2.6	0 / 11	6.2-r6.zip 6.2-r6.zip
6.2-r6 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.6 `Executions/Notifications` - Fix issue where server/client signalR connection is lost. With this update a reconnection attempt should trigger periodically if connection is lost and it should be indicated in the notification list. DEV-2141, PR-1300 `Orders` - Multipe Order Grid issues. Row group aggregate values must update after edit, If column is sorted, the row order should not change after edit, After Qty cell edit, if TAB pressed, should not capture the old value in Purchase Units and Orders grid should support custom editable columns.fix sorting after edit DEV-2150, PR-1313, PR-1322 `Workspaces` - Fix issue where cell focus was moved or lost after editing dataseries cells in series workspace views. This bug was introduced when fixing a related issue when editing checkbox values in serie grids. DEV-2154, PR-1329 `Workspaces` - Remove the overwriting of view filters by workspace/user/ad-hoc filters. Since the first release of AGR v6 the workspace filters would overwrite the same filter if it existed as a view filter. This was done so that admins could easily test new filter setups in a view without changing the view itself and it would also enable browsing between views where you'd be sure that the workspace filter setup would trump the view setup. With these changes both the workspace- and view filters are used to filter the grid results which means only the intersection of the filters are resolved. This is a more logical result and prevents users from gaining access to data in views that would otherwise be unreachable because of locked view-filters. DEV-2156, PR-1327 Databases 6.2.6 `Data Mapping - Change datatype to smallint for lead time DEV-2145, PR-1303 `Item Chart` - New setting to decide whether purchase plan should be included in the estimated stock calculations in the chart DEV-2132, PR-1301 `Item Chart` - Fixing ambiguity in chart elements if there is a column named "date" DEV-2152, PR-1307 `Tool Box` - new helper procedure for scripting module artifacts DEV-1864, PR-1309 `Translations` - Translation keys missing for new mbe columns DEV-2151, PR-1320 `Update Scripts` - Making sure standard procedures for customisations are backed up in upgrade DEV-2155, PR-1321 `Workspaces` - Fixing column agg. in series view DEV-2130, PR-1334
6.2-r5	master	2021-02-23T14:39:12Z	6.2.5	6.2.5	6.2.5	0 / 17	6.2-r5.zip 6.2-r5.zip
6.2-r5 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.5 `Item Card` - Set the min and max values for the x-axis in the Item Card chart so that the x axis doesn't change when series are hidden. With this change the x-axis values in the chart should always reflect the period range (history/forecast) values selected. DEV-2123, PR-1265 `Reports` - Fix error where report could not be saved because of an error in the Advanced Filter. Handle the error gracefully in the client. DEV-2107, PR-1272 `Workspaces` - Added a new config item to workspace column config "link". It is possible to specify a list of drilldowns that should be explicitly closed in the transferred view. DEV-2124, PR-1263 `Workspaces` - Fix issue where grid and cell focus was lost after updating the checkbox value of an editable checkbox-cell in the workspace view. This made it impossible to navigate and update the grid using the keyboard (space and arrow keys). DEV-2065, PR-1288 API 6.2.5 `User Management` - Clear encrypted password from API response DEV-1874, PR-1253 `User Management` - Flag deleted users instead of deleting them from the database. DEV-2127, PR-1289 `User Management` - Change verification check when checking if email exists for user so it ignores deleted users (e-mail can therefore be reused). Fix unique key constraint when dealing with email for deleted users. DEV-2127, PR-1289 Databases 6.2.5 `Audit db` - fix: `Add zys.generate_sql`. DEV-2088, PR-1218 `Actions/Executions` - Use named parameters for `dbo.de_execute_action`. DEV-2128, PR-1280 `Dashboard / Key Reports` - Adding nightly refresh to key report item count. DEV-2093, PR-1258 `Helper Objects` - Add `zys.generate_sql`. DEV-1864, PR-1227 `Item Card` - Using `hidden_in_chart` in `chart_item_select`. DEV-2054, PR-1255 `Logging/System Status` - Fix error when app server is logging big stack traces. DEV-2134, PR-1281 `Orders` - fix: Using access-group restrictions made orders disappear if some items were closed while the order is still in process DEV-2104, PR-1239 `Orders` - Override and backup the `dbo.orders_update_values_custom` procedure on database update. Consultants will have to manually move any customisations from the backup to the standard procedure which has changed significantly. DEV-2137, PR-1276 `Update Script` - Fix db various migration issues DEV-2102, PR-1237, PR-1245, PR-1242 `Workspaces` - Change description column in `data_element_calc/ref_columns` to `nvarchar(max)` DEV-2085, PR-1243
6.2-r4	master	2021-02-09T09:59:50Z	6.2.4	6.2.4	6.2.4	0 / 15	6.2-r4.zip 6.2-r4.zip
6.2-r4 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.4 `Translations` - Prompt the user to input an API key to use Google Translations when retrieving a suggested translation. This API key was stored in the application code, but because it can be revoked or changed at any time it was wise to remove it and have users input it instead. DEV-1978, PR-1196 `Translations` - Prompt the user to login again by opening the login modal when a user tries to save any new/updated translations when the current session has expired. This fixes an issue where users would lose all their translation changes when trying to save with an expired token. DEV-2063, PR-1189 `Workspaces` - Fix how the workspace period filter handles validating and updating big values. It used to change both the `to` and `from` value when either one was invalid. This change fixes this so only the invalid value is changed to the max/min valid value. DEV-1962, PR-1187 `Workspaces` - Fix: When series are updated and there is a config under row.uniqueKeyColumns, the query submitted to update (and refresh) should use the specified unique key columns instead of copying all non-serie columns in the view. DEV-1463, PR-1193 `Workspaces` - Clear cache after saving default config DEV-1891, PR-1210, PR-1212 `Workspaces` - Fix how the workspace period filter handles validating and updating big values. It used to change both the `to` and `from` value when either one was invalid. This change fixes this so only the invalid value is changed to the max/min valid value. DEV-1962, PR-1187 API 6.2.4 `Event Logging` - Fixes to forecast event logging DEV-2062, PR-1211 Databases 6.2.4 `Cleanup` - Removing fill factor and other unnecessary index options DEV-1906, PR-1203 `Correlated/Similar Items Workspace` - Added correlated/similar items database objects to core DEV-2084, PR-1216 `Data Mapping` - Making sure views are refreshed in the data transfer in order to have the correct data types DEV-1980, PR-1176 `Item Card` - Loading vdailydemand into table variable to improve performance DEV-2047, PR-1180 `Orders` - fix: When manual orders were created multiple order routes were falsely stopped by sanity check DEV-2001, PR-1184 `Orders` -Fix order line breakdown to properly reflect lost sale now that it's not a true/false anymore but a percentage DEV-2076, PR-1206 `Update Script` - fix: orderlogicsetting change from string to tinyint must translate values in pre migration step DEV-2075, PR-1182 `Update Script` - fix: Create missing settings groups and move the creation of the core.setting table out of the pre-update script DEV-2077 DEV-2089, PR-1201 PR-1217
6.2-r3	master	2021-01-28T13:50:13Z	6.2.3	6.2.3	6.2.3	1 / 31	6.2-r3.zip 6.2-r3.zip
6.2-r3 What's new? `Translations` - New translations feature which enables CRUD (Create, Read, Update, Delete) interactions with the translations on the AGR Pool cloud server. Users can maintain translations for all deployed systems (wherever in the world) running AGR v6.2 or newer from within the AGR app itself. DEV-1755, PR-1088 System users will need to login to the AGR Pool cloud service with separate credentials to enable the edit mode. All translation changes are staged and have to be manually saved by clicking the save button. Any staged changes can be undone/reset from the info sidebar. Translating to a new language can be amazingly fast using the new magic button which suggests a translation from Google based on the current english translation. When translating the application it is possible to turn off the default translation fallback behaviour to visualize all the untranslated strings for the selected language in the app. 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 There are known issues within the upgrade scripts between minor versions, i.e. the scripts to upgrade from 6.1->6.2 are broken and those issues are planned to be fixed in 6.2-r4 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, on the 6.2 release branch + these pull requests on the develop branch See code changes on GitHub compare Client 6.2.3 `Format` - Fix how durations are processed and formatted in the app. These changes enable us to use both `Date` objects and rounded/integer `number` values in milliseconds to store durations and display in the app. DEV-1858, PR-1051 `Grids` - Fix: issues that cause grid to re-sort after cell edit. DEV-1909, PR-1072 `Grids` - Fix: Distinct aggregation with grouping broke the grid when date fields were included in the grid DEV-1839, PR-1135 `Item Card` - Fix issue where grid was not displaying series data on the week level, when the start of week is not Monday (i.e aggregated to another day in `chart_item_select`). The `item_card_start_week` property was added to `dbo.settings` so the start of week can be changed. DEV-1948, PR-1057 `Item Card` - Fix issue where the forecast series in the Item Card chart was not displayed correctly when the start of week is not Monday (i.e aggregated to another day in `chart_item_select`). After these changes the forecast should be correctly placed and the helper/grid lines (tickInterval) in the chart are also moved to align with the newly added `item_card_start_week` setting. DEV-1960, PR-1099 `Item Card` - Make the week indication label on the x-axis optional in the Item Card chart. By setting the newly added `item_card_hide_week_number` setting to `true` the chart label will dislpay e.g. `7. Dec'20` instead of `w50 - Dec'20`. PR-1099 `Item Card` - Make the chart config visibility setting actually affect the default visibility for series. With this change, if the `"visible: false"` setting is set in `dbo.chart_elements.highcharts_series_options` the series will be hidden by default. DEV-2055, PR-1167 `Item Card` - Open datepicker for editable date values in item card details on previously selected date to improve the user experience. DEV-2064, PR-1166 `Item Card` - Open datepicker for editable date values in item card details on previously selected date to improve the user experience. DEV-2064, PR-1166 `Item Card` - Make the chart config visibility setting actually affect the default visibility for series. With this change, if the `"visible: false"` setting is set in `dbo.chart_elements.highcharts_series_options` the series will be hidden by default. DEV-2055, PR-1167 `Navigation` User that does not have access to any feature in a sub-menu will not see the empty sub-menu button. DEV-1868, PR-1073 `Translations` - New translations feature which enables CRUD (Create, Read, Update, Delete) interactions with the translations on the AGR Pool cloud server. Users can maintain translations for all deployed systems (wherever in the world) running AGR v6.2 or newer from within the AGR app itself. DEV-1755, PR-1088 System users will need to login to the AGR Pool cloud service with separate credentials to enable the edit mode. All translation changes are staged and have to be manually saved by clicking the save button. Any staged changes can be undone/reset from the info sidebar. Translating to a new language can be amazingly fast using the new magic button which suggests a translation from Google based on the current english translation. When translating the application it is possible to turn off the default translation fallback behaviour to visualize all the untranslated strings for the selected language in the app. `Workspaces` - Add dynamic query for action modal select options. DEV-1819, PR-1050 `Workspaces` - Fix column formatting assumption happening when a column name contains the word 'price'. PR-1074, DEV-1890 `Workspaces` - Filter drilldown be present viewfilter of same column DEV-1893, PR-1116 `Workspaces` - Fix: the edit-ability of the column in a total row when there is conditional editing on the column. For example with this column configuration on the weight column in a view with item no and weight present DEV-1577, PR-1140 `Workspaces` - Fix "selectedObj" attributes sent in workspace commands DEV-1911, PR-1150 `Workspaces` - Add a loading indicator to workspace lookup cell-editor. DEV-2061, PR-1154 `Workspaces` - Cache the lookup values query result when opening the workspace lookup cell-editor so that future requests are resolved immediately. DEV-2060, PR-1154 `Workspaces` - Make workspace lookup cell-editor display lookup options a lot quicker by only rendering a portion of items in the DOM. This is done by enabling the virtual scroll for the ngSelect component. DEV-2067, PR-1165 API 6.2.3 `App Service` - Fixes app-service restart state in core.event log, notification ordering in drop down menu and clear own notifications from drop down menu DEV-1850, DEV-1924, PR-1164 `Orders` - Faster paste (bulk update) in orders grid. DEV-1912, PR-1061 `Orders` - Timeout for manual orders extended to 4hrs DEV-2052, PR-1132 Databases 6.2.3 `Demand Run` - Fix issues with malformed reports halting the demand run DEV-1959, PR-1065 `Data Mapping` - Fix datatype to TINYINT for Price Includes VAT column in nav.Item table DEV-1949, PR-1066 `Data Mapping` - Standardising NAV datamapping for product groups to avoid duplications DEV-1953, PR-1142 `Data Mapping` - Forctype column in itemdetails not populated in inventory datamapping DEV-2049, PR-1161 `Data Mapping` - Exclude abc_grouping from inventory datamapping DEV-2053, PR-1160 `Item Card / Settings` - Add the `item_card_hide_week_number` property to the `dbo.settings` table to hide/show the week label when the Item Card chart is viewed on the weekly level. PR-1099 `Settings` - Add the `item_card_start_week` property to the `dbo.settings` table to control which day of the week series are aggregated to when looking at the Item Card Grid in weekly view. DEV-1948, PR-1057 `Split by Constraint` - fix: split by constraint logic broken if using fillup. DEV-1991, PR-1109
6.2-r2	master	2020-12-15T13:03:34Z	6.2.2	6.2.2	6.2.2	0 / 27	6.2-r2.zip 6.2-r2.zip
6.2-r2 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.2 `About Modal` - Remove toaster error message when pool.agrdynamics.com is not reached. Caused by restricted internet access. PR-1015, DEV-1831 `About Modal / Login` - Remove the `New Update/Patch Available!` message which is displayed when there's a new patch available for the currently installed minor version of AGR. PR-1013, DEV-1845 `App Bootstrap / Login` - Prevent app load from failing if loading translations from the API fails. Improve the error message by suggesting that there is a potential error with the App Service. PR-1028, DEV-1731 `General` - Fix/dropdown/autofocus filter PR-1004, DEV-1896 `Grids` - Fix cell height when fields are editable PR-1002, DEV-1899 `Item Card` - Prevent docked Item Card from updating when receiving external update request from another browser window. PR-1017, DEV-1766 `Scheduler` - Add scroll to position of month with scroll into view directive PR-905, DEV-1693 `Workspaces` - fix/workspaces/view-settings/not-able-to-select-info-text PR-1003, DEV-1898 `Workspaces` - Change the `In Range/Between` numbers filter to `>=` or `<=` when 1 value is missing for the range filter. PR-1009, DEV-1792 `Workspaces` - Fix bug in setting drilldown after transfer view PR-1022, DEV-1840 `Workspaces` - Parsing of advanced filters breaks on real numbers (with decimal point). PR-1036, DEV-1927 `Workspaces` - Datetimepicker in workspace action dialogs PR-1027, DEV-1820 API 6.2.2 `Forecast` - DB call in static constructor randomly throws error causing the daily job to stop PR-1026, DEV-1883 `Orders` - Fix: Planned orders not created for selected item-ids PR-1000, DEV-1892 `Reports` - Validate advanced filter PR-992, DEV-1821 `Scheduler` - weekly calculation changed to be mon-sun instead of sun-sat PR-1001, DEV-1861 `Scheduler` - Fix/scheduler/task execution improve robustness PR-1019, DEV-1872 `Workspaces` - Fix: Edit view modal in workspaces could not choose users and roles without being system user PR-1005, DEV-1869 Databases 6.2.2 `Helper Tools` - Fix lots of build warnings in zys.dbmindexoptimize PR-1035, DEV-1922 `Orders` - Adding the ability to constrain planned orders PR-997, DEV-1866 `Orders` - Lost sale negative stock fix - Negative stock causes false "expired" numbers and wrong order qty PR-1021, DEV-1905 `Patch process` - fixing various issues causing the rollback to fail PR-1031, DEV-1904 `STG` - Standardise lead time datamapping from NAV PR-995, DEV-1817 `STG` - item details now includes inactive items PR-996, DEV-1882 `STG` - Move "vendor missing" from inv.vlocations view to raw.vVENDOR view PR-1011, DEV-1901 `STG` - Add nav schemas to schema locking PR-1030, DEV-1910 `STG` - Sync Coding style in raw views PR-1033, DEV-1902
6.2-r1	master	2020-12-03T10:21:32Z	6.2.1	6.2.1	6.2.1	0 / 49	6.2-r1.zip 6.2-r1.zip
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
6.2-r0	master	2020-10-30T12:20:04Z	6.2.0	6.2.0	6.2.0	23 / 150	6.2-r0.zip 6.2-r0.zip
6.2-r0 What's new? New Staging Framework Staging 2.0 officially released and used in all new implementations going forward. The new staging framework standardizes data mapping, has a defined architecture for customizations and will be maintained and updated in future releases/patches like the prod database. The new framework is a step forward towards greater modularisation of the system. Task Scheduler New Task Scheduler to schedule forecasts and data transfer The `Scheduler` introduces new ways to manage and interact with tasks, whether it is to schedule them, restart, cancel them, disable them, take a look at their history, or just see the progress for that particular run. There is also the option to run a task partially. The new `Calendar` is interactive and flexes a new interface to schedule tasks and countings as well as serving as an overview of upcoming dates. The new and improved scheduling interface is far more flexible than before, including options to add a specific period, the exact time, and intervals. Furthermore, if a schedule is still not perfect, dates may easily be added or removed by simply toggling them in the calendar - without having to alter the schedule itself. Encapsulates `scheduled orders`, `scheduled counting`, and `schedules`. System Logging Logging in the system standardized and refactored. This new event logging replaces the old logging with a more unified concept with greater flexibility. Consultant Features Features that have until now been maintained by consultants are standardized and included in the release. Connected items Bridge Stockout Promo Smoothing Order Analysis Workspace Archiving of Old Orders Standard Reports - A portfolio of reports that enable effective exception management for analyzing the supply chain. Workspace Features Advanced Filter for complex queries. Number Filter Date Filter Labels for Dataseries Make the Item Card available within a workspace. Consultant Tools Performance helping tools for consultants New `zys` schema – Toolbox to help consultants analyze performance and database statistics. Ex Views – Views to flatten out tables so you don't have to join multiple tables to get information. Cloud Translations Translations now managed globally in the cloud (AGR Pool) and a `translation_override` table added to each setup for private (customer only) translations. Translations are retrieved in a background task that is initiated when the client application is loaded. Translations are only retrieved if the feature is turned on and there exists any new translations. Migrations Migrations i.e the support and conversion of old data structures (JSON objects) in the database moved away from the client project and into an external script that runs along with the installer/update scripts. What does the database scripts change/update? Check the reports (Update this on release) Known Issues/Bugs Critical issues and bugs that are persistent in this release Outstanding Issues Issues Issues that were addressed and fixed in this release See code changes on GitHub compare See list of pull requests involved in this update on GitHub AGR Service & Scheduler New Task Scheduler to schedule daily tasks, data transfers, forecasts and more. The scheduler runs as a service worker (AGR Service) on the same server as the API and takes care of queueing and executing tasks. The following Pull Requests / Issues were all part of developing the feature. AGR Service DEV-1069 Scheduler DEV-1076 Api/agr app server check status. - Initial creation of App Service project. PR-226 App srv merge - PR-678, DEV-1431, DEV-1434, DEV-1555, DEV-1320, DEV-1578 Create scheduler page. PR-186, DEV-1076 Create Scheduled Tasks page. PR-389, DEV-1071 Delete scheduled tasks. PR-262, DEV-1081 Add New Calendar sidebar to the tasks page. PR-313, PR-321, DEV-1077 Add timeline to the calendar sidebar to view run times of schedule within a day. PR-334, DEV-1078 Create/Edit scheduled tasks. PR-398, DEV-1072 Changes in ScheduleMdl, parameter schedules. - PR-349 Add multiline edit of scheduled tasks. PR-443, DEV-1082, DEV-1352, DEV-1353 Refactor Schedule JSON Object. PR-451, DEV-1363 Enable selection/deselection of specific dates for tasks in the calendar. PR-467 Update/Rewrite Scheduled Counting to use new type of schedules. PR-573, DEV-1085 Move schedules to settings dropdown, remove scheduler from inventory navigation and change tab in scheduler from orders to Scheduled Orders. PR-686, DEV-1596, DEV-1594, DEV-1597 Make last day of month a selectable option in the new Schedules component. PR-703, DEV-1320 Add task complete parameter and add API route to get single scheduled task. PR-732, PR-737 Display in client the status of tasks using web-sockets (SignalR) to notify the client of the state of all running tasks. The client shows a loading indicator and state. PR-685, DEV-1233 When tasks are enabled they will run according to schedule. If not enabled they can be run manually. Read-only access implemented for the start/resume/cancellation of tasks. PR-770, DEV-1451, DEV-1639, DEV-1641 Fix server error when `api/schedules/get_usage` is called. PR-790, DEV-1602 Fix missing base-dates for intervals in calendar. PR-838 Fix issue where the calendar "looks drunk" when toggling dates because of inconsistent date list in weekly. Correct how `ApplyToggleDates` is called with period. PR-827, DEV-1680 Fix issue where interval couldn't be changed/edited for daily task. Initial load tasks updated. PR-845, DEV-1716 Let user navigate without warning when the calendar is not showing. PR-845, DEV-1694 Fix input fields not filled correctly after saving schedule. PR-845, DEV-1696 Fix next run time in calendar not updating when task is disabled. PR-861, DEV-1724 Fix null value error in the delete route after creating a `Counting` without a schedule. PR-858, DEV-1712 Avoid calculations of dates (result of schedule setup) before baseDate for all intervals. Calendar having trouble when interval was >1 PR-885, DEV-1679 Fix the calendar timeline, times not showing up. Refactor, move logic from child to parent components. PR-871, DEV-1719 Change format of time interval to use minutes instead of time (e.g HH:mm). PR-892, DEV-1718 Fix error when saving monthly tasks. PR-899, DEV-1767 Make the scheduler read only so anyone can see the scheduled dates while `schedules.mod` feature privileges are required to modify schedule. PR-877, DEV-1704 Correction on setting in app service, setting.group_id missing. - PR-754 Rewrite Scheduled Counting to use new type of schedules. Model updated in client, api and database. PR-573, DEV-1085 Changes for process bar and history status so that the task progress shows when you load the page. PR-769, DEV-1637, DEV-1638 Fix percentage calculation (task progress) when executing tasks with partial option. PR-884 DEV-1736 Fix an exception in app-service when creating manual orders. Exception was caused by null value passed to `@task_name` parameter in `stg.event_task_start` procedure.PR-759 Client 6.2.0 `App Bootstrap / Login` - Add alert message and console error when app initialization fails in the process of retrieving settings or translations. PR-859 DEV-1731 `Chore` - Update dependencies and client framework to Angular version 9/10 DEV-867, PR-198, PR-251, PR-374, PR-739, DEV-1630 `Cypress E2E` - Lay the groundwork for future e2e testing with the cypress framework. PR-619, DEV-1529 `Datepicker` - Fix how first day of week is retrieved for Datepicker in app. Remove outdated config. PR-894, DEV-1760 `Dashboard` - Fix layout in dashboard settings modal. DEV-1101 `Dashboard` - Fix console error in dashboard and update what is displayed when there’s no dashboard elements in chart. PR-244 `Dashboard` - Fix colors in Dashboard KPI's; show colors depending on target / lower level ranging goal. PR-904, DEV-1621 `Demo Mode` - Add demo mode feature, enabling setups to be locked at a certain date. PR-615, DEV-1089 `Grid` - Update grid colors. Row hover color removed, row focus color added, highlighted cells background color is grey instead of blue. Odd row background colors in data grids removed (items, report details and orders). PR-704, DEV-1568 `Locale` - Save `locale` users settings in the database (used to be in browser local storage). DEV-1165 Fix issue where site was not refreshed after language change. PR-730, DEV-1626 `Locale` - Add ~60 new locales to the system. This way we are less likely to have to update the client when adding new language support (translations + locale file) to the system. Locale files are imported on demand in the client (dynamic imports) so unused locales don't have to be retrieved on app bootstrap/download. PR-890, DEV-1748 `Migrations` - Remove client-side migration for `workspace` views and `order` grid views. DEV-926 `Navigation` - Add filter in main dropdown navigation to filter/search for menu items. PR-689, DEV-1470 `Orders` - Fix order logic methodology setting. 3 possible settings; `standard`, `minmax` and `ifmax`. PR-531, DEV-1231 `Reports` - Fix bugs in create report modal. Select visibility wasn’t working, labels weren’t resetting. PR-682, PR-845 DEV-1570 `Roles` - Fix new roles not saving features immediately. It is now possible to start editing roles immediately after creation. PR-880, DEV-1749 `Translations` - Refactor `Translations Service` so it can be used in model classes directly as a static function. DEV-1014 `Translations` - New dynamic placeholder variable for translation strings. PR-607, PR-681, DEV-1509, DEV-1593 `Workspaces` - Refactoring of the serie checkboxes functionality. PR-220 `Workspaces` - Save column sort in local storage (user state) in workspace columns. DEV-1060 `Workspaces` - Fix saving/loading of workspace grid state. PR-285 `Workspaces` - Update links between workspaces so they can set drilldown values in targe view from source view. PR-286 `Workspaces` - Add `edit.readOnlyIfNull` to serie config that make cells only readable if they have null values. DEV-569 `Workspaces` - Make the Item Card available in workspace views by setting the workspace view config `itemCard.idColumn`. DEV-1242 `Workspaces` - Add tags/labels to dataseries to hide/show groups of series. PR-355, DEV-1173 `Workspaces` - New Date Filter to filter date data in grids based on column value constraints. PR-377, DEV-892 `Workspaces` - Make lookup filter always available for columns, so that some workspace columns have 2 filters (e.g. Date and Lookup). DEV-1366, PR-445 `Workspaces` - Format date values in drilldown and lookup filters. DEV-1367, PR-445 `Workspaces` - New Number Filter to filter numerical data in grids based on column value constraints. DEV-891, PR-454 `Workspaces` - Make JSON an editable cell type in workspaces. A JSON editor is opened in the client when JSON values are edited. PR-494, DEV-1400. Fix issue where JSON type cells were not saved to the database when editing. PR-842, DEV-1707 `Workspaces` - Add Advanced Filter to workspaces views using a subset of the TSQL syntax. This enables complex queries being added to workspace views which are validated on both the client and api to protect from executing insecure queries. PR-457, DEV-562 Make info tooltip position dynamic for Advanced Filter. PR-851, DEV-1706 Enable locking for advanced filter. PR-852, DEV-1711 Use column captions when constructing a filter in the Advanced Filter user interface. PR-864, DEV-1623 `Workspaces` - Fix missing first character when starting to edit an editable cell with lookup selection (dropdown). PR-848, DEV-1730 `Workspaces` - Remove/Disable grid column filters for data-serie columns. PR-853, DEV-1703 `Workspaces` - Fix formatting of `false` values being displayed as empty string e.g `''` instead of `'false'` in grid columns. PR-857, DEV-1713 API 6.2.0 `Clear Cache` - Add clear cache endpoint in API (Reset IIS) and call it whenever the indexedDB is cleared from the client. PR-712, DEV-1080 `DB new logging` - PR-458 Fix event logging in app-service, should log to `prod` and not `stg` database for orders and forecasts. PR-832, DEV-1690 `Dynamic Forecasts` - Forecast cleanup, refactor `dynamic_forecast_merge_data`. Remove `forecast_runs`. PR-721, PR-740, DEV-1432 `Error messages` - Error message improvements, order constraints. PR-706, DEV-1398 `ERP Connector` - ErpCommon, ErpConnector, Ax, Jira, Nav and Sap projects added to AgrAppService. PR-264, PR-469 `Forecast` - Add `confidence_factor` for logging in the forecast table. Can be used to find forecasts that need to be re-created. PR-711, DEV-1619 `Forecast` - Add forecast batching mechanism to enable scheduling store and warehouse batches separately. Location batch table used for parallel forecast enabled for normal forecasts as well. PR-708, DEV-1555 `Forecast` - Cleanup duplication. Remove step which deletes forecast data per location. PR-726, PR-728 DEV-1538 `Forecasts` - Move the date of `Skip Forecast to Date` to the first day of the month/week in forecast calculations if the date is recorded in the middle of the period (month or week). PR-765, DEV-1627 `Forecast` - Fix `Skip Forecast to Date` not working when there is only one salepoint. PR-900, DEV-1734 `Holidays` - Fix every year calendar events not working properly in `Holidays.cs`. PR-582, DEV-1487 `Item Card` - Make sure the `image_id` property from `item_details` is returned at the `api/items/{id}` route so the image id column can be used to construct the url/address to item images in the item card. PR-755, PR-797 DEV-1448 `Item Card` - Make the recalculate button/function in the item card trigger creation of new forecast for the item. PR-751, DEV-1088 `Notifications` - Refactor notifications to be set in queue rather than posting directly to api, this fixes an issue where App-Service notifications were blocking network calls. PR-874, DEV-1677 `Reports` - Delete private reports that belong to a user when the user is deleted and assign his public reports to the system user. DEV-730 `Reports/Items` - Improve upon issue where errors were occurring when editing views in reports/items. Fix concurrency error in delete mbe-filters. PR-889, DEV-1533 `Translations` - Retrieve translations from the AGR Pool, cloud server. New translations are only retrieved if there exist any changes. PR-714, DEV-1264 Make cloud translations a togglable feature `core.settings`. PR-835 Have the translations be retrieved in a background task which is initiated when any user loads the client application. PR-863, DEV-1726 Fix duplicate key error when using SQL Truncate statement instead of Entity Framework properly. PR-876, DEV-1264 Databases 6.2.0 `Roles` - Update initial load of user roles, add roles for modules. DEV-1107 `BM` - Remove old BM from repository PR-392 `Staging 2.0` `Product Assortment` - PR-446 `Product Groups` - Add `vendor missing` and `no group` rows. Product group and primary vendor set to -1 by default. DEV-1369, PR-447 `Product Structure` - Add new product structure tables in the inventory module. PR-499, DEV-1252 `Item Order Routes` - Create standard mapping for item order routes. Default setting so that all stores order from all warehouses and all warehouses from primary vendors. PR-501, DEV-1253 `NVARCHAR` - Changes `VARCHAR` to `NVARCHAR` on staging 2.0. PR-642, DEV-1560 `ctr.execute_stg_run` - Add `group_run_list` as parameter in `ctr.execute_stg_run`. Allows a consultant to run a list of staging elements. PR-695, DEV-1349 `Raw Clarifications` - Remove `description` from `raw.stock_level`, fix `min/max` columns missing in `raw.product_assortment`. PR-690, PR-744, DEV-1601 `BOM` - Add BOM to raw and prep. PR-713, PR-743, DEV-1605 `Placeholder Views` - Proved placeholder views when stg2 is installed and not connection to NAV. PR-733, PR-735, DEV-1611 `Settings` - Add naming convention for settings in stg2. Module names added and grouping. PR-741, DEV-1575 `Data Elements` - New JSON Config for data element series. Use native JSON parsing in MSSQL. DEV-1174, PR-448 `Views` - Add ex view for multiple tables, making it easier to work with them in SQL Studio. PR-375, PR-452, DEV-1301 `DeQuery` - Add operators for relative days, weeks, months and years to work with the new Date Filter in workspaces. DEV-1323 `Refresh Date` - Update `get_target_table_refresh_date.sql`. PR-474 `New Logging` - Design of new logging strategy. DEV-1026, PR-484, PR-487 `Workspaces` - Fix lookup filter for bit values, true/false (0, 1). DEV-1325, PR-489 `Forecasts` - Dynamic forecasts, daily distributed forecasts. `dynamic_forecast_merge_data.sql` grouping values by period grouping of output series. PR-491, DEV-1303 `Orders` - Remove `order_line_status` table. PR-523, DEV-1411 `zys` - Add various admin helper functions/procedures to the zys schema. PR-581, PR-612, PR-644, PR-687 DEV-1226, DEV-1567, DEV-1301 `Helper Procedures` - Add helper procedure to create new ERP tables. Add `mbe_add_column` procedure, improve `mbe_report_add` procedure etc. PR-752, PR-760, DEV-1549 `Inventory` - Fix stock out/promo smoothing. Input values fetched from `[core].[setting]`. `Migration` - Add migration events to `initial_load`. PR-592, DEV-1382 `Order Analysis` - Create new order analysis workspace. PR-495, PR-606, PR-645, PR-693, PR-698, DEV-1347 `Demand Processing` - Add capability to create single order for all items for MBE statistics. PR-589, DEV-1274 `DB Cleanup` - Many many things. PR-577, DEV-1446, DEV-1437, DEV-1401, DEV-1409, DEV-1118, DEV-1460, DEV-1489 `Staging` - Revert lead time function. Wasn’t returning correct values. PR-610, DEV-1485 `Promo` - Add invalidation to forecasts for changed items. PR-636, DEV-1376 `System health` - Add translations for forecasts in system health. PR-611, DEV-1292 `Translations` - Add `translation_override` table to store overrides of global/base translations. PR-605, DEV-1263 `MBE` - Changing Datetime to Date columns in `mbe_item_statistics.sql`. PR-637, DEV-1502 `Connected Items` - Invalidate forecasts when new connected items arrive. PR-631, DEV-1375 `Connected Items` - Fix issue where changing one date changes dates for all items. PR-844, DEV-1708 `Inventory` - Fix missing primary vendor id in `inv.product_item` causing the data transfer to fail. PR-641, DEV-1498 `Staging` - Add default item_map settings. PR-654, `Cleanup` - Fix data type discrepancy, change datetime to date etc. PR-668, DEV-1561 `Estimated Stock` - Fix stock series not taking into account reserved quantity. PR-664, DEV-1569 `Cleanup` - Datatype overhaul, review and migrate `VARCHAR` to `NVARCHAR`. PR-674, DEV-1566 `Bridge Stockout` - Rewrite `inv.histories_bridge_stockouts` with new logic and add `days_back_to_search_for_sale` parameter back to logic. Settings moved from `prod` to `stg`. PR-700, DEV-1586 `Workspaces` - Clean up view JSON, empty objects and arrays saved to the view JSON in the database. Remove deprecated properties in initial load. PR-697, PR-707, DEV-1607 `Order logic` - Order logic fortification. Make the input to `demand_processing_calc_run` stricter to prevent errors in the output. PR-702, DEV-1615 `System health` - Refactor system health to accommodate custom checks and better messages in the system health dashboard widget. PR-722, DEV-1579 `Item Card` - Always show stock history in chart even though there are no sales in the history for the period. PR-727, DEV-1585 `Lost Sale` - Split lost sale into 2 settings. `lost_sale_warehouse` and `lost_sale_stores`. PR-717, DEV-1507 `Orders` - Fix issue with user access and inactive items. If `item no` is 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-716, DEV-1455 `core.stg_group_element` - Add active column to `core.stg_group_element` so element can be disabled to disable `element inv_run_demand`. PR-746, DEV-1556 `Settings` - Change `group_id` column to `group_key` in the settings table. Change `setting_group_name` to `group_name` and `event_origin` to `origin_name`. PR-742, DEV-1620 `Item Card/Chart Data` - Remove invalid column name `origin` which was causing the API to throw a 500 server error when calling procedure `update_chart_data`. PR-757, DEV-1643 `Update/Migration` - Data element series SQL migration. Mapping and data changes that have to be taken bare of for a successful update to 6.2. PR-756, PR-891, DEV-1148 `Tasks` - Add a Staging run for monthly or weekly forecasts and add a task for it (Scheduler). Daily and forecast tasks. PR-749, DEV-1634 `Reports` - Add new standard reports to the Inventory setup. Based on scripts from Thorunn, Elva and Palmi. New standard reports, new standard report views, new standard report columns, procedures and more. PR-723, PR-768, PR-778, PR-836, PR-850, PR-866, DEV-1537 `Reports/Orders` - Modify standard reports initial load and order analysis initial load so the procedures can be run later by consultants and are run with the upgrade procedure. PR-810 DEV-1670, DEV-1671 `Staging, Custom Objects` - Make sure the core stg engine replaces tables, views, procedures etc. with elements from the `cus` schema. Example: if a customized `raw_stg.product_info` view is created it should be used automatically instead of `raw.product_info`. PR-767, DEV-1648 `Initial Load` - Remove/fix deprecated properties in initial load. PR-697, DEV-1607 `Staging 1` - Various fixes for Staging 1 to make sure it works after updating to version 6.2 PR-775, DEV-1665 `Staging` - Return element captions column from the `stg_run_get_element_list` for translations. Added stg element name to list. PR-779, DEV-1658 `Staging` - Fix app-service server side elements logging. Element names instead id's, logging in staging and prod. PR-834, DEV-1658 `Settings` - Rename demand days settings for consistency in the app. Fix discrepancy in `Constants.cs` vs `setting.name` in the database. PR-811, DEV-1486 `Logging & Migration` - Attempt to upgrade procedures that are supposed to be customized and see if we can replace the part in the procedures that handles logging to utilize the new logging mechanism. The procedures are; `post_order_run`, `scheduled_order_post`, `scheduled_orders_post_order_run_custom`, `mbe_item_custom_populate`. PR-816, PR-818, DEV-1669 `Staging` - Lock schemas on Staging that don't start (aren't prefixed) with `erp` or end with `cus`. Added `tr_ddl_core_schema_locking` trigger which notifies if you are not allowed to change objects. e.g "Check the `core.schema_locking` table for setup of schema locking and consult the customization section in the technical manual for further instructions." PR-802, DEV-1652 `Update Script` - Make sure old `error_log` and `action_execution` tables are backed up. PR-826, DEV-1676 `Staging` - Update `initial_load_stg_core.sql` so that names of both `@agr_prod_db` and `@agr_stg_db` are retrieved from `ctr.data_transfer_settings`. PR-828 `Planned Orders` - Fix error where planned orders weren't being created. PR-837, DEV-1651 Orders - Fix reserved missing from unitqtycalc and unitqtyresult in [dbo].[orderprocessinginitialize]. Reserved was only affecting stockagg and not unitqty calculations. PR-837, DEV-1685 `Item Card` - Fix missing order quantity column series in item card graph. PR-843, DEV-1728 `Staging` - Add group relation element `core_product_group_relation_stg_to_prod` to `core.stg_element`. Missing when executing `core.stg_run_tree`. PR-868, DEV-1739 `Staging` - Add a flag in `stg_elements` that enables the engine to add columns in the target merge table if it is missing. PR-875, DEV-1654 `Staging` - Allow null values in `nav.items` on staging. Fix stg element framework handling of numeric vs decimal data types properly. PR-875, DEV-1747 `System Health` - Fix error where the system health says everything is fine while the Scheduler reports an error. PR-882, DEV-1752 `Dashboard` - Fix null value where clause in `fn_mbe_where_clause_flat` for deleted = 1 columns. Fix `core.schema_locking` data in `initial_load` procedures. Delete `core.stg_run_tree`. PR-887, DEV-1705 `Staging` - Fix issue where staging framework is trying to execute server side elements. When running runs or single elements manually it will attempt to run server side elements. PR-895, DEV-1761 `Staging` - Standard flow through staging for `item_extra_info` and more misc fixes. PR-906, DEV-1653, DEV-1761, DEV-1775, DEV-1783 `Staging` - Fix bridge stockout missing from daily run. PR-907, DEV-1758
6.1-r25	release/6.1.x	2021-11-26T11:55:09Z	6.1.24	6.1.17	6.1.19	5 / 9	6.1-r25.zip 6.1-r25.zip
6.1-r25 What's new? `Forecast` - When the product is seasonal and with many zeros override the expert selection with the salt forecast model DEV-2945, PR-2366 `Forecast` - Include trend column in forecasts table for more detailed breakdown column DEV-2969, PR-2366 `Forecast` - Model description logged in the forecast table DEV-3018, PR-2366 `Forecast` - If skip forecast to date is set then the "removing leading zeros" functionality will be ignored, i.e. zero sales in the beginning of sale history are included in forecast calculations DEV-2360, PR-2366 `Workspaces` - Adding config options for links within workspaces to be able to open a linked view in another tab and apply conditions for what lines should display links. This change also adds the ability to link between workspaces. DEV-3063, DEV-3062, PR-2424 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 customizations 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.1.24 `Reports/Items` - Fix issues with not being able to remove columns from reports when two columns have the same name but different id's DEV-3031 , PR-2342 `Orders` - Fix paste into orders from excel DEV-2680, PR-2374 `Orders` - Fix: Orders views are "unsaved" after adding a column to orderviewcolumns + sidebar DEV-2951, PR-2410 `Workspaces` - Adding config options for links within workspaces to be able to open a linked view in another tab and apply conditions for what lines should display links. This change also adds the ability to link between workspaces. DEV-3063, DEV-3062, PR-2424 API 6.1.17 `Forecast` - When the product is seasonal and with many zeros override the expert selection with the salt forecast model DEV-2945, PR-2258 `Forecast` - Include trend column in forecasts table for more detailed breakdown column DEV-2969, PR-2258 `Forecast` - Model description logged in the forecast table DEV-3018, PR-2258 `Forecast` - If skip forecast to date is set then the "removing leading zeros" functionality is ignored DEV-2360, PR-2258 db 6.1.19 `Dynamic Forecasts` - fixing dynamic forecast timeout bug + initialize dynamic forc with trend + model description. Also fixing item group histories sale not merging correctly in dynamic forecast run group DEV-2706, PR-2390
6.1-r24	release/6.1.x	2021-10-28T08:57:43Z	6.1.23	6.1.16	6.1.18	0 / 7	6.1-r24.zip 6.1-r24.zip
6.1-r24 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 customizations 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.1.23 `Orders` - Fix paste from windows excel into order grid always clearing the cell after last pasted cell DEV-2680 , PR-2113 `Login` - Fix: login redirecting directly to dashboard even though the user doesn't have access to it resulting in ugly error DEV-2723, PR-2146 `Workspaces` - Fix: Move to next cell after TAB in insert action DEV-2413, PR-2151 `Grids` - Fix the sorting when columns are grouped and the user tries to sort on multiple columns. DEV-2987, PR-2259 `Workspaces` - Increase the queried range of period filter options to -100, +100 years. This is an extreme upper/lower range limit, the actual limit is determined by the available values in the database date table. PR-2299, DEV-2316 `Error Message` - Change error message pages and removing the cat references PR-2290, DEV-2381 db 6.1.18 `MBE` - fix: The standard MBE fields MAPE and MAPE CATEGORY retain outdated values DEV-2800, PR-2166
6.1-r23	release/6.1.x	2021-09-29T10:15:30Z	6.1.22	6.1.16	6.1.17	0 / 7	6.1-r23.zip 6.1-r23.zip
6.1-r23 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 customizations 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.1.22 `Item Card` - Prevent unnecessary refresh of Item Card. DEV-2703, PR-2051 `Workspaces` - Enable the save view button (detect changes) when locking or unlocking filters. DEV-2528, PR-2050 `Reports` - fix: Reports grouping by field with date field ungrouped causes error sometimes DEV-2606 , PR-2077 DEV-2606 - Reports grouping by field with date field ungrouped causes error sometimes #2077 `Grids / Reports` - Fix the formatting of grouped date columns. The sorting of grouped columns (which this issue is part of) had already been fixed with PR-2077 but the formatting of grouped date columns required a slight fix. DEV-2400, PR-2092 `Item Card` - Remove the series data description on the tooltip in the Item Card chart. This description would only appear in the tooltip if it existed and there was only a single series (point) in the tooltip (on the x axis). DEV-2651, PR-2055 API 6.1.16 `Forecasts` - Make sure we delete forecasts when there is no sale history DEV-2717, PR-2087, PR-1884 db 6.1.17 `Orders` - fix: [dbo].[orderruncheck_forecasts] not using values from settings DEV-2700, PR-1829, PR-1884
6.1-r22	lts/6.1	2021-09-23T11:14:12Z	6.1.21	6.1.15	6.1.16	1 / 11	6.1-r22.zip 6.1-r22.zip
6.1-r22 What's new? `Workspaces / Item Card` - Include the Order Qty (Order Selected) series in the item card when viewing the Item Card from within a workspace view that contains both an `item_id` column and an `order_id` column. DEV-2677, PR-1991 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 customizations 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.1.20 `Grids` - fixing group aggregation for date columns DEV-2400, PR-1829, PR-1884 `Orders` - fix: When paste-ing multiple values from excel into the order grid so that some of the values overlap a grouped (and therefore unmediatable cell) an endless loop trying to update values is reached. DEV-2638, PR-1920 `Item Card` - Add loading indicator to chart while it is loading, so users don't misunderstand which Item is visible in the chart when going between items. DEV-2411, PR-1939 `Item Card` - Fix load delay when selecting an item to load in the Item Card. Debounce timer now resolves immediately and queues consecutive requests until no new item has been selected for 400ms. DEV-2645, PR-1942 `Orders` - Fix: Confirmed, edited order lines stay in the order view DEV-2641, PR-1923 `Orders` - Fix: Values in the Confirm Orders dialog are out dated DEV-2640, PR-1975 `Workspaces / Item Card` - Include the Order Qty (Order Selected) series in the item card when viewing the Item Card from within a workspace view that contains both an `item_id` column and an `order_id` column. DEV-2677, PR-1991 `Item Card` - Make sure data in data series that are marked as `aggregated_over_period = true` are displayed in the grid when viewing data on the montly or weekly level (aggregated levels). With this change, rows are included that might not fit on the otherwise aggregated dates, i.e. Monthly used to show only rows on the 1st of every month and weekly the 1st of every week. The most common side effect to this is that a row for Today is always visible and thus we (@eyyrun) decided to highlight this row, this is a similar effect to the forecast period background in the chart. DEV-2601, DEV-2679, PR-1986 `Item Card` - Make sure a correct value for the stock history series is displayed for every interval when viewing the Item Card Grid. This is especially helpful when viewing the grid on a weekly or monthly level. DEV-1048, DEV-1207, PR-2000 `Orders` - Fix UI in Create Orders Modal so that the schedule dropdown can accomodate longer schedule names. DEV-2711, PR-2039 `Workspaces` - Fix issue when copying and pasting empty lines. The paste mechanism would ignore empty lines so that the paste result would potentially end up on the wrong line. DEV-2681, PR-2036
6.1-r21	lts/6.1	2021-08-12T21:37:19Z	6.1.20	6.1.15	6.1.16	0 / 7	6.1-r21.zip 6.1-r21.zip
6.1-r21 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.1.20 `Workspaces` - Use week and month captions from database in workspace period filters. DEV-2186, PR-1384 `Grids` - Update data grids style (orders, reports) so that a shadowed/gray line is shown one every other row in child-rows when data is grouped. This is common in the order grid (grouped by order id). Grouped rows (aggregated row) is empasized for numbers and text in child rows is slightly indented. The column header text was slightly emphasized with bold and darker color. DEV-2363, PR-1778 `Orders` - Fix paste into non-numeric cells in order grid DEV-2523, PR-1822 API 6.1.15 `Forecasts` - fix: Daydistribution not working for Easter and Christmas weeks [DEV-2431]https://agrinventory.atlassian.net/browse/DEV-2431), PR-1774 Databases 6.1.16 `Workspaces` - fix: reftableid can't be more than 5 characters. DEV-2368, PR-1675 `Demand from Stores` - fix: Lead time = 0 can mess up the demand calculations DEV-2418, PR-1722 `Upgrades` - fix: Problems with upgrades if database compatibility is wrong DEV-2427, PR-1715
6.1-r20	lts/6.1	2021-05-21T11:32:01Z	6.1.19	6.1.14	6.1.15	0 / 2	6.1-r20.zip 6.1-r20.zip
6.1-r20 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.1.19 `Workspaces` - fix: Workspace column config for fixed options not working. DEV-2186, PR-1544 API 6.1.14 `Custom Actions` - Column requiredrole in table customactions should only allow users having that particular role to see and execute the custom action. This was ignored and is now validated. DEV-2350, PR-1646
6.1-r19	lts/6.1	2021-04-07T10:31:12Z	6.1.18	6.1.13	6.1.15	0 / 10	6.1-r19.zip 6.1-r19.zip
6.1-r19 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.1.18 `Workspaces` - Workspace lookup fields - add support for fixed options. DEV-2186, PR-1384 `Orders` - Order grid update slow when order has thousands of lines DEV-2215, PR-1422 `Orders` - Update order info sidebar aggregated columns when order is edited DEV-2206, PR-1428 `Workspaces` - Fix unnecessary reloads og grid data in workspaces for every drilldown that is populated. This fix makes sure to only load grid once after all drilldowns have been populated. DEV-2217, PR-1424 `Workspaces` - send correct workspace action when editing aggregation. DEV-2182, PR-1430 `Orders` - Doesn't work to paste into ordergrid DEV-2224, PR-135 API 6.1.13 `Forecasts` Fix forecast error handling and solving weekly forecast issues when there is not one week of sale available. DEV-1832, PR-1398 Databases 6.1.15 `Constrainer` - fix errors with constraining by days DEV-2176, PR-1374 `Orders` - Planned Orders should use order frequency based on scheduled order settings DEV-2180, PR-1393 `Audit` - PAdding deworkspaces and deworkspace_views to audit if audit exists DEV-2229, PR-1444
6.1-r18	lts/6.1	2021-03-08T10:25:16Z	6.1.17	6.1.12	6.1.14	0 / 4	6.1-r18.zip 6.1-r18.zip
6.1-r18 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.1.17 `Orders` - Multipe Order Grid issues. Row group aggregate values must update after edit, If column is sorted, the row order should not change after edit, After Qty cell edit, if TAB pressed, should not capture the old value in Purchase Units and Orders grid should support custom editable columns.fix sorting after edit DEV-2150, PR-1323, PR-1335 `Workspaces` - Remove the overwriting of view filters by workspace/user/ad-hoc filters. Since the first release of AGR v6 the workspace filters would overwrite the same filter if it existed as a view filter. This was done so that admins could easily test new filter setups in a view without changing the view itself and it would also enable browsing between views where you'd be sure that the workspace filter setup would trump the view setup. With these changes both the workspace- and view filters are used to filter the grid results which means only the intersection of the filters are resolved. This is a more logical result and prevents users from gaining access to data in views that would otherwise be unreachable because of locked view-filters. DEV-2156, PR-1324 `Workspaces` - Fix issue where cell focus was moved or lost after editing dataseries cells in series workspace views. This bug was introduced when fixing a related issue when editing checkbox values in serie grids. DEV-2154, PR-1319 Databases 6.1.14 `Workspaces` - Value update failing if lookup filter has too many values (too long) DEV-2157, PR-1318
6.1-r17	lts/6.1	2021-02-23T14:39:01Z	6.1.16	6.1.12	6.1.13	0 / 12	6.1-r17.zip 6.1-r17.zip
6.1-r17 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.1.16 `Executions/Notifications` - Fix issue where server/client signalR connection is lost. With this update a reconnection attempt should trigger periodically if connection is lost and it should be indicated in the notification list. DEV-2141, PR-1285 `Item Card` - Set the min and max values for the x-axis in the Item Card chart so that the x axis doesn't change when series are hidden. With this change the x-axis values in the chart should always reflect the period range (history/forecast) values selected. DEV-2123, PR-1270 `Orders` - fix: Update all totals when order line is updated DEV-2096, PR-1229 `Orders` - Fix error when using orders constrainer that caused locked order lines to never unlock. The update presents error messages lines are already locked and checks whether a constraint was actually started, if not id refrains from locking the order lines. DEV-2142, PR-1291 `Reports` - Fix error where report could not be saved because of an error in the Advanced Filter. Handle the error gracefully in the client. DEV-2107, PR-1273 `Workspaces` - fix: Query filters don't work for dataseries update if data series are included in a view DEV-1463, PR-1179 `Workspaces` - Clear cache after saving default config DEV-1891, PR-1195 `Workspaces` - Fix issue where grid and cell focus was lost after updating the checkbox value of an editable checkbox-cell in the workspace view. This made it impossible to navigate and update the grid using the keyboard (space and arrow keys). DEV-2065, PR-1260 API 6.1.12 `User Management` - Clear encrypted password from API response DEV-1874, PR-1252 Databases 6.1.13 `Item Card` - Loading vdailydemand into table variable to improve performance DEV-2047, PR-1179 `Orders` - Fix order line breakdown to properly reflect lost sale now that it's not a true/false anymore but a percentage DEV-2076, PR-1207 `Orders` - fix: Using access group restrictions made orders disappear if some items were closed while the order is still in process DEV-2104, PR-1240
6.1-r16	lts/6.1	2021-01-28T13:50:02Z	6.1.15	6.1.11	6.1.12	0 / 8	6.1-r16.zip 6.1-r16.zip
6.1-r16 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.1.15 `Grids` - fix: Distinct aggregation with grouping broke the grid when date fields were included in the grid DEV-1839, PR-1128 `Workspaces` -fix: the edit-ability of the column in a total row when there is conditional editing on the column. For example with this column configuration on the weight column in a view with item no and weight present DEV-1577, PR-1139 `Workspaces` - Fix "selectedObj" attributes sent in workspace commands DEV-1911, PR-1148 `Workspaces` - Add a loading indicator to workspace lookup cell-editor. DEV-2061, PR-1152 `Workspaces` - Cache the lookup values query result when opening the workspace lookup cell-editor so that future requests are resolved immediately. DEV-2060, PR-1152 `Workspaces` - Make workspace lookup cell-editor display lookup options a lot quicker by only rendering a portion of items in the DOM. This is done by enabling the virtual scroll for the ngSelect component. DEV-2067, PR-1171 `Workspace` - Make workspace lookup cell-editor display lookup options a lot quicker by only rendering a portion of items in the DOM. This is done by enabling the virtual scroll for the ngSelect component. DEV-2067, PR-1171 Databases 6.1.12 `Forecast` - fixing problems with when orders need to check forecast and there are need of forecast then it can happened to go to timeout -but still with status=1 in forecast runs table. DEV-2041, PR-1146
6.1-r15	lts/6.1	2021-01-14T12:00:54Z	6.1.14	6.1.11	6.1.11	0 / 8	6.1-r15.zip 6.1-r15.zip
6.1-r15 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.1.14 `Item Card` - Fix issue where the forecast series in the Item Card chart was not displayed correctly when the start of week is not Monday (i.e aggregated to another day in `chart_item_select`). After these changes the forecast should be correctly placed and the helper/grid lines (tickInterval) in the chart are also moved to align with the newly added `item_card_start_week` setting. DEV-1960, PR-1063 `Item Card` - Make the week indication label on the x-axis optional in the Item Card chart. By setting the newly added `item_card_hide_week_number` setting to `true` the chart label will dislpay e.g. `7. Dec'20` instead of `w50 - Dec'20`. DEV-1960 PR-1063 `Orders` - Making sure the grid isn't resorted automatically after cell edit. DEV-1909, PR-1081 `Workspaces` - Filter drilldown be present viewfilter of same column DEV-575, PR-1098 `Workspaces` -the ability to have the select options in workspace action modals specified as a dynamic query. Also adds possibility to have modal selects multi-select. DEV-1954, PR-1084 API 6.1.11 `Schedules` - Remove deprecated purchase plans from schedules delete warning. DEV-1937, PR-1106 Databases 6.1.11 `Item Card / Settings` - Add the `item_card_hide_week_number` property to the `dbo.settings` table to hide/show the week label when the Item Card chart is viewed on the weekly level. DEV-1960 PR-1063 `Split by Constraint` - Fix fillup in split by constraint DEV-1991 PR-1108
6.1-r14	lts/6.1	2020-12-18T12:19:44Z	6.1.13	6.1.10	6.1.10	0 / 6	6.1-r14.zip 6.1-r14.zip
6.1-r14 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.1.13 `Item Card` - Fix issue where grid was not displaying series data on the week level, when the start of week is not Monday (i.e aggregated to another day in `chart_item_select`). The `item_card_start_week` property was added to `dbo.settings` so the start of week can be changed. DEV-1948, PR-1048 `Format` - Fix how durations are processed and formatted in the app. These changes enable us to use both `Date` objects and rounded/integer `number` values in milliseconds to store durations and display in the app. DEV-1858, PR-1047 `Workspaces` - Fix transfer view drilldowns DEV-1840, PR-1039 `Workspaces` - Add the ability to configure a datetimepicker in workspace action dialogs DEV-1928, PR-1040 API 6.1.10 `Workspaces` - Fix: It should be possible to choose users to share workspace-view without having user management role. DEV-1869, PR-1038 Databases 6.1.10 `Item Card / Settings` - Add the `item_card_start_week` property to the `dbo.settings` table to control which day of the week series are aggregated to when looking at the Item Card Grid in weekly view. DEV-1948, PR-1048
6.1-r13	lts/6.1	2020-12-14T10:53:11Z	6.1.12	6.1.9	6.1.9	0 / 2	6.1-r13.zip 6.1-r13.zip
6.1-r13 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 API 6.1.9 `Forecast` - DB call in static constructor randomly throws error causing the daily job to stop PR-1025, DEV-1883 Databases 6.1.9 `Orders` - Lost sale negative stock fix - Negative stock causes false "expired" numbers and wrong order qty PR-1020, DEV-1905
6.1-r12	lts/6.1	2020-12-09T09:16:42Z	6.1.12	6.1.8	6.1.8	0 / 10	6.1-r12.zip 6.1-r12.zip
6.1-r12 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.1.12 `Dashboard` - Fix/show colors depending on target / lower level PR-946, DEV-1621 `Grids` - Show better colors in ag-grid PR-976, DEV-1568 `General` - Remove New Update Available message from login and about PR-1010, DEV-1845 `General` Remove toaster error message when agr pool can't be reached PR-1007, DEV-1831 `Item Card` Prevent docked Item Card from updating on broadcast event PR-1008, DEV-1776 Databases 6.1.8 `Orders` - Fix/Order logic setting discrepancy in demand processing PR-929, DEV-1811 `Orders` - Fix/new fill up type for constrainer added to db migration PR-941, DEV-1787 `Orders` - Improved forecast obsolete check in order calculations PR-981, DEV-952 `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-966, DEV-1793 `Inventory` - Fix: When using undelivered all today setting days cover is always wrong PR-999, DEV-1887
6.1-r11	lts/6.1	2020-11-09T21:17:38Z	6.1.11	6.1.8	6.1.7	0 / 6	6.1-r11.zip 6.1-r11.zip
6.1-r11 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 See list on Jira See list of pull requests involved in this update on GitHub See code changes on GitHub compare Client 6.1.11 `Roles` - Fix new roles not saving features immediately. It is now possible to start editing roles immediately after creation. PR-878, DEV-1749 `Navigation` - Fix issue where icons with no captions were not appearing in navigation menus and submenus. PR-886, DEV-1709 API 6.1.8 `Reports/Items` - Improve upon issue where errors were occurring when editing views in reports/items. Fix concurrency error in delete mbe-filters. PR-841, DEV-1533 `Forecast` - Fix `Skip Forecast to Date` not working when there is only one salepoint. PR-902, DEV-1734 Databases 6.1.7 `Orders` - Fix reserved missing from `unit_qty_calc` and `unit_qty_result` in `[dbo].[order_processing_initialize]`. Reserved was only affecting `stock_agg` and not `unit_qty` calculations. PR-867, DEV-1685 Installer `Forecasts` Use polling forecast setting instead of service broker in the installer DEV-1800
6.1-r10	master	2020-10-09T12:32:47Z	6.1.10	6.1.7	6.1.6	4 / 21	6.1-r10.zip 6.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 See list on Jira See list of pull requests involved in this update on GitHub See code changes on GitHub compare 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
6.1-r9	master	2020-09-14T13:40:09Z	6.1.9	6.1.6	6.1.5	1 / 9	6.1-r9.zip 6.1-r9.zip
6.1-r9 What's new? Version info added to the login page as well as an indication if a patch updated exists for the current version. Database Update Scripts Check out the update reports for updating and patches 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.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 See list on Jira See list of pull requests involved in this update on GitHub See code changes on GitHub compare Client 6.1.9 `Datepicker` - Fix wrong day labels for dates in datepicker. DEV-1540 `Navigation` - Fix missing dropdown menu items. DEV-1572 `Version Info` - Add correct version info to the login page like in the about modal. Also add a notification if a new version exists according to version data at https://pool.agrdynamics.com/api/versions. DEV-1503 `Reports` - Fix create orders from item selection causing API errors. Fixed by limiting the selection amount and redirecting the request to the report ID when all items are selected. DEV-1536 API 6.1.6 `Forecast` - Fix slow parallel forecast. The async functionality for writing the forecast to the database was removed to improve the deadlock situation that was arising. DEV-1558 `Reports` - Prevent errors from occurring when updating items/reports quickly (adding columns). DEV-1533 Databases 6.1.5 `mbe_item_statistics_populate` - Fix reference to non existing setting. Turns out the settings (`demand_for_dc` and `demand_for_dc_days`) were renamed in 2018 in the demand process procedure but it was never updated accordingly in `mbe_item_statistics_populate`. - Consultants already had a fix for this SO-834, DEV-1557 `Items` - Remove old version of `mbe_report_remove` causing `[dbo].[items_temp_report_create]` to fail and the items feature not to work in the app. DEV-1464 `estimated stock` - Add reserved stock to stock estimation, chart data. DEV-1569
6.1-r8	master	2020-08-28T11:54:53Z	6.1.8	6.1.5	6.1.4	0 / 1	6.1-r8.zip 6.1-r8.zip
6.1-r8 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.1.8 `Items` - Remove edit and save buttons from the Items feature that were accidentally introduced in the last patch release. DEV-1530
6.1-r7	master	2020-08-20T16:38:28Z	6.1.7	6.1.5	6.1.4	0 / 13	6.1-r7.zip 6.1-r7.zip
6.1-r7 Known Issues/Bugs Unaddressed issues in JIRA `Items` - Edit and Save button accidentally introduced in the Items feature. DEV-1530. The issue was introduced when fixing DEV-1435 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.1.7 `Item Card` - Remove min/max stock input value logic that would make sure min stock couldn't exceed max and vice versa. DEV-1482 `Item Card` - Fix forever spinning animation on recalculate chart data button if recalculation fails/throws errors. DEV-1480 `Orders` - Fix bug when inserting a value into purchase units for one line then the quantity was updated in the line but not for the aggregation for the order. DEV-1473 `Orders` - Fix Selected view in orders resets after focus filter is cleared. Local storage was accidentally being reset. DEV-1477 `Orders` - Fix checkboxes in orders grid disappearing when switching between the "In Process" and "Confirmed" tabs. DEV-1478 `Reports` - Fix lookup filter (list filter) broken (hard to operate) when null or empty string values exist in the column data. DEV-1488 `Navigation` - Add modules to initial load navigation. DEV-1450 `Navigation` - Fix any runtime errors in navigation caused by incorrect/incomplete App Nav JSON. Fixed by initializing a class and taking responsibility for values in the client. DEV-1435 Api 6.1.5 `Forecast` - Fix Calendar events (Holidays) not working for every year. DEV-1487 `Forecast` - Fix weekly forecast bug. Doesn't give forecast for last 30 days even though it has a sale within the period. DEV-1496 Databases 6.1.4 `Update scripts` - New install and update scripts. PR-590 `Orders` - Fix error when recalculating planned orders where items have different schedule (if schedules for items didn't match you could end up with blank lines when recalculating). DEV-1494 `Scheduled Orders` - Fix error in scheduled orders when the order frequency of the item does not match the scheduled order frequency. DEV-1489
6.1-r6	master	2020-07-21T15:33:34Z	6.1.6	6.1.4	6.1.3	0 / 4	6.1-r6.zip 6.1-r6.zip
6.1-r6 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.1.6 `Workspaces` - Fix cell focused not moved after editing cells in column only workspaces, issue introduced when fixing DEV-1394. DEV-1466 `Workspaces` - Fix datepicker (cell editing in date column) not working after update to 6.1-r5, issue introduced when fixing DEV-1379. DEV-1467 `Workspaces` - Cancel ongoing grid query if changes are made to view settings to avoid unpredictable behaviour in grid. DEV-1441 Databases 6.1.3 `Orders` - Fixed Lost Sale percentage missing in some cases in demand calculations in `[dbo].[demand_processing_calc_run]`. DEV-1401
6.1-r5	master	2020-06-24T14:26:20Z	6.1.5	6.1.4	6.1.2	3 / 17	6.1-r5.zip 6.1-r5.zip
6.1-r5 What's new? Add support for togglable submenu dropdown within the modular navigation dropdown. Show correct app bundle version information in the about modal by querying the AGR Pool Api at pool.agrdynamics.com/api/versions/ Automatic deployment that triggers on any changes to the documentation manuals. The documentation is also deployed to a new server at: docs.agrdynamics.com Known Issues/Bugs Unaddressed issues in JIRA `workspaces` - Datepicker not working DEV-1467. Introduced with DEV-1379, enable usage of `,` instead of `.` for fractions when editing numbers. 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.1.5 `Login` - Fix extra refresh required when opening the site again the day afer login. Token expired DEV-1395 `Workspaces` - Fix issue where `null` value in filter turns to `0` when it shouldn't. DEV-1387 `Workspaces` - Fix issue when editing cells with the keyboard. Cell focused lost when edit stops/finishes. DEV-1394 `Workspaces` - Fix sorting of total rows in serie workspaces containing client side series. DEV-1360 `Workspaces` - Don't trigger/send update action when checkbox is clicked while doing a row insert. Do not show checkbox as editable (consistency with non-inserted rows). DEV-1326 `Format` - Validate date in format service to prevent grid grouping crash (Invalid Date error). DEV-1405 `Version Info` - Add correct app bundle version information to about modal by querying from AGR Pool (pool.agrdynamics.com/api/versions/). DEV-1427 `User Management` - Add warning message when trying to change current users passwords from user management feature. Not possible in API, use `My Profile` instead. DEV-1364 `Item Card` - Show primary route as default selected information in Details tab. DEV-1388 `Workspaces` - Enable usage of `,` instead of `.` for fractions when editing numbers. DEV-1379 `Workspaces` - Fix values in series showing at incorrect time after update. Solved by forcing a refresh if update data has less columns that the grid expects which was causing them to display in incorrect time/column in grid. DEV-1210 `Navigation` - Remove unimplemented `scheduler` from navigation `initial_load` and replace with `schedules`. DEV-1444 `Documentation` - Update URL paths to documentation manuals, now at docs.agrdynamics.com. DEV-1445 `Navigation` - Fix client console error caused by incorrect usage of PIPE. PR-488 `Navigation` - Add togglable submenu to modular dropdown navigation. DEV-1392 `Item Card` - Fix endless loading dots for item image when no url is constructed but a url was expected. DEV-1449 API 6.1.4 `Reports` - Extend debounce time in client and catch exception in API which overwrites temp report directly to avoid error message in client when updating report to quickly (adding columns fast). DEV-1429
6.1-r4	master	2020-05-28T14:24:35Z	6.1.4	6.1.3	6.1.2	1 / 2	6.1-r4.zip 6.1-r4.zip
6.1-r4 What's new? Ability to transfer to specified view based on action results in Workspaces. 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.1.4 `Workspaces` - Add ability to transfer to a different workspace view based on action result. So when an action result returns the key: `"transferView": "VIEWNAME"`, the user will be transferred to a view named `VIEWNAME`. PR-444, PR-460 API 6.1.3 `Forecast` - Fix: Polling not working for forecast. DEV-1396
6.1-r3	master	2020-05-06T10:55:23Z	6.1.3	6.1.2	6.1.2	0 / 9	6.1-r3.zip 6.1-r3.zip
6.1-r3 Database Update Scripts Prod - Patches `dbo.de_qb_sql_where_filter_clause` - Updated (DEV-1343) `dbo.json_toJson` - Updated (DEV-1343) `dbo.fn_de_client_calc_series_dependency` - Added (DEV-1315) `dbo.de_query_availability` - Updated (DEV-1315) `dbo.de_update_column` - Updated (DEV-1321) `dbo.version_db` - Update version number Stg - Patches `ctr.settings` - Update prod database version compatability 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.1.3 `Workspaces` - Fix period filter resetting to min max value when saved valued not matched caused by client timezone issue with the Javascript Date Object. DEV-1327 `Workspaces` - Show proper caption of data series in Excel export. DEV-1330 `Orders` - Add the ability to search for constraints in split by constraints. DEV-1322 `Workspaces` - Fix error when updating string values in grid which were also valid numbers (zero padded ID numbers). DEV-1346 `Workspaces` - Enable and use date picker when inserting row with date column in grid. Wasn't working unless the column was also editable afterwards. DEV-1339 `Workspaces` - Fix issue causing dates to jump back one day when selecting from datepicker. Caused by improper handling of client timezone with the Javascript Date Object. DEV-1313 Databases 6.1.2 `Workspaces` - Procedure `fn_de_client_calc_series_dependency` now used for calculated series, fixes issue when calculated series depends on another calculated series. DEV-1315 `Workspaces` - Fix issue with long filter value, problem found when pasting long lists into lookup filter. DEV-1321 `JSON` - Fix JSON parsing error when `"`-quotation characters not escaped in strings. DEV-1343
6.1-r2	master	2020-04-20T15:53:43Z	6.1.2	6.1.2	6.1.1	0 / 6	6.1-r2.zip 6.1-r2.zip
6.1-r2 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.1.2 `Workspaces` - Display total serie items like total rows in grid status bar. DEV-1277 `Dashboard` - Fix error causing no values to show in chart because of extra apostrophe (`'`) wrapping around the data. DEV-1307, SO-1056 `Workspaces` - Fix issues with checkboxes in total rows. DEV-1281 Only be shown when aggregation is set. Be readonly unless config.aggregation.editable is true Should update other (non-totalrow) checkboxes when clicked `Workspaces` - Fix timezone issue in the new datepicker for editable date column in workspaces causing the date to jump back one day upon edit. DEV-1313, SO-1070 API 6.1.2 `Forecast` - Check if forecast is needed. DEV-1304 `API` - Fix memory leak, out of memory error in SpWrapper. DEV-1290
6.1-r1	master	2020-03-27T11:12:12Z	6.1.1	6.1.1	6.1.1	2 / 25	6.1-r1.zip 6.1-r1.zip
6.1-r1 What's new? It is now possible to define a max number of fraction digits for `number`, `percent`, and `percentage` columns. e.g. `number:2` still behaves the same way printing exactly 2 fraction digits. `number:2:4` will print min 2 and max 4 fraction digits: `12.4` => `12.40`, `12.435` => `12.435`, `12.43585` => `12.4359`. System setting: `fraction digits for numbers` and `fraction digits for percentages` has been changed to only affect the MAX number of digits printed, e.g. when the column format is `number`, `percent` or `percentage` Database Update Scripts Prod - Patches `dbo.de_update_batch_series` - Updated version of this procedure `dbo.order_run_populate_orders_and_lines` - Fixing `@scheduled_order_id` hardcoded as 1 issue `dbo.settings` - Updated caption and description for formatnumberdigits and formatpercentagedigits settings `dbo.version_db` - Update version number Stg - Patches `ctr.settings` - Update prod database version compatability 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.1.1 `Navigation` - Fix missing homepage. PR-225 `Item-Card` - Fix runtime error in `Item-Card-Grid` if `chart-data` doesn't belong to any series. PR-247 `CSS` - Fix potential future bug discovered in `6.2` where any `slowAppear` animated object would never show (missing grid, missing login screen). PR-254 `Order` - Fix, clear order id filter on order confirm. DEV-1195 `Workspaces` - Refactor `WorkspaceGridEditSerieService`. Checkbox serie refresh. Check dependent series. PR-261, DEV-253, DEV-1160 `Workspaces` - Fixes to client side series. PR-273 `Excel/csv export` - Fix date and datetime exported values in `reports` and `orders` grid. DEV-1188 `Grids` - Fix clipboard export of dates in grids (reports and orders). DEV-1188 `Dashboard` - Sort data by date for the `dashboard` chart. PR-284, SO-1028 `Navigation` - Implement icon functionality in navbar, add custom icon. PR-298 `Workspaces` - Add `ItemCard` to `workspace-views` with `item_id` or `item_sku_id` columns. DEV-1219 `Grid/CSS` - Enlarge font size in all grids from 12 to 14px and add vertical column lines for sake of readability. PR-301, DEV-1151 `Orders` - Fix issue where orders could be edited/deleted when `confirmed`. DEV-1206 `Workspaces` - Refactor lookup editing to use the common method of executing the update and handling refresh. PR-289 `Workspaces` - Do not update client calculated columns until refreshed. DEV-996 `Workspaces` - Show default config editor as code. DEV-1189 `Format` - Update default percentage and number system setting to only affect max digits displayed instead of exactly how many. DEV-1257 `Format` - Add ID column for unformatted number values. DEV-1257 `Format` - Enable column format to set a range of displayed digits. e.g number:2:4 now formats a number to display min 2 fraction digits and max 4. DEV-1257 `Orders` - Fix custom date column values disappearing when updating row. DEV-1154 API 6.1.1 `Forecast` - Make forecast service thread safe. DEV-1259 `Forecast` - Fix confidence factor not affecting the forecast/safety stock. DEV-1216 Databases 6.1.1 `Workspaces` - Fix distribution when average series has 0 value. DEV-1192 `Scheduled Orders` - Split order is partially hard-coded in the `order_run_populate_orders_and_lines`. DEV-1205 `Workspaces` - Fix issues in `non data series views` where `de_update_batch_series` was expecting a date. DEV-1249
6.1-r0	master	2020-02-19T13:24:13Z	6.1.0	6.1.0	6.1.0	13 / 40	6.1-r0.zip 6.1-r0.zip
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 be`NULL`. 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
6.0-r18	lts/6.0	None	6.0.16	6.0.11	6.0.12	0 / 1	6.0-r18.zip 6.0-r18.zip
6.0-r18 Known Issues/Bugs Unaddressed issues in JIRA Issues Issues that were addressed and fixed in this release See a list of issues fixed on Jira See list of pull requests involved in this update on GitHub See code changes on GitHub compare Client 6.0.1 `xxx` - xxxx DEV-1577, PR-1134 API 6.0.12 Databases 6.0.13
6.0-r17	lts/6.0	2021-06-09T09:53:32Z	6.0.16	6.0.11	6.0.12	0 / 23	6.0-r17.zip 6.0-r17.zip
6.0-r17 Known Issues/Bugs Unaddressed issues in JIRA Issues Issues that were addressed and fixed in this release See a list of issues fixed on Jira See list of pull requests involved in this update on GitHub See code changes on GitHub compare Client 6.0.16 `Workspaces` - fix: the edit-ability of the column in a total row when there is conditional editing on the column. For example with this column configuration on the weight column in a view with item no and weight present DEV-1577, PR-1134 `Grids` - fix: Distinct aggregation with grouping broke the grid when date fields were included in the grid DEV-1839, PR-1137 `Workspaces` - fix: Query filters don't work for dataseries update if data series are included in a view DEV-1463, PR-1189 `Workspaces` - Clear cache after saving default config DEV-1891, PR-1191 `Orders` - fix: Update all totals when order line is updated DEV-2096, PR-1231 `Orders` - fix: multiple issues with order grid UI: Row group aggregate values must update after edit, If column is sorted, the row order should not change after edit and After Qty cell edit, if TAB pressed, should not capture the old value in Purchase Units DEV-2150, PR-1344 `Orders` - fix: Order grid rounding of purchase unit DEV-2175, PR-1354 `Item Card` - Set the min and max values for the x-axis in the Item Card chart so that the x axis doesn't change when series are hidden. With this change the x-axis values in the chart should always reflect the period range (history/forecast) values selected. DEV-2123, PR-1269 `Reports` - Fix error where report could not be saved because of an error in the Advanced Filter. Handle the error gracefully in the client. DEV-2107, PR-1274 `Workspaces` - Remove the overwriting of view filters by workspace/user/ad-hoc filters. Since the first release of AGR v6 the workspace filters would overwrite the same filter if it existed as a view filter. This was done so that admins could easily test new filter setups in a view without changing the view itself and it would also enable browsing between views where you'd be sure that the workspace filter setup would trump the view setup. With these changes both the workspace- and view filters are used to filter the grid results which means only the intersection of the filters are resolved. This is a more logical result and prevents users from gaining access to data in views that would otherwise be unreachable because of locked view-filters. DEV-2156, PR-1326 `Orders` - Order grid update slow when order has thousands of lines DEV-2215, PR-1415 API 6.0.11 `User Management` - Clear encrypted password from API response DEV-1874, PR-1251 Databases 6.0.12 `Forecasts` - fixing problems with when orders need to check forecast and there are need of forecast then it can happened to go to timeout -but still with status=1 in forecast runs table. DEV-2041, PR-1147 `Item Card` - Loading v daily demand into table variable to improve performance DEV-2047, PR-1178 `Item Card` - fix: Estimated stock chart element not handling a certain scenario resulting in an empty item chart DEV-2159, PR-1338 `Orders` - fix: Using access group restrictions made orders disappear if some items were closed while the order is still in process DEV-2104, PR-1241 `Constrainer` - fix errors with constraining by days DEV-2176, PR-1375 `Orders` - Fix reserved missing from unitqtycalc and unitqtyresult in [dbo].[orderprocessinginitialize]. Reserved was only affecting stockagg and not unitqty calculations. DEV-2185, PR-1387 `Orders` -Planned Orders should use order frequency based on scheduled order settings. DEV-2180, PR-1394 `Workspaces` - Fix unnecessary reloads of grid data in workspaces for every drilldown that is populated. This fix makes sure to only load grid once after all drilldowns have been populated. DEV-2217, PR-1426 `Orders` -Update order info sidebar aggregated columns when order is edited DEV-2206, PR-1418 `Audit` - Adding deworkspaces and deworkspace_views to audit if audit exists DEV-2229, PR-1443 `Workspaces` - fix: Workspace lookup insert values should not submit DEV-2408, PR-1698
6.0-r16	lts/6.0	2021-01-14T12:00:32Z	6.0.15	6.0.10	6.0.11	0 / 11	6.0-r16.zip 6.0-r16.zip
6.0-r16 Known Issues/Bugs Unaddressed issues in JIRA Issues Issues that were addressed and fixed in this release See a list of issues fixed on Jira See list of pull requests involved in this update on GitHub See code changes on GitHub compare Client 6.0.15 `Format` - Fix how durations are processed and formatted in the app. These changes enable us to use both `Date` objects and rounded/integer `number` values in milliseconds to store durations and display in the app. DEV-1858, PR-1049 `Item Card` - Fix issue where the forecast series in the Item Card chart was not displayed correctly when the start of week is not Monday (i.e aggregated to another day in `chart_item_select`). After these changes the forecast should be correctly placed and the helper/grid lines (tickInterval) in the chart are also moved to align with the newly added `item_card_start_week` setting. DEV-1960, PR-1096 `Item Card` - Make the week indication label on the x-axis optional in the Item Card chart. By setting the newly added `item_card_hide_week_number` setting to `true` the chart label will dislpay e.g. `7. Dec'20` instead of `w50 - Dec'20`. DEV-1960 PR-1096 `Item Card` - Fix issue where grid was not displaying series data on the week level, when the start of week is not Monday (i.e aggregated to another day in chartitemselect). The itemcardstart_week property was added to dbo.settings so the start of week can be changed DEV-1948 PR-1056 `Orders` - Making sure the grid isn't resorted automatically after cell edit. DEV-1909, PR-1082 `Workspaces` - Filter drilldown be present viewfilter of same column DEV-575, PR-1113 `Workspaces` - Fix not being able to edit string columns in a workspace (Affecting the ABC Analyzer Workspace) DEV-1926 PR-1112 API 6.0.10 `Schedules` - Remove deprecated purchase plans from schedules delete warning. DEV-1937, PR-1105 `Workspaces` - Fix: It should be possible to choose users to share workspace-view without having user management role DEV-1869, PR-1037 Databases 6.0.11 `Item Card / Settings` - Add the `item_card_hide_week_number` property to the `dbo.settings` table to hide/show the week label when the Item Card chart is viewed on the weekly level. DEV-1960 PR-1097 `Item Card / Settings` - Add the itemcardstart_week property to the dbo.settings table to control which day of the week series are aggregated to when looking at the Item Card Grid in weekly view. DEV-1948 PR-1058
6.0-r15	lts/6.0	2020-12-09T09:15:45Z	6.0.14	6.0.9	6.0.10	0 / 11	6.0-r15.zip 6.0-r15.zip
6.0-r15 Known Issues/Bugs Unaddressed issues in JIRA Issues Issues that were addressed and fixed in this release See a list of issues fixed on Jira See list of pull requests involved in this update on GitHub See code changes on GitHub compare Client 6.0.14 `Dashboard` - Fix/show colors depending on target / lower level PR-947, DEV-1621 `Grids` - Show better colors in ag-grid PR-1018, DEV-1568 `Workspaces/Plans` - Fix issue with series values with dot interpreted as thousands PR-1006, DEV-1889 `General` - Remove New Update Available message from login and about PR-1012, DEV-1845 `General` Remove toaster error message when agr pool can't be reached PR-1014, DEV-1831 `Item Card` Prevent docked Item Card from updating on broadcast event PR-1016, DEV-1776 `Roles` Fix new roles not saving features immediately. It is now possible to start editing roles immediately after creation. PR-879, DEV-1749 API 6.0.9 `Reports/Items` - Improve upon issue where errors were occurring when editing views in reports/items. Fix concurrency error in delete mbe-filters. PR-841, DEV-1533 `Forecasts` - fix/forecast decimal/overflow/ PR-994, DEV-1884 Databases 6.0.19 `Orders` - Improved forecast obsolete check in order calculations PR-980, DEV-952 `Inventory` - Fix: When using undelivered all today setting days cover is always wrong PR-998, DEV-1887
6.0-r14	lts/6.0	2020-10-09T12:32:33Z	6.0.13	6.0.8	6.0.9	1 / 15	6.0-r14.zip 6.0-r14.zip
6.0-r14 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. DEV-1588 Known Issues/Bugs Unaddressed issues in JIRA Issues Issues that were addressed and fixed in this release See a list of issues fixed on Jira See list of pull requests involved in this update on GitHub See code changes on GitHub compare Client 6.0.13 `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. 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. DEV-1609 `Grids` - Fix issue where it wasn’t possible to deselect all selected rows in grouped grids, e.g `Orders`-grid. 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. 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 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. 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. DEV-1622 `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. DEV-1580 `Workspaces` - Fix issue where grid state (e.g. column width) in views was lost when navigation between views. 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. DEV-1647 `Workspaces` - Fix `Period Filter` so that just 1 month/week or day can be selected when working with fixed periods. 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. DEV-1587 API 6.0.8 `Reports/Items` - Improve upon issue where errors were occuring when editing views in reports/items. DEV-1533 Databases 6.0.9 `Item Card` - Fix chart so that stock history series is always shown even though last sale is not included in the period. 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. DEV-1455
6.0-r13	lts/6.0	2020-09-14T13:39:57Z	6.0.12	6.0.7	6.0.8	1 / 6	6.0-r13.zip 6.0-r13.zip
6.0-r13 What's new? Version info added to the login page as well as an indication if a patch updated exists for the current version. Database Update Scripts Check out the update reports for updating and patches 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.0.5 Add max fraction digits format DEV-1257 DB 6.0.4 Update translations DB 6.0.3 Run translations initial load DB 6.0.2 Add purchase plan workspace if missing DEV-1022 Run translations initial load DB 6.0.1 Add new timezone server settings DEV-933 Run translations initial load DB 6.0.0 Add items to dbo.features Add items to dbo.role_features Add planned orders order type DEV-23 Change currency format in dashboardelements,dataelements,mbecolumns,orderviewaggcolumns,orderviewcolumns DEV-228 Add planned orders order type DEV-437 New settings in dbo.settings DEV-227 Run translations initial load DEV-226 Update available languages Stg - data migration No change Known Issues/Bugs Unaddressed issues in JIRA Issues Issues that were addressed and fixed in this release See a list of issues fixed on Jira See list of pull requests involved in this update on GitHub See code changes on GitHub compare Client 6.0.12 `Version Info` - Add correct version info to the login page like in the about modal. Also add a notification if a new version exists according to version data at https://pool.agrdynamics.com/api/versions. DEV-1503 `Reports` - Fix create orders from item selection causing API errors. Fixed by limiting the selection amount and redirecting the request to the report ID when all items are selected. DEV-1536 API 6.0.7 `Forecast` - Fix slow parallel forecast. The async functionality for writing the forecast to the database was removed to improve the deadlock situation that was arising. DEV-1558 Databases 6.0.8 `mbe_item_statistics_populate` - Fix reference to non existing setting. Turns out the settings (`demand_for_dc` and `demand_for_dc_days`) were renamed in 2018 in the demand process procedure but it was never updated accordingly in `mbe_item_statistics_populate`. - Consultants already had a fix for this SO-834, DEV-1557 `Items` - Remove old version of `mbe_report_remove` causing `[dbo].[items_temp_report_create]` to fail and the items feature not to work in the app. DEV-1464 `Workspace` - Fix issue where user was unable to delete values in series that had nullable value columns. DEV-1542
6.0-r12	lts/6.0	2020-08-20T16:38:16Z	6.0.11	6.0.6	6.0.7	0 / 10	6.0-r12.zip 6.0-r12.zip
6.0-r12 Known Issues/Bugs Unaddressed issues in JIRA Issues Issues that were addressed and fixed in this release See a list of issues fixed on Jira See list of pull requests involved in this update on GitHub DEV-1473, DEV-1477, DEV-1478, DEV-1480 and DEV-1482 are missing from the PR-list because they were commited straight into the release/6.0.x branch. See code changes on GitHub compare Client 6.0.11 `Item Card` - Remove min/max stock input value logic that would make sure min stock couldn't exceed max and vice versa. DEV-1482 `Item Card` - Fix forever spinning animation on recalculate chart data button if recalculation fails/throws errors. DEV-1480 `Orders` - Fix bug when inserting a value into purchase units for one line then the quantity was updated in the line but not for the aggregation for the order. DEV-1473 `Orders` - Fix Selected view in orders resets after focus filter is cleared. Local storage was accidentally being reset. DEV-1477 `Orders` - Fix checkboxes in orders grid disappearing when switching between the "In Process" and "Confirmed" tabs. DEV-1478 `Reports` - Fix lookup filter (list filter) broken (hard to operate) when null or empty string values exist in the column data. DEV-1488 API 6.0.6 `Forecast` - Fix Calendar events (Holidays) not working for every year. DEV-1487 `Forecast` - Fix weekly forecast bug. Doesn't give forecast for last 30 days even though it has a sale within the period. DEV-1496 Databases 6.0.7 `Update scripts` - New install and update scripts. PR-599 `Orders` - Fix error when recalculating planned orders where items have different schedule (if schedules for items didn't match you could end up with blank lines when recalculating). DEV-1494
6.0-r11	lts/6.0	2020-07-21T15:33:24Z	6.0.10	6.0.5	6.0.6	0 / 3	6.0-r11.zip 6.0-r11.zip
6.0-r11 Known Issues/Bugs Unaddressed issues in JIRA Issues Issues that were addressed and fixed in this release See a list of issues fixed on Jira See list of pull requests involved in this update on GitHub See code changes on GitHub compare Client 6.0.10 `Workspaces` - Fix cell focused not moved after editing cells in column only workspaces, issue introduced when fixing DEV-1394. DEV-1466 `Workspaces` - Fix cell editing in date column not working after update to 6.0-r10, issue introduced when fixing DEV-1379. DEV-1467 `Workspaces` - Cancel ongoing grid query if changes are made to view settings to avoid unpredictable behaviour in grid. DEV-1441
6.0-r10	lts/6.0	2020-06-24T14:26:05Z	6.0.9	6.0.5	6.0.6	1 / 13	6.0-r10.zip 6.0-r10.zip
6.0-r10 What's new? Show correct app bundle version information in the about modal by querying the AGR Pool Api at pool.agrdynamics.com/api/versions Known Issues/Bugs Unaddressed issues in JIRA Issues Issues that were addressed and fixed in this release See a list of issues fixed on Jira See list of pull requests involved in this update on GitHub See code changes on GitHub compare Client 6.0.9 `Login` - Fix extra refresh required when opening the site again the day afer login. Token expired DEV-1395 `Workspaces` - Fix issue where `null` value in filter turns to `0` when it shouldn't. DEV-1387 `Workspaces` - Fix issue when editing cells with the keyboard. Cell focused lost when edit stops/finishes. DEV-1394 `Workspaces` - Fix sorting of total rows in serie workspaces containing client side series. DEV-1360 `Workspaces` - Don't trigger/send update action when checkbox is clicked while doing a row insert. Do not show checkbox as editable (consistency with non-inserted rows). DEV-1326 `Format` - Validate date in format service to prevent grid grouping crash (Invalid Date error). DEV-1405 `Version Info` - Add correct app bundle version information to about modal by querying from AGR Pool (pool.agrdynamics.com/api/versions/). DEV-1427 `User Management` - Add warning message when trying to change current users passwords from user management feature. Not possible in API, use `My Profile` instead. DEV-1364 `Item Card` - Show primary route as default selected information in Details tab. DEV-1388 `Workspaces` - Enable usage of `,` instead of `.` for fractions when editing numbers. DEV-1379 `Documentation` - Update URL paths to documentation manuals, now at docs.agrdynamics.com. DEV-1445 `Item Card` - Fix endless loading dots for item image when no url is constructed but a url was expected. DEV-1449 API 6.0.5 `Reports` - Extend debounce time in client and catch exception in API which overwrites temp report directly to avoid error message in client when updating report to quickly (adding columns fast). DEV-1429
6.0-r9	lts/6.0	2020-05-28T14:24:15Z	6.0.8	6.0.4	6.0.6	0 / 1	6.0-r9.zip 6.0-r9.zip
6.0-r9 Known Issues/Bugs Unaddressed issues in JIRA Issues Issues that were addressed and fixed in this release See a list of issues fixed on Jira See list of pull requests involved in this update on GitHub See code changes on GitHub compare API 6.0.4 `Forecast` - Fix: Polling not working for forecast. DEV-1396
6.0-r8	lts/6.0	2020-05-06T10:45:38Z	6.0.8	6.0.3	6.0.6	0 / 7	6.0-r8.zip 6.0-r8.zip
6.0-r8 Database Update Scripts Prod - Patches `dbo.de_qb_sql_where_filter_clause` - Updated (DEV-1343) `dbo.json_toJson` - Updated (DEV-1343) `dbo.fn_de_client_calc_series_dependency` - Added (DEV-1315) `dbo.de_query_availability` - Updated (DEV-1315) `dbo.de_update_column` - Updated (DEV-1321) `dbo.version_db` - Update version number Stg - Patches `ctr.settings` - Update prod database version compatability Known Issues/Bugs Unaddressed issues in JIRA Issues Issues that were addressed and fixed in this release See a list of issues fixed on Jira See list of pull requests involved in this update on GitHub See code changes on GitHub compare Client 6.0.8 `Workspaces` - Fix issues with checkboxes in total rows. DEV-1281 Only be shown when aggregation is set. Be readonly unless config.aggregation.editable is true Should update other (non-totalrow) checkboxes when clicked `Workspaces` - Fix period filter resetting to min max value when saved valued not matched caused by client timezone issue with the Javascript Date Object. DEV-1327 `Workspaces` - Show proper caption of data series in Excel export. DEV-1330 `Orders` - Add the ability to search for constraints in split by constraints. DEV-1322 Databases 6.0.6 `Workspaces` - Procedure `fn_de_client_calc_series_dependency` now used for calculated series, fixes issue when calculated series depends on another calculated series. DEV-1315 `Workspaces` - Fix issue with long filter value, problem found when pasting long lists into lookup filter. DEV-1321 `JSON` - Fix JSON parsing error when `"`-quotation characters not escaped in strings. DEV-1343
6.0-r7	lts/6.0	2020-04-20T14:24:55Z	6.0.7	6.0.3	6.0.5	0 / 4	6.0-r7.zip 6.0-r7.zip
6.0-r7 Known Issues/Bugs Unaddressed issues in JIRA Issues Issues that were addressed and fixed in this release See a list of issues fixed on Jira See list of pull requests involved in this update on GitHub See code changes on GitHub compare Client 6.0.7 `Workspaces` - Display total serie items like total rows in grid status bar. DEV-1277 `Dashboard` - Fix error causing no values to show in chart because of extra apostrophe (`'`) wrapping around the data. DEV-1307, SO-1056 API 6.0.3 `Forecast` - Check if forecast is needed. DEV-1304 `Forecast` - Fix memory leak, out of memory error in SpWrapper. DEV-1290
6.0-r6	lts/6.0	2020-03-27T11:06:07Z	6.0.6	6.0.2	6.0.5	2 / 9	6.0-r6.zip 6.0-r6.zip
6.0-r6 What's new? It is now possible to define a max number of fraction digits for `number`, `percent`, and `percentage` columns. e.g. `number:2` still behaves the same way printing exactly 2 fraction digits. `number:2:4` will print min 2 and max 4 fraction digits: `12.4` => `12.40`, `12.435` => `12.435`, `12.43585` => `12.4359`. System setting: `fraction digits for numbers` and `fraction digits for percentages` has been changed to only affect the MAX number of digits printed, e.g. when the column format is `number`, `percent` or `percentage` Database Update Scripts Prod - Patches `dbo.de_update_batch_series` - Updated version of this procedure `dbo.settings` - Updated caption and description for formatnumberdigits and formatpercentagedigits settings `dbo.version_db` - Update version number Stg - Patches `ctr.settings` - Update prod database version compatability Known Issues/Bugs Unaddressed issues in JIRA Issues Issues that were addressed and fixed in this release See a list on Jira See list of pull requests involved in this update on GitHub See code changes on GitHub compare Client 6.0.6 `Grids` - Fix clipboard export of dates in grids (reports and orders). DEV-1188 `Format` - Update default percentage and number system setting to only affect max digits displayed instead of exactly how many. DEV-1257 `Format` - Add ID column for unformatted number values. DEV-1257 `Format` - Enable column format to set a range of displayed digits. e.g `number:2:4` now formats a number to display min 2 fraction digits and max 4. DEV-1257 `Format` - Fix precision issue for `percentage` formatting. PR-244 `Orders` - Fix custom date column values disappearing when updating row. DEV-1154 API 6.0.2 `Forecast` - Make forecast service thread safe. DEV-1259 `Forecast` - Fix confidence factor not affecting the forecast/safety stock. DEV-1216 Databases 6.0.5 `Workspaces` - Fix issues in `non data series views` where `de_update_batch_series` was expecting a date. DEV-1249
6.0-r5	lts/6.0	2020-03-10T15:26:36Z	6.0.5	6.0.1	6.0.4	0 / 14	6.0-r5.zip 6.0-r5.zip
6.0-r5 Database Update Scripts Prod - Patches `dbo.de_update_batch_series` - Updated version of this procedure `dbo.order_run_populate_orders_and_lines` - Fixing `@scheduled_order_id` hardcoded as 1 issue `dbo.scheduled_orders_run` - Moving set description into `scheduled_orders_post_order_run` `dbo.scheduled_orders_post_order_run` - Moving set description into `scheduled_orders_post_order_run` `dbo.translations` - Translations updated `dbo.version_db` - Update version number Stg - Patches `ctr.settings` - Update prod database version compatability Known Issues/Bugs Critical issues and bugs that are persistent in this release Issues Issues that were addressed and fixed in this release See list of pull requests involved in this update on GitHub See code changes on GitHub compare Client 6.0.5 `Workspaces` - Fix refresh profile on row in data elements. DEV-907 `Excel/csv export` - Fix date and datetime exported values in `reports` and `orders` grid. DEV-1188 `CSS` - Fix potential future bug discovered in `6.2` where any `slowAppear` animated object would never show (missing grid, missing login screen). PR-255 `Item-Card` - Fix runtime error in `Item-Card-Grid` if `chart-data` doesn't belong to any series. PR-250 `Workspaces` - Fixes to client side series. PR-279 `Grids` - Enlarge font size in all grids from 12 to 14px and add vertical column lines for sake of readability. PR-282 `Dashboard` - Sort data by date for the `dashboard` chart. PR-283, SO-1028 `Orders` - Fix issue where orders could be edited/deleted when `confirmed`. DEV-1206 `Orders` - Fix, clear order id filter on order confirm. DEV-1195 Databases 6.0.4 `Workspaces` - Fix average distribution in `de_update_batch_series`. Total row of type `avg` not updating values proportionally. DEV-1131 `Workspaces` - Fix wrong calculation when overwriting data series in total/each week by percentage or sum. DEV-1033 `Scheduled Orders` - Set description action moved to `scheduled_orders_post_order_run`. DEV-1145 `Workspaces` - Fix distribution when average series has 0 value. DEV-1192 `Scheduled Orders` - Split order is partially hard-coded in the `order_run_populate_orders_and_lines`. DEV-1205
6.0-r4	master	2020-02-14T12:53:40Z	6.0.4	6.0.1	6.0.3	0 / 19	6.0-r4.zip 6.0-r4.zip
6.0-r4 Known Issues/Bugs Critical issues and bugs that are persistent in this release 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.0.4 Fix console error when opening delete modal. DEV-1038 Fix editable lookup values in planner when column is min/max aggregated. DEV-1008 Make cached values in client indexed database only valid for 1 day, replaced if expired. DEV-1036 Fix overwriting of workspace data in total columns by percentage or sum wasn't working correctly, `display-div` series. DEV-1033 Fix date editing (e.g. `2020W48`) in workspace, was sending unedited value to database. DEV-1066 Fix excel export bug, where name of report was causing exported file to be corrupted. DEV-1075 Rename `NULL` value to `[no value]` in workspace drilldown and filters and fix broken null filtering in filters. DEV-1099 Visualize paste option when right-clicking in Workspace grid. DEV-1108 Fix, rows in orders not deleted (from grid view) if they'd been edited unless grid is resynced. DEV-1029 Fix item card grid state not stored correctly. DEV-1113 Fix row totals in grid of workspace client side series. DEV-984 Fix orders grid, deselection of all rows not working. DEV-1132 Fix bug that would shift the first line of workspace series. PR-192 Fix column header heights in Item Card > Grid, caused by two grids displayed on same page. DEV-1140 Fix scheduled order deleted column was marked as NULL after edit from the client, it is now 0 (false) unless actually deleted. DEV-1116 Fix checkbox column placement in workspace after more columns are pinned. DEV-1137 Fix password autocompletion, undesired behaviour when editing/creating user. PR-199 Databases 6.0.3 Fix `NULL` issue in `de_update_batch_series.sql`. Fix missing `ELSE IF` clause in `mbe_qb_sql_flat.sql`, When using data access `Items features` would display no data. DEV-1090
6.0-r3	master	2020-01-31T13:37:34Z	6.0.3	6.0.1	6.0.2	2 / 18	6.0-r3.zip 6.0-r3.zip
6.0-r3 What's new? Visual changes to the about modal Version information changes on the login page Known Issues/Bugs Critical issues and bugs that are persistent in this release 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.0.3 Constrain editable cells in workspaces by comparing values from other columns, see documentation. DEV-1061 Make period filters always available in workspaces. DEV-1032 Fix error when adding data-series in workspace where no period filter exists. DEV-1028 Fix custom data series not appearing in Item Card grid. See stackoverflow. DEV-1030 Fix error causing all workspaces of type to break if actionJson is partial from context. DEV-1049 Fix issue where workspace view is reloaded after save, even though there are no updates. DEV-1006 Fix row total in workspace views not showing/updating until the user scrolls the view. DEV-980 Implement refresh workspace view/grid after action config `refreshGridAfterAction`. DEV-960, DEV-1043 Fix read only not working correctly in workspace view. Editable cells were still editable even though access indicated read only. DEV-945 Fix and enable amending start week/end week after recoding, Recodes view. DEV-1037 Fix planner background colorization/division lines drawn in random places after sorting on column. DEV-1027 Fix delayed planner update. DEV-987 Fix delete orders not working after recalculate. DEV-1029 API 6.0.1 Fixes slow load and private key error when loading data in the Item Card. The modular design of the Item Card does multiple requests to the `api/items/{id}/chart_data/` endpoint causing a forecast race condition. This update fixes issues by not creating a forecast if the forecast_length is 0. DEV-1023 Databases 6.0.2 Translations additions/updates. Fix Reserved units/reservedqty issue in version 6 dbscripts. DEV-1056 Fix Error in dbo.logstgtransfer_log causing it not to indicate yellow light in the client dashboard. DEV-1052 Fix planned orders, consider previous order lines when recalculating. DEV-1018
6.0-r2	master	2020-01-23T15:36:09Z	6.0.2	6.0.0	6.0.1	2 / 20	6.0-r2.zip 6.0-r2.zip
6.0-r2 What's new? This version introduces a new versioning scheme, identical for all projects (client, API, database) where the first two values (major and minor e.g 6.0) are always in sync but the third value (patch) is updated individually for each project. There's also a `bundle version` which is the tag of this release (v6.0.2), the bundle version is always bumped on every release. New setting property `server_timezone` added, used to fix issues caused by the server (API and/or database) not sending timezone information with time values to the client. This value has to be set correctly for any setup where the database and API are not in UTC time. See list of tz database time zone names. Known Issues/Bugs Critical issues and bugs that are persistent in this release Issues Issues that were addressed and fixed in this release See list on Jira Client 6.0.2 Fixes timezone issues by adding a `server_timezone` property to the settings table. This value takes a tz database time zone name, e.g `Europe/London`, `America/New_York`. The root problem is caused by the server (API and/or database) not sending timezone information with time values and the client therefore assuming UTC time. DEV-933, DEV-1007 Fixes runtime error in Settings > System where nothing appears on the page. This was caused by the newly introduced search/filter input box. DEV-965 Fixes error in workspaces when changing a data-series checkbox, both oldValue and newValue property were being assigned the newValue. DEV-977 Updates and fixes to the migration of workspace config objects. DEV-995, DEV-957 Pin total column to the left in workspace views. DEV-968 Fixes error where the order of columns is lost/reverted in workspace views after adding a new column. DEV-989 Fixes error where unchanged values from dropdown are sent to the database. Editable column, lookup. DEV-994 Migrate app and settings navigation objects to v6. DEV-929 Fixes error where data in columns in workspace views disappears after changing the aggregation on the column. DEV-972 Fixes error where drilldown values are not persistent/memorized when navigating between workspace views. DEV-914, DEV-963 Fixes wrong implementation of constraining editable values in column config where more than, less than and equals operators were reversed. DEV-970, DEV-971 Fixes long load (app seems frozen) in workspace lookup filters. DEV-974 Clears the search string in workspace drilldowns so it's not the same everywhere. DEV-961 Add loading bar on all HTTP request in app, this is very helpful as it indicates if the app has requested data and is actually waiting for a response from the backend. DEV-986, DEV-1002 Fixes error when selecting schedules caused by the wrong API endpoint being used when checking the usage of the schedule. DEV-953 Fixes error where state of grids in the app was not persistent (saved), e.g sorting, filter values and column info. DEV-942 Adds missing dashed line to current period column in workspace views. DEV-990 Fixes incorrect data state and loading feel when opening new workspace view. DEV-981 Databases 6.0.1 Translations additions/updates. Add `server_timezone` property to settings table.

Allocation Module


6.2.1	develop	2021-05-20T15:07:26Z	0 / 0	6.2.1.zip
6.2.1 Separating alloc.location into two views, one filtered on stores and the other one on warehouse a. alloc.vlocationstore b. alloc.vlocationwh Various small changes and bug fixes Known Issues/Bugs Unaddressed issues in JIRA Issues Issues that were addressed and fixed in this release See list on Jira `Allocation logic` - Columns Store location and WH location are showing the same locations. ALLOC-143, PR-87 `Allocation Logic` - Primary key column in productitemskuextrainfo needs to match primary key column in productitemsku table. ALLOC-141, PR-86 `Allocation Logic` - Allocation method name options not showing up. ALLOC-133, PR-83 `Allocation Logic` - Error when erasing from POL hold back field. ALLOC-132, PR-89 `Allocation Logic` - Handle NULL fields in allocate selected PO lines calculations. ALLOC-131, PR-81 `Allocation Logic` - All POL are updated with new hold_back when updating, but only one line should be effected. ALLOC-130, PR-81 `General db` - Add changes to initial load. ALLOC-128, PR-80 `Allocation Logic` - alloc-pol-allocation-method twice in data-element-ref-tables. ALLOC-126, PR-78, PR-80 `Allocation Logic` - Allocation - only map active product group columns. ALLOC-125, PR-81 `Allocation Logic` - alloc prefix missing from OM procedures. ALLOC-122, PR-75
6.2.0	develop	2021-02-12T10:55:29Z	1 / 0	6.2.0.zip
6.2.0 What's new? Allocation module code updated to account for the following 6.2 changes 1. [ctr] schema changed to [core] 2. Data series now stored in a new format in dataelementseries 3. JSON format updated 4. New logging mechanism Known Issues/Bugs Unaddressed issues in JIRA Issues Issues that were addressed and fixed in this release See list on Jira
6.1.2	release/allocation/6.1.x	2021-05-20T09:14:41Z	0 / 0	6.1.2.zip
6.1.2 Separating alloc.location into two views, one filtered on stores and the other one on warehouse a. alloc.vlocationstore b. alloc.vlocationwh Various small changes and bug fixes Known Issues/Bugs Unaddressed issues in JIRA Issues Issues that were addressed and fixed in this release See list on Jira `Allocation logic` - Columns Store location and WH location are showing the same locations. ALLOC-143, PR-88 `Allocation Logic` - Primary key column in productitemskuextrainfo needs to match primary key column in productitemsku table. ALLOC-141, PR-86 `Allocation Logic` - Error when erasing from POL hold back field. ALLOC-132, PR-90 `Allocation Logic` - Handle NULL fields in allocate selected PO lines calculations. ALLOC-131, PR-82 `Allocation Logic` - All POL are updated with new hold_back when updating, but only one line should be effected. ALLOC-130, PR-82 `Allocation Logic` - Allocation - only map active product group columns. ALLOC-125, PR-77 `Allocation Logic` - alloc prefix missing from OM procedures. ALLOC-122, PR-75 `General db` - Add changes to initial load. ALLOC-128, PR-79
6.1.1	release/allocation/6.1.x	2021-02-17T09:44:54Z	0 / 0	6.1.1.zip
6.1.1 Known Issues/Bugs Unaddressed issues in JIRA Issues Issues that were addressed and fixed in this release See list on Jira `Workspace Views` - The column Allocation Method can now be included in the view Review and Confirm Allocation. ALLOC-87, PR-43, PR-47 `Allocation Logic` - Fixing issue causing min_qty not being distributed to all store in certain cases ALLOC-92, PR-42 `Workspace views` - All standard views are now system views ALLOC-97, PR-43 `Allocation Logic` - Changing default settings for Hold back and min alloc qty in Settings now immediately updates for all POL's as long as they have not been manually changed on that level ALLOC-101, PR-49 `Workspace Views` - Drilldown on Allocation No added to the standard view Allocation Overview ALLOC-103, PR-43 `Allocation Logic` - Not possible to allocate delivered POs anymore as they become a part of WH stock. ALLOC-104, PR-68 `General db` - alloc_ prefix added to all ref columns, views, etc. so that names don't conflict with other modules ALLOC-108, PR-72,PR-55 `Allocation Logic` - Reallocation and 2nd iteration of allocation calculations are now in sync. ALLOC-109, PR-66 `Allocation Logic` - Issues fixed in the reallocation logic ALLOC-117, PR-71
6.1.0	release/allocation/6.1.x	2020-10-12T10:47:02Z	2 / 0	6.1.0.zip
6.1.0 What's new? Everything! This is the first release of AGR's Allocation Module, there are more features to come! 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

Financial Planning Module


6.2.0	release/financial_planning/6.2.x	2020-12-18T15:35:04Z		0 / 0	6.2.0.zip
6.2.0 6.2.0

Release notes - AGR Development - 6.3-r32

Task

Bug

Release notes - AGR Development - 6.3-r31

Task

Bug

Release notes - AGR Development - 6.3-r30

Task

Bug

Release notes - AGR Development - 6.3-r29

Task

Bug

Release notes - AGR Development - 6.3-r28

Task

Bug

Release notes - AGR Development - 6.3-r27

Task

Release notes - AGR Development - 6.3-r26

Task

DEV-6363 demand_processing_calc_run - save the list of items causing error in demand to a table

DEV-7538 Scheduled orders - list fetched via a procedure

Release Notes

DEV-7746 Change setting days_cover_calc_stock_days_type to be DEFAULT 3 for new setups

Release Notes

DEV-7747 Change ABC to have scaling default off for new setups

DEV-7786 Change to new logo in AGR on plus

DEV-7796 Denormalize items master data to table items_dx

Release Notes

DEV-7798 Forecast 6.3: Outlier detection not working when running it from the item card

DEV-7821 demand_processing_calc_run not using #item_id_list for "Adding from the store order matrix" part

DEV-7826 Performance improvements - Index tuning

DEV-7880 Change index maintenance to reindex tables with 200+ pages

DEV-7881 Allow index maintenance on different days for stg and prod databases

DEV-7893 Change scheduled_orders_post to scheduled_order_post_batch_custom

Release Notes

DEV-7963 Change index maintenance to use default 15/45 % for reorganize/rebuild

DEV-7977 Demand parallel execution options as standard

Release Notes

DEV-8068 Change raw.v_SALE_HISTORY to use Quantity <> 0

DEV-8168 Performance fix in mbe_item_statistics_populat

DEV-8208 Use cursor variable in demand_processing_calc_run

DEV-8209 Clustered index on demand_processing_calc_run_results.item_id to avoid full scans

DEV-8210 DROP INDEX IX_ItemLedgerEntry á nav/erp/erp_bc_sql.ItemLedgerEntry

DEV-8211 Change designated little override procs to have Author AGR

DEV-8235 Forecast stays on the item after connection in connected Items is deleted

DEV-8236 Calculation "Forecast missing" on dashboard error

DEV-8274 Helper objects 2024-01

Bug

DEV-6122 Closed items that should get forecast will not have forecast when item card is opened until Forecast Service is restarted.

DEV-6140 Forecast 6.3: When confidence factor is set to 0% in item card the forecast is not removed.

DEV-6933 Update Order Status always logged on system user

DEV-7570 Forecast and Demand randomly disappears from item chart when recalculating forecast with forecast profiles

DEV-7669 Scheduler - Tasks - run 2x at same time

DEV-7914 Item details read only bug - users not seeing updated values

Release notes - AGR Development - 6.3-r25

Task

Release notes - AGR Development - 6.3-r24

Task

DEV-6571 Improve stockout smoothing code

DEV-6819 Hide data series from promotion module in Sales Plan by default and not have standard Promotions with "Old" in caption

DEV-7527 Columns ORIGINAL_NO and original_item_no should be NVARCHAR(255)

DEV-7538 6.3 ping sql to procedure

DEV-7552 Log days_back to core.event in daily

DEV-7553 Use SWITCH for heavy daily prod elements so system can be used while running

DEV-7603 Change view v_mbe_item_statistics_abc to use lookup table

DEV-7635 Helper objects 2023-11

Release Notes

Release notes - AGR Development - 6.3-r23

Task

DEV-7214 tb.events 0 as default

Release Notes

DEV-7257 Master Item Id not updating when item is closed

Release Notes

DEV-7266 inv_cus.item_order_routes_populate

DEV-7289 Decrease location info logging

DEV-7294 Have alloc disabled in new setups

DEV-7346 Estimated future stock is now logged into Plus if activated in settings

DEV-7350 inv.order_exception_check causing deadlocks

DEV-7426 Timeout at PetValu for filter_order_master_view on single order_line_id and user_id

DEV-7436 Improve performance for single order line update in orders_update_values