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:

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

17.0.90

Issues Resolved
Issues Resolved
Material Planning

  • Fix to why on hold sales orders were not appearing in the stock movements screen


Date applied: March 13, 2019

18.0.25

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

Material Planning

  • Fix to creating WAP requisitions where the preallocated quantity was being set incorrectly

Works Order Processing

  • Fix to stop part issued lines from being able to be deleted
  • Fix to unissuing traceable items where the internal area had been change after issuing
  • Fix to linking purchase order lines to works order lines to stop over preallocations


Hot Fix Enhancements

Material Planning

  • Warnings in suggested purchase will now be much faster
  • The deletion process will now also be much faster


Date applied: March 8, 2019

17.0.89

Issues Resolved
Issues Resolved

Works Order Processing

  • Fix to stop users being able to delete part issued works orders


Date applied: March 6, 2019

190.0.0

New Features Important
Important Info

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

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

  • It’s now possible to change the quantity on the Back Flush screen
  • Any free stock will be used when creating a works order, not just if there is enough available to fulfil the full required quantity
  • Unissue bin selection setting and screen added.  Mainly used with Barcoding, as gives the user the option to select the bin stock should be returned to when unissuing
  • New setting that when enabled will cause the nominal set on job headers to be used by labour, machine, non stock lines and when issuing stock
  • Many speed improvements to the ‘Back Flush’ screen
  • Timesheet screen added to allow labour and time off to be booked to employees
  • More information will now be recorded in the history of a works order
  • Added new processes for calculating team availability based on amount of employees in team, work patterns and employee holidays

Material Planning

  • Improvements made to the Capacity Plan so it now looks at teams, work patterns and employee holiday.  This has replaced Availabilities
  • Added Team scheduler to the Capacity Plan screen
  • Added Overloaded Teams to the Capacity Plan screen
  • Added Overdue Works Order list to the Capacity Plan screen
  • Forecasts can now be reduced on sales order entry
  • New Calculate button added to suggested works orders which calculates when it can next be built
  • Added new processes for calculating team availability based on amount of employees in team, work patterns and employee holidays


Date applied: March 4, 2019

18.0.24

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 unissuing components from a works order which were allocated using the deprecated process and are not traceable
  • The internal area used when allocating will be the one used when issuing instead of the one in settings



Kitting

  • Unissued items cost will now be the same as the cost they were issued at
  • The internal area used when allocating will be the one used when issuing instead of the one in settings


Date applied: March 1, 2019

18.0.23

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

Material Planning

  • Fix to creating suggestions where demand is in the past
  • Fix to time out when processing suggested works orders on data sets with large amounts of stock items
  • Fix to inconsistencies of supplier lead time for suggested purchase orders
  • Fix to object reference error when converting quotes and estimates to sales orders and works orders
  • Fix to why date filters on the ‘Process Works Orders’, ‘Amend Estimates’ and Amend Templates’ screen were not working correctly
  • Fix to suggestions for works orders which have multiple unit of measures
  • Fix so forecasts are not deleted on import
  • Fix to selecting warehouse when creating works orders

Works Order Processing

  • Changed the create/amend preallocation screen so it can be used without Distrbution being enabled
  • Fix to stop multiple records being creating for the works order text from a sales order line
  • Fix to creating purchase order for a works order sub contract so the cost is passed through
  • Fix to stop economical batch size message appearing unnecessarily

Hot Fix Enhancements

Kitting

  • Now when unallocating a kit line that has been picked in Barcoding, the stock will be automatically transferred to the put away bin if it exists for the item
  • The kit import will now remove all lines from a kit before adding the lines in the import file

Material Planning

  • Improvements made to suggested purchase order warning messages

Date applied: February 26, 2019

18.0.22

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

Kitting

  • Fix to viewing kits on the sales order line screen

Works Order Processing

  • Fix to unissuing traceable items
  • Fix to update from BOM so it handles components inside phantoms that are inside phantoms and so on
  • Fix to converting quotes to sales orders to stop object reference error appearing for templates that do not have finished items

Date applied: February 21, 2019

18.6.21

Issues Resolved Pre-release Important

