Manufacturing

Sicon Manufacturing is a set of additional modules for Sage 200, integrated with Stock, BOM, Sales and Purchase Order Processing. Including modules for Job Costing, Works Order Processing and Estimating, this package can be configured for one-off job costed manufacture or high volume repeat production manufacture. Material and Resource Planning provides suggested works orders and purchase orders plus a rough cut capacity plan at labour and machine levels.

Search by different Manufacturing Modules:


Release notes:

Make it easier to find your content with:

Expand content Collapse Content New Features Only Issues Resolved Only Release Only Pre Release Only Hot Fix Enhancements Important Only

Know the release number? Use quick search:

191.0.13

Issues Resolved Important
Important Info

Please note that with this update, if barcoding is installed, Manufacturing will require at least version x.191.0.5 or above of barcoding.

 

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v191 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Distribution

  • Fix to create preallocation screen to stop over preallocting lines that already have preallocations

Works Order Processing

  • Fix to back flushing lines that are already part allocated or part issued

Kitting

  • Fix to kit status not updating after allocating using the Allocate kits screen
  • Fix to why the build kit button on a sales order line wasn’t enabled when creating a sales order line with allocate on order entry disabled
  • Code and name controls will now be disabled on active kits

Date applied: October 7, 2019

191.0.12

Issues Resolved Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v191 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fixes to costing finished items on works orders where the show finished items tab is enabled
  • Fix to issuing lines with multiple allocations
  • Fix to checking required works order line quantity when back flushing

Date applied: October 7, 2019

191.0.11

Issues Resolved Hot Fix Enhancements Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v191 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fix to back flush screen to clear build quantity values when closing out of the screen prematurely
  • Improvements to the part issue components screen in works orders for serial items
  • Change so a check for works order finished item quantity is made instead of if the setting is enabled
  • Fix to make sure serial numbered items are not allocated with a decimal value
  • Fix to works order status check for the part issued status
  • Fixes to setting budget and actual values on works order labour lines

Hot Fix Enhancements

Works Order Processing

  • Added the ability to part issue traceable components

Date applied: October 7, 2019

19.0.33

Issues Resolved Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v19 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Material Planning

  • Fix to stop intermittent object reference error when running for Kitting and Works Order Processing

Date applied: October 7, 2019

18.0.43

Issues Resolved Important
Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v18 FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fix to saving on sub contract screen that was causing lines to not be updated correctly

Date applied: October 7, 2019

18.0.42

Issues Resolved Important
Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v18 FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Update to the Confirm Goods Received page to handle updated most recent Sage200c release removing ‘Save and Allocate’ button.
  • Fix to part issuing a part allocated item.
  • Fix to splitting suggested Works Orders to stop Out of Range Exception.
  • Fix to part issued line costs not being set correctly when completing Works Order with unconfirmed costs enabled.
  • Fix to issuing traceable Works Order lines.
  • BOM Version now updating from the BOM.

Kitting

  • Fix to Object Reference error when cancelling a kit build when selecting serial numbers for the finished item.

Material and Resource Planning

  • Fix to forecast import when first line in CSV is the header.

Date applied: September 20, 2019

19.0.32

Issues Resolved Hot Fix Enhancements Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v19 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Build Time Screen date will show red if the date is in the past.
  • Fix to the numbering on sub assemblies within a Works Order.
  • Update to the Confirm Goods Received page to handle updated most recent Sage release removing ‘Save and Allocate’ button.
  • Traceable items with multiple history lines can now be un-issued.

Hot Fix Enhancements

Works Order Processing

  • Update from BOM now checks to see if a component line is now a sub assembly on the BOM and will show the create sub assembly screen.

Date applied: September 20, 2019

191.0.10

Issues Resolved Hot Fix Enhancements Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v191 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Build Time Screen date will show red if the date is in the past.
  • Fix to the numbering on sub assemblies within a Works Order.
  • Attachments will now be accessible on completed Works Orders.
  • Update to the Confirm Goods Received page to handle updated most recent Sage release removing ‘Save and Allocate’ button.
  • Traceable items with multiple history lines can now be un-issued.

Material Planning

  • Booked Works Orders will be excluded from the overdue and Department Work Schedule Tabs.
  • Operation label updated to display quantity.

Hot Fix Enhancements

Works Order Processing

  • Update from BOM now checks to see if a component line is now a sub assembly on the BOM and will show the create sub assembly screen.
  • Sub Contract Management now has a new column Last Updated Date and will order using that column by default.
  • Sub Contract Management screen now has an Un-Despatch button on the Sub Contract tab.

Date applied: September 20, 2019

191.0.9

Issues Resolved Hot Fix Enhancements Important
Important Info

Please note that with this update, if barcoding is installed, Manufacturing will require at least version x.191.0.5 or above of barcoding.

 

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v191 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fixed an issue where copying the Works Order also copied the printed flag.
  • Fixed an error occurring when allocation via the Process Works Order form when the setting to split allocations across multiple warehouses is activated.
  • Multiple minor fixes/improvements to booking works orders with multiple finished items.
  • Fix to part booking using back flush where costs were not being set on the finished item correctly.
  • Fixed issue where traceable batch type items wouldn’t un-issue if Sicon History does not exist.
  • Fixed an error where unallocation was trying to send the item to the Returns warehouse.
  • Fix to calculating finished item costs.
  • Fix to error when booking an item that is set to a bin that has been deleted.
  • Fix to error when tabbing out of the finished item screen.

