Common Components v22.1
Fix to update the pre-allocation correction routine that gets run from MRP to check any ‘Warehouse Stock’ type pre-allocations are correct. ‘Warehouse Stock’ pre-allocations should only exist if the purchase order or works order is being order/built from another warehouse to fulfil the Min or Reorder level of another warehouse, #9820.
POP Import Sicon Diagnostic tool too added.
—
Added an adjustment co-ordinator to handle SOP and POP adjustments, #8217.
Base CSV Import architecture improvements, #9340.
Date applied: May 8, 2024
Updated to be compatible with Sicon DevExpress 23.2 Packages.
Sicon WebAPI endpoint GetPurchaseInvoices will now return any applicable Project analysis for nominals, #9612.
Add new status Enums to show picked or part picked status on Active Kits List, #7893.
Added a new SiconDiagnostic class that posts a log file (no functional changes), #9423.
Updated Manufacturing data model.
Resolved a “failed to compare two elements in the array” error when using the sort method on a Sage list (POP008), #9331.
SFDC error when starting an operation on SFDC app, Method not found set_StopReference, #9666.
Fix Barcoding ‘The highlighted items use batch/serial numbering and require numbers to be confirmed …’ error when reducing allocated quantity of a traceable item with batch/serials assigned at allocation, US 9631.
Stock Shortage Transfer Import validation fix for ‘The quantity entered is greater than the free stock …’ error when no quantity to allocate is set, Case 38529.
Resolved a null reference exception when closing the base form.
Software dependancies: Sicon DevExpress 23.2 Packages
Date applied: May 1, 2024
Added Stock Transfers hidden ‘Unallocate’ button for selected, #9201.
ProcessUnallocationsAndMoveStock method change to update traceable item Additional Reference, Use By & Sell By dates if passed (Case 38366) & set stock transaction analysis codes, US 8797.
MoveStockAndAllocationToBin method change to update traceable item batch attributes if passed, Case 38366.
Fixed ‘object reference error’ when receiving a batch item in Barcoding for an existing batch item with batch attributes changed, #6556.
Added an extra check before creating a cross warehouse pre-allocation transfer to make sure we have a source and destination warehouse for the transfer.
Fixed Operation times issue with expected hours calculating incorrectly when changing the quantity per run value on an operation when editing the operation, #6511.
Resolved an issue with whitespace being encrypted in common settings.
Date applied: April 17, 2024
Timesheet line rejection reason field added.
Inspections enhancements:
– Added ability to set the default value from the inspection template questions grid, #6397.
– 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, #6397.
– Corrected inspections ‘value cannot be null’ message when adding a new global template, #6397.
– Fixed issue with input string not in correct format when setting default values on the inspection template questions grid. Also changed the control for a number question and a selection question to show the correct input controls, #6397.
– Fixed issue with answers for selection option not copied to templates on stock item and works orders correctly. Also fixed issue where answers for selection option was not saved first time, #6397.
– When viewing inspections and amending the values, it was not displaying the changes straight after the amendment, #6397.
– Added clone inspections option in code so that we could create inspection templates for all levels of sub assemblies in works orders, #6397.
– Now update the default answers on the works order template after booking in and answering inspection questions, #6397.
– If the same batch is booked in on a separate works order, then the inspection answers are updated, #6397.
Pre-allocation view now handles Service Parts, #9201.
Fixed problem when issuing stock after a pre-allocation is fulfilled and the traceable details were missing, thus showing an ‘object reference …’ error, #9220.
ProcessUnallocationsAndMoveStock() method change to update traceable item batch attributes if passed & ‘IsUpdateTraceableBatchAttributes’ parameter is ‘true’, Case 38366.
Updated Barcoding data model, #8340.
Date applied: April 10, 2024
Stock shortage transfer now allow multiple transfers to be selected for deleting at same time, US 9454.
Stock transfer transaction analysis codes 5-20 added so available to be populated by Barcoding Inspection Failed, US 8797.
Date applied: April 3, 2024
Allocations fix to allow the ‘Activity Date’ filter be applied when the fulfilment strategy is set to either ‘Oldest Use By date’ or ‘Oldest Sell By Date’. Issue where we would select batches past the use by date when allocating works order lines, #8789.
Fix ‘ReduceAllocationOnSalesOrderLine’ method not reducing sales order Allocated Status ID value after unallocating stock from a sales order line, US 8962.
Date applied: March 27, 2024
Changes to make sure that timesheets work with works orders.
Made sure an employee was selected before timesheet entries can be entered.
Daily calculations for timesheets and works patterns were not calculating correctly if there were multiple timesheet entries.
Fixed issue with issuing stock during Backflush where the allocated works order line is allocated across multiple bins. The fulfilment process for the traceable items was not taking the bin into account, #8921/#8844.
Stock Transfer to project now retains allocations when allocating at new transfer, #8934.
Fixed issue where the stock unit available to despatch quantity was not correctly set when a Pre-allocation is fulfilled. Therefore the sales order would end up as part despatched, and the quantity to despatch was incorrect, #6537.
Added feature level locks.
Date applied: March 20, 2024
Stock Transfer Import allocation quantity validation changed to allow zero allocated, Case 38529.
When writing off stock in Dynamic Stocktake nd 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, #8202.
Fixed SiBespoke database table types causing locks.
Date applied: March 13, 2024
Staged Nominal Accruals removed code that was causing Projects to work out Project Enquiry, #8606.
Added new columns to Operation header table to store cost and selling price values to be used in projects, #8907.
Distribution ‘trial’ license/enable string will now include all sub-modules, US 8941.
Updated Barcoding datamodel.
Date applied: March 6, 2024
Fixed CSV Import form using TCM message box instead of architecture #8890.
Unit Price and Quantity Labels will no longer be switched for call-off orders. #8870.
Fixed a null ref exception when cancelling a PO (POP020), #5002.
Removed the Software Licence agreement link.
Updated the Manufacturing DataModel.
Date applied: February 28, 2024
Added analysis codes to the stock items request model (no functional changes).
Added ‘StringBuilder’ for HTML Formatting (no functional changes).
When a stock transfer is edited, and received on the edit screen, the status of the transfer was not updated on the Stock Shortage Transfers screen, Case 37930.
Updated the module ID’s for ‘Works Order Processing’, ‘MRP’, and ‘Kitting’, #8463.
Date applied: February 21, 2024
Added a Base Controller that supports post requests.
Fix Approval request failing if Common Components didn’t have a license for Approvals.
Move all appointment message service to Common Components, Case 8229.
Date applied: February 14, 2024
If no enable string is found for an installed module a ‘trial’ license will be requested from the Online Licensing server, #8459.
Customer locations selection enhancement to add new data filter setting on head office, address instead of branch account list, #8509.
Staged Nominal Accruals support added for goods received receipt dates in nominal journal postings, #8534.
Added new methods for copying Analysis Codes from a source to a target in analysis code tool, #8550.
Resolved an issue with the call-off orders scripts where it was leaving an object ‘dirty’ after loading.
Date applied: February 7, 2024
SiconAttachmentsControl, add function return selected files path, Case 7685.
Added tutorial form.
Fixed week 53 error on Timesheets when week start date is later than a Wednesday, #8588.
Change previous fix for ‘The highlighted items use batch/serial numbering and require numbers to be confirmed’ error appearing when removing traceable item SOP allocations for Barcoding, US 8444.
Date applied: January 31, 2024
Set Password Control to use System Password character.
Move equipment created/amended/deleted and appointment confirmed/unconfirmed message sources from API to object, to avoid service Web API call crash, Case 8229.
Fix/suppress error ‘The highlighted items use batch/serial numbering and require numbers to be confirmed’ appearing when reducing a SOP allocation for a traceable item with batch/serials assigned at allocation, US 8444.
Date applied: January 24, 2024
Added WEB API Message Sources for projects to use with Stock issues and Returns, #7722 #7723
Removed version numbers from ‘BaseSiconModule’, added base controllers, added enchange logging & error handling, expanded on examples and work on new base api controller.
Fix to no longer receive pre-allocations when pre-allocated to a kit line and the kitting setting ‘Enable Allocations for Kit Lines’ is turned off, #8343.
Date applied: January 19, 2024
Added additional function extension overloads class.
Stock Shortage Transfers fix ‘to’ bin selection drop-down to list bins in the target warehouse + throw exception if attempting to transfer between bins on different stock items, Case 36905.
Pre-allocations fix/check added when the user attempts to change a warehouse on a sales order line or purchase order line to make sure the lines are not pre-allocated. If the line is pre-allocated the user will be informed that they need to delete the pre-allocation before they are allowed to change the warehouse, #6686.
Date applied: January 10, 2024
Stock Reserves fix to set the correct ‘Quantity to Allocate’ when allocating a stock reserve. Previously this would not take the current allocated quantity into consideration and would therefore only allocate the free stock available, #7767.
Resolved an issue with the customer transaction enquiry form where the account reference would not focus on form load if EP was installed and Popup Notes enabled, Case 36002, #7817.
Date applied: January 3, 2024
Add from warehouse & to warehouse in base Stock Transfer screen grid/list, Case 28880.
Resolved an issue where call-off quantities were not being set correctly for free text lines, #6803
Corrected the warehouse when a pre-allocation is for a kit line to use the kit lines warehouse ID, #6370.
Fix to get the correct values for Stock Transfer pre-allocations when it is an ‘In’/’Out’ and creating new pre-allocations. Issue where stock transfers could be over pre-allocated, #6365.
Date applied: December 13, 2023
Pre-allocation changes, #7656.
– Cross warehouse pre-allocations will no longer create a stock transfer when they are created. Instead when the purchase order is received it will create/add to an existing Stock Transfer and be pre-allocated to this transfer (which in turn will pre-allocate to the ‘Out’ document).
– Added a new pre-allocation type ‘Warehouse Stock’ which will allow Manufacturing to pre-allocate to min stock suggestions when MRP is run
– Added a new pre-allocation view that returns the ‘Source’ and ‘Destination’ warehouse and due dates for pre-allocations.
– Updated the pre-allocation view to give the ‘In’ and ‘Out’ descriptions.
– Added a new method to fetch the pre-allocation view.
Set Exchange Office default connection limit to 999.
Resolved an issue with Call-off orders where editing a line after ticking the call-off box and saving changes would reset the quantity/unit prices, as the line was not aware changes had been made to it.
Change pre-allocation required quantity on operation to be multiplied by Quantity per run on operation, #6962.
Restored missing Projects data model.
Date applied: December 7, 2023
Contact list fix updating sub-location column with correct field, #5137.
Pre-allocations destination warehouse field added, #6800.
Enhancement Pack ‘ Popup Notes’ fix for licenses which limit the number of features that are available, Case 35855.
Architecture base SOP Order/Return form checks for existence of delivery address fields and if order/return is saved before new customer check.
Date applied: November 29, 2023
Fix for Works Order Processing back flush error ‘Collection was modified; enumeration operation may not execute’ during pre-allocation processing. This was due to multiple message service subscriptions within message notifications when deleting pre-allocations and stock transfer items, #5259.
Fix to call-off order state when amending orders, #6803.
CSV import fix to flag (IsDirty) when detected .csv files have changed.
Terms and conditions endpoint address corrected, data will now handle file contents being cleared and default back to encrypted empty data.
Projects data model changes to add Hired in plant detail to the Enquiry Plant view, US6043.
Date applied: November 22, 2023
Fix to the drop down of Custom Analysis Codes where if the list was amended, the old values were still in the settings cache, and therefore the user would still get the old values in the drop down list until sage was restarted.
Fix create new equipment notification message event fire logic, Case 34804
Purchase order creation factory new property added to allow a PO number passed from Web API to be used as the document number, Case 34603.
Meta data initialisation/sync client files amendments (no functional changes).
Date applied: November 15, 2023
Fix when adding a new sales order standard item line through the sales order factory to check the customer setting ‘Use Tax Code As Default’ to override the default, #6377.
Fix attachments control potentially showing an error if the progress indicator has not been initialised yet.
Fix when creating a pre-allocation from a works order to a sales order and it checks whether the projects on both match to also check the works order setting ‘Enable Project Integration’. There was an issue where we were checking works order and sales order projects match before creating the pre-allocation, #6697.
Add Appointment confirm message event to schedule, Case 34804.
Added cross cut message service events for SOP Returns, Quotes and Proformas and also added Projects specific message sources for these too (as well as extending the existing message sources to handle returns), #6636.
Extended Barcoding datamodel for SiconWABSmartPickingBinTraceView and SiconWABTransferItemView.
Date applied: November 8, 2023
Approvals app. fix for creating timesheet line entries issue, #6549
Date applied: November 1, 2023
Stock Transfers fix to set the value of the transfer type box when loading the stock transfer form… Issue when transferring to a project and then project controls wouldn’t be added correctly and the transfer would ask the user to set a warehouse, #6161.
Fix Analysis Code Tool handling for non-existent ‘CanAmend’ property on other entities except SOP and POP, #6275.
WOP/Projects now has added validation to the create pre-allocation screen when attempting to create a pre-allocation between a works order line and a sales order line with projects associated to both, to make sure both of these projects are the same, if not then pre-allocation cannot be created.
Truncated ‘OutDocumentNo’ on pre-allocations for project operations if the description is over 64 characters, Case 34421.
Fix SiconPreallocation database table missing primary key to improve performance and fix timeout in MRP, 35132.
Fix Enhancement Pack ‘Popup Notes’ not being displayed if other Sicon modules are not installed.
Date applied: October 25, 2023
Fix sales return factory additional charge and free text lines now accounting for imported tax codes, #5399.
Convert field types in timesheet related fields from (n)text to Varchar(4000).
Date applied: October 18, 2023
Resolved an issue where the popup notes tab would not appear when the Enhancement Pack package was not installed.
Date applied: October 10, 2023
Add total hours to each day in the ‘Amend Timesheet Clock Ins Lines’ form, 6135.
Add total hours, minutes and seconds to each day in the ‘Amend Timesheet Clock Ins Lines’ form.
Added extension methods for case sensitive filtering.
Added prefer server affinity to http headers.
Date applied: October 4, 2023
Added common setting for Exchange 365 URL, removed unused exchange settings.
Enhancement Pack ‘Staged Nominal Accruals’ foreign currency exchange rates added, #6045.
Works Order Allocations fix when allocating serial or batch items where the traceable bins have been passed through, to correctly update our dictionary with the correct bins and quantities [“An item with same key has already been added”], #6154.
Converted Notifications form/screen to use the new repeater control.
Date applied: September 27, 2023
Sales Order Import fixes to resolve validation error when trying to validate decimal numbers [#5988], validate item line description value has been entered if override item line description is set to true [#5250] and nominal spelling/typo [#4472].
Fix Work Pattern timespan over end/start of day calculated as full day, #5897.
Fix Notification ‘Dismiss All’ button not working, Case 6048.
Enhancement Pack ‘Customisable Sales Order Status’ setting validation added to limit to 60 valid characters, #4576.
Stock Transfer resolved issue with stock items with zero quantities being removed regardless of if the user says no to removing them, #4006.
Works Order allocations fix for issue where batches can be split across multiple bins where bin 1 would be allocated and bin 2 would have stock and it would attempt to allocate from bin 1 incorrectly, despite ‘bin 2’ being passed to (i.e. use BinItemIDs/TraceableBinItemIDs), #5923.
Works Order allocation fix for ‘Value cannot be null. Parameter name: source’ error due to null TraceableBinItems collection, #5689.
Date applied: September 20, 2023
Sicon stock transfer import code from Barcoding into Common Components so that the import is available in stock transfers from other products.
Works Order Operations fix when calculating the start time of an operation. If the overlap percentage is 100% then return the previous operations start date.
Disabled Checking Enable Strings for TFA controller methods.
Exchange/office 365 integration overrides added for auto discover and redirect validation call-backs.
Sicon generic multi-select list check all/none/invert options (with read-only), added missing variables in property setters and null reference handling.
Enhancement Pack data model updated.
Date applied: September 13, 2023
Reverse fix to Name and Description textboxes being displayed the wrong way round, Case 32264 (applied to v221.0.38).
Fix Works Orders Operations, when creating a works order with an operation with an overlap and it is the only operation on the works order, to set the start date as the date has been passed through, #5865.
Add Equipment operation (Created, Amend, Delete) notification to equipment details.
Enhancement Pack data model updated to include legacy direct debit objects, #5682.
Service Manager data model change for Quote Details report printing, Case 28880 Part 2.
Updated contracts data model.
Date applied: September 6, 2023
Updated Self Service data model to include new ‘LastTrackingNoteDescription’ field.
Fixed error on updating employee rates from default rates (payroll) when only 1 employee exists, Case 32018.
Fixed an issue with Stock Popup Notes not showing, #5622.
Fix to Name and Description textboxes being displayed the wrong way round, Case 32264.
When a Sicon Stock Transfer was updated by despatching/receiving from the list of transfers screen, the status of the transfer was not updating correctly.
Sales order import fix to resolved issue with cost centre not being imported correctly, EP-SOP001, #5413.
Date applied: August 31, 2023
Add Employee Portal to list of enable strings (for future use).
Distribution Reserve Stock fix to read free stock out and add a new ‘manually allocate’ flag when calculating quantity to allocate. This is used to resolve an issue where the screen would still allocate, even if the user doesn’t want a quantity to be allocated, #5375.
Date applied: August 23, 2023
Fix (Works Order Processing) inspections when viewing completed inspections where the question type is a combo box, switch this to text box when it is completed.
Date applied: August 16, 2023
Fix pre-allocations checking the allocated and preallocated quantities match… Use the “preallocated Quantity” column when the “Available Quantity” column is not visible.
Date applied: August 2, 2023
Fix for missing Common Components scripted enhancements based on installed modules and enable strings. For example, the stock item maintenance ‘Inspection’ check-box was not shown when only Distribution was installed.
Date applied: August 2, 2023
Added a warning if the Sage 200 Log file exceeds 10mb.
Fixed issue where user would manually create a pre-allocation between a stock transfer and a works order line. The system would create a new stock transfer instead of pre-allocate to the selected existing stock transfer. The pre-allocation was created within works orders, but the same could potentially happen if pre-allocating to a sales order line, Case 29847.
Adding SOP analysis codes to web, analysis codes view changes for config, 5348.
Changed the notification List Form Message Column to auto size.
Fixed Sicon message box button display on message action bar.
Added values and default to analysis code view, 5348.
Schedule Control change to remove the background progress bar for now, Case 31892.
SQL script SiconAllocationLine is now created using spCreateTable so primary key is created. This fixes error ‘Cannot create more than one clustered index on table ‘SiconAllocationLine_index’ …’ if Barcoding is installed.
Updating barcoding data model to include new SiconWABTransferItem fields.
Date applied: July 26, 2023
Date applied:
Date applied:
Date applied:
Date applied: July 21, 2023
Date applied:
Date applied:
Date applied:
Date applied: June 14, 2023
Date applied: June 6, 2023
Intercompany fix to resolve issue with BatchStockTransfer not recording batch number details on stock item history when the transfer quantity is less than 1, BUG-4422.
Enhancement Pack sales order import duplicate field renamed “Override Item Line Description Value”, BUG-5028.
Date applied: May 31, 2023
Set auto-size on the LinkLabel control for SiconMessageAction and added error handling to control fader.
Updated Common Components data model.
Date applied: May 24, 2023
Stock Transfer part despatch/deletion processes changed to not call a messaging service when updating pre-allocations, as this causes transfer items to be deleted resulting in ‘Unable to update object x as it has been deleted’ the error. Move existing pre-allocations when part despatching a stock transfer and add extra checks when looking for existing stock transfers.
Date applied: May 17, 2023
Operations Scheduler performance improvement using added date range filter when collecting data, Card 4565/Case 28975.
Fix (Distribution-preallocations): Updated the ‘Receive Preallocations’ screen when receiving batch items that are pre-allocated to display the pre-allocated quantity required and the allocated quantity in a panel below the grid. Hide the ‘Preallocated’ quantity column to avoid confusion if multiple batches exist for the same sales order line, US 4692.
Fix for Barcoding Warehouse Transfer error ‘Serial selection failed on item ‘xxxxxx’, identification no ‘xxxxxx’, bin ‘Picked:Transfer’ – Of x.x supplied, x.x were unavailable’ for batch/serial items if source warehouse holding/quantity is below minimum stock level, US 4844.
Added Sicon Progress Dialog and additional parameters to the Sicon Message Box to architecture.
Added a pop up when refreshing the scheduler to say we are refreshing the calendar.
Remove all data model code that was used in checking for Sicon Features for an Employee.
Date applied: May 17, 2023
Distribution Allocation screen fix to correctly page the allocations grid (i.e. repeating data), US4526.
MRP preallocation fix when running the preallocation correction process to not delete preallocations for operation lines, BUG4590.
Enhancement Pack (SOP001) Fixed issue with sop import not using price band prices, BUG-4874.
Date applied: May 10, 2023
Preallocation functionality added to operation stock.
Fix Contacts List was not displaying customer account name, 28340.
Added logging to auth. controller.
Reinstate Sage.MMSAdmin.DbLayer to ensure add-on package versions are updated on Sicon Products system.
Date applied: May 3, 2023
EP-COM001 resolved issue with popup notes not showing on different forms related to same entity, BUG-4648.
Resolved memory leak when dismissing banners.
Date applied: April 26, 2023
Added SetViewOnly method to enable the attachment control to be set to View Only-mode
(This disables Drag & Drop, as well as editing buttons (add, set description, remove)
Date applied: April 12, 2023
Preallocations – When running the preallocation correction process (e.g. from MRP) do not include the invoiced amount of a purchase order as PO line can be invoiced without being received and this will cause the preallocation to be deleted without being received/completed. Also updated the ‘Deleted By’ to indicate in the process of deleting the preallocation, US4545.
When deleting an employee allowing for multiple reasons for the process to be cancelled and display errors as a list.
Fix contact list sub location description not shown.
CRM fix to resolve issue with Yes/No checkbox SiconAnalysisCode where tick-box would always load as CheckState.Indeterminate, BUG-4061.
Version Reporting now writes any errors to static messages, which can be viewed from the Enable Strings screen messages log.
Date applied: March 29, 2023
Date applied: March 21, 2023
Date applied: March 15, 2023
Date applied: March 8, 2023
Date applied: February 22, 2023
Date applied: February 10, 2023
Date applied: February 7, 2023
Date applied: January 27, 2023
Date applied: January 10, 2023
Date applied: December 13, 2022
Release version.
Date applied: November 11, 2022