Pre-Release Version: features are only available to customers using a pre-release version who have signed up to the Early Adopter Programme.


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

  • Changes so team member count and manning levels are taken into consideration when creating operations

Date applied: February 19, 2019

17.0.88

Issues Resolved
Issues Resolved

Works Order Processing

  • Fix to handle unissuing components that have duplicate serial numbers issued

Date applied: February 19, 2019

18.7.21

Issues Resolved Pre-release Important

Pre-Release Version: features are only available to customers using a pre-release version who have signed up to the Early Adopter Programme.


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

  • Changes so team member count and manning levels are taken into consideration when creating operations

Date applied: February 19, 2019

18.0.21

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

  • Fix to creating suggested works orders in the past
  • Suggested works order scrap percentages will now be added correctly

Works Order Processing

  • Fix to unissuing traceable items from works orders

Date applied: February 18, 2019

18.0.20

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 free text, additional charge and comment sales order lines to stop casting error being thrown
  • The stock item balances screen free stock column will now appear correctly

Material Planning

  • Fix to the quantity used when creating reason for purchase orders
  • Fix so when ‘Preallocate to Reason’ is disabled, all suggested works orders will be separate (no parent/child relationships)
  • Fix to populating list when creating works orders
  • Fix to stop suggested works orders appearing in the works order list

Date applied: February 8, 2019

18.0.19

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

  • Unissue of traceable items will no longer allow users to select less than the required serials, unless the ‘allow part unissue’ setting is enabled
  • Sage transfer stock form will no longer allow users to transfer stock allocated to a works order
  • The back flush process will now post labour and machine time correctly
  • Labour description will now save on first try when adding to a works order
  • Settings ‘Months to display in process screens (each way from today)’ and ‘Enable finished products tab’ can now be enabled on the main settings screen
  • Fix to stop ‘out of memory’ exception appearing when running the Job Costing transaction migration

Material Planning

  • Fix to works order suggestions where lead time was being multiplied by the quantity of the suggestion giving very long lead times.  This may need to be put back at a later date when lead time is changed to be based on economical batch size

Date applied: February 7, 2019

18.0.18

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 setting the status on works orders
  • Fix to WIP view so labour appears for issued works orders
  • Message to create works orders will not appear when converting quote to sales order
  • Now able to amend works order allocation using the standard Sage allocation screens
  • Analysis code 3 is back on works orders
  • Fix to Job Costing transactions for a works order that’s liked to a sales order and a job (job costing v18.0.7 minimum upgrade required)

Material Planning

  • Fix to stop divide by zero error when creating suggested works orders
  • Fix to deleting preallocations for deleted works order suggestions

Kitting

  • Fix to error that appeared when loading a sales order line thats of a different type to standard item line.

Date applied: February 4, 2019

18.0.17

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

Kitting

  • Fix made to building a kit on a sales order for traceable items where kit build was wrongly cancelled after preallocation screen appeared
  • Fix to stop multiple people going into the same kit at the same time

Material Planning

  • Supplier part code can now be changed in the create purchase order screen
  • Stock movements screen shows more information when movements are selected

Works Order Processing

  • Fix so the amend allocations screen now works instead of refusing the user access
  • Warehouses will now appear in the default warehouse selections on the ‘WOP/MRP’ tab for new stock items
  • Sub contract cost can now be set without the need to create a purchase order

Date applied: January 30, 2019

18.0.16

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 amending allocations on the works order screen
  • History will now be added when allocating, issuing or booking works orders
  • The view works orders and amend estimates and templates screens will no longer allow the user to allocate or book
  • The right click menu when viewing a works order will no longer allow users to amend allocations
  • Fix to auto allocating on works order creation

Material Planning

  • Fix to why MRP was not looking at some existing works orders when running

Hot Fix Enhancements

Works Order Processing

  • Now able to set purchase order date when generating purchase orders from the works order screen

Date applied: January 25, 2019

17.0.84

Issues Resolved
Issues Resolved

Works Order Processing

  • Fix to stop users being to amend works order lines when viewing a works order

Date applied: January 25, 2019

17.0.83

Issues Resolved
Issues Resolved

Works Order Processing

  • Fix to the Amend Batch Serial Number screen to stop loading/freezing issues for large amounts of data

