190.0.6
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 Order Processing
•
• Fix to why when issuing a traceable item the serial number selection appeared twice
• Fix to stop sub assembly works orders from being put onto jobs when created from a sales order
• Fix to issuing part allocated batch traceable item lines
• The works order allocations screen will now auto select based on bin priority if the FIFO allocations setting is disabled
• It will no longer be possible to complete a works order that has a finished item but nothing booked
• Fix to selecting items to unissue on the traceable internal return form
Material Planning
•
• Fix to built or bought check on stock items
• Fix to running material planning for a second time without closing and opening the screen where items were stored in memory and used to filter the next run
• Fix to suggested works orders to handle over suggesting works orders which have an economical batch size
• Fix to works orders suggestions for items with economical batch size and are at least one level down in a BOM
• Fix to build/buy calculations so the material planning settings are no longer checked
Date applied: April 24, 2019