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