Manufacturing v22.1

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.

Hot Fix Enhancements

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.

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.

Hot Fix Enhancements

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.

Date applied: April 3, 2024

221.0.61

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’

Hot Fix Enhancements

Works Order Processing

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.
Added a ‘Max Batch Size’ column to the ‘Generate Works Order from Sales Order’ screen.
Added a destination warehouse field the works order form to view where the finished item will end up.

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.
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.
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.
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.
Reasons on the suggested transfer out are now showing on the stock movements screen.
Suggested stock transfers now appear for where there is free stock in the production warehouse instead of suggested works orders in the demand warehouse.
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.

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.

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

Hot Fix Enhancements

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
Improved the performance of the ‘Process Works Order’ and ‘Complete Works Order’ screens

Material Resource Planning

Improved the performance of the ‘Suggested Works Order’ tab

Date applied: March 20, 2024

221.0.59

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

Hot Fix Enhancements

Works Order Processing

Added the ability to complete ‘Part Booked’ works orders via the ‘Complete Works Order’ screen
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

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

Hot Fix Enhancements

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

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

Hot Fix Enhancements

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

Hot Fix Enhancements 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.

Hot Fix Enhancements

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.

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.

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.

Hot Fix Enhancements

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

Hot Fix Enhancements

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

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

Hot Fix Enhancements

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

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 issue when viewing the ‘Materials’ tab on the works order settings and settings would not appear
Rationalised the allocation settings within the ‘Materials’. By default now the only option that will be available will be ‘Use Sage Stock Fulfilment’ (Formally ‘Use Sage SOP Fulfilment’) setting. Anyone using existing allocation settings will see no change and will remain on that setting when upgrading.

Date applied: October 19, 2023

221.0.42

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 form additional information tab – corrected tab index order, fixed cursor appearing at the end of the production date field, allowed a decimal place within the numeric field and fixed information saving as soon as the WO is created.
Fix when deleting a works order with sub assemblies [“Execution timeout expired”]
Fix when unbooking a works order when unconfirmed costs are turned on, check nominal postings have been made before creating a WIP Summary posting [“Object Reference error”]

Date applied: October 17, 2023

221.0.41

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 importing works order lines to honour the setting for sub assemblies ‘Allocate From Free Stock If Available’
Fix to exclude deleted preallocations when getting the ‘Actual Quantity’ for creating a project transaction after booking in a finished item [“Object Reference Error]
Fix for the components summary tab on works order screen not showing any details.

Material Resource Planning

Fix for grouping suggestions when the grouping matches set the date to the earliest suggestions, issue where suggestion were too late as the earliest suggestion was a sub assembly

Kitting

Fix when building a kit and it would incorrectly check that enough of each kit line has been allocated for the quantity to build

Date applied: October 10, 2023

221.0.40

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 an issue when amending or completing works orders and it would refer to a Sicon Projects dll when Sicon Projects was not installed [“Could not load file or assembly ‘Sicon.Sage200.Projects.Objects version x or one of its dependencies”]

Date applied: October 6, 2023

221.0.39

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 getting operations to delete, when refreshing the rough cut screen [“Object Reference Error”]
Fix to pass through the ‘Name’ and ‘Description’ in the correct order when creating a new Sicon team off the back of creating a new Labour resource Group… Issue where the description was being set as the name and the name as the description

Material Resource Planning

Fix when creating user suggested purchase orders to exclude quarantined warehouses from being selected and attempt to default the warehouse to the same as the original suggested purchase order if that location exists on the stock item

Date applied: October 3, 2023

221.0.38

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 components onto operations
Added a summary list on the Materials tab

Issues Resolved

Works Order Processing

