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