Kitting

  • Fix to building a kit when select bin is enabled and the warehouse does not exist.

Material and Resource Planning

  • Fix to calculating suggested Purchase Order quantity when grouping warehouses and free stock is available in one but demand is coming from another.
  • Fix to suggested Works Orders getting the same number when the preallocate child to parent setting is disabled.
  • Fix to over suggesting Purchase Orders when combining all warehouses with free stock in one and demand in another, and the total amount suggested is greater than the minimum order quantity for the supplier.

Hot Fix Enhancements

Works Order Processing

  • Added better error message when an un-issue is attempted to an Internal Area that no longer exists.

Date applied: September 13, 2019

191.0.8

Issues Resolved Hot Fix Enhancements Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v191 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fixed error when creating a sub contract where the quantity breaks are not set correctly.
  • Fix to back flush free stock for component check so it only checks for stock needed based on quantity to build.
  • Fix to part booking on the back flush screen.
  • Fix to back flush booking where costs were not being set if the finished products tab was enabled but had not been viewed on a new Works Order.
  • Fix to Works Orders where if all lines were Part Issued the status was showing as Issued.
  • Fix a rounding issue when booking a Works Order with multiple finished items.

Kitting

  • Fix to allocating kit lines with a quantity of less than one.

Hot Fix Enhancements

Works Order Processing

  • Added a button to the Purchase Order tab to switch stock values between the warehouse on the suggestion and all warehouses processed if separate by warehouse is not enabled.
  • Added a Sales Order drop down to the back flush screen.

Date applied: September 13, 2019

19.0.31

Issues Resolved Hot Fix Enhancements Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v19 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fix to setting works order sparememo1 field to a value greater than 4000 characters
  • Fix to copying works orders so the printed value is not copied
  • Fix to why the ‘Unallocated on WO ‘ was not showing any value on the ‘View Item Balances Screen’
  • Fix to unissuing batch traceable items where no issue history exists in Sicon tables
  • Allocations now ignore returns warehouse
  • A more informative error message will now show when trying to unissue a line that was issued to an internal area that no longer exists
  • Fix to editing estimates where an error was thrown and the screen would not load

Kitting

  • Fix to creating an adhoc kit with component quantities less than 1
  • Fix to the ‘Build Kit’ screen to stop an object reference error

Material Planning

  • The warehouse value is now longer cleared when tabbing through the ‘Create Works Orders’ screen
  • Fix to why economical batch size works orders had the same suggestion number

Hot Fix Enhancements

Works Order Processing

  • Improvements to loading works orders from the ‘Process Works Orders’ screen
  • Speed improvements to the allocation process on works orders

Date applied: September 13, 2019

19.0.28

Issues Resolved Hot Fix Enhancements Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v19 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fix to stop error when sorting columns in the process works order screen
  • Change so the works order generated date is now populated with the works order created date where it is null
  • Fix to nominal rounding problems when booking in a finished item
  • Change to the variance posting setting so it is now always used when there is a variance and not just when the finished item is set to standard costing
  • Fix to not defaulting batch numbers on works orders when setting is not enabled

Material Planning

  • Fix to forecast import to handle the first line of a csv file being header values

Kitting

  • Fix to why some kit lines were not being issued when there is enough stock but the first bin in the warehouse is empty

Hot Fix Enhancements

Works Order Processing

  • Performance improvement when issuing works order lines

Material Planning

  • Added setting to exclude purchase orders in the past from availability calculation
  • Added setting to always use standard works order numbering

Kitting

  • New select serials screen will now appear in Kitting when selecting serials at allocation that will allow the user to select serial numbers from any bin in the warehouse

Date applied: August 29, 2019

191.0.7

Issues Resolved Hot Fix Enhancements Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v191 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Material Planning

  • Fix to stop the Sage login screen appearing when sorting by any column on the suggested purchase order tab

Works Order Processing

  • Fix to why it wasn’t possible to complete a works order that had deleted works order lines

Kitting

  • Fixed the problem of not all items being issued when a kit was built, where the item had enough free stock but the first bin was empty

Hot Fix Enhancements

Material Planning

  • Speed improvements to the suggested purchase order tab during and after load
  • The date range fields on the stock movements screen will now refresh the data

Works Order Processing

  • Speed improvements to the works order issue process

Kitting

  • A new screen will appear when allocating a traceable item when the show bin on kit line is enabled, which will allow the user to select a traceable item from any bin in the warehouse

Date applied: August 23, 2019

191.0.6

Issues Resolved Hot Fix Enhancements Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v191 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Change to SQL script so the works order generated date is set to created date where it’s null
  • Fixes to time sheet entry from a works order where transactions where being duplicated
  • Fix to works order cost calculations when booking multiple times, unbooking and booking again and using multiple finished items