Fix when updating a quotes selling price that is linked to an estimate, to send through the total selling price from the estimate, issue where the cost value was being sent through
Fix when changing the works order quantity to make sure component line quantities honour the stock setting ‘On adding line to works order round quantity up to’
Fix to reset the ‘Completed’ flags on copied operations when copying a works order
Fix to create ‘WIP Summary’ entries when unissuing or unbooking a works order
Fix when creating a works order where the child sub assembly has a eco batch quantity and it was displaying to set this quantity to a negative figure. This would happen when there was enough free stock to fulfil the works order line and then a the eco batch popup would appear suggesting to create a works order for a negative value
Fix when creating a purchase order for a works order line to set the document date to todays date
Fix corrected the works order list view to get the correct BOM version
Fix when backflushing works orders where sub assemblies contain no materials to book these sub assemblies in as part of the ‘Allocate and Issue’ process so the parent works order can be issued correctly
Fix when creating a works order sub assembly to make sure we do not over preallocate the parent works order line… Issue where economical batch size was turned on and this would create 2 sub assemblies which combined have a greater total than the original works order line. This would result in the parent works order line being over preallocated

Material Resource Planning

Fix when running MRP for only suggest PO’s for supplier via stock or direct deliveries [“Value cannot be null”]
Fix when running MRP where a BOM would have the same stock item and it would duplicate the child BOM line suggestions

Kitting

Fix if the user adds kit line to back order when using the ‘Build Kit’ menu item and they then build the rest of the kit. Make sure to unlock the new sales order lines… Issue when editing the order it originated from [“Must set field StockItem”]
Corrected an issue where the radio buttons on the settings screen in the conversion tab where all grouped together

Date applied: September 26, 2023

221.0.37

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 attempting to book in a works order where lines are bulk issue and of stock type Miscellaneous, setting ‘Issue Bulk Issue Items At Book’ as true and these lines wouldn’t get correctly issued. Therefore the works order wouldn’t get booked in
Fix when using the setting to ‘Issue Bulk Issue Items At Booking’ to exclude bins where the free stock is in minus to issue from
Fix to adjust the sub contract line quantity when the associated purchase order line quantity has been adjusted. Check to make sure this doesn’t go below the allocated or despatched quantity
Fix to display a message when generating works orders from sales orders and the item that the works order is being created for is set to ‘Default Bought’. Brings this inline with manual works order creation
Fix when allocating a works order line with the setting ‘Auto Allocate To A Bin’ and it would not allocate any stock when there is free stock available
Added a new flag on the ‘SiWorksOrderLineIssueHistory’ table to show when a line has been unissued. Now create a new entry on this table for ‘Unissued’ lines so that we can get true linking to the transaction history table
Fix to correct store the production date and continuous flag of a works order when the works order is created [“Object Reference Error”]
When component list refreshes on the amend works order screen, the list would go back to the top, when the users would prefer it to stay in the current position. This is particularly useful with large works orders.
Updated the unbooking message when there is not enough stock in the location it was booked into to give the user some more information
Fix to correctly display the ‘Allocated’ or ‘Issued’ batches to a works order when viewing on the context menu
Fix to check the user has selected a ‘BOM/Template’ before searching [“Object Reference Error”]
Fix to increase the maximum value of a numeric field before setting this value… Issue where values stored above 100 would keep getting set back to 100 when amending a works order

Material Resource Planning

Fix when getting the works order min stock, reorder level or maintain zero suggestions to check the ‘Default Built/Bought’ flag on a stock item… Issue where suggested works orders were being created for items that are ‘Default Bought’ items when it is only a re-order level suggestion needed
Fix to suggested works orders quantity allowing value to be set to a negative number or zero.
Fix to prevent user from adding inputting 0 into the quantity field of suggested purchase order lines table
Fix the clear the ‘Follow Up’ filter on the suggested purchase order tab in MRP when hitting the ‘Clear’ button

Kitting

Fix when attempting to disassemble kits on a sales return and the user would get an error [“Invalid column name ItemDbKey”]
Fix to also stop the prompt to create a kit on the fly when creating a new sales return

Date applied: September 12, 2023

221.0.36

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

Kitting

Added new kitting web API methods to create, allocate and build a kit, these web API methods can be used when the ‘Use Allocation’ setting is turned on

Issues Resolved

Works Order Processing

Fixed to store the reason code in the SiWorksOrderHistory table

Material Resource Planning

MRP will now honour the Projects setting ‘Auto Issue After Goods Received’ and any purchase orders that are associated to a project will display in the ‘Future Stock Movements’ screen as being automatically issued and will also not be considered when running MRP
Fix when creating suggested purchase orders, to honour the setting ‘Supplier Lead Time Calculations in Calendar Days’… Issue where suggestions for weekends were being brought forward to the Friday incorrectly

