190.0.34
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 v19 FROM v17 OR LOWER FOR THE FIRST TIME
Works Order Processing
- When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin. This will remove all existing transactions for works orders from jobs, and replace them with a single transaction. From now on, only a single works order transaction will appear on jobs.
- SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID. You can now get the picked and allocated quantity from SiWorksOrderLine.
- SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory. SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID. SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.
Issues Resolved
Works Orders
- Fix to costs being displayed in the Works Order when calculating sub contract costs.
- Fix to WorksOrders screen being displayed underneath Sage when running reports and in the Process Works Orders screen.
Material Planning
- Fix to why built Kit Lines were still appearing as requiring a suggestion
- Fix to suggested Purchase Orders reasons to stop duplicates
- Fix to updating suggested Works Order quantity for suggested sub assemblies where pre-allocate child Works Orders to parent Works Order is disabled.
Kitting
- Fix to behaviour when building traceable kits and not using the Web API. Now correctly shows the traceable add stock form.
Date applied: November 25, 2019