Material Planning

  • Speed improvements to loading suggested purchase orders
  • Fix to why date format changes when exporting to excel from the Forecasts screen

Hot Fix Enhancements

Works Order Processing

  • Added the ability to book works orders that have not had anything issued if use unconfirmed costs is enabled

Material Planning

  • Added new setting to use sales order line description when generating purchase orders for a supplier via stock or direct delivery sales order

Date applied: August 18, 2019

191.0.5

Issues Resolved Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v191 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Material Planning

  • Check to creating purchase orders for suggestions that no longer have a reason, ie the sales order it was suggested for has now been actioned
  • Fix to the warehouse controls where not all warehouses were being selected incorrectly
  • Fix to the supplier popup so it is ordered correctly
  • Fix to exporting from the suggested purchase orders screen so the free stock column exports correctly
  • Fix to handle error on the stock running balance screen when loading lots of items and warehouses
  • Fix to forecast import so it ignores first line if its the headers

Works Order Processing

  • Change to the setting for showing the sub creation screen when a purchase order is available so it will only show if there is no free stock available for the item
  • Fix to the back flush screen so all finished items are shown at the end of the build process, added progress bar to the create WO from SO screen, fix to handle error on the stock running balance screen when loading lots of items and warehouses
  • Fix to the back flush screen so all finished items are shown at the end of the build process
  • Fix to how the exclude purchase orders in the past setting got enabled/disabled
  • Rounding fixes when booking in a finished item to round up cost price to 5 decimal places
  • Fix so estimate lines linked to sub assemblies use the sub assembly cost instead of using future buy price

Date applied: August 14, 2019

191.0.4

Issues Resolved Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v191 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fix to sub assembly creation popup screen to handle always showing if purchase available and do not always create sub setting config
  • Fix to build time calculation where include purchase orders in the past setting was being incorrectly checked and an incorrect next available date was being returned
  • Fix to flag a sales order to show works order creation screen on close so the screen will now only not appear if the don’t ask again button is clicked

Material Planning

  • Fix to why suggestions for items that have no movements and required a suggestion for minimum stock were not being created
  • Fix to populating old back to back information on a purchase order where new purchase orders were taking a while to load (only effects customers who have used SiBackToBack table in the past as this is now all handled by preallocations)

Date applied: August 14, 2019

191.0.3

Issues Resolved Hot Fix Enhancements Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v191 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fix to creating sub selection screen when it sometimes appeared when a sub should just have been automatically generated
  • Performance improvements to the sub contract management screen
  • Fix to the unallocated quantity on the view item balances screen

Material Planning

  • Fix to resolve object reference error when saving a sales order line when reducing forecasts is enabled

Kitting

  • Fix to selecting a bin when allocating a traceable kit line where the first bin in the warehouse was always being selected

Hot Fix Enhancements

Material Planning

  • Added setting for excluding purchase orders in the past from availability calculation

Works Order Processing

  • Added ability to create a bin on the works order finished item screen using the bin selection control

Date applied: August 1, 2019

19.0.22

Issues Resolved Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v19 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Kitting

  • Fix to selecting a bin when allocating a traceable kit line where the first bin in the warehouse was always being selected

Date applied: August 1, 2019

19.0.21

Issues Resolved Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v19 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fix to process works order screen so the list is refreshed after exiting a works order that was just being edited
  • An error will no longer be thrown when booking a works order that pushes the stock level above the warehouse maximum

Material Planning

  • Fix to warnings so they now only appear if the stock level drops below 0 instead of when it goes below the stock level option set
  • Fix to why some suggested works orders were not given the correct works order number,
  • Removed some of the sales over lead time view as it was making it very slow on sites with lots of transaction histories.  Some items on works orders that have been issued, then unissued and then issued again may give incorrect results
  • Fix to availability calculation so today’s date will be returned for a component if there is enough stock including all future outs

Date applied: August 1, 2019

191.0.1

Issues Resolved Hot Fix Enhancements Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v191 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fix to why WOP/MRP settings on a stock item were being cleared if a stock item was saved but the Sicon tab had not been viewed
  • Change to process works order screen so status is used when doing any filtering

Material Planning

  • Fix so templates no longer appear in the works order scheduler
  • Operations amended on the operation scheduler will now refresh
  • Fix to sales over lead time view
  • Improvements to overloaded on capacity plan screen

Hot Fix Enhancements

Works Order Processing

  • Added new setting for purchase order option at create sub assembly

Date applied: July 18, 2019

191.0.0

New Features Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v191 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

New Features

Works Order Processing

  • Added purchase orders as an option in the create sub assembly screen on works order creation
  • Added day delay to operations
  • Our operations will now use the standard delay settings on BOM operations
  • Colour attribute can be copied to the description field of operations on a works order, and will be used as the colour of the operation in the schedulers
  • Changing the dates on a works order will now ask to update operations
  • Labour transactions must now be entered using the timesheet screen
  • Added fixed length to operations
  • Added a ‘Use sales order requested date’ setting to works order processing which is used when changing the sales order dates and the change works order dates message appears (this is the same setting as in material planning)
  • Changed how settings are read in works order processing to cut many of the database calls which will improve performance to the whole module
  • Added area import
  • Build time screen now handles multiple BOMs
  • Change to allow allocated works order stock to be transferred
  • Sub contract operations will now be created like any other operation
  • Added scrap quantity to works order finished item
  • Added setting to issue bulk issue items at book
  • Added time to issue and book on works orders
  • Added create BOM from a works order

