Manufacturing v22.1

Issues Resolved

Works Order Processing

[#15015]: When creating a works order, and there are component lines linked to an operation, those component lines were automatically allocating.
[#15039] Fix for over inflated quantities (despatched or received) on sub contract component lines when receiving a sub contract purchase order.
[#15523] Fix when attempting to allocate a traceable works order line through the API ‘WorksOrderAPI/AllocateWorksOrderLine’ and the user would get an error. [“Allocation failed, no bins with free stock.”]
[#15524] Fix works order Book finished goods ‘Object reference not set …’ error when the finished item is pre-allocation to a sales order and the works order was initially imported/created without a finished item.
[#15683] WOP – Improve query for retrieving Works Orders in the Complete Works order window.
[#16094] Fix to ensure the full variance posting from all booking transactions is reversed out when unbooking the works order.
[#15967] Fix when closing the amend stock item form and the BoundObjects collection is set to null when Sicon Documents is installed. [“Value cannot be null”].

Material Resource Planning

[#14814] Fix for suggested works orders arriving earlier than they are required when there is enough stock to fulfil demand and suggested works order is a sub assembly of another suggested works order.
[#14814] Fix for ‘Ignore Free Stock’ set on a stock item not being correctly used.
[#15045] Updated the ‘NewSiconStockMovementsView’ for Approvals (WAP) reqs when they are linked to a PO and it has then been approved.
[#14967] Fix Material Planning ‘Execution Timeout Expired’ error during ‘Suggested Kits’, ‘Suggested Purchase’ and ‘Works Orders’.
[#15458] Fix when running MRP and it errors when getting to suggested works orders. [“The incoming request has too many parameters. The server supports a maximum of 2100 parameters.”]
[#15765] Fix to honour the ‘Create selected works orders only’ setting when there is a batch item in the selection and there is no grouping of sub assemblies.
[#15765] Further fix to also ensure the correct sub assembly quantities are passed through when creating the works orders.

Kitting

[#14730] Fix ‘Object reference not set to an instance of an object’ error when building a kit from Barcoding Despatch Sales Orders.

Change in Functionality

Works Order Processing

[#15053] Added new Web API endpoint ‘UnissueWorksOrderLine’ to un-issue works order components.
[#15667] Added the ability to add a reason when adding works order lines via the web API method ‘Create New works order line’ (api/WorksOrderLineAPI/CreateNewWorksOrderLines).

Date applied: August 20, 2025

221.0.91

Works Order Processing

[#12830] Fix create works order ‘Create’ button causing screen rescaling when display resolution is not 100%.
[#14367] [#14365] Fix for the sort by ‘Ascending’ and ‘Descending’ not working correctly on the ‘Process Works Orders’ and ‘Complete Works Orders’ screen.
[#14407] [#14405] Fix when selecting multiple works orders to be completed and some may have unconfirmed lines to allow those without unconfirmed lines to be completed.
[#14436] Fix to load the ‘Print Labels’ form with a large amount of stock items. [“Out of memory”].
[#14548] Fix when importing works order lines which are components on a works order that exists. [“Out of memory”]
[#14573] Fix when receiving a sub contract purchase order via the ‘Confirm Goods Received’ screen and the user would incorrectly be informed the sub contract line has not been despatched. Further check to not leave the user stuck in a loop on this screen so if they receive the message they can leave the ‘Qty Received’ column.
[#14709] Show previously hidden works order on the complete works order screen.
[N/A] Fix to also display the ‘Unconfirmed’ tick if there are works order with ‘Unconfirmed sub contracts’.

Material Resource Planning

[#14408] Fix for incorrect rounding for the unit price of a purchase order when multiple unit of measures are used for suggested purchase orders.
[#14609] Fix for incorrect items running through MRP suggested works orders when they default bought and rescheduling is enabled.
[N/A] Fix when closing the amend stock item form [“Value cannot be null”]

Date applied: April 23, 2025

221.0.90

[#14258] Fix to ensure no further allocations are made to ‘Issued’ lines when using the ‘Process Works Orders’ screen.

Date applied: April 9, 2025

221.0.89

Issues Resolved

Works Order Processing

[#13523] On the works order completion screen only attempt to close child works orders associated to the selected works orders that are fully booked.
[#13645] Removed ‘Manning level’ from increasing/decreasing the time it takes to complete an operation.
[#13880] Notify user that supplier has not been set for sub contracts when selecting subcontract operations for a works order or maintaining it or adding it to a BOM.
[#14356] fix when adding time to a labour operation that has been manually added to a works order. [“Unable to update the object (Sage.Manufacturing.BusinessObjects.BillOfMaterials.BomOperationResourceDataObject, ), as the object has been deleted”]

Material Resource Planning

[#13168] Fix to ensure any works orders that contain phantom items which themselves contain sub assemblies follow the ‘Create selected works order only’ setting. Issue where users would still get the popup to create a sub assembly for these lines even when they were not ticked on the ‘Suggested Works Order’ tab.
[#13711] Fix for purchase orders being suggested a day or 2 days after they are required if the required date is a Saturday or Sunday and the MRP setting for supplier lead times.
[#13744] The refresh button on capacity planner rough cut teams tab will refresh the labour availability the charts of all teams.
[#14487] Fixed an issue when running MRP and it would error running suggested works orders when rescheduling is enabled [“Object Reference Error”]

Kitting

[#13592] Allow the bin priority 6 bin to be available for picking.

Change in Functionality

Works Order Processing

[#14306] Added a new stock item setting to determine the way works orders are numbered when they are split by batch size. This requires that both ‘Auto generate WO number’ and ‘Use standard WO number’ settings are enabled for this to be applied.

Date applied: March 26, 2025

221.0.88

Works Order Processing

[#11295] Fix for settings being incorrectly disabled based on the compatibility with other works order settings being enabled. ‘Use warehouse hierarchy’ and ‘Show allocations screen to split allocations across multiple warehouses’.
[#12570] Prevent phantom BOMs from being available as finished items on the dropdown when creating a new works orders.
[#13438] Improved error handling from ‘Generate SO From WO’ screen so it no longer crashes out of sage.
[#13664] When adding Subcontracts to a Works Order, only the Subcontract Operations with associated supplier will be listed for selection.
[#13623] Fix error when closing a BOM Operation when maintaining an operation from Bill of Materials List and the Operations Register. [“Object Reference Error”]

Material Resource Planning

[#13258] Fix to correctly display on the ‘Suggested Works Order’ tab the ‘Base UOM’ and ‘Base UOM Quantity’ if there is a ‘Production UOM’ set against a stock item.
[#13628] Fix for a sorting issue on the ‘Suggested Works Order’ tab when sorting by the item code. [“Failed to compare two elements in the array”]
[#13653] Fixed an issue when running MRP and if a suggestion was to be processed before the out movement a further check to make sure the movement is processed after the earliest date it can arrive, otherwise extra suggestions could be made unnecessarily.

Date applied: March 12, 2025

221.0.87

Works Order Processing

[#10316] Added a new popup before attempting to book in a finished item when there are multiple finished items to remind the user to check they are happy with the cost split on the finished items before booking in. this can be disabled at a user level in the user settings.
[#12546] Improve handing of stock attributes on spilt works orders.
[#13282] Utilise BOM line quantity correctly for phantom stock items when creating works orders labour, machine and sub contract lines
[#13319] Fix to also update associated sub assembly works order quantities if the parent works order line has been updated so that preallocations between the both remain the same when using the ‘Update from BOM’ feature.
[#13358] Resolved error with a view ‘vw_siconexpectedoperationenddates’.
[#13362] Fix when adding multiple ‘Machine’ transactions to a works order and after the first transaction then all other transactions would get added at a cost of ‘0’.
[#13384] Fix when printing a picking list on a works order directly after manually adding lines to a works order before closing the works order. [“Warehouse with id 0 cannot be found.”]
[#13402] Timestamp works order lines table when being unallocated or removed.

Material Resource Planning

[#12675] Fix for inflated ‘Suggested Auto Stock Transfer’ quantities when viewing the ‘Future Stock Movements’ screen.
[#13259] Fix to improve the memory usage when running MRP with a large amount of data. [“Out of Memory Exception.]

Date applied: February 27, 2025

221.0.86

Works Order Processing

[#11715] Fixed issue where scrap percentage was not taken into account when update from BOM was used on a works order.
[#12813] Further validation added so that operations cannot be deleted from a works order if time has been set against them.
[#13153] Performance improves when searching by works order number etc on the ‘Complete Works Order’ screen.
[#13180] Fix to read the ‘SiJcTrn’ with an isolation level of ‘ReadUncomitted’ to help with deadlocks on this table.
[#13193] Fix to add validation on the stock item import when attempting to set bulk issue items. These cannot be set if the item is not a component or non traceable.
[#13205] Fix for traceable components to appear on the component traceability selection when booking in a works order the lines have had multiple issues against them.
[#13216] Fix backflush ‘Unable to allocate works order lines, Some of the items were allocated: Error ‘Sequence contains no elements …” error if backflushing a works order which includes non-stocked components, e.g. miscellaneous stock items.
[#13236] Fix for the ‘Issue Allocations’ screen defaulting to the free stock of a batch quantity when the screen initially opens.
[#13236] Fix to add so0me validation when reducing line quantities before attempting to complete ‘Part Booked’ works orders via the ‘Complete Works Orders’ to make sure that child sub assemblies are ‘Completed’ before reducing the parent works order line.
Fix when generating works orders from sales orders using the menu option ‘Generate Works Orders from Sales Orders’ without Projects and the user would get an error. [“Could not load file or assembly ‘Sicon.Sage200.Projects.Objects version=x.x.x.x'”]

Material Resource Planning

[#11968] Fix for the ‘Suggested Works Orders’ tab not correctly refreshing after the creation of works orders, users would sometimes experience an error after creating multiple works orders. [“Object reference error”]
[#13127] Corrected the warehouse for a suggested child kits and the user would encounter an error when running MRP. [“Object reference error”]
[#13158] Fixed issue where scrap was not taken into account for suggested works orders, and so suggested purchase orders were also less than required.
[#13165] Fix to create ‘Min Stock’ or ‘Reorder Level’ suggestions when using the ‘Stock Level Option’ of ‘Maintain max based on min stock’ or ‘Maintain max based on reorder level’ and there is current demand in the system but this wouldn’t bring it below min/reorder level.
[#13217] Fix to update kit line quantities if the parent suggested kit quantity has changed. To note this will not update child kit quantities if a child kit exists on the parent kit.

Date applied: February 12, 2025

221.0.85

Works Order Processing

Fix to post material overhead postings when completing a works order so that there is not a negative value left in WIP. [#11272]
Fix to calculate operations times at the end of creating a full works order structure to improve the performance of creating a works order. [#12186]
Fix traceable item use/sell by dates lost when booking in finished goods from barcoding. [#12357]
The add extra quantity works order material setting also applies to subcontracts and finished items. [#12525]
With simple timesheet works order setting, recording the full quantity can complete the associated operation and adjust the area on the work order for the next operation [#12690]
Fix to tick any traceable items that are going to be issued when issue works orders and selecting traceables at despatch is turned on. [#12702]
Fix to allow ‘Bulk Issue’ items to be unissued when they have been issued at the point of booking with the setting ‘Issue bulk issue items at booking’ is enabled. then the works order is unbooked. [#12832]
Update the message box displayed when changing promised dates on a sales order where a works order is linked to inform the user the date can only be set if the works order operations allow this to happen. [#12833]
Fix for ‘Sub contract’ and ‘Non stock’ costs being included in the cost of a works order when the setting to include either of these costs was not turned on. Issue could be seen where ‘calculate cost’ would produce a different result to the drilldown. [#12837]
Fix to ensure the ‘WOCost’ field on ‘SiWorksOrder’ is set to 0 when the works order status is new. issue where ‘New’ works order could not be deleted as there was a cost still left in this field. [#12901]
Exclude completed works orders from selection when adding to a bulk issue. [#12922]
Fix to set the ‘StockItem’ on a works order when importing works order lines and there is a finished item so that the associated project transactions are set correctly. [#12958]
Fix to check the ‘Default for component warehouses’ instead of the ‘Default when component’ stock item setting when generating a works order from sales order, to set the ‘Default component’ warehouse on a works order. [#12985]
Fix to correctly enable and disable the project control when there is no finished item and a works order line has been issued or time has been added against Labour/Machine lines. [#13139]
Fix to improve getting sales order details that are associated to works order to help with searching on the works order desktop list. [“Database timeouts”]

Material Resource and Planning

Fix for ‘Future Stock Movements’ and ‘Suggested Stock Transfer’ quantities to handle when stock transfer item has been allocated to multiple times. [#13000]
Fix for inflated kitting suggestions when a kit is part of another kit and the parent kit is on a sales order and then there is active kits within the system. [#13090]

Kitting

Fix for full ‘Labour/Machine’ postings being posted when a kit is part built. [#12811]

Date applied: January 29, 2025

221.0.84

Works Order Processing

Fix for Sage closing abruptly when backflushing a works order with a large number of sub assemblies.
Fix to not leave a traceable item as ‘reserved’ when originally booking a finished item that requires a backflush but the backflush does not complete.
Fix to only enable the ‘batch print’ and ‘Update from BOM’ buttons on the works order screen when the user is able to use them. issue where these were enabled before the works order was created causing an error when pressed. [“Object reference error”]
Fix to use the correct price when creating pos from a works order and using eps (POP008) function ‘Supplier quantity price breaks’ and the supplier is in a foreign currency.
Fix for stock item settings not being correctly loaded when switching between items.
Fix for ‘Miscellaneous’ items not working correctly when they haven’t been confirmed and the cost of them is included in the finished item with the settings ‘reduce line quantity when booking’, ‘remove unused lines when booking’ and ‘zero unneeded lines when booking’. Issue would occur where the cost of miscellaneous items were being included when they were not confirmed and a works order would be booked and completed.
Fix for ‘Fixed length quantity’ being ignored when creating a works order. Issue when a larger quantity was entered and the operation quantity would be set via the works order quantity, causing inflated operation times.
Fix when creating a works order with operations and there is a fixed length but no fixed quantity. [“Attempt to divide by 0”]
Fix to correctly set a works order due date when the setting ‘Only use production lead time for works orders’ is enabled and the date would go further back than today’s date.
Fix to not allow a works order to be split if a miscellaneous item has been ‘Confirmed’ on it.
Fix when viewing the work in progress (summary) report and the machine costs would be shown as the same as the labour costs.

Material Resource Planning

Fix for MRP stock settings not remaining when switching between tabs on a stock item.
Fix to set the correct delivery address when creating a stock transfer from MRP (Suggested Stock Transfer) so that it is set as the destination warehouse.

Kitting

Fix to display the traceable information popup when building a traceable kit item when the traceable generation type is not ‘Do not generate’ and the item has ‘Has Compulsory Attributes’ or ‘Uses Use by Dates’ or ‘Uses Sell by Dates’ or ‘Uses Alternative Refs’.
Fix to correctly populate the finished item bin on a kit. Issue attempting to build a kit and the finished item bin was not set correctly.

Date applied: January 15, 2025

221.0.83

Works Order Processing

Timesheets retain links to works orders.
The add extra quantity works order material setting is now applied to subcontract works order lines but not the finished goods quantity.
Fix backflush ‘Stock item ‘xxxxxx’ has been allocated and issued’ shown in messages list despite no stock being allocated/issued.
Fix works order maintenance ‘Book’ button causing screen rescaling when display resolution is not 100%.

Material Resource Planning

Fixed an issue where some works order suggestions were not raised if allow over ordering is off. this would happen if there were suggested works orders for multiple BOM.

Date applied: January 2, 2025

221.0.82

Works Order Processing

Fix backflush from barcoding device ‘object reference not set …’ error when works order components are traceable, #12208.
Fix issue where the area on the operation of the BOM that is duplicated was not set on the operation of the new BOM.
Prevent quantity adjustment of miscellaneous items on a works order once they are confirmed; simply unallocate the item first if you need to adjust the quantity.
Inform that child rows do not stay selected when collapsing the tree on the processing works orders screen, and provide the option to confirm when using “collapse”.
Fix ‘frmbaseworksordertreeview.updateprogress(int, int, string)’ is inaccessible due to its protection level’ build error.
Ensure checked sub-assemblies take precedence from a checked parent works order when putting them on hold.
Update sub-assembly on-hold toggle changes to deal with child/sub-assembly works orders, add progress bar, case 44275, 44651.
Allow overriding of default works order numbers in the trial kitting grid before creating them when the auto-generate works order number setting is unchecked.
Prevent error saving a sales order line related to allocations following allocation from a works order.
Include ‘machine’ times for ‘estimated’ and ‘actual’ times when viewing the ‘works order scheduling’.
Fix timesheet error display when saving a timesheet after entering a project timesheet line, if the first line is a works order type and the project type for the subsequent line is not selected but defaulted.
Prevent stock item changes during backflushing of a works order on the booking in stage; also prevent warehouse changes if the line is preallocated.
Prevent errors when attempting to ‘amend works order’ on the backflush screen for lines that are ‘invalid’.
Prevent allocation/issue of more than the outstanding amount when using the ‘bulk issue’ screen; refresh the grid after allocation/issue to stop the same works orders being allocated/issued multiple times.
Refresh ‘free stock’ values after allocate and issue on the ‘bulk issue’ screen.
Inform the user when updating works order line quantities that any miscellaneous lines that have been allocated (“confirmed”) will not be updated unless unallocated.
Fix issue completing a works order that is linked to a project and no sales order.
Fix incorrect deletion of works orders from the ‘process works orders’ screen.
Fix subcontractor advice note ‘the report could not be generated. no data was returned for this report’ error when dispatching multiple sub-contract lines, case 43797.

Material Resource Planning

Reduce memory use + improve performance when generating suggested purchase orders using warehouse hierarchy, case 43114.
Refresh ‘suggested purchase order’ tab correctly after a suggested purchase order has been deleted and the screen is filtered. {“unable to update the object (sicon.sage200.materialplanning.objects.simrpsuggestedpoline, x), as the object has been deleted”}
Prevent suggested purchase orders from being created for items marked as ‘do not include in MRP’.
Correctly calculate the ‘unit price’ of a suggested purchase order with multiple units of measure and an override buying unit price, case 43114.
Correct ‘future stock movements’ view when checking ‘WAP requisition’ entries incorrectly displayed on the ‘future stock movements’ screen.
Continue to update the ‘COS’ transaction on a project once the works order has been booked in, if the ‘allow book before issue’ setting is enabled and the works order is linked to a sales order.
Update sales order header total values for lines with manual prices when editing a finished item quantity linked to a sales order line.
Prevent duplicate barcodes for operations when ‘splitting’ or ‘copying’ a works order.
Pull notes from a subcontract operation when manually adding the subcontract to a works order.
Fix validation for unbooking serial items, ensuring available serials are in the correct bin, preventing errors further in the unbooking process.
Prevent updates to ‘completed’ sub-assemblies when using the ‘update from BOM’ feature.
Fix correct status setting of a works order when it only contains miscellaneous items.

Kitting

Fix issue when building a kit (mainly from barcoding) where the finished item is traceable, and the number is not auto-generated, then an error may appear ‘cannot update field traceableitemdbkey with a null value’.
Fix incorrect text being displayed on the ‘name’ dropdown for build kit.
Use priority bin for the kit item when creating kits from sales orders from the kit suggestion pop up and improve the message if you try to build kits where the designated bin was removed for the kit item.
Check user access to kitting before running kitting when running standalone MRP, ensuring the same user is used each time we check for MRP settings.

General

Fix leaving the stock item code or name selection without selecting a stock item. {“object reference error”}
Fix error when amending multiple stock items and then switching from one item to another.
Prevent message ‘the data on this screen has not been saved. would you like to save the data before closing the screen?’ from appearing when amending multiple stock items.
Update the data model to include ‘siworksorderquantityview’, ‘siworksorderunallocatedview’, and ‘siworksorderallocatedview’.

Date applied: December 11, 2024

221.0.81

Works Order Processing

Fix to pull the notes from a sub contract operation when manually adding the sub contract to a works order.

Material Resource Planning

Updated the data model to include ‘SiWorksOrderQuantityView’, ‘SiWorksOrderUnallocatedView’ and ‘SiWorksOrderAllocatedView’
Corrected the ‘Future Stock Movements’ view when checking ‘WAP Requestion’ entries that were being incorrectly displayed on the ‘Future Stock Movements’ screen.
Fix for the ‘Suggested Purchase Order’ tab not correctly refreshing after a suggested purchase order has been deleted and the screen is filtered. [“Unable to update the object (Sicon.Sage200.Materialplanning.Objects.SiMRPSuggestedPOLine, x), as the object has been deleted”]

Kitting

Fix when leaving the stock item code or name selection without selecting a stock item on the ‘Build Kit’ screen. [“Object reference error”]
Fixed issue when building a kit (mainly from barcoding) where the finished item is traceable, and the number is not auto generated, then an error may appear ‘cannot update field traceableitemdbkey with a null value’.

Date applied: November 27, 2024

221.0.80

Works Order Processing

Fix backflush from barcoding device ‘Object reference not set …’ error when works order components are traceable.
Fix to also check the ‘Default bought’/’Default buy’ field on a stock item as to whether to create a sub assembly when using the ‘Update from BOM’ feature.
Fix when using the ‘Update from BOM’ feature and it would calculate incorrect new quantities for items with unit of measure.
Fix to reinstate the sub assembly popup form when using the ‘Update from BOM’ feature to create sub assemblies.
Fix for incorrectly removing when a works order line has been updated from a component line to a sub assembly from the ‘Update from BOM’ log.
Fix to load the correct BOM when a works order finished item has changed when using the ‘Update from BOM’ feature. no longer allow the Update from BOM’ feature to work with multiple finished items.
Removed the restriction for receiving a sub contract purchase order in when completing a works order and using the setting ‘Allow book before issue’ and ‘Unconfirmed costs’ is turned off.
Fix when creating a works order with sub contracts to link the finished item to the sub contract.
Fix for ‘Deleted’ works orders appearing when filtering on the ‘Process Works Orders’ screen.
Fix when retrieving the default component warehouse for a works order to fall back to the default WOP settings, if not then select a warehouse associated to. Issue found when creating a works order from a sales order using the workflow options.
Fix when backflushing a works order via the web API method ‘api/worksorderbackflushapi/backflushworksorder’ and the setting ‘Hide add stock button on backflush’ enabled, to not allow a works order to be backflushed if there is not enough stock of all the components available.
Fix when part backflushing an item with sub assemblies and this would cause the sub assembly to be booked in twice.

Material Resource Planning

Fix for incorrect suggested works orders dependent on min stock levels and starting stock levels.
Fix when running MRP with date filters and a works order with multiple preallocations and it would produce incorrect suggestions for works order that were already preallocated.
Fix for incorrect suggested works order quantities when there are preallocations associated to the works order line.
Fix to handle multiple preallocations to a sales order when running MRP suggested purchase orders for the correct results to be shown

Kitting

Fix to add a kit line to back order on a sop with value of 0 when not using the setting ‘Use sum of component selling prices on sales order line.’.
Fix for an issue loading the ‘Build Kit’ screen with a large amount of templates and the setting ‘allow building kits without templates’ disabled. [“Out of Memory”]
When building a kit from barcoding, the stock attributes, sell by date, use by date and additional reference were not stored against the traceable item if the finished item is traceable.
Auto numbering for traceable finished items on kits was not working (also when building kits from barcoding).

Date applied: November 13, 2024

221.0.79

Issues Resolved

Works Order Processing

Fix when loading the labour transactions causing a big red cross on the grid. [“Attempt to divide by zero”]
Fix to make sure the same logic is applied for selecting the ‘Finished Item’ warehouse and ‘Component’ warehouse when generating a works orders from MRP, generate a wo from so and workflow.
Fix when updating a promised date on a sales order which is linked to a works order with operations but no SiOperationLines have been created for the SiOperation. [“Object reference error”]
Updated the message if a works order cannot be deleted so it informs the user which works cannot be deleted and why. Also if multiple works orders are checked and it cannot delete a works order it will continue to delete what it can.
Filter by ‘WO Number’ or ‘WO Name’ or ‘From Estimate’ will override all other filters on the ‘Process Works Order’ screen.
Fix when posting a purchase invoice where the line is associated to a works order line. [“Database timeout”]
Fix when booking in a works order to validate if the item is in negative stock and is preallocated. If this is the case inform the user that the preallocation will be deleted.
Fix to not allow quarantine warehouses to be selected as the ‘Finished Item’ warehouse when creating a works order.
Fix to make sure works order comments are saved if they are entered before the user has created the works order.
Fix book in finished goods ‘Action failed unavailable batch items’ error for traceable items if pre allocations exist and more batch/serial items are being received than required for the pre allocations.
Fix to not remove miscellaneous stock items if the setting ‘Remove unneeded line when booking’ is enabled.

Material Resource and Planning

Fix to allow the MRP setting ‘Split purchase orders by warehouse when creating from suggestions’ to be turned off.

Change in Functionality

Works Order Processing

Added a ‘Sort By’ filter to the ‘Process Works Orders’ and ‘complete works orders’ screen, which only the parent works order in the tree view will follow.

Date applied: October 30, 2024

221.0.78

Works Order Processing

Handle if the machine efficiency is set to 0%. It was previously displaying a divide by zero error when creating the works order. Also added a warning when saving the machine in the machine registry.
Fixed issue when deleting works orders from the ‘Process Works Order’ screen and a message ‘Unable to locate works order with works order id #’ was popping up if deleting sub assemblies as well.
Fix for the use by and sell by date on the traceable item not saving when it was manually updated when booking in.
Fix backflush add stock button not adding new stock when warehouse hierarchy is enabled, instead the errors list is simply refreshed.
Fixed issue where copy and paste identification number into the search box when issuing component lines during a back flush was causing a cross thread error.
Fix when opening the ‘Unconfirmed lines’ screen. [“Object Reference Error”]
Fix to update the ‘Unconfirmed’ message when attempting to complete works orders when the issue is that the sub contract line has not been received and not using unconfirmed costs.
Fix to also update the operation ‘Completed’ quantity when a works order has been deleted.
Fix works order un issue components ‘System Out of Memory’ error and confirmation message no longer reports the un issue if cancelled by the user.
Fix to display the correct ‘Labour’ and ‘machine’ costs on the ‘WIP summary’ report dependent upon Labour/Machine costing settings.
Fix to improve the performance when using ‘Update from BOM’ feature.
Fix to allow works orders with sub contracts to be completed via the ‘Complete Works Orders’ screen when there is a sub contract associated to it and it has been received but not invoiced and ‘unconfirmed costs’ are turned off.
Fix to correctly calculate the ‘Timesheet Line Quantity’ when viewing the ‘Labour’ tab on a works order.
Fix when adding a new timesheet line via the timesheet entry that was a ‘Works Order’ line and the works order cost transaction was not created.
Fix for duplicate ‘SiconStockAttribute’ entries being made when amending a sales order line and not selecting the ‘manufacturing’ tab.
Fix to set the ‘Unit Cost’ of a labour line to 0 when a timesheet has been added for that line and the costing method is to use ‘actual’ for labour lines.
Fix when creating a works order from the ‘Generate Works Order from Sales Order’ screen when there is no ‘Promised Date’ set on the associated sales order. instead the ‘Due Date’ for the works order will be set to today’s date. a warning will be displayed on screen for the user about this too.
Fix for the estimate conversion screen incorrectly popping up when saving a sales order and then causing the screen to hang on save.
Fix to inform the user if a works order line cannot be added to the works order if the stock item has no locations set against it. [“Object Reference Error”]
Fix when attempting to allocate a works order using the allocation setting ‘Use Specific Bin’. [“No bin with free stock available can be found for ‘StockItem'”]
Fix when adding a new finished item to a works order and adding materials with a sub assembly and this would cause sage to hang.
When adding a new works order for a subassembly item, honor the “‘Always ask before generating subassembly”‘ on the stock item Sicon setting.
Works orders when generating subcontracts for multiple finished items ensure the subcontract line details are not duplicated on the subcontract tab.
When generating the purchase order lines from sub contracts exclude any leading and trailing blank lines from the item description.

Material Resource Planning

Fix future stock movements balances incorrectly calculated due to ‘Predicted Sales Over Lead Time’ transactions being omitted from the list. Also fix hourglass not shown during refresh and movements list not updated after the movement types filter is applied.
Fix for standalone MRP displaying the company id of 0 when it has connected to a company.
Fix for ‘Direct PO’ suggestions being missed when running MRP.
Fix when creating purchase orders from MRP on sage version 12.0.0.0054 and above. [“The maximum stock level for the item will be exceeded.”]
Deleted and former employees (Projects) are not shown on the employee resource scheduler (Capacity Planning) nor on the employee tab on the rough cut scheduler.

Date applied: October 16, 2024

221.0.77

Works Order Processing

Fix backflush add stock button not adding new stock when warehouse hierarchy is enabled.
Works orders no longer recalculates costing for non labour operations from the timesheet save on the labour tab.
Fix when adding a new finished item to a works order and adding materials with a sub assembly and this would cause sage to hang.
Fix to display the correct ‘Labour’ and ‘Machine’ costs on the ‘WIP summary’ report dependant upon labour/machine costing settings.

Material Resource Planning

Fix for ‘Direct PO’ suggestions being missed when running MRP.
Fix for standalone MRP displaying the company id of 0 when it has connected to a company.

Date applied: October 2, 2024

221.0.76

Issues Resolved

Works Order Processing

Works orders improved date validation on the process works order screen.
Fix to auto populate the quantity for a works order via the bill of materials when switching between Bill of Materials to create before creating a works order.
Works orders tab data will also be refreshed on the projects enquiry screen when the refresh button is hit.
Fix when using unconfirmed costs and receiving a purchase order where the component has been used on a works order line and it would incorrectly recalculate the cost. this would happen when issuing and unissuing the line multiple times.
Fix to add some validation before printing the ‘Expediting’ report to check that ‘Expediting’ form has been run against this works order so that the colours appear correctly in the report.
Fix print picking list ‘No data was returned for this report’ error after a works order number has been updated following preallocation creation.
Fix to display works orders with no finished items on the ‘Process Works Orders’ and ‘Complete Works Orders’ screen.
Fix ‘Process Works Orders’ screen buttons automatically selecting subassemblies, despite not checked/ticked in the list.
Allow the project on a works order to be changed when it is linked to a sales order and the project is ‘N/A’. Also pull the same project as the sales order when using the ‘Generate Works Orders for Non Built Items’ menu option.
Fix when completing works orders associated to projects and attempting to post a variance to the project [“Unable to reconcile project transaction. can’t find nominal record (urn: nl: // value:)”].
Fix when adjusting a works order quantity and changing the works order lines, if the lines are allocated and we increase the line quantity to not unallocate and the reallocate the line. if the line is reduced and the allocation setting ‘Select Bin’ is true handle reallocating the line [“dicbinsandqtys object was returned as null by method sicon.sage200.worksorder.objects.coordinators.allocationcoordinator.getbinsandquantitiesforallocation()”].
Fix to correctly update the ‘Completed Quantity’ of an operation when removing/deleting a timesheet line from the ‘timesheet entry’ screen.
Fix for correctly calculating the ‘Future Buying Price’ of a part issued works order line when updating the quantity of the line.
Fix for the ‘Update from BOM information’ incorrectly removing ‘Failed’ updates.
Fix to reset the ‘IsIssued’ flag when an issued line has been increased from the ‘Update from BOM’ routine.

Material Resource Planning

Improved integration with MRP and Approvals requestions for receiving orders through Sage as well as via Approvals.
Fix for incorrect ‘Warehouse Stock’ preallocations being created in MRP, which would lead to incorrect ‘auto stock transfers’ being displayed on the ‘future stock movements’ screen.
Fix to correctly filter the ‘Future Stock Movements’ screen when changing which warehouses to be displayed.
Fix for MRP creating suggestions to arrive too late and grouping them into larger suggestions for ‘Min Stock’ or ‘Reorder Level’ only suggestions when the setting ‘Separate Suggestions per Warehouse’ is disabled.
Fix for MRP not producing any ‘Suggested Purchase Orders’ when ‘Rescheduling’ is enabled.
Fix to correctly set the ‘Default Purchasing Warehouse’ from warehouse hierarchy as the warehouse for a suggestion when the suggestion type is ‘Min Stock’ or ‘Reorder Level’ when running MRP with ‘Warehouse Hierarchy’ enabled.
Fix to validate whether a purchase order line that is associated to a sub contract line has been despatched before the user attempts to receive that line in when attempting to receive the sub contract from ‘Purchase Order Processing’ in Sage.

Change in Functionality

Works Order Processing

‘Process Works Orders’ and ‘Complete Works Order’ screens now have new selection filters to allow you to list the works orders with unissued and unconfirmed works order lines
Removed the sorting on the ‘Process Works Order’ and ‘Complete Works Order’ screens.

Material Resource Planning

Updated the ‘split’ po function for ‘suggested purchase orders’ so that the user can split a new purchase order out with a greater quantity than was originally suggested and if there is no reason for this new purchase order line then it will be given the reason ‘split purchase order line’ allowing this line to still be created.

Date applied: September 18, 2024

221.0.75

Issues Resolved New Features

Issues Resolved

Works Order Processing

Fix when filtering the ‘Suggested Works Order’ tab, ‘Process Works Orders’ or ‘Complete Works Orders’ screens by ‘Stock Item Analysis Codes’ and the user would get an error. [“Invalid Object Name SIWorksOrderProcessView”]
Fix when using the web API ‘Update Sage BOM’ where components are removed that are currently allocated to a sage BOM build, to allow these components to be deleted . [“‘the delete statement conflicted with the reference constraint \”‘fk_wopbomcomponentlinelink_bomcomponentline\”‘. the conflict occurred in database \x\”‘, table \”‘dbo.wopbomcomponentlinelink\”‘, column ‘bomcomponentlineid’.\r\nthe statement has been terminated.”‘]
Fix when unissuing a works order line where the original bin it was issued from has been deleted. [“Object Reference Error”]
Fix to enforce that the ‘Appointment Calculation Interval’ setting on the ‘Dates’ tab can only be ’15’, ’30’ or ’60’.
Fix to allow finished item preallocations to be deleted from the works order ‘Preallocation’ tab, if the works order is not linked to a sales order or has has some booked.
Reintroduced the route ‘api/operationworksorderline/{sioperationid}’ for updating works order operations.
Fix to allow ‘Miscellaneous’ item quantities to put updated when using the ‘Edit All Quantities’ screen on a works order.
Fix to not allow the ‘Yield’ value on a BOM record to be above 100.

Material Resource Planning

Improved the handling of closing the MRP screen while it is still running and give the user the option to not close the form if it is still running. [“‘Thread was being aborted.”‘]
Fix when viewing the ‘Future Stock Movements’ screen [‘Unable to update the object(sicon.sage200.materialplanning.objects.simrpsuggestedpoline, ), as the object has been deleted”]
Fix for when viewing the ‘Future Stock Movements’ and ‘Auto Stock Transfers’ were appearing to be too low when there was a purchase order for multiple reasons.
Fix to give the user a message when cancelling the creation of works orders from MRP so that it will stop creating them after the one it is creating. issue where after closing the screen it would continue to create the works orders.

Kitting

Fix to correctly set the ‘Kit Cost’ field on a sop quote when a kit is linked to the quote line.
Fix when building traceable kit items on the fly and then attempting to allocate them to a sales order when they are built. [“The quantity to allocate is greater than the quantity available at the location.”]

Shop Floor Data Capture

Fixed issue when booking in finished item for a copied works order via SFDC, the identification number of the batch was the previous works order number, and not the new works order number.

Change in Functionality

Works Order Processing

Added bespoke setting to show inspection templates when amending a component stock item.

Material Resource Planning

Expanded the ‘display waring on MRP has results if new orders have been placed for stock items since MRP has run’ to work with suggested kits.

Date applied: September 4, 2024

221.0.74

New Features

Works Order Processing

Added the ability to to convert estimates to works orders when converting quotes to sales orders from Sicon CRM.

Issues Resolved

Works Order Processing

When completing an operation, the area on the works order is moving to the next area (linked to the next operation). But it wasn’t excluding deleted operations. It now does exclude deleted operations on the works order.
Fix when changing the ‘Promised Delivery Date’ on a sales order line and the works order popup to update works order dates would cause Sage to be ‘Minimised’ or go to the back of the desktop.
Fix to set the ‘Finished Item Warehouse’ to be same as the demand warehouse if this has been set for sub assemblies after looking at the stock item settings first.
Fix when issuing traceable components and the setting ‘Show Traceable Issue Adjustment Screen’ is enabled and the user would get an error [“Object Reference Error”]
Fix to filter out deleted works orders to be selected when entering a timesheet.
Fix to allow the sales order dropdown to be filtered by the users inputted text on the ‘Generate Works Order from Sales Order’ screen.
Fix when amending a purchase orders status from ‘Amend Order Status’ which has a sub contract associated to it and this would in turn remove the link between other sub contracts and their purchase orders.
The inspection tab on the Amend stock item screen was not appearing for some stock items, and appearing for others that are not built items.
Fix when using the ‘Update From BOM’ routine where an item appears multiple times on a BOM and this would incorrectly calculate the lines new quantity.
Improved logging messages displayed to the user when lines have not changed.
Fix when updated the run time for a labour item and the ‘Estimate Quantity’ on the ‘Labour’ tab would not update or refresh after save.
Fix to filter ‘Deleted’ works orders when viewing an ‘Item Balances’ so the correct value is shown in the ‘Quantity on WO’ column.
Fix to fetch the latest ‘Unit Cost’ for operation lines (Labour/Machine) when copying works orders.
Adjust Works Order Booking checks for Works Orders created with Create Empty Works Order.
Fix to honour the setting ‘Only use Production Lead Time for Works Orders’ when changing the due or start date of a works order when the works order has operations on it.
Fix when the setting ‘Book Finished Item when receiving Sub Contract’ is enabled and booking in a works order after receiving the purchase order for a sub contract, to include the cost of the sub contract in the finished goods cost.

Material Resource Planning

Adjust forecasts form to force dd/mm/yyyy format.
The machine demand on the overall tab on the rough cut screen was showing labour demand instead of the machine demand.
Prevent error when calculating a Sales Order you have created by converting a Pro Forma [“Index out of Range”]

Date applied: August 21, 2024

221.0.73

Works Order Processing

Fix to allow completed purchase orders to be viewed from sub contracts.
Fix to allow preallocations to be amended when a works order is associated to a Sicon Project. Only the ‘Finished Item’ preallocation will be locked down if the works order is associated to a sales order and Project OR if the works order is associated to a project and some of the works order has been booked in.
Fix re apply the users chosen sort columns after refreshing the datasource for the components and finished items list.
Fixed error that would appear when allocating misc stock item works order line and warehouse hierarchy is on. ‘Specified argument was out of range of valid values’.
Fix to display the purchase order document number on the sub contracts tab. This will allow PO numbers to be visible on the works order at all times, including completed.
Fixed issue where the delay time was not added to the remaining hours on the operations screen when editing the run time fields.
Fix for the ‘Production Date’ not saving when it is amending on the ‘Additional Info’ tab.
Fix to allocate sub assembly lines after operations have been added, when the sub assembly setting ‘Allocate sub assembly from free stock is available’ is enabled, so that if the line is required for an operation it can be split for the operation.
Fix Allow user to unbook a Works Order where the returned traceable build item quantities cannot be retrieved from history using the finished item.
Fix to not allow ‘Warehouse Hierarchy’ and ‘Show allocations screen to split allocations across multiple warehouses’ settings to be enabled at the same time.
Fix to display the correct ‘Free Stock’ on a works order when ‘Warehouse Hierarchy’ is enabled.
Fix for correctly validating whether a line can be allocated when using ‘Backflush’.
Fix Process works orders screen now allows multiple works orders to be selected for label printing.
Fix Update the Works Order Start Date when modifying the Works Order Due Date from SOP Order Line form.
Fix to display the purchase order document number on the sub contracts tab. This will allow PO numbers to be visible on the works order at all times, including completed.
Fix Exclude deleted Works Orders when retrieving by Works Order Number to prevent APIs from adding lines and operations to the deleted WO rather than the live WO.

Material Resource Processing

Fix to filter out any deleted supplier quantity breaks when getting the price of a suggested purchase order line and using ‘Sicon Enhancement Pack POP008: Supplier Price Lists with Quantity Breaks’.
Fix for ‘Suggested Auto Stock Transfers’ displaying to high of a quantity for the required demand.
Fix to also display the ‘Preferred supplier lead time’ when viewing the ‘Future Stock Movements’ screen.
Fix for duplicate entries on the ‘Future Stock Movements’ screen for ‘Project Issue’ lines when the setting ‘AutoIssueAfterGoodsReceived’ is enabled and the associated purchase order.
Fix Move the Show Confirmed Checkbox setting to its own Advanced Features tab and use it to control when it appears and is populated on the Purchase Order Line form.

Date applied: August 7, 2024

221.0.72

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

Issues Resolved

Works Order Processing

Fix to display the ‘Customer Name’ when a works order is linked to a sales order on the ‘Process Works Orders’ screen.
Labour cost and quantity processing when apportioning quantity and remove labour lines from the Labour Items Actual Transactions Panel.
Fixed issue where the works order created from a sales order line was not using the warehouse of the sales order line for the finished item of the works order. The sales order line warehouse will now be used unless there are warehouses set on the stock item to override.
Fix for calculating the correct cost and variance when scrapping finished items that are ‘Standard Cost’.
Disable Complete button if finished item added on an empty works order, disable Add if components or labour/machine lines are issued.
Fix for the Start time reverting to 9AM on works order settings.
Fix for incorrectly highlight the WO BOM Version on the works order desktop list when the columns are rearranged.
Fixed issue where allocating with warehouse hierarchy on, would return a message saying no stock available, as it was trying to allocate against the incorrect warehouse.
Populate Works Order Comment with the Order Number, Stock Item Description (including and amendment) and the Stock Item Code when generating a Works Order from a Sales Order.

Material Resource Planning

Fixed error when running MRP and using warehouse hierarchy when the warehouse required is not found on the stock item. It will now use the first warehouse on the stock item if a warehouse to use is not found. [“Object Reference Error”]
Fixed issue where allocating with warehouse hierarchy on, would return a message saying no stock available, as it was trying to allocate against the incorrect warehouse.
Fix to load selected warehouses correctly when opening the ‘Future Stock Movements’ screen.
Fix to also make sure the ‘Future Stock Movements’ screen opens with the correct selected warehouse when using ‘Warehouse Hierarchy’ in MRP from the ‘Suggested Works Order’ tab and the ‘Suggested Purchase Order’ tab.
Fixed rescheduling to work for items that have no suggestions. Also made sure that we checked the ‘Production lead time calculation in working days’ setting when calculating the works order completion date for suggestions.
Fix for duplicates appearing on the ‘Suggested Works Order’ tab when there are multiple units of measure.
When creating a WO Approvals Requisition form MRP, the Description column is populated with the Item Description on the Stock Item line.
Fixed when running MRP and using warehouse hierarchy when the warehouse required is not found on the stock item. It will now use the first warehouse on the stock item if a warehouse to use is not found. [“Object Reference Error “]

Kitting

Fix to correctly update the cost of a kit line when the item is FIFO. Issue where it would set the ‘Total Cost’ using the ‘Average Buying Price’ of the stock item instead of using the actual ‘Issued’ cost of the kit line component.
Fix when building a kit which has components that are ‘Miscellaneous’ to multiple the cost of these components by the quantity of the kit line.
Fix to correctly display the ‘Actual Cost Per Kit Line’ when a kit is fully built.

Change in Functionality

Works Order Processing

Added a new setting to handle if a purchase order lines item description should use the associated works order lines comment or use the stock items name or description dependent on the stock items settings

Material Resource Planning

Added a new setting to handle if a purchase order lines item description should use the associated works order lines comment or use the stock items name or description dependent on the stock items settings

Date applied: July 24, 2024

221.0.71

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

Issues Resolved

Works Order Processing

Allow WIP Summary data to be exported via the context menu.
Extended the length of ‘SiWorksOrderLine’ ‘LineText’ to 4000 characters.
Fix when using ‘Unconfirmed Costs’ to include traceable items when the goods have been received and then filter the purchase order transaction types so there is not duplicate when the purchase order has been invoiced on the ‘Traceable Enquiry’ screen.
Fix to not allow the user to set a works order line quantity to 0 when using the ‘Edit All Quantities’ feature.
Fix to move the warning “Please add a location first.” to the stock item tab itself. Issue where this would keep being displayed on a new stock item when there is a combination of just Contracts and Manufacturing installed.
Fixed issue where the quantity on the operation was changing/set incorrectly when viewing a works order operation when it should equal the quantity of the works order. Also disabled the expected hours text box.
Fix for opening a works order screen speed when warehouse hierarchy is enable for works orders.
Fix to update the quantity and expected hours of an operation when the works order quantity changes.
Fix to correctly display the ‘Line Cost’ and ‘Machine Cost’ of a machine line on the ‘Machine’ tab of a works order.
Disable Complete button if finished item added, Disable Add if components issued on an empty works order.

Material Resource Planning

Fix to display ‘Suggested Auto Stock Transfers’ on the ‘Future Stock Movements’ screen when there is a suggested purchase order that has been generated for a different warehouse to where the demand is as when the purchase order has been received the preallocation will move the stock to a Sicon stock transfer to be transferred to the original demand.
Fix to add reasons to ‘Suggested Stock Transfers’ in MRP.
Fix for creating suggested stock transfers for any movements before the earliest movement date. Issue where it would appear suggested stock transfers were including the supplier lead times in the transfer date.

Kitting

If a kit quantity is increased, and there is a linked preallocation, then the preallocation will increase as well.
If the sales order line quantity is increased, and the kit quantity is increased, then it would leave a reserved quantity on the WarehouseItem and the StockItem.
Fix issue where there is no free stock, and the sales order line quantity is increased, the user would be asked if they wanted to create a new kit for the sales order line instead of increasing the quantity of the already linked kit.

Change in Functionality

Works Order Processing

Added new menu item to add inspection results for booked in works orders.

Date applied: July 10, 2024

221.0.70

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

Issues Resolved

Works Order Processing

Fix when part completing a part booked works order and it would generation an incorrect and inflated variance posting (‘Book in difference in cost’). This would be due the works order line cost being incorrectly recalculated.
Fix to also not change the ‘IsIssued’ status of ‘Misc’ item works order lines when editing quantities or using the ‘Reduce Lines to Issued Quantity’ buttons.
Fix when confirming costs of a purchase order line when they are linked to a works order line and unconfirmed costs is turned on and the line has been issued and unissued and this would recalculate the LineCost incorrectly and therefore when completing the works order it would generate an inflated ‘Variance’ posting.
Fix to allow works order to be booked in when the setting ‘Reduce line quantity when booking’ is enabled and ‘Allow book before issue’ is not enabled and not all the works order lines have been issued. [“To book in the last item on this Works Order, all components must be issued”]
Fix archive tab on the View Traceable History screen to retrieve the grid details. [“Unable to cast object of X to type Y”]
Prevent user from modifying the Finished Goods Quantity for “Booked” Work Orders, but this check will be bypassed when the Works Order is flagged as ‘Continuous’.
Reduced Current Stock level by to show only the free stock, not the in stock figure. Issue when viewing stock running balances.
Improved the speed when creating works orders with operations. Can also get stuck when creating multiple works order from MRP.

Material Resource Planning

Fix for suggested POs suggesting a larger quantity than is required when the stock item uses ‘Minimum and Usual order quantities’ and the quantity is for the minimum order quantity however it would then add the ‘Usual order quantity’ onto this incorrectly.
Fix to make sure the MRP setting ‘Separate suggestions per warehouse’ is enabled when ‘Warehouse Hierarchy’ is enabled. Issue where this was not enabled and then suggested stock transfers were not being created.
Corrected the link to the latest help and user guide.
Exclude stock items where they are marked as “Do not include item in Materials Planning” for the warnings checks for Suggested Purchase Orders section of MRP process.
Fix when grouping sub assemblies in MRP to correctly update the reason to the new grouped works order line so that it can be correctly preallocted when they are created.
Fix to also correctly updated the reason document numbers when a works order has been created. This allows parent works orders to be created before the grouped sub assembly and then once the sub assembly has been created it will correctly preallocate to the parent works order line.

Kitting

Corrected the link to the latest help and user guide.
Allow for Kit Component Quantities to be recalculated when the Quotation Line Quantity has changed.

Change in Functionality

Material Resource Planning

In Future Stock Movements screen, added Purchase Order buffer days in the Summary section when PO or Suggested PO lines are selected.
- Previously, the delivery buffer days field was visible, but not the Purchase Order buffer days field. The intention behind displaying this is to make it clearer why a purchase suggestion has been made on a particular date.

Date applied: June 26, 2024

221.0.69

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

New Features

Works Order Processing

Added the ability to complete ‘Empty Works Orders’ and therefore post ‘Actual’ transactions for non stock items against a project.

Within Sicon Works Order Processing, it has always been possible to create an empty Works Order (Sicon Works Order Processing – Works Orders – Create New Empty Works Order). This might be used to track stock that has been issued as part of another process (that doesn’t require building a finished item). Once all the components have been issued on an empty Works Order, the Works Order status changes to Booked and that’s how it stays…. until now!

For sites integrating Works Order Processing with Sicon Projects, this could be confusing in terms of viewing actual and estimated costs on the project. As there is no finished item to book in, there was no trigger to move the costs from estimated to actual, like there is on a standard works order, so a booked Works Order can still show committed costs:

With the new Complete routine, the relevant costs are moved from committed to actual:

There is a bit more to it than just moving the costs to actual, so have a look through the “Create New Empty Works Orders” section of the Works Order Processing Help & User Guide for more information on the postings that will be made, along with some recommended settings, before using this feature.

Issues Resolved

Works Order Processing

Fix to correctly export the ‘Type’ field when exporting the works order history tab.
Fix when viewing the ‘Works Order Expediting’ screen to exclude suggested movements when calculating the free stock. Issue where to would display not enough free stock on lines when there was enough free stock.
Changing the Timesheet Entry Type in Project settings now updates the ‘Use hours instead of start and end time in timesheets’ tick box in WOP settings.

Kitting

Fix to use the kit reference for batch numbers when the stock item is set to use ‘Order and Sequence’

Date applied: June 12, 2024

221.0.68

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

Issues Resolved

Works Order Processing

Fix to remove the project transaction if the user sets the Project to ‘N/A’.
Fix when multiple works orders for the same sales order are associated to the same project and then it would incorrectly only post 1 committed transaction. This can happen when a works order has a max batch size associated to it.
Fix when creating PO’s from a works order to honour the suppliers ‘Pricing Source’. Previous issue where it would only set the price as the suppliers ‘List Price’ and not ‘Last Buying Price’.
Fix to truncate the works order history reason when it is above 2000 characters long [“Cannot set the value of field (.Reason) to ‘xxxx’]
Fix to auto uncheck sub assembly options on the ‘Sub Assembly Creation’ form if these have not been manually entered and another option has been selected so that selection will auto populate with the required quantity. This will also select this option and auto populate with the amount left that is required if the user has set values in another sub assembly option.
Fix for duplicate ‘Sicon Stock Attribute’ entries being made when amending a works order.
Fix to exclude estimates from the ‘Process Works Order’ screen.

Material Resource Planning

Sicon Tab on Amend Customer Account and Create Customer Account includes the MRP tab (rather than having a separate MRP tab)
Fix when selecting items on the ‘Suggested Purchase Order’ tab on MRP and it would select multiple lines at once.
Fix when generating a suggested purchase order to set the date to the earliest time the stock goes below minimum when the only movements in a warehouse are ‘Suggested Stock Transfers’.
Fix when viewing the ‘Future Stock Movements’ screen to correctly get the ‘Earliest PO Arrival’ date.

Kitting

Enable the Build Kit button when you set Qty to Allocate to zero on SOP Create New Order Item line for a kit item, and also disable if you then override it back to match the Order Line Quantity.
Fix to allow allocation if kit item selected by item name.
Quantity field is disabled and greyed out after selecting the kit, but still enabled when selecting by stock code.

Date applied: June 5, 2024

221.0.67

Issues Resolved New Features Change in Functionality Important

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

Issues Resolved

Works Order Processing

Prevent users from editing quantities if their user permission do not allow them to.
Force batch attributes to be entered when they are compulsory and default values exist when backflush from Barcoding.
Operation Scheduler will no longer display deleted works orders.
Also Deleting operations from the scheduler should function correctly without erroring [“Object Reference Error”]
Null entries in SiWorksOrderStage preventing area from being selected. Prevent a row with no department from being added.
Fix when competing works orders and it would incorrectly display ‘Unconfirmed Lines’ and therefore would not complete if the sub assembly was also to be completed. The ‘Unconfirmed Lines’ popup would also appear blank.
Fix when viewing the ‘Works Order Cost Summary’ tab and the ‘Overhead’ values would be massively inflated.

Material Resource Planning

Fix for the ‘Previous MRP Results’ screen not displaying as an open window in Sage.
Fix to only include out transaction types of ‘Sales Order’ and ‘WO/BOM Issue’ out types when calculating stock item sales over lead time.
Fix to loading the sales over lead time screen.
Fix to not require a supplier when using the MRP stock item settings import.
Fix to allow the user to select the top parent when completing works orders and it will also complete all sub assemblies if they can be completed.
Updated the ‘SiconWorksOrderProjectCostsView’ so that it now includes a date to be used for reporting

Kitting

Prevent picked kits from being unallocated.

Change in Functionality

Works Order Processing

Added ability to issue to works order after receiving a purchase order.
- Previously a user could allocate received stock to a Works Order. Now there is also an option to issue the stock to the works order.
Updated the works order line import to the new import format.
- Sicon imports are gradually being updated to a standard method across all modules, and the Import Works Order Line import has now been updated to follow this format. The import change is to make importing simpler. The process will prompt the user to first save the import file (so it doesn’t matter if Excel isn’t installed). The import can be manipulated on-screen if simple mistakes need correcting. And the import can be split between successful and unsuccessful rows.
- Further information is available in the Works Order Processing Help and User Guide under the section WOP Menu 11. Utilities > Import Works Order Lines.

Material Resource Planning

Added new ‘Stock Item’ and ‘Warehouse’ filters to the ‘Sales Over Lead Time’ screen.
- The intention of these new filters are to make it easier to search for particular Sales Over Lead Time items by Warehouse or by Stock Item. Previously, users would need to scroll a potentially long list of stock items to find the entry they were looking for.

Date applied: May 22, 2024

221.0.66

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

New Features

Material Resource Planning

Added the ability to delete suggestions;
- It is now possible to delete a suggestion in MRP. This can be helpful for sites with large volumes of suggestions, who wish to physically remove the suggestions on screen until MRP is run again. Selecting the item(s) and then clicking ‘Delete Suggestion’ will remove the suggestions from the MRP results view (current or previous, if viewing retrospectively). When MRP is run again, if the demand still exists the suggestions will return.
Added a new warning icon when MRP has run to flag any items with a warning icon where a new order has been raised against that item. Currently behind a new setting (Display a warning on MRP results if new orders have been placed for stock items since MRP has run). See Material Planning Help and User Guide for more information.
- From Sicon Material and Resource Planning – Utilities – MRP settings, the new setting is called “Display a warning on MRP results if new orders have been placed for stock items since MRP has run”. In case it’s not obvious, what it does (if enabled) is display a little warning triangle on any stock items that have had an order raised since MRP was last run. It’s nothing too sophisticated, it doesn’t reduce any suggested quantities or tell a user what’s been raised. It is simply a way of illustrating that something has changed since MRP was last run.
Grouping Subassemblies Display change in Material & Resource Planning: We’ve made a change to the way MRP groups subassemblies when this setting has been applied (in MRP Options). Previously, if MRP was run using one of the settings to Group Subassemblies, MRP would have first gathered all stock demand and then preallocated the first subassembly, and any child subassemblies, with the first parent demand found. The remaining parent works orders would not have a subassembly linked with them and instead the excess subassembly stock would go into free stock, (which could then later be consumed on those parent works orders). Why have we made this change? : Ultimately, linking all subassemblies with one demand goes against the intention behind grouping subassemblies. In addition, this approach could be confusing to track and explain the logic to new users. In certain scenarios, it could even result in an excess quantity of stock being suggested if used with the Sicon stock item settings to split by maximum Economical Batch sizes. So now, when using Group Subassemblies in MRP, each grouped subassembly is presented in a flat structure and any suggested works order actioned will create its own Works Order.

NB: if grouping subassemblies when running MRP, it is recommended to enable the MRP setting to “create selected works orders only”.

Information around this feature can be found in the Group Subassemblies section of the Material & Resource Planning Help and User Guide.

Issues Resolved

Works Order Processing

Fix when entering a timesheet against an operation and the user would get an error when there is no quantity remaining [“The Quantity entered is above the remaining quantity to complete this operation. Quantity Remaining: 0.00000”]
Fix when associating a works order to a sales order and the works order comments on a sales order line would get overwritten to blank.
Fix when filtering on the ‘Process Works Orders’ screen for a sub assembly with multiple prealloctions and it would group the quantities together incorrectly.
Fix when adding a new component line to a works order and the selected warehouse would get overridden if the stock item had a ‘Default Component’ set against it.
Fix when filtering an ‘To’ date on the ‘Process Works Orders’ and it would include works order for the next day where the time is set to ’00:00:000′.
Disallowed amending component line allocations if the component line is fully issued.
Fix when booking a works order that has a project on it and is preallocated to a slaes order. If the user then cancels the preallocation to issue the item to the project. [“Object Reference Error”]
Fix when creating works orders from ‘Trial Kitting’ to auto generate the works order number at the point of creation to make sure the works order format is consistent when ‘Auto Generate Works Order Numbers’ is enabled.
Fix to correctly update the actual quantity of a labour line when adding a timesheet line.
Fix when updating a works order quantity that is associated to a sales order line and the quantity of the sales order line changes to calculate the new net values of the line and sales order.
Fix when creating works order from the ‘Generate Works Orders from Sales Orders’ to check whether the assigned works order number is in use before attempting to create the works order [“Works order with the WoNumber ‘xxxx’ already exists”]

Material Resource Planning

Fix to create works orders from the lowest BOM level first when the setting ‘Create Selected Works Orders’ is false and grouping sub assemblies is on.
Fix when creating a new works order and it would update to check when the last MRP run to validate MRP has run once otherwise there will be no date [“String was not recognized as a valid DateTime.”]
Fix for items not appearing as suggestions when there is a min max/reorder level set against the stock item and no free stock available.
Fix when creating suggested works order and the user would get an error once they have been completed [“Index out of range”]
Fix when running MRP and incorrect ‘Warehouse Stock’ type preallocations were being created and this would then lead to ‘Min Order’ or ‘Reorder Level’ suggestions to not be created [“Object Reference Error”]
Fix for the ‘Previous MRP Results’ screen not displaying as an open window in Sage

Change in Functionality

Works Order Processing

Added the ability to just create a works order line without a sub assembly and without using any stock when creating a works order.
- This option is would mostly be used when creating Top-level works orders from MRP, where grouping has been enabled and the subassembly works order will be created later for the lower levels.

Kitting

Updated the ‘Import Kits’ screen to use the new import format.
- Sicon imports are gradually being updated to a standard method across all modules, and the Import Kits has now been updated to follow this format. The import change is to make importing simpler. The process will prompt the user to first save the import file (so it doesn’t matter if Excel isn’t installed). The import can be manipulated on-screen if simple mistakes need correcting. And the import can be split between successful and unsuccessful rows. Further information is available in the Kitting Help and User Guide, under the Import Kits section.

- Why have we changed the format?
  Various reasons;
  - Consistency across the Sicon modules.
  - You don’t need Excel installed to generate and save the import template.
  - You can easily see if a record is invalid and split out the invalid entries into a new template to work with later.
  - If there’s a simple change required, that change can be made in-screen and the system will save the import file.
  No more navigating to the old Excel, finding the incorrect row(s), making the adjustment, re-importing, pressing validate and hoping-and-praying you’ve updated the right record… just change it then and there.

Date applied: May 8, 2024

221.0.65

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

Issues Resolved

Works Order Processing

Corrected the filtering of the ‘Generated Date To’ filter on the ‘Process Works Orders’ screen.
Corrected the namespace of the ‘Process Works Orders’ screen for third party scripting

Material Resource Planning

Fix for the ‘Calculate’ button on sales order always returning today’s date.
Fix when running MRP for phantoms where there are the same item and it was creating a suggestion for the wrong quantity. If a suggestion got decreased on the second line of the works order it would not take this into consideration and therefore give the wrong quantity.

General

Compatibility with DevExpress v23.2

Date applied: May 1, 2024

221.0.64

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

Issues Resolved

Works Order Processing

Updated the works order view to pull the ‘LineComment’ through so that when viewing the ‘Works Order’ tab on a project the description for non-stock items is displayed in the tree view
Fix to not show the sub assembly popup form when the setting ‘Always Ask Before Creating Sub Assembly’ setting is turned off.
Fix to exclude deleted operations when getting the next sequence number for new operations. Issue where the sequence would jump numbers and then would not allow for the operations to be reordered.
Fix when the setting ‘Always ask before creating sub assembly’ is off and ‘Allocate subassembly it from free stock if available’ is turned on and there is some free stock but not enough to fulfil the works order line. No longer popup with the sub assembly form and instead use the free stock available and create a sub assembly for the remaining amount.
Fix when deleting a purchase order line that is linked to a sub contract line and this would then incorrectly unlink all sub contract lines from PO lines.
Fix when posting credit notes. [‘Incorrect syntax near ‘S’. Unclosed quotation mark after the character string ”.”]
Fixed problem when issuing stock after a pre allocation is fulfilled, and the traceable details were missing. [“Object Reference Error”]
Fixed object reference error when part allocating a works order line and warehouse hierarchy is enabled.

Material Resource Processing

Fix when running MRP and no suggested works orders would be created when the reason for the line is a Sicon Stock Transfer.
Fix when using the ‘Calculate’ button on a sales order and it would return dates in the past and then that would also mean the ‘Production Date’ from WOP settings would not get correctly added.

Kitting

Prevented error messages from appearing if cancel disassembly half way through disassembly. Also added warning messages.
Prevented the user from attempting to continue the disassemble process by not entering any traceable item details when adding traceable component items, and thus cause problems with the disassemble of the kit.

Date applied: April 17, 2024

221.0.63

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

Issues Resolved

Works Order Processing

Fix when using the ‘Generate Works Orders from Sales Orders’ screen to get the ‘Default Finished Item Warehouse’ and ‘Default Component Warehouse’ from stock item settings.
Fix to allow operation times to be updated when they have no duration time and the works order ‘Due Date’ gets updated.
Fix to allow operation times to be updated when they have no duration time and the works order ‘Start Date’ gets updated.
Added further validation when selecting how to fulfil a sub assembly when the ‘Sub Assembly Creation’ popup appears [‘Input string not in correct format’]
Removed inspection questions from popping up when issuing a component line on a works order. Also made sure that the inspection template options are only available on the amend stock item screen for BOM items.

Material Resource Planning

Fix when running MRP to get the correct finished item warehouse for nested sub assemblies where the reason hasn’t been generated yet but the demand warehouse has been.
Fix to set the correct component warehouse on a works order suggestion otherwise when viewing a suggestion on FSM it would only display the ‘Out’ and not the ‘In’ as no warehouse would be set on the parent works order line.
Fix to correctly display the finished item warehouse for MRP suggestions.
Fix to get the correct quantity for a sub assembly works order when it is part of a phantom and there are multiple of these phantoms on a BOM.
Fix when creating works orders from MRP and it would try to update a suggestion link to a works order that doesn’t exist and would throw an error silently so it looks like the screen had froze [‘Object Reference Error’].
Fix the validation when selecting a direct delivery suggested PO if the sales order has ‘Use Invoice Address’ checked.

Change in Functionality

Works Orders Processing

Improved inspection templates to be stored at multiple levels, not just at a global level. Inspections can also be recorded at a traceable item level.
- Previously, if an inspection template created from within Sicon Works Order Processing – Maintenance – Inspections – Maintain Inspection Templates, was subsequently amended on a stock item (Sicon – Inspections tab), the stock item version would overwrite the original template within the WO Maintenance screens.
- Now, if an inspection template is overridden on the stock item, these changes will stay with the stock item only.
  An additional inspection tab also exists on the Works Order screen, for the purposes of amending the inspection template further only at the Works Order level.
- If using inspection templates with Batch Traceable stock items, it is possible to amend the template further on the batch if required. However, it would not be possible to use the same batch number on other works orders when using this functionality.
  All inspection results can be found in Sicon Works Order Processing – Maintenance – Inspections – View Completed Inspections.

Date applied: April 10, 2024

221.0.62

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

Issues Resolved

Works Order Processing

Fix to highlight any traceable items where the ‘Use by’ or ‘Sell by’ date is before today’s date when amending a works order lines allocation.
Fixed problem with error ‘Stock item with id 0 cannot be found’ when selecting the Issue button on the Process Works Order screen.
Fixed issue where a stock analysis code is mandatory, but analysis code on the stock item is not set, and we using auto numbering, then an error would occur: ‘Analysis Code is mandatory and does not have the value specified in its list of allowable values.’
Fixed works order settings for spare text fields where a ‘:’ was left in the label, and thus would display the spare text field on the additional info tab on the works order incorrectly.

Kitting

Fix when a kit already exist for a sales order line to update the kit quantity and it’s component when the setting ‘Prompt for kit creation for sales order line shortage’ is not enabled.

Change in Functionality

Works Order Processing

Added new setting to always use the works order numbering when creating works orders. Therefore, if the user creates a works order from a sales order, it will use the works order numbering format, not the sales order number.
- Works Orders generated from a Sales Orders (via any method, workflow options, Generate WO from SO etc) will always be given the Sales Order number by default as the Works Order number also. It was only possible to override this if creating a Works Order through MRP and the setting to “Always use standard works order numbering” was enabled.
  By default, this setting will always be disabled to work like this still.
- With the setting enabled, when Works Orders from Sales Orders are created, it will use the numbering sequence as defined in the Numbering & Document tab of the Works Order settings.
- This setting is found in Sicon Works Order Processing Utilities – Quotations & Sales Orders tab. If enabled in WOP, it will automatically be enabled in MRP, and vice versa.

Date applied: April 3, 2024

221.0.61

Issues Resolved New Features Change in Functionality Important

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

Issues Resolved

Works Order Processing

The generate works order from sales order screen was not showing stock unit quantity. It was incorrectly showing the line quantity, which is in that particular unit of measure.
Fix to not allow the projects control to be enabled when a works order has been part booked and it is not associated to a sales order.
Fix when amending the dates of a works order where there are no operations but there are sub assemblies to allow the user to update the dates of each sub assembly too. Issue where it would appear this screen wouldn’t honour the WO setting to ‘Add an extra day when creating sub assemblies’.
Fix for ongoing issue when upgrading Manufacturing and update companies wouldn’t run successfully [‘Invalid object name ‘xxxx”]
Fix to calculate the outstanding quantity to be booked instead of the ‘IsReceived’ flag. Issue when attempting to book in a works order when there is an outstanding quantity and the book button would not do anything.
Fix to correctly set the works order status from ‘New’ to ‘Allocated’ to ‘Issued’ when there are bulk issue items on the works order.
Fix to also ‘Unconfirm’ a bulk issue item when unissuing a works order.
Fix to set the correct source and destination warehouse when booking a finished item in that is preallocated to a works order/sales order in another warehouse.
Fix when creating works order from the ‘Generate Works Order from Sales Order’ screen to honour the ‘Default delivery buffer’ setting from MRP settings.
Fix on the ‘Process Works Order’ screen to handle multiple finished items.
Fix when creating an empty works order [“Object reference error”]

Material Resource Planning

Fix to allow suggested purchase orders to still be created when there are no period exchange rates setup.
Corrected the filtering on the ‘Suggested Works Order’ tab on MRP to be able to filter sub assemblies
Fix when running MRP with items that are batch split and grouping sub assemblies is set. When creating the works orders create the parent works orders first and update the sub assembly reasons with the correct works order ID’s to allow them to be correctly preallocated once created. Fix to also correctly preallocate the batch split sub assemblies when creating the works order.
Fix to handle not splitting by eco batch size for parent works orders as this now gets done at the point of creating works orders.
Fix an issue when over ordering is turned off and suggestions were getting incorrectly deleted.
Fix to correctly suggest works orders to be created in the correct warehouse dependant on the ‘Default Finished Item Warehouse’ stock setting.
Fix to disable the ‘Run’ button on MRP when the user has no run options selected.

Kitting

Fix for auto allocating kit lines when using the ‘Build Kit’ menu item and saving the kit
Fix to correctly set a kit’s status when all lines are allocated and the kit would still get given a status of ‘Part Allocated’

Change in Functionality

Works Order Processing

Added a ‘Max Batch Size’ column to the ‘Generate Works Order from Sales Order’ screen.
- Previously only the minimum batch size was visible. This enables users who are also using the function to Split by Max batch size to more easily see the levels configured on the stock item. Creating a Works Order from this screen will honour these settings if not overwritten.
Updated the ‘Booked Finished Goods’ web API endpoint to now accept a ‘Warehouse Name’ and ‘Bin Name’ to allow the bin to be selected for the item to be booked into.
- Previously it was not possible to specify the location and bin that an item would be booked into using this API. Further information is available on the WebAPI Documentation – https://webapidocs.blob.core.windows.net/published/Documentation.html
Added a destination warehouse field the works order form to view where the finished item will end up.

Manufacturing Additional Information Destination Warehouse Image 5

- See https://www.sicon.co.uk/user-guide/additional-manufacturing-information/ for further information.
- To improve visibility of when a Works Order will ultimately be transferred to another warehouse. For example, if a Sales Order will be despatched from Warehouse B, but the manufactured item is always built in Warehouse A. Historically it has not been easy to see this on the Works Order linked with the Sales Order.
- Now, the linked Works Order will show as “Warehouse A” as usual for the production warehouse, but there is also an additional field showing Destination Warehouse as “Warehouse B” (parent WO/SO warehouse).

Material Resource Planning

Added the ability to filter by multiple products group when viewing MRP results. This has been added on all three (Kitting, Works Orders and Purchase Orders) tabs.
- It has always been possible to filter by one product group at a time on the Suggested Works Order tab. Now this has been extended so it is possible to select multiple product groups at a time to filter results by.
Added a new screen when viewing the ‘Suggested Works Orders’ to allow the user to see what split is going to happen when they create the works order.
- For sites who are using Min/Max batch sizes on stock items, together with the setting to split by Max batch size, it is now highlighted with an additional icon to show that a split will be made. Double-clicking the icon takes the user into this extra information.
- Further information is available in the “Stock Item Settings” section of the MRP user Guide, and also in the Manufacturing Additional Information – https://www.sicon.co.uk/user-guide/additional-manufacturing-information/
When running MRP and grouping sub assemblies to create the grouped sub assemblies as works orders on their own and no longer preallocate to just one parent.
- Essentially this has updated to simplify how subassemblies are grouped and displayed on the Suggested Works Order screen in MRP. If users are not grouping subassemblies when running MRP this will not impact them.
- Previously when running MRP and grouping subassemblies, although subassemblies were grouped, they were linked with the first parent found when running through stock demand. There was confusion around this, particularly when users are using the Split by Max Batch functionality.
  How the subassembly was displayed and preallocated was confusing. The subassembly quantity required for the first parent would be preallocated to the parent, but the rest of the subassembly would be booked into free stock. For some sites, they would want all of the subassemblies to go into free stock. For others, they would all subassemblies preallocated to all the relevant parents so the stock isn’t used elsewhere. In addition, this made tracking stock movement more difficult.
- At the core, Group Subassemblies is designed for sites who wish to make a bulk of their subassembly(ies) to cover multiple works orders. Therefore, if subassembly grouping is applied when running MRP, these will now be created as individual works orders when actioned. They will be preallocated to the parents (if the parent is also created at the same time, and preallocating to reasons is enabled).
- It is recommended that the MRP setting to “create selected works orders only” is enabled for users who are grouping subassemblies.
We now show Suggested Auto Stock Transfer out and Suggested Auto Stock Transfer In in the stock movements screen for suggested works orders that are going to be transferred to another warehouse based on warehouse settings on the stock item.
- If a production warehouse is configured on the Sicon tab within the WOP menus of a stock item, but demand is in a different warehouse, an automatic stock transfer will be completed at the point of booking in the Works Order. This is shown in the Future Stock Movements screen.
  For example, a Sales Order for a built item will be despatched from Warehouse B, but the stock item always needs to be made in Warehouse A.
  Once the Works Order is booked in, it will be preallocated to a stock transfer to move the stock from the Production Warehouse A to the Despatch Warehouse B.
Reasons on the suggested transfer out are now showing on the stock movements screen.
- Historically reasons have not shown for Stock Transfers. With the work done on improving visibility of warehouse movements, reasons will now be populated as well.
Suggested stock transfers now appear for where there is free stock in the production warehouse instead of suggested works orders in the demand warehouse.
- In the example where a Sales Order for a Built Item is despatched from Warehouse B, and the built item itself is always built into Production Warehouse A, if there is free stock in Warehouse A to cover the demand in Warehouse B, users will no longer see a Works Order suggestion into Warehouse A, but instead a Suggested Stock Transfer of the free stock from Warehouse A to Warehouse B.
Added the ability to create a ‘Warehouse Stock’ preallocation for suggested purchase/works orders that are for ‘Min Stock’ suggestion for a different warehouse to the warehouse that it will be purchased into.
- In line with the other Warehouse and Stock transfer changes outlined in this document, this is a new preallocation method for when there is a Minimum Stock demand in a different warehouse to where the stock will be purchased/built into.
- For example, where there is a minimum stock level in Warehouse A, but purchased/built stock is always received/built into Warehouse B. When running MRP now, a minimum stock suggestion will be made for Warehouse B, and it will be preallocated to a Warehouse Stock transfer. This will be shown as an Auto Stock transfer from Warehouse B (Production/Purchasing Warehouse) to Warehouse A (Minimum Stock demand warehouse).
- If the Purchase/Works order is created, at the point of booking/receiving in the item, an automatic stock transfer will be created to move the minimum stock requirement from the Production/Purchasing warehouse to the Demand warehouse.
- Previously this kind of scenario would have been booked free stock into Warehouse B, and users would then manually need to create a stock transfer from the Production/Purchasing warehouse to the demand warehouse. (JS to confirm this bit).

Date applied: March 27, 2024

221.0.60

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

New Features

Significant Speed Improvements | Sicon Works Order Processing
- These speed improvements, predominantly in the Process Works Orders Screen, will assist sites who use complex, layered BOMs and we’ve also given the screens a facelift in the process. Subtle changes, but columns such as the “Unconfirmed” and “Unissued Lines”, (which a user cannot edit) now show with a different icon compared to columns such as “Printed”, which the user can manually override.It is now significantly faster to load. With this facelift we’ve rewritten the code underneath. For sites with complex multi-layered BOMs that historically can take a long time to load, users should notice a significant improvement loading and working with this screen.
- We have done similar with the Complete Works Order Screen within Sicon Works Order Processing, and the Suggested Works Order view within Sicon Material and Resource Planning, Material Planning results.
- For more information, please refer to the WOP Help & User Guide; https://www.sicon.co.uk/user-guide/works-order-processing-help-and-user-guide/#3-3

Enhanced Update from BOM Functionality | Sicon Works Order Processing
- Within Sicon Works Order Processing, it is possible to use the Update from BOM feature to update a Works Order with any amendments that have been made to the linked BOM since the Works Order has been created. We have now enhanced the functionality so this feature works with more scenarios.
- Why have we made this change?
  Previously, only Works Orders with a status of New or Allocated could use this feature. This is because once a component has been part or fully issued, the stock item may have been consumed, so quantities could not be updated on the Works Order.
  This logic still applies however, we recognise that for some sites they may want to add more stock, or reduce just part of the works order quantities. As such, from Sicon v221.0.60 it is now possible to update Works Orders with a status of New, Allocated, Issued and Part-issued, if the below criteria is met;
  - If the component quantity has been increased on the BOM | On the Works Order, increases will be reflected in line with what has already occurred, e.g. if 10 were required and fully issued on the Works Order, updating the quantity to 15 would set the line so it no longer shows “Issued”.
  - If the component quantity has been decreased on the BOM | Decreases will only be allowed down to the already-allocated/issued quantity on the Works Order, e.g. if 10 were required and 6 have been issued on the Works Order, updating the quantity to between 6-9 would be updated, but anything less would remain as it is.
  - If component lines have been removed on the BOM | Component lines will only be removed on the Works Order if they have not already been allocated/issued and the Works Order setting to allow removal of lines is turned on.
- Changes will be recorded to the History Tab of the Works Order as well to improve visibility of the success of the Update from BOM routine.NB: Update from BOM still does not work with operations, only material items.
- For more information, please refer to the WOP Help & User Guide; https://www.sicon.co.uk/user-guide/works-order-processing-help-and-user-guide/#3-4

Issues Resolved

Works Order Processing

Fix when adding a sub assembly line to a works order and Sage would just hang. Included a new progress bar to update the user when exploding these BOM lines out
Fix when un-issuing a works order line when the works order is associated to a project to create a ‘WOPRTN’ transaction to reverse the cost out of the Project
Fix when issuing stock to a project upon booking and the setting ‘Use Project Header when Issuing’ is true to use the project header nominal code override
Fix when deleting a ‘Labour’ or ‘Machine’ line to correctly display this type and code on the works order history
Fix when opening the ‘Generate Works Orders from Sales Order’ screen [“Cannot find specified Warehouse”]
Fix to disable the control on the WOP stock settings to configure ‘Bulk Issue’ items when they are not a component or are of a traceable stock type
Fix when unbooking a works order where a variance has been posted when booking and then once un-booked an extra unbook variance would get posted. This then leaves a value within WIP incorrectly
Corrected the works order name to following the conventional “ItemCode (ItemName)” format when creating works orders from the ‘Generate Works Orders from Sales Orders’ screen
Fix to set the correct source and destination warehouse when booking a finished item in that is preallocated to a works order/sales order in another warehouse
Fix backflush error ‘Serial selection failed on item ‘xxxxxx’, identification no ‘x,x’, bin ‘xx’ – Of x.xxxxx supplied, x.xxxxx were unavailable.’ if multiple allocations exist for the same traceable item
Fixed issue with issuing stock during backflush where the allocated works order line is allocated across multiple bins. It was also popping up asking for the traceable items when the stock items are set to auto select the traceable items
Fix when adding multiple BOM lines to a works orders [“Invoke or BeginInvoke cannot be called on a control until the window handle has been created”]
Fix to allow ‘WO Comments’ on a new sales order line to be saved and then edited again without saving the line
Fix when closing without saving a sales order line [“Unable to update object, due to it’s state”]
Fix when completing a works order to and works order would incorrectly reset the ‘Average Buying Price’ of a stock item when there are unconfirmed costs. The movement balance for a works order should be deleted before we query the database, and we only want to look for records that are associated to this works order

Material Resource Planning

Fix to correctly set the ‘ Default Component Warehouse’ on a works order when it has been created from MRP
Fix when running standalone MRP and it would leave a disconnected login
Fix when creating suggested works orders [“Value does not fall within the expected range”]
Fix to correctly calculate the unit cost for a purchase order line when using multiple units of measure and the purchasing unit is overridden on the stock item settings

Barcoding

When writing off stock in dynamic stocktake and the stock was allocated on the works order component line, then allocated quantity and the status of the works order was not updated until the works order was opened in Sage. We now update these straight away

Change in Functionality

Works Order Processing

Added more logging when running ‘Update From BOM’ methods to inform the user of changes made. Also allow works orders that have a status of ‘Part Issued’ or ‘Issued’ to also be updated.
- Previously it was only possible to use Update from BOM on New or Allocated orders. This has now been updated to allow changes to Part Issued and Issued, where the values are higher than what has been issued. (E.g. if you have issued 5 components, and the BOM now only requires 3, this line will not be changed on the Works Order).
- On the Works Order, History tab, changes to the Works Order as a result from running the Update from BOM will show more detail to illustrate the above.
Improved the performance of the ‘Process Works Order’ and ‘Complete Works Order’ screens.
- For sites with complex, multi-layered BOMs, working with these screens could take a long time to load. These screens have been re-written to reduce the time taken to expand and filter these results.

Material Resource Planning

Improved the performance of the ‘Suggested Works Order’ tab.
- For sites with complex, multi-layered BOMs, working with this screen could take a long time to load. These screens have been re-written to reduce the time taken to expand and filter these results.

Date applied: March 20, 2024

221.0.59

Issues Resolved New Features Change in Functionality Important

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

New Features

Works Order Processing

Added the ability to complete ‘Part Booked’ works orders via the ‘Complete Works Order’ screen: This may seem like an obvious feature, but with the potential for complex Work in Progress (WIP) nominal postings, it was historically safer to force users to raise a final booking that would trigger a reconciliation of WIP. This was to ensure that the final item was booked in at a value that would bring the WIP nominal postings back to zero for the Works Order in question. For example, if 10 items had been created, but only 9 have been booked in, historically a further booking for the final 1 would have been required (it is still possible to process this way, so no obvious changes are required by users). It is now also possible that instead of booking the final item as above, the option to Complete a Part Booked Works Order can be used to trigger a posting of any outstanding WIP. This will be posted to the Finished Item Variance and then mark the Works Order as Completed. Therefore, to use this feature users must have a nominal configured in the Finished Item variance setting within the Works Order Settings:

Information around this feature can be found in the Complete Works Order section of the Works Order Processing Help and User Guide.

Issues Resolved

Works Order Processing

Fix to filter out deleted operation lines on timesheets.
Fix on the complete works order screen for using the ‘Expand All’ button and this making the screen fall over after a period of time.
Fix to operation rate being used for actual labour time instead of employee rate on Works Order.

Material Resource Planning

Fix when running MRP for suggested purchase orders to be raised for stock items that are ‘Built/Bought’ ‘Default Bought’ when the demand is for a works order/ suggested works order.
Fix when using the ‘Generate Works Orders From Sales Orders’ screen to correctly filter by the ‘Promised Delivery Date To’ field and to also allow the columns to be sorted.
Fix when using the ‘Generate WO From SO’ screen and changing the filters without using the clear filter and it would filter using some of the old filters.
Fix when running MRP for it to honour the ‘Fixed Quantity’ setting for BOM lines.
Fix when running MRP with dynamic forecasts to also adjust the demand of a forecast for built items

Kitting

Fix when adding standard lines to a sales quote/proforma to populate the ‘Unit/Kit Cost’ field upon creation.

Change in Functionality

Works Order Processing

Added the ability to complete ‘Part Booked’ works orders via the ‘Complete Works Order’ screen.
- Historically Sicon have not allowed users to complete partially booked Works Orders. This is because doing so could leave a balance in WIP. Now, there is a routine to complete the works order even if partially booked.
- It is held in a separate screen to mitigate the risk of accidentally closing off a works order. Users will need to ensure that all checks have been made before processing (stock consumption etc.).
Added the ability when attempting to complete part booked works order to allow the user to reduce the works order line quantities down to the quantity that has been issued on that works order at that time.
- In conjunction with the above, if users have unissued lines outstanding on a Works Order they will be unable to complete the works order.
- This new option allows users to reduce the quantity issued to match the quantity booked so that the order can then be completed.
- It is held in a separate screen to mitigate the risk of accidentally closing off a works order. Users will need to ensure that all checks have been made before processing (stock consumption etc).

Date applied: March 6, 2024

221.0.58

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

Issues Resolved

Works Order Processing

Fix when deleting a works order [“Object Reference Error”]
Fix to correctly update the actual quantity of a labour line when adding a timesheet line.
Fix to correctly set the ‘Ultimate Parent WOID’ when adding new sub assemblies to a works order via the ‘Update From BOM’ routine.
Fix to exclude works order templates when displaying the ‘Quantity on WO’ and ‘Unallocated on WO’ values on the ‘View Stock Item Balances’ screen.
Fix when unbooking an works order with overhead and Sage will look to use an exchange rate nominal and this may not be set and this is incorrect [“The account specified does not exist”]
Fix to allow the user to update just the ‘Quantity’ field when editing a machine transactions.
Fix to update the existing transaction when editing a machine transaction and not create a new line each time
Fix to also display ‘Non-Stock’ works order lines if they are included in the cost of the works order when viewing the works order tab on the ‘Project Enquiry’ screen

Date applied: February 28, 2024

221.0.57

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

Issues Resolved

Works Order Processing

Fixed problem with duplicate actions on adding operations to a works order in web API.
Fix when reducing the quantity works order lines when reducing the finished item quantity of a works order, to correctly set the allocated amount to 0 and set lines correctly to ‘IsIssued’ if the reduction in the finished item quantity is the same as the quantity booked (The works order will be changing to a ‘Booked’ state)
Fix to allow works order lines that are issued to be changed as long as the quantity doesn’t decrease below the issued amount.
fix to also check whether there is a max batch set against a stock item to create the min/max batch split when using the ‘Generate Works Order from Sales Order’ screen

Material Resource Planning

Fix to include ‘Suggest supplier via stock purchase orders’ and ‘Suggested direct delivery purchase orders’ into the ‘Future Stock Movements’ screen

Change in Functionality

Material Resource Planning

Added a ‘Suggested Header’ column for suggested purchase orders that will come from default settings or operations dependant on the reason for the suggestion. This information is then passed through when creating the suggested purchase order or Approvals purchase requisition.
- Previously, purchase suggestions made in MRP would not pull through to Purchase Orders or Approvals with the Project header information.

Date applied: February 21, 2024

221.0.56

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

Issues Resolved

Works Order Processing

Fix if Backflush from Barcoding/Web API fails only un-book fished goods if some stock has been added
Fix to maintain the link when creating a link between a quote and an estimate

Material Resource Planning

Fix when generating works orders in MRP and the sub assembly group is set to ‘All’ but the parent is set to ‘Never’ and this would not generate the correct quantities. Also a further fix to make sure max batch sizes are considered when creating these works orders and to also allow grouping when these are set
Fix when creating ‘User Suggested POs’ and there are already suggested PO’s that the line can be linked to. However the user does not select one and hits OK. [“Index out of range”]

Change in Functionality

Works Order Processing

Added a new setting to display the traceable allocation selection at the allocation part of a works order line when the allocation setting ‘Use Stock Fulfilment’ setting is enabled

Date applied: February 14, 2024

221.0.55

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

Issues Resolved

Works Order Processing

Fix Internal Issue ‘Incorrect syntax near ‘S’. Unclosed quotation mark after the character string ”.’ error
Removed the setting to ‘Show message to allocate/issue bulk issue items’ as they are now ‘Confirmed’ and then issued at booking when the setting ‘Issue bulk issue items at booking’ is turned on.
Fix to also correctly confirm bulk issue items when using back flush so that it correctly books the back flushed items in
Fix when copying a sales order when there was linked works order [“Execution timeout”]
Fix to reset the picked quantity when unallocating a works order line
The line cost of a works order line was incorrect if the works order line was issued multiple times, and then the cost was updated via an invoiced purchase order. Unconfirmed costs need to be on.
Fix to remove already scrapped (written off) serial or batch numbers when scrapping components on a works order
Fix to only create a scrap log for lines that have been scrapped. Issue with traceable items where a log was being created with 0 quantities and cost. Also added further detail to the reason if it is a traceable item to display the traceable number

Material Resource Planning

Fix when running MRP and the suggested works order contains phantoms and within these phantoms contains the same sub assembly. The suggested works order quantity would add all these quantities together for each individual suggested sub assembly incorrectly.

Date applied: February 7, 2024

221.0.54

Change in Functionality Important

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

Issues Resolved

Works Order Processing

Fix to return the stock item default component warehouse for a sub assembly suggestion so the correct demand warehouse is checked when running MRP. Issue when sub assemblies were being incorrectly suggested when there is stock available
Added scripting to the ‘Timesheet (Single User) ‘ screen within the Projects menu, so that the user can select ‘Works Orders’ when entering a timesheet
Fix to correctly filter the traceable enquiry when selecting ‘Sicon Works Orders’ and component traceability is turned on

Material Resource Planning

Fix when opening the ‘Future Stock Movements’ screen from MRP when the use has selected to use ‘Warehouse Hierarchy’ to also pass through the dates selected otherwise the information outside of the MRP run dates will be displayed

Date applied: January 31, 2024

221.0.53

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

Change in Functionality

Works Order Processing

Enhanced the ‘Generate Works Orders from Sales Orders’ screen to give the user more feedback and progress when generating the works orders. Improved the loading speed when displaying the works orders that need to be created.
- To make the creation progress clearer. Previously Works Orders generated from Sales Orders would run through the processes in the background, and on large orders it wasn’t always obvious that a process was still running.

Date applied: January 24, 2024

221.0.52

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

Issues Resolved

Works Order Processing

Works Order Operations methods/endpoints error handling will now write to Web API Log + Validate timesheet creation team/resource is set to avoid error generated if SiconResource is NULL.
Fix when using the ‘Update from BOM’ routine and not all works orders were getting updated. This could have happened if the ‘Default Component’ warehouse was not set on the works order.
Fix to disable the ‘Update From BOM’ button when a works order is ‘Part Issued’, ‘Issued’, ‘Part Booked’, ‘Booked’ or ‘Completed’
Fix when creating a works order and the stock item using min and max batches to correctly create the works orders with the correct quantities that are calculated using these settings.
Fix to filter the works order drop down to only display works orders that have sub contract lines associated to them
Fix for a rounding error when viewing a stock items balances on the ‘Unallocated on WO’ column
Fix when viewing the ‘Unallocated on Works Order’ to filter out works orders that are ‘Suggested’, ‘Templates’ or ‘Estimates’

Material Resource Planning

Fix to correctly display the reason when a suggested kit is for an operation line.
Added a project column for when creating an approval purchase order. This now stores the project so that approvals can then assign this project to the purchase requisition.
- Previously, purchase suggestions made in MRP would not pull through to Approvals with the Project information.

Kitting

Added a message when receiving a purchase order when there is a preallocation to a kit line and setting ‘Use allocations’ is turned off, to inform the user that preallocations will be completed upon receipt however will not be allocated to the kit line.

Change in Functionality

Material Resource Planning

Added a project column when create a approval purchase order. This now stores the project so that approvals can then assign this project to the purchase requisition

Date applied: January 18, 2024

221.0.51

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

Issues Resolved

Works Order Processing

Fix when ‘Allocating’ and ‘Issuing’ bulk issue items from the ‘Process Works Orders’ screen to no longer allocate and issue at this point and only ‘Confirm’ the bulk issue items

Material Resource Planning

Fix for correctly adjusting the unit cost when using ‘Unit of Measure’. This should get done at the point we create the ‘Suggested Purchase Order’ as this sets the ‘Unit Price’

Date applied: January 10, 2024

221.0.50

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

Issues Resolved

Works Order Processing

Fix to also update the works order object when updating an operation via the web API. Issue where project transactions weren’t updating correctly when operations were updated via the web API
Fix for the stages drop down on the works order header was not showing all the stages set on the operations on the works order. The drop down was also not refreshing when an operation was completed.
If no area has been set on the BOM operation line, then when creating a works order, we now check the operation on the operation register as well to see if there is an area set there. Also, when editing an existing BOM operation on the BOM, and no area has been set, we default the area to what is set in the operation register.
Fix when booking batch finished items to correctly update the ‘Next Available Number’ on the stock item when the ‘Automatic Number Generation’ is either ‘Generate Using Sequence’ or ‘Generate Using Order Number And Sequence’
Fix to default the starting number when ‘Auto Generating Serial Numbers’ when booking a finished item to the ‘Next Available Number’ on the stock item
Fixed the SiconWOWIPView for calculating the correct cost of sub contract lines
Fix when generating a works order from a sales order using the works order workflow option. To correctly split the works order up when using eco batch sizes. Issue where it would always suggest a works order quantity of 0
Fix when creating an empty works order and adding a BOM finished item to correctly consolidate the lines if the user selects to consolidate them
Fix to reload the ‘Manufacturing Attributes’ tab after a sales order line has been saved.
Fix to store dates in the spare text fields on a works order without the time stamp
Fix when resetting the works order number to make sure the number set is the next number that gets used. Issue where the number was set to 100 as an example however the next number that would have been used when a works order was created would have been 101.
Fix for allow the ‘Materials’ tab on the works order settings screen to be scrollable

Material Resource Planning

Fix when using the ‘Calculate’ button on a sales order and calculating a built item that contains a phantom item. Now explode the phantom and calculate all the lines that are part of it [“Object Reference Error”]
Fix when generating suggested kits for sales order lines to get the correct preallocated quantity. Issue where a kit would be preallocated to a sales order line and then deleted and MRP would not generate the suggestion again
Fix when creating suggested kits from MRP and once they are created these lines wouldn’t be removed from the ‘Suggested Kits’ tab. This could then mean they get created multiple times
Fix when generating warnings for purchase orders, to run through all items. Issue where some purchase order lines were being displayed as a warning but others on the PO were now

Kitting

Fix when using the ‘Build Kit’ screen to build a kit without a template [“Cannot update field (ItemDbKey) with a null value, as it is marked as not accepting ‘Null’ values”]

Change in Functionality

Works Order Processing

Updated the ‘Send to Excel’ form from the ‘Process Works Order’ screen to match all the columns that are on the ‘Process Works Order’ screen
- As columns have been added, not all columns were previously captured when exporting to Excel.

Date applied: January 2, 2024

221.0.49

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

Issues Resolved

Works Order Processing

Fix to update works order from BOM where not all component lines were updating.
No longer allow works orders that have been ‘Issued’ or ‘Booked’ to be updated via ‘Update from BOM’
Fix to keep the link between a works order (SOPOrderReturnLineID) when the works order is booked and the preallocation is completed. Issue when viewing the ‘Works Order’ tab on a sales order and once complete this works order would not appear in the list of works orders for the sales order

Date applied: December 12, 2023

221.0.48

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

New Features

Works Order Processing

Added ability to select/deselect and delete multiple operations. Included a progress bar to track progress of deletion.

Issues Resolved

Works Order Processing

Store the works order ID in the ‘Second Reference’ field on the movement balance table to help identify them easier when coming to confirm them upon completion of a works order. Issue when confirming works orders with unconfirmed costs where the works order number is longer than 20 characters long.
Fix for an issue when booking ‘Unconfirmed Costs’ works orders and they would get set to complete incorrectly.
Fix to remove warehouses from being selected dependant on whether the current user has that access to that warehouse from the works order settings on the works order line allocation screen.
Fix when despatching sub contract purchase order lines and it would duplicate the despatch popup box after despatching the first line.
Fixed issue where if a traceable item was setup for auto number generation, and custom traceable numbers were entered on the works order, then extra numbers were appearing when booking in the finished items on the works order.
Fix when calculating the next available date and switching between the radio buttons to keep hold of the calculated date.
Fix when drilling down into this date to not recalculate the information again and instead load the screen with the calculated lines

Material Resource Planning

Fix to override the warehouse for suggested purchase orders with the ‘Default Purchasing Warehouse’ set on the stock item if there is one set.

Date applied: December 6, 2023

221.0.47

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

New Features

Material Resource Planning

Added the ability to select multiple follow up types when filtering the MRP results screens
Added a new setting for production lead times to allow suggested works orders generate for weekends

Issues Resolved

Works Order Processing

Fixed issue where the cost of the works order line was not updating if when an purchase invoice is recorded for the stock of the works order line. This is if unconfirmed costs is on and we are updating at invoice, and if nominal integration is off.
Refresh on amend works order screen was not updating the issued cost field after a purchase order was invoiced.
Fixed the persistence of setting ‘Print Labels when items are reserved serials’
Fixed update BOM record via web API when version control is enabled. It wasn’t finding the correct BOM version.
When the description of the labour resource was changed in Sage manufacturing register, then the description on the Sicon team was not updated.
Fix to correct the labour/machine postings made to a project when there is no finished item
Fixed issue with project costing using new single project cost transaction, where the committed cost was calculated incorrectly if there was labour estimate and actual transactions involved.
Fix when reducing a works order quantity to default the batch allocation quantity for a works order line to the reduced quantity when there is only one batch
When creating a sub assembly on a works order, the popup to create the sub assembly was appearing multiple times if the user had changed companies multiple times.
When deleting the preallocation for a works order to sales order on the amend works order screen, the link from the works order to the sales order line was not removed. It now removes this link and therefore no longer displays the sales order number on the works order header.
Fix to correctly set the sub assemblies due date when the parent works order start date (which can be set through operations)

Date applied: November 29, 2023

221.0.46

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

Issues Resolved

fix to correctly subtract the sum of all the preallocations for a sales order line to get the corect quantity required when generating a suggested works order. Issue where it was giving the incorrect sales order as the reason as this would join to the SiconPreallocation table multiple times (per preallocation) and this would give confusing results
Fix for when a sub assembly was pre allocated to multiple parent works orders and the warehouses on the parent are different, it was creating sicon stock transfer with the lines the quantity of the booked in quantity, not the pre allocated quantity. This was therefore creating stock transfer lines with the incorrect quantity on it.
Fixed object reference error when saving a sales order after selecting the Payment tab just before saving.
Fix when using the ‘Copy Lines’ feature in Sicon Distribution when on a sales order to also copy the Manufacturing attributes that have been set on the original line that got copied
Fix when creating a works order either through ‘Generate Works Order from Sales Order’ or ‘MRP’ to also copy the attributes from the sales order to the works order
Fix when querying the works order issue history table to get the current allocated and issued batches for each works order lines
Fix when querying the works order issue history table to get the current allocated and issued batches for each works order lines
Fix Booking Finished Goods with auto-generated batch/serial numbers jumping sequential numbers if the batch/serial already exists without order number prefix

Change in Functionality

Added new tab to add bom drawings to a works order
Added options to print bom drawings
Added new settings to set the format of the traceable numbers when booking in traceable numbers.
Made sure the settings were on a hidden features tab in settings screen. Also made sure we didn’t get an error if the number of #’s entered in the format was something other than 4 #’s

Date applied: November 22, 2023

221.0.45

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

Issues Resolved

Fix when getting the estimated cost for a works order when associated to a project to filter out the deleted Sicon Prealocations otherwise we get duplicates and then the costing of the works order doubles, trebles etc
Fix to also update the project transaction lines when a works order is associated to a sales order with the correct sales order line ID and sales order ID
Fix when creating a template and it requires the user to input the template number, updated the validation message to inform them that it must be in a numeric format. If the user cancels this process it will no longer continue to create the template
Fix when backflushing multiple works orders, to check if it is the ultimate parent when on the ‘Allocate and Issue’ stage. If it is the ultimate parent then only book at the final step of the backflush… Issue where works orders would get booked twice in the process if it was initally only part booked
Fix when calculating the next available date for a built item to initialise the starting date to today’s date and also return today’s date if there are no movements otherwise dates will be in the year ‘0001’
Fix to default the build time to today’s date otherwise the calculate can get return min date build times ending ‘/0001’
Fix for bulk issue items to no longer allocate or issue these items when the setting ‘Issue Bulk Issue Items at Booking’ is turned off. If this setting is turned then they will still be issued at booking. Bulk issue items will also display as ‘Confirmed’ once the issue process has been completed
Updated the message given when attempting to allocating only bulk issue items to a works order to state these get confirmed at the issue stage of the works order
Fix when adding anew works order line to make sure we set the reason earlier in the process so that when the line gets updated it correctly populates the reason field when adding a history line
Fix for posting project transactions when the setting ‘Issue To Project’ is turned off and it was creating duplicates
Fix when using the web API method ‘Create WO from BOM’ to correctly set the passed in due date and works order name against the generated works order
Fix unissue components not totalling quantity correctly if multiple part-issues were processed for the same item & bin. For example, issue 2 items, then 3 more, then unissue. This code will only unissue a quantity of 2.

Date applied: November 22, 2023

221.0.44

Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v22.1 FOR THE FIRST TIME. THIS IS BECAUSE WORKS ORDER FINISHED ITEM TRANSACTIONS WILL BE SWITCH TO BOM BUILD TRANSACTIONS, DUE TO HOW THE SAGE STOCK VALUATION REPORT HANDLES UNCONFIRMED TRANSACTIONS.

TRANSACTION HISTORY FOR UNCONFIRMED COSTS WHERE THE NOMINAL HAS NOT BEEN UPDATED WILL HAVE THE COST VALUE REDUCED TO 0. THIS IS TO FIX INCORRECT VALUES BEING SHOWN ON THE RETROSPECTIVE STOCK VALUATION REPORT.

New Features

Works Order Processing

Added the ability to complete works orders on a specified date

Material Resource Planning

Added a new warning message when creating purchase orders informing the user if they have selected a quarantined warehouse and this purchase order line will not be used when running MRP

Issues Resolved

Works Order Processing

Fix to correctly split works orders if by the specified minimum batch size when creating works order from sales orders
Fix when backflushing works orders with sub assemblies which only contain bulk issue items to correctly issue and allocate and book these at the ‘Allocate and Issue’ stage of backflushing. If not then these won’t be booked in before the parent is booked in and therefore the user is unable to fully backflush
Fix when backflushing works orders and the user selects to only backflush the sub assembly to correctly follow the process through. Issue when it would come to booking in the sub assembly and it would not appear on the list to be booked in
Fixed issue where the create sub assembly form would appear during creating a works order, and then afterwards Sage would crash.
Fix when booking a finished item in with the setting ‘Enable Finished Products Tab’ enabled and this would leave the works order in a ‘Booked’ state rather than ‘Complete’
Fix for issue when the setting ‘Allow Book Before Issue’ was enabled or unconfirmed costs is turned on when completing works orders no nominal postings would be created for Labour, Machine, Sub Contract and Overhead items. Also in the case of unconfirmed costs no ‘Add Finished Item’ transaction would occur
Fix when adding new lines to purchase orders that have sub contract lines on them and the user would be informed this cannot be created as it is linked to a sub contract
Fix to reintroduce a warning message when the setting ‘Allow Book Before Issuing all Components’ is turned on and not all works order lines have been issued

Material Resource Planning

Fix when using the ignore follow up on suggested works orders and purchases order. If the option is set to ignore and the user filters the screen this will remain greyed out and cannot be checked
Fix when using the calculate button to check there are items to calculate… Issue where the button would be pressed and there was no standard item SOP lines [“Value cannot be null”]

Kitting

Fix to correctly enable or disable the ‘Disassemble’ button on sales returns

Date applied: November 1, 2023

221.0.43