Manufacturing v19.1

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

Fix to the works order list view infinite scroll view.
Fix to stop duplicating Works order numbers when adding sub assemblies to a works order.
Now sets the ‘default supply to’ on a purchase order created by a sub contract.

Date applied: February 25, 2021

191.0.55

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

Fix to prevent order number incrementing unnecessarily when creating sub assemblies when adding new lines to an existing Works Order causing duplicate Works Order numbers.
Fix to allow unissue lines where there is no SiWorksOrderLineIssueHistory but Issue transaction histories exist for the item on the works order.

Date applied: February 25, 2021

191.0.54

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Kitting

Fix to rounding discrepency between the kit cost and nominal postings.

Works Order Processing

Fix to an error thrown when view works orders with many levels via the desktop list.
Fix to sub contract to show the purchase order confirmation screen if auto generate order number is disabled.
Fix to process works order to show the sales order delivery dates as blank if no sales order is linked.

Date applied: February 25, 2021

191.0.53

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Material and Resource Planning

Fix to ensure that On hold sales orders includes Sales Orders for accounts on hold.

Date applied: September 25, 2020

191.0.51

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

Allow copied Estimates to be converted to Works Orders when created from copying Quotations.
Fix to BOM component costs to handle Standard Costs.

Date applied: September 10, 2020

191.0.50

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Material and Resource Planning

Fix to add suggested Works Order created by splitting by economical batch size to the parent Suggest Works Order.

Works Order Processing

Fix to post nominal for actual cost labour lines.

Date applied: August 12, 2020

191.0.49

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Material and Resource Planning

Fix to setting suggested works order numbers to stop duplicates

Works Order Processing

Fix to finished item screen load so it has the correct quantity to book set.

Date applied: August 12, 2020

191.0.48

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

Fix to use nominal for each Works Order Line for labour/machine transactions.

Date applied: July 27, 2020

191.0.47

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

Fix to copying sales orders where suggested works orders linked to original sales order were also being copied
Fix to stop error occurring when a quantity has not been set in the quantity to book

Date applied: July 1, 2020

191.0.46

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

Fix to stop suggested works orders from being copied when copying sales orders
Fix to enable the allocate to works order button on purchase order goods receipt

Date applied: June 16, 2020

191.0.43

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

Fix to stop users being able to issue works orders through the standard Sage issue allocations screen
Fix to completing works orders where the stock had been moved between book and complete

Date applied: June 16, 2020

191.0.39

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Material Planning

Fix to why completed preallocations were showing as reason in stock movements

Works Order Processing

Fix to why works orders with a scrap quantity and complete were still showing in stock item balances
Job Costing transactions will be deleted when a works order is deleted
Fix to why switching companies was retaining previous companies settings

Hot Fix Enhancements

Material Planning

The stock item import now has the same fields for importing as v19.2

Date applied: April 15, 2020

191.0.35

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

Fix to updating movement balances when completing a works order for actual costed items while using unconfirmed costs

Date applied: February 21, 2020

191.0.34

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

Fix to copy works orders to correct sub assembly numbers
Fix to updating sales order line unit price when using update from inside a works order
Fix to to convert estimate to works order

Date applied: February 21, 2020

191.0.33

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

Fix to why the include allocated and issued lines check box was not working on the expediting screen
Fix to copy works orders during quotes to sales order conversion where a error was thrown if an operation could not be found

Date applied: February 21, 2020

191.0.31

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

Fix to auto populating quantity when creating a sub assembly
Fix to typing in works order number on timesheet screen and the operations not populating

Hot Fix Enhancements

Works Order Processing

Added date column to labour transactions

Software dependancies: Common Components 191.0.24

Date applied: January 31, 2020

191.0.30

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

Added extra checks when deleting stock item if it’s on a works order
Fix to error thrown when closing subcontract screen when no lines were entered
Fix to all buttons being disabled for booked works orders

Hot Fix Enhancements

Material Planning

Warehouse selection now has select all button

Date applied: January 31, 2020

191.0.29

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

New Features

Works Order Processing

Completed jobs will no longer be updated by Works Orders that are linked.
Fix to exclude Misc items from appearing in the expediting screen.
Fix to remove the job from suggested Purchase order line when the Works Order has a job linked.

Date applied: January 20, 2020

191.0.28

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

New Features

Material Planning

Fix to preallocation cleanup when running MRP.

Date applied: January 20, 2020

191.0.27

Hot Fix Enhancements Important

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

New Features

Works Order Processing

Sub Contract costs update on the Works Order when changed on the Purchase Order.

Date applied: January 9, 2020

191.0.26

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Hot Fix Enhancements

Material Planning

Change to the warehouse controls in MRP so they exclude quarantined warehouses.

Date applied: January 9, 2020

191.0.25

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

New Features

Works Order Processing

Fix to stop error being displayed when deleting a new Works Order.
Fix to adding a bin through the Works Order finished item screen.
Fix to stop un-allocated quantity on the stock item balances screen including suggested Works Orders.
Fix when creating comment operations where an error was being displayed when the description was too long.
Fix to setting Works Order status on Works orders that were originally created for disassembly.

Kitting

Fix to disassembling kits with 0 value.

Material Planning

Fix to stop possible duplication of suggested Works Order numbers.
Fix to stop on hold BOMs appearing in the MRP screen.

Date applied: January 9, 2020

191.0.24

New Features Hot Fix Enhancements Important

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

New Features

Works Order Processing

Fix to unissuing traceable items with different combinations of use by date, sell by date and alternate references.

Kitting

Fix to unit price being removed when building a kit.

Material Planning

Fix to handle when the Works order setting ‘Create separate works order for each sub assembly’ when it is disabled.