Material Planning

  • Added month to date, year to date and 12 month usage to suggested purchase order screen
  • Operations in the operation scheduler will now only show remaining time
  • Works orders can now be dragged and dropped in the works order scheduler
  • Added sales over lead time
  • Added setting for usual and minimum order quantities on stock item supplier so no longer appear by default
  • Added colours to the works order scheduler based on status
  • Added a traceable item history enquiry screen
  • Added a Master Production Schedule

New tables and views

  • SiWorksOrderOpOperation
  • SiconMRPSalesOverLeadTime
  • SiconMRPMPSLine
  • SiconMRPMPS
  • SiconMRPSOPQtyOverLeadTime
  • SiconMRPSalesOverLeadTimeView

New fields to existing tables

  • SiWorksOrderFinishedItem – ScrappedQuantity
  • SiWorksOrderFinishedItemTran – ScrapQuantity, ScrapReason
  • SiWorksOrderLineIssueHistory – IssueDate

Date applied: July 18, 2019

19.0.20

Issues Resolved Hot Fix Enhancements Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v19 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fix to saving a stock item where the component warehouse was being cleared if the Sicon tab had not been viewed

Material Planning

  • Fix to build time calculation so it returns today’s date if free stock is available

Hot Fix Enhancements

Kitting

  • Added migration for sites upgrading from a very old version of Kitting.  This will fix kit statuses as they were not used in older versions of Kitting.  A migration screen will appear for the first user who opens a Kitting screen after the module has been upgraded

Date applied: July 18, 2019

19.0.19

Issues Resolved Hot Fix Enhancements Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v19 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Material Planning

  • Fix to why not including existing sales orders was causing an error to be thrown
  • Fix to the view item balances form so it correctly picks up which warehouse a works order line has allocations for

Hot Fix Enhancements

Works Order Processing

  • Change so the status lookup is used with all searching on the process works order screen

Date applied: July 18, 2019

19.0.18

Issues Resolved Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v19 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fix to setting the quantity based on economical batch size and the setting to round up the last works order when creating a works order from a sales order
  • Fix to create works order from sales order screen where the quantity to make was being calculated incorrectly when the sales order already has a preallocated works order

Date applied: July 11, 2019

19.0.15

Issues Resolved Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v19 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fix to unissuing batch traceable items from a works order
  • Fix to unissuing works order line that was issued using a different internal area and is traceable

Date applied: July 1, 2019

19.0.14

Issues Resolved Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v19 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fix to stop object ref error appearing when unissuing an item from a works order that has no history
  • The areas control now shows code instead of description
  • Change to build time calculate process so purchase orders in the past are no longer included
  • Fix to why the allocation migrations were not always running

Kitting

  • Fix to stop kits being allocated when allocations are not enabled

Material Planning

  • Fix to why items flagged to not be included were still appearing in suggested works orders

Date applied: July 1, 2019

19.0.13

Issues Resolved Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v19 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fix to sub contract speed issues
  • Improvements to the issue process on the process works orders screen

Date applied: July 1, 2019

19.0.12

Issues Resolved Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v19 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fix to completing works orders with unconfirmed costs enabled where the line costs on lines that had been part issued was not being set correctly
  • Fix to the Forecasts screen to handle casting to new datasource type
  • Performance improvements to issuing from the process works orders screen
  • Fixes to the area import
  • Fix to setting sub assembly due dates so the include the extra day if enabled

Date applied: July 1, 2019

19.0.11

Issues Resolved Hot Fix Enhancements Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v19 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fix to sub contract quantity on purchase order so it is no longer reduced by the despatched or received quantities
  • Fix to calculating dates for works orders and sub assemblies where if the start date was going to be in the past, then after calculating the new start date for all sub assemblies was the same date instead of all the sub assembly due dates
  • Fix so works orders created date and due date are the same if there is no labour or machine time and the works order is top level
  • Fix to correct operation date calculations
  • Fix to unbooking works orders with multiple finished items so the cost percentage is used and the unbook button is enabled correctly
  • Fix to the use by date on works order finished items so it uses the UOM correctly

Material Planning

  • Fix to deleting suggested works order warnings

Hot Fix Enhancements

Works Order Processing

  • Added areas import

Date applied: July 1, 2019

19.0.10

Issues Resolved Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v19 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fix so the direct purchase order line option will no longer appear when creating a preallocation from a works order
  • The warehouse controls in WOP/MRP settings on a stock item will now be cleared after an item has been saved
  • Fix to the margin calculation on works orders
  • The component preallocation quantity will now be refreshed when a preallocation is created
  • Fixed length operations on a BOM will now be calculated correctly when added to a works order
  • Fix to error thrown from works orders on the amend stock item screen
  • Fix to why unneeded works order suggestions were appearing in the create works order from sales order screen
  • Fix to calculating dates when creating works orders where sub assemblies at the same level were not running in parallel