Date applied: September 5, 2023

221.0.35

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 there is no works order cost and we calculate the values to split when there are items that are standard cost [“Attempted to divide by 0”]
Fix to keep phantom lines all together when they are added to a works order… Issue where multiple phantoms would get added and when viewing the works order there would be no order to how they were added
Fix to hide the ‘WIP Summary’ tab when the stock setting ‘Integrate with nominals’ is turned off

Kitting

Fix when using ‘Add To back Order’ in kitting and part way through the user would get an error [“Collection was modified; enumeration operation may not execute”]
Fix for some of the sales order lines that were created would be “locked” and therefore could not be edited
Fix to also get the ‘Unit Selling Price’ for the new sales order lines when adding them to the sales order

Date applied: August 30, 2023

221.0.34

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 with Projects Integration and Works Orders and it would ignore the setting “Issue Stock to Projects”

Date applied: August 23, 2023

221.0.33

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 copy batch attributes across all batches when booking in a finished item

Issues Resolved

Works Order Processing

Fix when duplicating or loading a stock item where there are Manufacturing attributes [“Failed to update objects”]
Fix to correctly export the manufacturing attributes set when exporting from ‘Sub Contract Maintenance’ screen and the item is the finished item of a warehouse.
Added a purchase order filter to this tab to make searching easier
Fix to allocations form not displaying components in the correct sequence

Date applied: August 16, 2023

221.0.32

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 a new web API method to get works order finished item transactions (Get Works Order Finished Item Transactions)
Added a new setting to default the ‘Use by’ date on a finished item that has a shelf life to be calculated from the ‘Booked In’ date

Issues Resolved

Works Order Processing

Fix to make sure we read the traceable item to get the correct ‘Use By’ date before sending it back… Issue where new SiWorksOrderSerialNumber were being created and then the information we would send back would be today’s date rather than the TraceableItems ‘Use By’ date which is set by Sage when calling the ‘Retrieve Production Orders’ web API
Fix to overallocation WOP setting not allowing overallocations
Further error logging when backflushing through the web API
Fix for using the ‘Booked Finished Goods’ web API end point and it would complete part booked works orders causing it to post the full cost of the works orders incorrectly
Fix to check an operation resource or component has been sent when creating a BOM through the web API
Fix to not display the preallocation popup if the setting ‘Do not ask to allocate preallocated lines’ is true
Fix when selecting the traceable tab and the user would get an error [“Object Reference Error”]
Fix when creating the WIP summary when issuing components to check the stock item setting ‘Integrate with Nominals’ [“Object Reference Error”]
Updated the API method (Create Labour Timesheet) to include OperationID, SiWorksOrderLineID, SiWorksOrderID, Quantity and Status
Display better message when there is not enough stock in bin to allocate component line. Also fixed issue when using sage sop fulfilment methods to allocate, and needed to allocate across multiple bins
Fix when viewing the ‘Traceable Item Enquiry’ and the traceable item is associated to a deleted works order and it would error out [“Unable to locate one works order with the works order number ‘X’]
Fix to filter out deleted works orders on the view to get the current balances on a works order and unallocated view
Fix when calculating the split of cost for finished items, to not change the value of ‘Standard Cost’ items
Fix to use the bin that has been selected by user if the setting ‘Show allocations screen’ is turned on
Fix to an issue where works orders created from the web API would not have project transactions created without having to amend the works order
Fix when adding or updating an operation via the web API to correctly update the quantity field on the works order line that is associated to it with the expected hours value
Fix when using “standard cost” finished items that have a higher value than the works order cost… when recalculating the lines on the ‘Finished Item Tab’ the value of the other finished items will be set to 0 unless they have been manually set. A variance posting will be posted upon completion of the works order

Material Resource Planning

Fix when running MRP the user would incorrectly get suggestions made for warehouses that are marked as ‘Returns’ or ‘Direct Delivery’
Stock transfers are now created between the works order finished item and the sales order line if they are pre allocated to each other and the warehouses are different.

Kitting

