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

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