Material Planning

  • Fix to stop creating unneeded minimum stock suggestions for an item with an economical batch size
  • Fix to suggestion quantity for works order lines that need to be rounded up due stock item settings

Kitting

  • Fix to cancelling kit build at point of selecting serial numbers for finished item to stop obj ref error
  • Fix to error thrown from Kitting on amend stock item details form

Date applied: May 28, 2019

19.0.9

Issues Resolved Hot Fix Enhancements Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v19 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Material Planning

  • Fix to why the calculate button on sales orders was being hidden
  • Fix to stop out of memory when exporting to excel from forecast screen
  • Fix to availability calculation for bought parts so the date returned is the first date available

Kitting

  • Kits on quotes will no longer appear in the allocate kit line screen

Works Order Processing

  • Improvements to build time screen
  • Fix to sub contract nominal set check
  • Issuing progress bar added when issuing from process works order screen
  • Fix to the sales order workflow so completed preallocations are checked when working out whether or not a line needs a works order
  • Sell by and use by dates on the works order finished item screen will now refresh on open
  • Fixed works order number on works orders created due to economical batch size from the create works order menu item
  • Check on unissue to see if bin exists and if it doesn’t then unissue to unspecified,
  • Fix to index out of range error thrown on the view item balances screen
  • Fix to back flush screen so works orders can be part booked again
  • Fix to the cost percentage check for works orders with multiple finished items
  • Fix to booking works orders that are traceable and are preallocated to multiple orders

Hot Fix Enhancements

Manufacturing

  • Indexes added to improve SQL query

Date applied: May 17, 2019

18.0.34

Issues Resolved Important
Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v18 FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Material Planning

  • Fixed out of memory error when exporting large amounts of forecasts from the forecast screen
  • Fix to the date returned when running the availability calculation on a sales order

Works Order Processing

  • The use by and sell by dates will now be recalculated when the works order finished item screen is opened for booking

Date applied: May 15, 2019

19.0.8

Issues Resolved Hot Fix Enhancements Important
Important Info

The following fields have been changed to handle larger values and five decimal places. If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail
Kitting
• SiconKit.FinishedItemQuantity
• SiconKitLine.Quantity
• SiconKitLine.AllocatedQuantity
• SiconKitIssueLine.QuantityIssued
• SiconKitTemplate.Quantity
• SiconKitTemplateLine.QuantityToBuild
Works Order Processing
• SiWorksOrder.WOQuantity
• SiWorksOrderLine.Quantity
• SiWorksOrderLine.QuantityAllocated
• SiWorksOrderLine.QuantityIssued
• SiWorksOrderLineIssueHistory.IssuedQuantity
• SiWorksOrderFinishedItem.Quantity
• SiWorksOrderFinishedItem.QuantityBooked
• SiWorksOrderFinsihedItemTran.Quantity
Material Planning
• SiMRPSuggestedPOLine.Quantity
• SiMRPSuggestedPOLine.QtyInStock
• SiMRPSuggestedPOLine.QtyOnOrder
ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v19 FROM v17 OR LOWER FOR THE FIRST TIME
Works Order Processing
• When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.
• SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
• SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.


Issues Resolved

Works Order Processing

  • Fix to costs on works orders with estimate time for labour and machine
  • Fix to linking works orders without finished items to sales orders
  • Fix to bin validation check when booking works orders
  • Permissions in place for amending works orders based on the ‘Process Works Orders’ feature
  • Added sub contract nominal ‘has been set’ check at works order book
  • Sub contract quantity when coming from a BOM operation fixed
  • Added works order unallocated quantity to stock balances screen

Material Planning

  • Fix to why the calculate button on sales orders was being hidden

Hot Fix Enhancements

Material Planning

  • Improvements to the calculate function on sales order lines

Date applied: May 7, 2019

19.0.7

Issues Resolved Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild
Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity
Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v18 FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fix to specific bin selection when unissuing
  • Fix to issuing traceable items on a works order
  • Items set to built/bought default buy will now appear when generating a works order from a sales order
  • Speed improvement made to creating operations
  • Speed improvements to the create works order from sales order screen
  • Manufacturing attributes will now be copied with works orders
  • Option to round up to economical batch size when manually creating a works order added
  • Sub contracts will now show correct currency in sub contract screens but will show in base on the works order
  • Back flush check for components issued fixed
  • Now able to amend an allocated/issued component line quantity using the edit all quantities screen
  • Job stage/phase/activity can now be imported using the works order import
  • Fix to Barcoding script check when auto deleting picked bins

Material Planning

  • Fix to stop index out of range error when running calculation on sales orders
  • Added required by date to calculation to improve date returned

Kitting

  • Fix to kit imports to stop object reference error

Date applied: May 1, 2019

18.0.32