Fix for an issue where kit line required quantities were being incorrectly calculated using the ratio which was only being stored to 5dp and therefore causing rounding errors, therefore when allocating and building a kit where the line quantities had changed it would would incorrectly recalculate the value to allocate or build
Fix to filter the warehouse bins by the selected bin for the kit line… Issue on Web API where the user would pass a bin item in and this would not be used when issuing the kit line
General clean up of the kitting settings screen
Default the kit finished item quantity to 1 if this has not been set already adding a new kit line [“Attempted to divide by zero”]
Fix corrected the line quantity that is required when part building a kit

Date applied: August 9, 2023

221.0.31

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 for using the ‘Booked Finished Goods’ end point and it would complete part booked works orders causing it to post the full cost of the works orders incorrectly.
Fix when selecting the traceable tab and the user would get an error… No longer join to the stock item table on the control as we do this by default [“Object Reference Error”].

Date applied: July 28, 2023

221.0.30

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 updated the data type on the finished item request object for DateTime types to help with serialization.
Fix to when using the ‘BookedFinishedItem’ API method when booking non traceable items in to not include or validate the traceable information.
Fix to when allocating a sub assembly pre-allocation to pass through the correct quantity… Issue where the full works order line quantity was being passed through and this would cause it to error as there was not enough free stock.
Added a new setting to allow the user to select whether they would like the use by date to be set via the production date or by the earliest component date.
Fix to get the correct cost of a purchase order line when creating PO’s from a works order… Issue with suppliers in different currencies and changing the value even if the value come from the stock item supplier
Fix to set the BOM component line type when posting a comment line to the BOM creation methods [“You must specify a valid Stock Item for a Component Line.”].
Amended the MRP sql script by stopping it picking up all transactions of transactiongroupID 1 with replacement suggested (6,15,23).
Fix to item name not displaying name for any stock code on subcontract management form grid.
better handling when there we don’t have a cost price to recalculate the values from [“Attempted to divide by zero”] – Enable and disable the split line button dependent on the quantity booked in
Fixed issue where ‘Use By’ date was being reverted to the current date for booked items.
Fix for recalculating the values/percentage when new items have been added and the cost of the works order has changed.
Fix to make sure our finished item totals are correct before we book and unbook a finished item, issue with recent finished item changes where the unbook value would be different to the booked value also always set the cost of the works order if there is only one finished goods and set percentage to 100.
Fix to when using the ‘BookedFinishedItem’ API method when booking non traceable items in to not include or validate the traceable information.
Fix to update the percentage and variance when there is only one finished item on the finished item tab

Date applied: July 28, 2023

221.0.29

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 options to group suggested works order sub assemblies by a defined period in MRP.

Works Order Processing

New message box pop up on the works order form -Appears if stock item warehouse doesn’t match the default component warehouse, finds the reason why and displays it, if stock item doesn’t exist in either WOP settings on stock item details or WOP settings default component warehouse the message will display where it HAS been set to.

Issues Resolved

Works Order Processing

Fix to when retrieving the movement balance record for a works order to calculate the cost of the works order to only sub string this value when it is over 20 characters long.
Fix when issuing stock to a project [“Object Reference Error”].
When component list refreshes on the amend works order screen, the list would go back to the top, when the users would prefer it to stay in the current position. This is particularly useful with large works orders.
Fix to get the correct sub assembly number when creating a works order
Updated the ‘Create Sage BOM’ and ‘Update Sage BOM’ web API methods to allow the user to add or update operation resources on a Sage BOM
fix to when booking an item in where not all components have been issued and the backflush screen would appear but would not correctly populate.
Fixed an object reference error when updating / creating BOM from web api when no operation details are provided.
Fix to set the requested delivery date when adding a sub contract line to an existing PO to the operation due date… This follows how the requested delivery date is set when generating a PO.
Fix to display to the user whether a purchase order line is linked to a works order sub contract when the user is going to cancel an order and then allow them to either cancel the deletion process or they will hae the associated sub contract transaction deleted [“Object Reference Error”].
Fix to when creating a works order with sub assemblies to pass through the correct warehouse for the finished item warehouse [“Object Reference Error”].
Fix for getting the correct nominal amount when posting hte issue cost for the WIP summary… Previous issue where it was pulling the average cost of the item however this could be different for FIFO items.
Fix to use the total cost column to get the correct total value when updating a quote from the works order summary… Issue previously where the unit value was larger than the total and therefore this would send an incorrect value back to the quote.
Fixed works order appearing as ‘completed’ instead of ‘booked’ when the WO number is greater than 20 characters.
Fix when deleting a works order where there are sub contracts and therefore no stock item associated when adding this to the history to use the line comment rather than the item code

