Manufacturing

Back to release notes

191.0.0

New Features Important
Important Info

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

Kitting

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

Works Order Processing

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

Material Planning

  • SiMRPSuggestedPOLine.Quantity
  • SiMRPSuggestedPOLine.QtyInStock
  • SiMRPSuggestedPOLine.QtyOnOrder

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

Works Order Processing

  • When using Job Costing and opening a WOP screen for the first time after upgrading, a Job Costing transaction migration will begin.  This will remove all existing transactions for works orders from jobs, and replace them with a single transaction.  From now on, only a single works order transaction will appear on jobs.
  • SiWorksOrderAllocationLine has been removed and replaced with SiconAllocationLine. SiconAllocationLine.ForeignID links to SiWorksOrderLine.SiWorksOrderLineID.  You can now get the picked and allocated quantity from SiWorksOrderLine.
  • SiWorksOrderAllocIssHist has been removed and replaced with SiconWorksOrderLineIssueHistory.  SiconWorksOrderLineIssueHistory.SiWorksOrderLineID links to SiWorksOrderLine.SiWorksOrderLineID.  SiconWorksOrderLineIssueHistory stores information when a works order line is issued and links to the transaction history table by IssueTransactionHistoryID.
New Features

Works Order Processing

  • Added purchase orders as an option in the create sub assembly screen on works order creation
  • Added day delay to operations
  • Our operations will now use the standard delay settings on BOM operations
  • Colour attribute can be copied to the description field of operations on a works order, and will be used as the colour of the operation in the schedulers
  • Changing the dates on a works order will now ask to update operations
  • Labour transactions must now be entered using the timesheet screen
  • Added fixed length to operations
  • Added a ‘Use sales order requested date’ setting to works order processing which is used when changing the sales order dates and the change works order dates message appears (this is the same setting as in material planning)
  • Changed how settings are read in works order processing to cut many of the database calls which will improve performance to the whole module
  • Added area import
  • Build time screen now handles multiple BOMs
  • Change to allow allocated works order stock to be transferred
  • Sub contract operations will now be created like any other operation
  • Added scrap quantity to works order finished item
  • Added setting to issue bulk issue items at book
  • Added time to issue and book on works orders
  • Added create BOM from a works order

Material Planning

  • Added month to date, year to date and 12 month usage to suggested purchase order screen
  • Operations in the operation scheduler will now only show remaining time
  • Works orders can now be dragged and dropped in the works order scheduler
  • Added sales over lead time
  • Added setting for usual and minimum order quantities on stock item supplier so no longer appear by default
  • Added colours to the works order scheduler based on status
  • Added a traceable item history enquiry screen
  • Added a Master Production Schedule

New tables and views

  • SiWorksOrderOpOperation
  • SiconMRPSalesOverLeadTime
  • SiconMRPMPSLine
  • SiconMRPMPS
  • SiconMRPSOPQtyOverLeadTime
  • SiconMRPSalesOverLeadTimeView

New fields to existing tables

  • SiWorksOrderFinishedItem – ScrappedQuantity
  • SiWorksOrderFinishedItemTran – ScrapQuantity, ScrapReason
  • SiWorksOrderLineIssueHistory – IssueDate

Date applied: July 18, 2019