Issues Resolved Hot Fix Enhancements Important
Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v18 FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fix to why memos on stock items were not saving correctly
  • Fix to issuing traceable items
  • Fix to creating works orders using the sales order work flow so the quantities are correct based on economical batch size
  • Items set to built/bought default buy will now appear in the works orders for sales order list
  • Fix to movement balance updating when unbooking a works order using unconfirmed costs

Material Planning

  • Fix to the calculate function on sales orders so Material Planning settings are no longer checked

Hot Fix Enhancements

Works Order Processing

  • Added the option to select bin on unissue which is needed when using Barcoding

Date applied: May 1, 2019

19.0.6

Issues Resolved Important
Important Info

The following fields have been changed to handle larger values and five decimal places. If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail
Kitting
• SiconKit.FinishedItemQuantity
• SiconKitLine.Quantity
• SiconKitLine.AllocatedQuantity
• SiconKitIssueLine.QuantityIssued
• SiconKitTemplate.Quantity
• SiconKitTemplateLine.QuantityToBuild
Works Order Processing
• SiWorksOrder.WOQuantity
• SiWorksOrderLine.Quantity
• SiWorksOrderLine.QuantityAllocated
• SiWorksOrderLine.QuantityIssued
• SiWorksOrderLineIssueHistory.IssuedQuantity
• SiWorksOrderFinishedItem.Quantity
• SiWorksOrderFinishedItem.QuantityBooked
• SiWorksOrderFinsihedItemTran.Quantity
Material Planning
• SiMRPSuggestedPOLine.Quantity
• SiMRPSuggestedPOLine.QtyInStock
• SiMRPSuggestedPOLine.QtyOnOrder
ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v19 FROM v17 OR LOWER FOR THE FIRST TIME
Works Order Processing
• When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.
• SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
• SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.


Issues Resolved

Works Order Processing

Fix to unissuing a serial item which caused an object reference error to appear and stopped serial numbers from being selected
• Fix to why when issuing a traceable item the serial number selection appeared twice
• Fix to stop sub assembly works orders from being put onto jobs when created from a sales order
• Fix to issuing part allocated batch traceable item lines
• The works order allocations screen will now auto select based on bin priority if the FIFO allocations setting is disabled
• It will no longer be possible to complete a works order that has a finished item but nothing booked
• Fix to selecting items to unissue on the traceable internal return form

Material Planning

Fix to purchase order suggestions when grouping is set to never and demand is in the past
• Fix to built or bought check on stock items
• Fix to running material planning for a second time without closing and opening the screen where items were stored in memory and used to filter the next run
• Fix to suggested works orders to handle over suggesting works orders which have an economical batch size
• Fix to works orders suggestions for items with economical batch size and are at least one level down in a BOM
• Fix to build/buy calculations so the material planning settings are no longer checked


Date applied: April 24, 2019

18.0.31

Issues Resolved Important
Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v18 FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

Fix to issuing part issued traceable items where not all of the allocated stock was being unallocated
• Fix so sub assemblies will not be linked to a job
• The works order allocations screen will now auto select based on bin priority if the FIFO allocations setting is disabled
• Works orders can no longer be completed if they have finished items and none have been booked


Date applied: April 24, 2019

17.0.92

Issues Resolved
Issues Resolved
  • Fix for when the user amends a Purchase Order and the delivery address was getting overwritten with nothing

Date applied: April 16, 2019

19.0.5

Issues Resolved Important
Important Info

The following fields have been changed to handle larger values and five decimal places. If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail
Kitting
• SiconKit.FinishedItemQuantity
• SiconKitLine.Quantity
• SiconKitLine.AllocatedQuantity
• SiconKitIssueLine.QuantityIssued
• SiconKitTemplate.Quantity
• SiconKitTemplateLine.QuantityToBuild
Works Order Processing
• SiWorksOrder.WOQuantity
• SiWorksOrderLine.Quantity
• SiWorksOrderLine.QuantityAllocated
• SiWorksOrderLine.QuantityIssued
• SiWorksOrderLineIssueHistory.IssuedQuantity
• SiWorksOrderFinishedItem.Quantity
• SiWorksOrderFinishedItem.QuantityBooked
• SiWorksOrderFinsihedItemTran.Quantity
Material Planning
• SiMRPSuggestedPOLine.Quantity
• SiMRPSuggestedPOLine.QtyInStock
• SiMRPSuggestedPOLine.QtyOnOrder
ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v19 FROM v17 OR LOWER FOR THE FIRST TIME
Works Order Processing
• When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.
• SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
• SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.


Issues Resolved

Works Order Processing

Fix so allocation quantities across multiple warehouses are auto populated
• Fix to works order screen which caused it to be locked down when there were multiple finished items and the first was fully booked
• Fix to creating works orders during the sales order workflow so economical batch works orders are created with correct quantities
• Free stock will now be shown in the location drop down on the allocations screen

Material Planning

Fix to why Material Planning was not suggesting all the suggested purchase orders it should have been when suggested works order ran first
• Fix to stop error appearing in direct delivery and supplier via stock suggestions
• Fix to both works orders and purchase orders so movements are refreshed after rescheduling
• Fix to how cost for suggested purchase orders is calculated so now the live purchase order is checked to see if it’s for the preferred supplier


