Sicon Manufacturing is a set of additional modules for Sage 200, integrated with Stock, BOM, Sales and Purchase Order Processing. Including modules for Job Costing, Works Order Processing and Estimating, this package can be configured for one-off job costed manufacture or high volume repeat production manufacture. Material and Resource Planning provides suggested works orders and purchase orders plus a rough cut capacity plan at labour and machine levels.
191.0.58
Issues Resolved ImportantImportant 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
- Data fix routine to correct works order ultimate parent ID.
- Fix to allow booking stock items that allow duplicate traceable numbers.
Date applied: February 25, 2021
191.0.57
Issues Resolved ImportantImportant 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
Issues Resolved ImportantImportant 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
Issues Resolved ImportantImportant 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
Issues Resolved ImportantImportant 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
Issues Resolved ImportantImportant 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
Issues Resolved ImportantImportant 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
Issues Resolved ImportantImportant 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
Issues Resolved ImportantImportant 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
Issues Resolved ImportantImportant 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
Issues Resolved ImportantImportant 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
Issues Resolved ImportantImportant 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
Issues Resolved Change in Functionality ImportantImportant 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
Change in Functionality
Material Planning
- The stock item import now has the same fields for importing as v19.2
Date applied: April 15, 2020
191.0.35
Issues Resolved ImportantImportant 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
Issues Resolved ImportantImportant 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
Issues Resolved ImportantImportant 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
Issues Resolved Change in Functionality ImportantImportant 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
Change in Functionality
Works Order Processing
- Added date column to labour transactions
Software dependancies: Common Components 191.0.24
Date applied: January 31, 2020
191.0.30
Issues Resolved Change in Functionality ImportantImportant 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
Change in Functionality
Material Planning
- Warehouse selection now has select all button
Date applied: January 31, 2020
191.0.29
New Features ImportantImportant 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
New Features ImportantImportant 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
New Features ImportantImportant 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
Change in Functionality ImportantImportant 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.
Change in Functionality
Material Planning
- Change to the warehouse controls in MRP so they exclude quarantined warehouses.
Date applied: January 9, 2020
191.0.25
New Features ImportantImportant 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 ImportantImportant 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
New Features Change in Functionality ImportantImportant 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.
Change in Functionality
Works Order Processing
- Added Quantity on the Works Order form for labour items.
Date applied: January 9, 2020
191.0.22
Issues Resolved ImportantImportant 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
Issues Resolved ImportantImportant 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
Issues Resolved ImportantImportant 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
Issues Resolved Change in Functionality ImportantImportant 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
Change in Functionality
Works Order Processing
- Backflush now runs reports and print labels on booking in finished product.
Date applied: November 25, 2019
191.0.18
Issues Resolved ImportantImportant 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
Issues Resolved Change in Functionality ImportantImportant 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
Change in Functionality
Works Order Processing
- Speed improvements to the works order screen
Date applied: October 29, 2019
191.0.16
Issues Resolved ImportantImportant 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
Issues Resolved Change in Functionality ImportantImportant 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
Change in Functionality
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
Issues Resolved ImportantImportant Info
Please note that with this update, if barcoding is installed, Manufacturing will require at least version x.191.0.5 or above of barcoding.
The following fields have been changed to handle larger values and five decimal places. If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail
Kitting
- SiconKit.FinishedItemQuantity
- SiconKitLine.Quantity
- SiconKitLine.AllocatedQuantity
- SiconKitIssueLine.QuantityIssued
- SiconKitTemplate.Quantity
- SiconKitTemplateLine.QuantityToBuild
Works Order Processing
- SiWorksOrder.WOQuantity
- SiWorksOrderLine.Quantity
- SiWorksOrderLine.QuantityAllocated
- SiWorksOrderLine.QuantityIssued
- SiWorksOrderLineIssueHistory.IssuedQuantity
- SiWorksOrderFinishedItem.Quantity
- SiWorksOrderFinishedItem.QuantityBooked
- SiWorksOrderFinsihedItemTran.Quantity
Material Planning
- SiMRPSuggestedPOLine.Quantity
- SiMRPSuggestedPOLine.QtyInStock
- SiMRPSuggestedPOLine.QtyOnOrder
ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v191 FROM v17 OR LOWER FOR THE FIRST TIME
Works Order Processing
- When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.
- SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
- SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.
Issues Resolved
Distribution
- Fix to create preallocation screen to stop over preallocting lines that already have preallocations
Works Order Processing
- Fix to back flushing lines that are already part allocated or part issued
Kitting
- Fix to kit status not updating after allocating using the Allocate kits screen
- Fix to why the build kit button on a sales order line wasn’t enabled when creating a sales order line with allocate on order entry disabled
- Code and name controls will now be disabled on active kits
Date applied: October 7, 2019
191.0.12
Issues Resolved ImportantImportant Info
The following fields have been changed to handle larger values and five decimal places. If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail
Kitting
- SiconKit.FinishedItemQuantity
- SiconKitLine.Quantity
- SiconKitLine.AllocatedQuantity
- SiconKitIssueLine.QuantityIssued
- SiconKitTemplate.Quantity
- SiconKitTemplateLine.QuantityToBuild
Works Order Processing
- SiWorksOrder.WOQuantity
- SiWorksOrderLine.Quantity
- SiWorksOrderLine.QuantityAllocated
- SiWorksOrderLine.QuantityIssued
- SiWorksOrderLineIssueHistory.IssuedQuantity
- SiWorksOrderFinishedItem.Quantity
- SiWorksOrderFinishedItem.QuantityBooked
- SiWorksOrderFinsihedItemTran.Quantity
Material Planning
- SiMRPSuggestedPOLine.Quantity
- SiMRPSuggestedPOLine.QtyInStock
- SiMRPSuggestedPOLine.QtyOnOrder
ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v191 FROM v17 OR LOWER FOR THE FIRST TIME
Works Order Processing
- When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.
- SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
- SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.
Issues Resolved
Works Order Processing
- Fixes to costing finished items on works orders where the show finished items tab is enabled
- Fix to issuing lines with multiple allocations
- Fix to checking required works order line quantity when back flushing
Date applied: October 7, 2019
191.0.11
Issues Resolved Change in Functionality ImportantImportant 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
Change in Functionality
Works Order Processing
- Added the ability to part issue traceable components
Date applied: October 7, 2019
191.0.10
Issues Resolved Change in Functionality ImportantImportant 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.
Change in Functionality
Works Order Processing
- Update from BOM now checks to see if a component line is now a sub assembly on the BOM and will show the create sub assembly screen.
- Sub Contract Management now has a new column Last Updated Date and will order using that column by default.
- Sub Contract Management screen now has an Un-Despatch button on the Sub Contract tab.
Date applied: September 20, 2019
191.0.9
Issues Resolved Change in Functionality ImportantImportant 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.
Change in Functionality
Works Order Processing
- Added better error message when an un-issue is attempted to an Internal Area that no longer exists.
Date applied: September 13, 2019
191.0.8
Issues Resolved Change in Functionality ImportantImportant 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.
Change in Functionality
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
Issues Resolved Change in Functionality ImportantImportant 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
Change in Functionality
Material Planning
- Speed improvements to the suggested purchase order tab during and after load
- The date range fields on the stock movements screen will now refresh the data
Works Order Processing
- Speed improvements to the works order issue process
Kitting
- A new screen will appear when allocating a traceable item when the show bin on kit line is enabled, which will allow the user to select a traceable item from any bin in the warehouse
Date applied: August 23, 2019
191.0.6
Issues Resolved Change in Functionality ImportantImportant 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
Change in Functionality
Works Order Processing
- Added the ability to book works orders that have not had anything issued if use unconfirmed costs is enabled
Material Planning
- Added new setting to use sales order line description when generating purchase orders for a supplier via stock or direct delivery sales order
Date applied: August 18, 2019
191.0.5
Issues Resolved ImportantImportant Info
The following fields have been changed to handle larger values and five decimal places. If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail
Kitting
- SiconKit.FinishedItemQuantity
- SiconKitLine.Quantity
- SiconKitLine.AllocatedQuantity
- SiconKitIssueLine.QuantityIssued
- SiconKitTemplate.Quantity
- SiconKitTemplateLine.QuantityToBuild
Works Order Processing
- SiWorksOrder.WOQuantity
- SiWorksOrderLine.Quantity
- SiWorksOrderLine.QuantityAllocated
- SiWorksOrderLine.QuantityIssued
- SiWorksOrderLineIssueHistory.IssuedQuantity
- SiWorksOrderFinishedItem.Quantity
- SiWorksOrderFinishedItem.QuantityBooked
- SiWorksOrderFinsihedItemTran.Quantity
Material Planning
- SiMRPSuggestedPOLine.Quantity
- SiMRPSuggestedPOLine.QtyInStock
- SiMRPSuggestedPOLine.QtyOnOrder
ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v191 FROM v17 OR LOWER FOR THE FIRST TIME
Works Order Processing
- When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.
- SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
- SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.
Issues Resolved
Material Planning
- Check to creating purchase orders for suggestions that no longer have a reason, ie the sales order it was suggested for has now been actioned
- Fix to the warehouse controls where not all warehouses were being selected incorrectly
- Fix to the supplier popup so it is ordered correctly
- Fix to exporting from the suggested purchase orders screen so the free stock column exports correctly
- Fix to handle error on the stock running balance screen when loading lots of items and warehouses
- Fix to forecast import so it ignores first line if its the headers
Works Order Processing
- Change to the setting for showing the sub creation screen when a purchase order is available so it will only show if there is no free stock available for the item
- Fix to the back flush screen so all finished items are shown at the end of the build process, added progress bar to the create WO from SO screen, fix to handle error on the stock running balance screen when loading lots of items and warehouses
- Fix to the back flush screen so all finished items are shown at the end of the build process
- Fix to how the exclude purchase orders in the past setting got enabled/disabled
- Rounding fixes when booking in a finished item to round up cost price to 5 decimal places
- Fix so estimate lines linked to sub assemblies use the sub assembly cost instead of using future buy price
Date applied: August 14, 2019
191.0.4
Issues Resolved ImportantImportant Info
The following fields have been changed to handle larger values and five decimal places. If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail
Kitting
- SiconKit.FinishedItemQuantity
- SiconKitLine.Quantity
- SiconKitLine.AllocatedQuantity
- SiconKitIssueLine.QuantityIssued
- SiconKitTemplate.Quantity
- SiconKitTemplateLine.QuantityToBuild
Works Order Processing
- SiWorksOrder.WOQuantity
- SiWorksOrderLine.Quantity
- SiWorksOrderLine.QuantityAllocated
- SiWorksOrderLine.QuantityIssued
- SiWorksOrderLineIssueHistory.IssuedQuantity
- SiWorksOrderFinishedItem.Quantity
- SiWorksOrderFinishedItem.QuantityBooked
- SiWorksOrderFinsihedItemTran.Quantity
Material Planning
- SiMRPSuggestedPOLine.Quantity
- SiMRPSuggestedPOLine.QtyInStock
- SiMRPSuggestedPOLine.QtyOnOrder
ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v191 FROM v17 OR LOWER FOR THE FIRST TIME
Works Order Processing
- When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.
- SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
- SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.
Issues Resolved
Works Order Processing
- Fix to sub assembly creation popup screen to handle always showing if purchase available and do not always create sub setting config
- Fix to build time calculation where include purchase orders in the past setting was being incorrectly checked and an incorrect next available date was being returned
- Fix to flag a sales order to show works order creation screen on close so the screen will now only not appear if the don’t ask again button is clicked
Material Planning
- Fix to why suggestions for items that have no movements and required a suggestion for minimum stock were not being created
- Fix to populating old back to back information on a purchase order where new purchase orders were taking a while to load (only effects customers who have used SiBackToBack table in the past as this is now all handled by preallocations)
Date applied: August 14, 2019
191.0.3
Issues Resolved Change in Functionality ImportantImportant 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
Change in Functionality
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
Issues Resolved Change in Functionality ImportantImportant 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
Change in Functionality
Works Order Processing
- Added new setting for purchase order option at create sub assembly
Date applied: July 18, 2019
191.0.0
New Features ImportantImportant Info
The following fields have been changed to handle larger values and five decimal places. If there are custom indexes on these tables, they will need to be removed otherwise update companies will fail
Kitting
- SiconKit.FinishedItemQuantity
- SiconKitLine.Quantity
- SiconKitLine.AllocatedQuantity
- SiconKitIssueLine.QuantityIssued
- SiconKitTemplate.Quantity
- SiconKitTemplateLine.QuantityToBuild
Works Order Processing
- SiWorksOrder.WOQuantity
- SiWorksOrderLine.Quantity
- SiWorksOrderLine.QuantityAllocated
- SiWorksOrderLine.QuantityIssued
- SiWorksOrderLineIssueHistory.IssuedQuantity
- SiWorksOrderFinishedItem.Quantity
- SiWorksOrderFinishedItem.QuantityBooked
- SiWorksOrderFinsihedItemTran.Quantity
Material Planning
- SiMRPSuggestedPOLine.Quantity
- SiMRPSuggestedPOLine.QtyInStock
- SiMRPSuggestedPOLine.QtyOnOrder
ALL USERS MUST BE LOGGED OUT WHEN UPGRADING TO v191 FROM v17 OR LOWER FOR THE FIRST TIME
Works Order Processing
- When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.
- SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
- SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.
New Features
Works Order Processing
- Added purchase orders as an option in the create sub assembly screen on works order creation
- Added day delay to operations
- Our operations will now use the standard delay settings on BOM operations
- Colour attribute can be copied to the description field of operations on a works order, and will be used as the colour of the operation in the schedulers
- Changing the dates on a works order will now ask to update operations
- Labour transactions must now be entered using the timesheet screen
- Added fixed length to operations
- Added a ‘Use sales order requested date’ setting to works order processing which is used when changing the sales order dates and the change works order dates message appears (this is the same setting as in material planning)
- Changed how settings are read in works order processing to cut many of the database calls which will improve performance to the whole module
- Added area import
- Build time screen now handles multiple BOMs
- Change to allow allocated works order stock to be transferred
- Sub contract operations will now be created like any other operation
- Added scrap quantity to works order finished item
- Added setting to issue bulk issue items at book
- Added time to issue and book on works orders
- Added create BOM from a works order
Material Planning
- Added month to date, year to date and 12 month usage to suggested purchase order screen
- Operations in the operation scheduler will now only show remaining time
- Works orders can now be dragged and dropped in the works order scheduler
- Added sales over lead time
- Added setting for usual and minimum order quantities on stock item supplier so no longer appear by default
- Added colours to the works order scheduler based on status
- Added a traceable item history enquiry screen
- Added a Master Production Schedule
New tables and views
- SiWorksOrderOpOperation
- SiconMRPSalesOverLeadTime
- SiconMRPMPSLine
- SiconMRPMPS
- SiconMRPSOPQtyOverLeadTime
- SiconMRPSalesOverLeadTimeView
New fields to existing tables
- SiWorksOrderFinishedItem – ScrappedQuantity
- SiWorksOrderFinishedItemTran – ScrapQuantity, ScrapReason
- SiWorksOrderLineIssueHistory – IssueDate
Date applied: July 18, 2019