Date applied: January 23, 2019

18.5.15

Issues Resolved Pre-release Important

Pre-Release Version: features are only available to customers using a pre-release version who have signed up to the Early Adopter Programme.


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

  • Many speed improvements to the ‘Back Flush’ screen

Date applied: January 21, 2019

18.0.15

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

  • Many improvements to the Back Flush process to stop the screen freezing when loading, improve overall speed and correct problems with checking available stock

Date applied: January 18, 2019

18.4.14

New Features Pre-release Important

Pre-Release Version: features are only available to customers using a pre-release version who have signed up to the Early Adopter Programme.


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.

New Features

Works Order Processing

  • New setting that when enabled will cause the nominal set on job headers to be used by labour, machine, non stock lines and when issuing stock

Date applied: January 11, 2019

18.0.14

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

Material Planning

  • Many speed improvements made to the Capacity Plan screen on all tabs
  • Fix to works orders appearing multiple times in the Future Stock Movements screen

Works Order Processing

  • Components will now refresh when editing the quantity of a finished item on a works order that has multiple finished items

Hot Fix Enhancements

Material Planning

  • Added default colour option to the Scheduler Colour Maintenance screen

Date applied: January 11, 2019

18.0.13

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

  • Fix to suggested works orders and sub assemblies where they were not being linked correctly
  • Works orders generated will now use sales order number where applicable

Works Order Processing

  • Fix to allow works orders without finished items to be completed
  • Works order created for disassembling with now be created without trying to allocate stock, and sub assembly lines will always be from stock

Kitting

  • Fix to setting the status on a kit after it has been disassembled
  • Fix to the convert quote to sales order screen where an error was thrown due to not finding a kit on the sales order line being converted
  • Fix to user permissions check on many screens that have the create/edit/build kit button
  • Fix to auto allocating when converting from quote to sales order

Date applied: January 4, 2019

17.0.79

Issues Resolved
Issues Resolved

Material Planning

  • Fix to stop error stating settings cannot be found where the user creating a works order, kit or purchase order is not the one who ran material planning

Date applied: January 2, 2019

18.0.12

Issues Resolved Hot Fix Enhancements
Issues Resolved

Works Order Processing

  • Fix to the option to delete preallocations when allocating a works order line
  • Fix to checking for economical batch sizes
  • Improvements and fixes to the Job Costing transaction migration

Hot Fix Enhancements
Material Planning

  • New feature which calculates works order availability based on component free stock and movements.  A setting exists to enable this feature, off by default


Date applied: December 21, 2018

18.3.11

New Features Pre-release Important

Pre-Release Version: features are only available to customers using a pre-release version who have signed up to the Early Adopter Programme.


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.


New Features
Works Order Processing

  • Unissue bin selection setting and screen added.  Mainly used with Barcoding, as gives the user the option to select the bin stock should be returned to when unissuing


Date applied: December 18, 2018

18.2.11

New Features Pre-release Important

Pre-Release Version: features are only available to customers using a pre-release version who have signed up to the Early Adopter Programme.


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.

New Features

Works Order Processing

  • It’s now possible to change the quantity on the Back Flush screen
  • Any free stock will be used when creating a works order, not just if there is enough available to fulfil the full required quantity


Date applied: December 18, 2018

18.0.11

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 allow amending allocations when there is no finished item
  • Allocations screen will now auto populate with the outstanding quantity
  • The ‘allocated to batches’ option when right clicking on a component on the materials list will now show information when line is either allocated or issued
  •  Fix to the Job Costing migration to handle how Job Costing flags transactions as deleted


Hot Fix Enhancements
Works Order Processing

  • Preallocated column on the works order screen will be hidden if no preallocations exist
  • Lines that are not fully allocated will show the quantity allocated in red


Date applied: December 13, 2018

18.0.10

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

  • When completing the works order, the last finished item transaction history cost was incorrect set to the whole works order cost.
  • When setting operation due date based on a previous operation for a works order ignore existing operations with NULL due date

 


Date applied: December 7, 2018

18.0.9

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 when auto allocating traceable items across multiple bins to stop ‘serials are unavailable’ message
  • Works order list will now only show live works orders


Date applied: November 30, 2018