Date applied: April 16, 2019

19.0.4

Issues Resolved Important
Important Info

The following fields have been changed to handle larger values and five decimal places. If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail
Kitting
• SiconKit.FinishedItemQuantity
• SiconKitLine.Quantity
• SiconKitLine.AllocatedQuantity
• SiconKitIssueLine.QuantityIssued
• SiconKitTemplate.Quantity
• SiconKitTemplateLine.QuantityToBuild
Works Order Processing
• SiWorksOrder.WOQuantity
• SiWorksOrderLine.Quantity
• SiWorksOrderLine.QuantityAllocated
• SiWorksOrderLine.QuantityIssued
• SiWorksOrderLineIssueHistory.IssuedQuantity
• SiWorksOrderFinishedItem.Quantity
• SiWorksOrderFinishedItem.QuantityBooked
• SiWorksOrderFinsihedItemTran.Quantity
Material Planning
• SiMRPSuggestedPOLine.Quantity
• SiMRPSuggestedPOLine.QtyInStock
• SiMRPSuggestedPOLine.QtyOnOrder
ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v19 FROM v17 OR LOWER FOR THE FIRST TIME
Works Order Processing
• When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.
• SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
• SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.


Issues Resolved

Works Order Processing

Default work patterns will now be set on teams when they are initially created after install
• Fix to operation descriptions so the BOM operation description is used rather than the resource line description
• Fix to operation date and time calculations on creation

Material Planning

Fix to creating suggested economical batch sized sub assembly works orders where the first was the correct quantity but the following were not
• Fix to dates on works orders created from Material Planning where the start date was always being set as todays date
• Fix to Capacity Plan so demand hours from operations are no longer split by the manning level as this was incorrect
• Fix to suggested purchase order warnings for works orders


Date applied: April 16, 2019

18.0.30

Issues Resolved Important
Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v18 FOR THE FIRST TIME

Works Order Processing
• When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.
• SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
• SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.


Issues Resolved

Works Order Processing

Fix to part issuing traceable component lines to stop incorrect quantities being issued
• Free stock will now be shown in the location drop down on the allocations screen
• Operation column removed from materials list on the works orders screen

Material Planning

Fix to how cost for suggested purchase orders is calculated so now the live purchase order is checked to see if it’s for the preferred supplier
• Fix to not show quotes in stock movements screen


Date applied: April 16, 2019

18.0.29

Issues Resolved Important
Important Info

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v18 FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fix to operation descriptions so the BOM operation description is used rather than the resource line description
  • Fix to handle works orders with multiple finished items where the works order was being locked if the first of the finished items was booked

Date applied: April 16, 2019

19.0.3

Issues Resolved Hot Fix Enhancements Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild
Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity
Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v19 FROM v17 OR LOWER FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

  • Fix to unissuing traceable items that were allocated/issued from the same batch multiple times
  • Fixed error which caused the traceable internal return form to be blank when unissuing batch items,
  • Fix to creating works orders from sales orders which have an economical batch size set and wasn’t creating the correct amount of works orders
  • Fix so miscellaneous nominal postings will not be generated if integrate with nominal is disabled in stock control
  • Bulk issue items will no longer be considered when running status checks
  • Fix to part issued status on works orders, where it was sometimes showing part allocated instead
  • Fix to cancelling purchase orders that were once linked to works orders
  • Fix to sub contract costs on works orders created when generating from a BOM

Material Planning

  • Fix to handling suggestions for demand in the past which are split be economical batch size and end up being above the stock level option
  • Fix to creating works orders where duplicate lines were appearing in the create works order screen
  • Fix to why minimum stock works order suggestions were not being created when grouping is set to never

Hot Fix Enhancements

Works Order Processing

Kitting


Date applied: March 26, 2019

18.0.28

Issues Resolved Hot Fix Enhancements
Issues Resolved

Works Order Processing

  • Fix to unissuing traceable items that were allocated/issued from the same batch multiple times
  • Fixed error which caused the traceable internal return form to be blank when unissuing batch items,
  • Fix to creating works orders from sales orders which have an economical batch size set and wasn’t creating the correct amount of works orders
  • Fix so miscellaneous nominal postings will not be generated if integrate with nominal is disabled in stock control
  • Bulk issue items will no longer be considered when running status checks
  • Fix to part issued status on works orders, where it was sometimes showing part allocated instead
  • Fix to cancelling purchase orders that were once linked to works orders

Hot Fix Enhancements

Works Order Processing

  • Added ‘WO Qty Issued’ column to the traceable internal return form, which displays the quantity issued to the works order when unissuing

Date applied: March 26, 2019

17.0.63

Issues Resolved
Issues Resolved
Works Order Processing

  • Back flush screen will now handle pre-allocations automatically
  • Fix to why the Areas form was not loading in Sage 200 2013 or 2015

Material Planning

  • Fix to purchase order suggestions so quantities will no longer be multiplied by the minimum order quantity