Kitting

Fix to when building kits on the fly on a sales order and a reserved quantity would get left on the stock item and the setting ‘Use Allocation’ was turned on… Issue would occur when there is some free stock available that can be allocated to the sales order but doesn’t make the required quantity and this value would then go to reserve on the stock item but would not clear.

Date applied: July 28, 2023

221.0.25

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

Material Resource Planning

When creating a top level works order from MRP, it wasn’t using the warehouse set on the stock item. It was using the warehouse of the suggestion.

Date applied: July 28, 2023

221.0.28

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 improve the loading speed when viewing a stock items balances.

Kitting

Fix to when part building a kit where the components are batch items, to correctly set the batch amount to be used when building and the stock setting is select serials at despatch.
Fix to when trying to disassemble a large quantity of items with high cost, an error message displayed.

Material Resource Planning

Updated the stored procedure when getting suggested MRP operation lines, to subtract the total pre-allocated quantity for that operation line from the quantity otherwise we can get multiple suggestions for the same operation line when there are multiple pre-allocations for that operation line.
Fix to when running MRP and processing existing stock movements to not include reallocated quantities in our running free stock balance… Issue where suggestion would get deleted too early in the process due to reallocated ‘in’ movements increasing the running balance this would cause MRP to believe there is enough stock to fulfil the demand and then by the end of the run a ‘Minimum Stock’ suggestion would be created as the free stock balance would end up in minus.
Fix to correctly treat a ‘Built/Bought’ item that is defaulted to be ‘Built’ as BOM line when running MRP. Previously these items would not be included when running MRP
Fix when running MRP for suggested works orders and the usage due date falls on a weekend make sure our suggestion date comes before the weekend… Issue where the suggestion would come after the weekend and therefore after the usage

Date applied: July 28, 2023

221.0.27

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 ‘Select All/Deselect All’ to MRP Kitting tab.

Issues Resolved

Works Order Processing

Fix to when adding a new works order line that is a sub assembly but the setting ‘Separate WO For Each Sub Assembly’ is turned off to still add this line as a line type ‘Sub Assembly’.
Fix to when adding a new component line to check that it is a sub assembly before changing the line type.
Fix to no longer automatically update works order comments when amending/saving a sop order. Added a new button on the ‘Works Order’ tab to allow the user to manually update these if they wish to.
Fix to add the default project phase, stage and activity (–/–/activity) to a works order if none have been selected… Issue when viewing the the project where phase, stages and activities are not enabled and the column to display these would be empty.
Fix to allow the user to either add Materials, Operations or Both when adding a new finished item to a works order.
Fix to when creating a new works order to select the highest bin priority for the finished items bin.
When component list refreshes on the amend works order screen, the list would go back to the top, when the users would prefer it to stay in the current position. This is particularly useful with large works orders.

Material Resource Planning

The ‘Previous MRP results’ form will now open to the results tab by default & from the ‘Material planning’ form the ‘Show Results’ button will now open straight to the results tab.
Fix to when using the calculate button and it would send a minimum date through to be calculated with [“SQLDateTime overflow”]
fix when it would not update the MRP grid correctly when calculating all the lines, this would just sit displaying “calculating”.

Date applied: July 28, 2023

221.0.24

Issues Resolved New Features

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 a new web API method to book a finished item in.

Issues Resolved

Works Order Processing

Resolved memory issues on the Import Forecasts Screen
Fix object reference error when amending stock item via the web api.

Kitting

Fix to building kits on the fly on a sales order and a reserved quantity would get left on the stock item… Issue would occur when there is some free stock available that can be allocated to the sales order but doesn’t make the required quantity and this value would then go to reserve on the stock item but would not clear.

Material Resource Planning

When creating a top level works order from MRP, it wasn’t using the warehouse set on the stock item. It was using the warehouse of the suggestion.

