Manufacturing

Back to release notes

191.0.6

Issues Resolved Change in Functionality 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.
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