Date applied: March 21, 2019

190.0.2

Issues Resolved Hot Fix Enhancements Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v18 FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Material Planning

  • Fix as to why some items where not being processed when separating suggestions by warehouse and use reschedule messages is enabled

Works Order Processing

  • Extra checks made when completing works orders
  • Fix to stop save message appearing unnecessarily when saving on the transfer stock screen
  • Fix to completing works orders that have not had all the finished items booked and unconfirmed costs is enabled
  • Fix to the build time screen so it correctly shows free stock levels
  • Fix to getting a price for a works order line in base currency when the purchase order used for costing is not
  • Fix to stop error when converting estimates to works orders
  • Fix to sales order lines being allocated after converted from a quote with an estimate to works order conversion

Kitting

  • Fix to adding a kit to a quote
  • Fix to stop an error when entering a decimal value as the unit cost on a sales order line

Hot Fix Enhancements

Works Order Processing

  • Added amend stock item details and stock movements buttons to the build time screen

Date applied: March 19, 2019

18.0.27

Issues Resolved
Issues Resolved

Material Planning

  • Fix as to why some items where not being processed when separating suggestions by warehouse and use reschedule messages is enabled

Works Order Processing

  • Extra checks made when completing works orders
  • Fix to stop save message appearing unnecessarily when saving on the transfer stock screen
  • Fix to completing works orders that have not had all the finished items booked and unconfirmed costs is enabled
  • Fix to getting a price for a works order line in base currency when the purchase order used for costing is not

Kitting

  • Fix to adding a kit to a quote
  • Fix to stop an error when entering a decimal value as the unit cost on a sales order line

Date applied: March 19, 2019

17.0.91

Issues Resolved
Issues Resolved

Kitting

  • Fix to stop an error that appeared when entering a decimal value as the unit cost on a sales order line

 


Date applied: March 19, 2019

190.0.1

Issues Resolved Hot Fix Enhancements Important
Important Info

The following fields have been changed to handle larger values and five decimal places.  If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail

Kitting

  • SiconKit.FinishedItemQuantity
  • SiconKitLine.Quantity
  • SiconKitLine.AllocatedQuantity
  • SiconKitIssueLine.QuantityIssued
  • SiconKitTemplate.Quantity
  • SiconKitTemplateLine.QuantityToBuild

Works Order Processing

  • SiWorksOrder.WOQuantity
  • SiWorksOrderLine.Quantity
  • SiWorksOrderLine.QuantityAllocated
  • SiWorksOrderLine.QuantityIssued
  • SiWorksOrderLineIssueHistory.IssuedQuantity
  • SiWorksOrderFinishedItem.Quantity
  • SiWorksOrderFinishedItem.QuantityBooked
  • SiWorksOrderFinsihedItemTran.Quantity

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v18 FOR THE FIRST TIME

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved
Kitting

  • Fix to stop kits with zero quantity lines throwing an error when creating and building, lines with a zero quantity will need to be removed before the kit can be built

Material Planning

  • Fix to generating works order sub assembly suggestions where the suggested quantity didn’t match the value specified on the BOM
  • Fix to why on hold sales orders were not appearing in the future stock movements screen
  • Works order suggestions that could not find a warehouse to use during creation will now use the first warehouse on the stock item as a last resort, instead of using a warehouse in which the stock item does not exist

Works Order Processing

  • Fix to stop over preallocating when linking a purchase order to a works order from the works order screen
  • Fix to create works orders that have operations with no resources which caused an index out of range error to be thrown
  • The works order status will now be set correctly when a works order is created from a sales order and auto allocated
  • Fix to the works order list to stop out of memory errors when loading many works orders
  • Fix to the Back Flush routine to stop the preallocation messages appearing unnecessarily
  • Changing the internal area used when issuing components on a works order while there are existing issues to works orders is now handled correctly when then unissuing those works orders
  • Fix to the transfer stock form works order allocation calculation
  • Change to the works order WIP view used in reporting so estimate labour will show as actual and be calculated based on the ration between the works order finished item quantity and the quantity booked in


Hot Fix Enhancements

Material Planning

  • Speed improvements to deleting previous suggestions, gathering built or bought items and generating warning messages
  • Setting added to allow users to specify whether or not they want suggested sub assemblies preallocated to parent works orders.  Off by default
  • Selected warehouses will now appear next to the warehouse select button


Date applied: March 14, 2019

18.0.26

Issues Resolved
Issues Resolved
Kitting

  • Fix to stop kits with zero quantity lines throwing an error when creating and building, lines with a zero quantity will need to be removed before the kit can be built

Material Planning

  • Fix to why on hold sales orders were not appearing in the future stock movements screen
  • Works order suggestions that could not find a warehouse to use during creation will now use the first warehouse on the stock item as a last resort, instead of using a warehouse in which the stock item does not exist

Works Order Processing

  • Fix to the transfer stock form works order allocation calculation
  • Change to the works order WIP view used in reporting so estimate labour will show as actual and be calculated based on the ration between the works order finished item quantity and the quantity booked in


Date applied: March 13, 2019