Date applied: July 28, 2023

221.0.23

New Features

feat(wop-emptyworksorder-api): added an API method for creating a new empty works order
feat(wop-api): updated the works order creation and amend api methods to also allow the user to update the project phase, stage and activity

Issues Resolved

fix(sub-assembly-popup): fix to make sure the sub assembly popup is always displayed in front of the other screens when creating a works order
fix(mrp-booked-wos): fix to not exclude booked works orders for components that have not been allocated/issued on a works order… Issue with the setting ‘Booked Finished Goods Without Issuing’ and MRP would not generate a purchase order for these items and the usage would not display on the ‘Future Stock Movements’
fix(wop-projects-integration): fix to add the default project phase, stage and activity (–/–/activity0) to a works order if none have been selected… Issue when viewing the the project where phase, stages and activities are not enabled and the column to display these would be empty
fix(kitting-sop-lines): fix to bring sales pro-formas in line with sales quotes in terms of kitting… Issue where kitting would try to allocate a kit to a pro-forma line
fix(kitting-proformas): fix when creating a kit for SOP proforma line and this would break the bindings on the screen
Further fix to move the preallocation when converting a proforma to a sales order so when the kit is built it will allocate the sales order, also delete the preallcoation if the user attempts to build the kit without converting it first and display a warning to the user that this is going to happen
fix(kitting-proforma): fix to refresh the kitting button text at the correct point
fix(kitting-dissemble): fix to add an allowable warning when the debit and credit nominals are the same for this transaction. Added a message box to allow the user to either continue or cancel the transaction if this is the case
fix(wop-bulk-issue): fix when issuing bulk issue items on booking a works order and it would not issue the stock in bin priority order
fix(wop-attributes): fix to improve the loading speed when using Manufacturing attributes on a sales order line
fix(mrp-timeout): updated the SiconMRPSalesOverLeadTimeView to use only one sub query as this caused a timeout
fix(mrp-create-wo): fix to update the works order stage when it is created from MRP
fix(wop-sub-contract-filter): added a new filter to the ‘Sub Contract Management’ screen to allow the user to filter by the works order number
Corrected the column on the ‘Backflush’ screen from ‘Original Qty’ to ‘Outstanding Qty’
fix(wop-creation): fix when creating a works order to use the original default component warehouse if the warehouse for components hasn’t been set [“Object Reference Error”]
fix(wop-backflush): fix when backflushing works orders where there are multiple finished items and it would default the quantity of all finished items to the original finished item quantity. This now allows them to add a boked and scrapped quantity for each finished item
fix(wop-copy-works-order): fix for setting the “Generated Date” to today on copied works orders
fix(wop-desktop-list): fix on the works order desktop list to make the ‘Generated Date Short’, ‘Start Date Short’ and ‘Due Date Short’ to field type of ‘Date’ so that those columns can be correctly sorted

Date applied: May 26, 2023

221.0.22

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 currency conversion columns like the ‘Materials’ tab when viewing the works order summary tab on an estimate to ‘Non-Stock’, ‘Labour’, ‘Machine’ and ‘Sub Contract’ tabs
Updated the summary tabs to now all follow the ‘Materials’ tab when foreign currencies are involved. Added a new column to the ‘Summary’ tab for the total in the currency too

Issues Resolved

Works Order Processing

Fix to display the correct ‘Unit Total’ on the works order summaries for all the tabs. Also made sure all columns that are numeric display on the right hand side

Date applied: May 24, 2023

221.0.21

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 selecting a Project on works order with the new projects method

Material Resource Planning

Fix to make sure MRP suggests the ‘Min stock suggestion’ or ‘Reorder level suggestion’ at the earliest date that it can arrive and then fixed an issue with grouping to make sure the min stock suggestion is processed first therefore it cannot be moved and grouped with other suggestions but other suggestions can be grouped with it.
Fix to when works order is created from suggested works order in material planning, it wasn’t using the warehouses set on the stock item.

Date applied: May 24, 2023

221.0.20

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