Date applied: January 9, 2020

191.0.23

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

New Features

Works Order Processing

Fix to handling duplicate batch numbers when booking a Works Order.
Fix the setting ‘Sub Assembly Number’ when manually adding an item to a Works Order.
Fix on process Works order screen when amending Estimates.
Fix to multiple errors being displayed when trying to access an estimate that is already open by another user.
Fix to enable adding new finished item.

Hot Fix Enhancements

Works Order Processing

Added Quantity on the Works Order form for labour items.

Date applied: January 9, 2020

191.0.22

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

Fix to handle negative Works Order costs when completing.
Remove Stock Item Settings Import from Works Order menu. It can now be found only in the Material and Resource Planning menu.
Fix to check for child Works Orders when calculating costs.
Fix to backflush so reports now run for traceable items with no use-by date.
Fix to un-issuing a batch traceable item line that doesn’t have a use-by or sell-by date

Date applied: December 5, 2019

191.0.21

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

Fix issues with copying quotation where the promised date on the sales order line is not set.
Fix to handle completing Works Orders with traceable finished items where on completion the movement balances were not being updated.
Fix to handle Works Order booking in duplicate batches so the user is asked what action to take.

Date applied: November 28, 2019

191.0.20

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

Fix to why and error was thrown when booking a finished item with serial numbers
Fix to additional text being added to component lines when opening the Works Order screen.
Fix to stop the Works Order list view breaking when spare text fields were being set to higher than 32 characters.

Date applied: November 25, 2019

191.0.19

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

Added check on works order update message so Jobs are not updated when suggested works orders are
Fix to booking works orders from the process works orders screen where the works order has multiple finished items
Fix to booking in finished items with batch attributes
Renamed setting for finished item variance

Hot Fix Enhancements

Works Order Processing

Backflush now runs reports and print labels on booking in finished product.

Date applied: November 25, 2019

191.0.18

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

Fix to booking a finished item that has required attributes but are not being passed in by Barcoding
Added the option to hide the add stock button on the back flush screen
Change to show the calculated time screen as a tree structure
Fix to booking a works order to stop error being thrown when trying to scrap the last item

Material Planning

Fix to why suggested works orders could not handle more than 2100 items to not include in run

Date applied: November 25, 2019

191.0.17

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

Fix to stop error being thrown when cancelling a traceable item issue
Fix to rounding problem when booking with non stock items
Migrating attachments will no longer delete the old attachment location
Fix to part issuing traceable items when selecting serials at despatch

Material Planning

Speed improvement to exploding BOMs

Hot Fix Enhancements

Works Order Processing

Speed improvements to the works order screen

Date applied: October 29, 2019

191.0.16

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

Fix to why the works order form was being sent to the back when running reports
Fix to stop errors when sorting columns on the ‘Process Works Order’ screen
Fix to not allow finished item quantities to be lowered to below the amount booked plus 1, as this would cause the rest of the works order cost to be lost
No longer possible to preallocate completed works orders to sales orders
Use by date on finished will now be correctly calculated when using the component use by dates

Material Planning

Fix to why suggested works orders were being generated for items that should have suggested purchase orders

Date applied: October 29, 2019

191.0.15

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Material Planning

Fix to why built kit lines were still appearing as requiring stock and a therefore a suggestion
Fix to stop duplicate reasons appearing for suggested purchase orders
Fix to updating child works orders were preallocating child works orders to parents is disabled

Kitting

Fix to building kits with traceable finished items
Fix to handle bins on kit lines being deleted
Fix to why kit line quantity was being zeroed when tabbing out

Works Order Processing

Changes to purchase order linked to sub contracts now reflects in the works order cost

Hot Fix Enhancements

Works Order Processing

Increased the SpareMemo1 field on SiWorksOrder to max
The works order link button now takes you to the preallocation tab

Date applied: October 29, 2019

191.0.13

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Distribution

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

Works Order Processing

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

Kitting

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

Date applied: October 7, 2019

191.0.12

Important Info

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

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

Date applied: October 7, 2019

191.0.11

Important Info

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

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

Hot Fix Enhancements

Works Order Processing

Added the ability to part issue traceable components

Date applied: October 7, 2019

191.0.10

Important Info

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

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

Material Planning

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

Hot Fix Enhancements

Works Order Processing

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

Date applied: September 20, 2019

191.0.9

Important Info

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

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

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

Kitting

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

Material and Resource Planning

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

Hot Fix Enhancements

Works Order Processing

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

Date applied: September 13, 2019

191.0.8

Important Info

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

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

Kitting

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

Hot Fix Enhancements

Works Order Processing

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

Date applied: September 13, 2019

191.0.7

Important Info

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Material Planning

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

Works Order Processing

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

Kitting

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

Hot Fix Enhancements

Material Planning

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

Works Order Processing

Speed improvements to the works order issue process

Kitting

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

Date applied: August 23, 2019

191.0.6

Important Info

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

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

Material Planning

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

Hot Fix Enhancements

Works Order Processing

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

Material Planning

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

Date applied: August 18, 2019

191.0.5

Important Info

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Material Planning

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

Works Order Processing

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

Date applied: August 14, 2019

191.0.4

Important Info

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

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

Material Planning

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

Date applied: August 14, 2019

191.0.3

Important Info

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

Kitting

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

Works Order Processing

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

Material Planning

SiMRPSuggestedPOLine.Quantity
SiMRPSuggestedPOLine.QtyInStock
SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.

SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.

Issues Resolved

Works Order Processing

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

Material Planning

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

Kitting

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

Hot Fix Enhancements

Material Planning

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

Works Order Processing

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

Date applied: August 1, 2019

191.0.1

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