Change to now use the project header factory to get the project header.
Fix to stop project transactions being updated on completed works orders.
Corrected issues with future buy price for sub assembly component lines. The future buy price was not the unit cost, but the total cost. This was incorrect and now its set as the unit cost.
Fix to take the machine or labour efficiency percentage into consideration when adding operations to a works order.
Fix to get the correct sub assembly number when creating a works order.

Material Resource Planning

Fix to improve the loading speed of the ‘Suggested Purchase Order’ tab.
Fix for the screen hanging when saving the stock item from the suggested purchase order tab in MRP.

Date applied: May 24, 2023

221.0.19

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(wop-issue): fix to not filter the ‘Issue Allocations’ screen when bin items are sent in but instead set the quantity to be issued to the associated bin
fix(mrp-calculate): fix when calculating the date for a BOM on a sales order to first check the free stock available and then reduce the amount that is required by this. Issue when calculating the operation times where it was including the full quantity and therefore giving an inaccurate date
fix(wop-allocations): fix when splitting lines on the allocations screen and the ‘Split selected allocation with another warehouse’ button would not do anything
fix(wop-split-allocations): fix to also check whether the setting ‘Use FIFO Allocation’ has already added the new split line when splitting the allocation
fix(wop-update-from-bom): fix to correct the ‘Update From BOM’ routine where it was doubling the quantities for some records

Date applied: April 14, 2023

221.0.18

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(wop-copy-estimate): fix for the missing estimate selection control when copying an estimate
fix (wop-batch-booking): fix when booking a works order in that is a batch item and has auto generate batch numbers on to also consider the ‘Separator Character’ length [“Input string was not in the correct format”]
fix(wop-creation): improved the performance of creating works orders
fix (wop-trial-kitting): fix to get the correct ‘Default Location For Components’ from the stock item when creating works orders from ‘Trial Kitting’
fix(wop-workflow): fix to set the SOP quantity when the item is of type ‘Built/BOM’

Date applied: March 31, 2023

221.0.17

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(wop-sub-assembly): fix when creating a sub assembly when the form no longer needs to popup to get the correct finished item from the stock item settings
fix(wop-sub-assembly-creation): fix when the setting to always ask before sub assembly is turned on to make sure the form is always shown
fix(wop-sub-assembly-creation): fix when creating a sub assembly to keep the parent works order line warehouse as the default component warehouse for the parent WO because if the sub assembly is coming from a different warehouse when it is booked in a stock transfer will get created
fix(wop-maintain-teams): fix when saving a team where the associated labour resource group has been deleted, to allow the user to recreate a new labour resource group to be linked to the team so that it can be used on BOM or WOP [“Unable to update the object (Sage.Manufacturing.PersistentObjects.PersistentLabLabourResourceGroup, ) as the object has been deleted”]
fix(wop-maintain-teams): fix when maintaining a team and it would create duplicate entries
fix(kitting-build-kit): fix when on the build kit screen and they would change the quantity to build of a kit line and it would recalculate the quantity which could sometimes lose the precision from the entered value (ie will drop a couple a decimal places)
fix(wop-copy-wo): fix to display all works orders so that they can be copied including completed works orders
fix(wop-settings): fix to make sure the setting ‘Show Traceable Adjustment Form’ remains in line with the stock setting when serials are selected
fix(wop-amend-stock-item): fix when amending a stock item and it would appear to remove the locations from the stock item and therefore force the user to make the item inactive when saving
fix(quantity-validation): Fixed issue where customer was able to set a quantity of 0 to a component line after clicking the ‘Edit all quantities’ button. Added validation to prevent this.
fix(wop-add-finished-item): fix when adding a new finished item and the component warehouse would not be the same as the works order default component warehouse.
fix when adding a new finished item (built item) and the user adds BOM components from the new item to ask the user if they wish to consolidate the new works order line with the existing ones if they can be
fix(wop-add-finished-item): added the bin priority to the bin lookup dropdown and then sorted the bins that get displayed by ‘Allocation Priority’
fix(wop-add-finished-item): fix when adding a new finished item and user selects to add the components for that BOM to the works order to also add the operations too

Date applied: March 24, 2023

221.0.16

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(wop-allocations): fix when allocating a line with warehouse hierarchy turned on and it would not allocate due to it checking for bins with a quantity of 0 or more

Date applied: March 14, 2023

221.0.15