Distribution v21.1

Sicon Distribution Manager is designed specifically as an enhancement for Sage 200. Fully integrated with the Sage 200 Stock and Order Processing modules. Designed to manage the requirements of distribution organisation’s to improve costing, reduce stock holdings, manage seasonal trends, increase telesales productivity and incorporate sales forecasting within future stock projections and suggested purchase order creation.

Release notes:

Make it easier to find your content with:

Expand content Collapse Content New Features Only Issues Resolved Only Release Only Pre Release Only Hot Fix Enhancements Important Only

Know the release number? Use quick search:

211.0.24

Issues Resolved
Issues Resolved
  • Removed incorrect warning when selecting a stock item on a purchase order line with no landed costs

Date applied: August 2, 2023

211.0.23

Hot Fix Enhancements
Hot Fix Enhancements

Module license will now expire the day after the enable string expiry date, not on that date.
Changed the way Distribution stock matrix checks for the next despatch note number.
Container Manager fix when splitting purchase order lines on a container and the value in the purchase order notifications would be incorrect, US3599.


Date applied: April 17, 2023

211.0.22

Issues Resolved
Issues Resolved
  • fix(stock-reserves): fix when selecting an item for a stock reserve and is only one stock item code with the entered text however this text appears in other columns on the lookup and it would appear as if it would not select this item
  • fix(stock-reserves):added an active lock to the reserve screen when a user is amending a reserve

Date applied: February 2, 2023

211.0.21

Issues Resolved
Issues Resolved
  • fix(stock-matrix): fix to allow associated stock items to be deleted from the matrix group if they can and delete the matrix group. Display a message to show the user what items cannot be deleted if there are any
  • fix(container-manager): fix to correctly work out the total price of the line when different unit of measure are used between the buying and pricing units

Date applied: December 2, 2022

211.0.20

Issues Resolved
Issues Resolved
  • Fix to only display the ‘Undespatched Sales Orders’ screen when a sales order is new
  • Only store customer batch attributes that have a value
  • Fix to correct the transfer quantities when using “Stock Replenishment” [“The quantity entered is greater than the stock at the location”]

Date applied: November 18, 2022

211.0.19

Issues Resolved
Issues Resolved
  • Fixed the loading speed of the ‘Add Historical’ screen
  • Fix for sorting columns on the ‘Add Historical Lines’ screen on SOP and also fixed the jittery scrolling

Date applied: September 23, 2022

211.0.18

Issues Resolved
Issues Resolved
  • Fix for returning allocated stock from a SOP back to the original reserve when unallocating an order line

Date applied: September 15, 2022

211.0.17

Issues Resolved
Issues Resolved
  • Fix when selecting stock matrix options [“Unable to case object of type ‘Sage.Accounting.DataModel.SiDistStockItemGroup’ to type ‘Sicon.Sage200.Distribution.Objects.SiDistStockItemGroup’]
  • Fix for returning allocated stock from a SOP back to the original reserve when unallocating an order line
  • Fix to correctly display the preallocated quantity on the SOP and POP grids after part of the preallocation has been received

Date applied: August 26, 2022

211.0.16

Issues Resolved
Issues Resolved
  • Fix for container splitting lines that have multiple unit of measures and the ‘OnOrderQuantity’ would not update correctly and instead would increase by the base unit of measure difference
  • Fix for saving a container and analysis codes would not save on first attempt
  • Fix for container lines skipping a number each save

Date applied: July 29, 2022

211.0.15

Issues Resolved
Issues Resolved
  • Fix to not filter out any lines that associated to the purchase order when they are completed when adding lines to a container
  • Fix to correctly allocate reserve quantities dependant on what has been specified in ‘Quantity to Allocate’
  • Fix to correctly amend allocations when updating the ‘Quantity To Allocate’ value when saving ‘Reserve Stock’ lines

Date applied: July 22, 2022

211.0.14

Issues Resolved
Issues Resolved
  • Fix when receiving lines through Sage that are associated with a container and when they get fully received they were being removed from the container
  • Fix for the data fix shortcut key to set the ‘QuantityForContainer’ to the ‘LineQuantity’ otherwise the container cannot be saved
  • Fix to not filter out any lines that associated to the purchase order when they are completed on the ‘View Lines’ radio button

Date applied: July 15, 2022

211.0.13

Issues Resolved
Issues Resolved
  • Fix issue with the ‘POP Line List’ where it wouldn’t correctly colour the status column when the list is opened without another form being opened first
  • Fix issue with the ‘POP Line List’  where the document number would turn into the item name for some lines
  • Added supplier column as a default column in the list now to the ‘POP Line List’
  • Fix the loading speed on the ‘POP Line List’ for ‘Viewing’ or ‘Amending’ an order

Date applied: July 1, 2022

211.0.12

Issues Resolved
Issues Resolved
  • Fix on the ‘POP Expected Deliveries’ screen to display lines when only the header or line date for the purchase order line
  • Fix for splitting container lines when multiple units of measure are being used. Main issue comes when the quantity unit of measure is different from the buying price unit of measure
  • Fixed an issue where internal container numbers were being skipped. Issue would arise if a new container was saved and there was an error with the initial save it would still increase the internal container number
  • Fix for viewing the values on the container with units of measure

Date applied: June 22, 2022

211.0.10

Issues Resolved
Issues Resolved
  • Desktop list speed improvements for the POP and SOP line lists, previously not paging correctly
  • Fix when adding or updating container line quantities and it would incorrectly recalculate the total weight and volume of the line… Issue with lines with multiple units of measure
  • Fix for duplicate lines being created on the SiconDistPOPOrderReturnLine table

Date applied: May 26, 2022

211.0.9

Issues Resolved
Issues Resolved
  • Fix for the ‘Stock Replenishment’ screen when attempting to adjust the transfer quantities [“Index was out of range”]
  • Added better validation when selecting a sales or purchase contract to use on a sales order line and the user would select a larger quantity than what is remaining on the contract line and this would send the contract line into a minus
  • Correctly not close the contract selection form is there is a validation error
  • Fix when loading the contract select screen [“Object Reference Error”]
  • Fix to correctly update the quantity when adding traceable lines from a sales order template and the user updates the quantity that the lines should be multiplied by
  • Fix for stock replenishment when drilling down to change quantities and after the first drilldown it wouldn’t display anything
  • Corrected displaying lines that can’t be replenished in red (Occurred when available quantity is 0)
  • Fix when using a contract line on a purchase order and the user was loading which contract line to select [“Object Reference Error”]
  • Fix when selecting a sales contract and closing the screen but it would still link to a contract
  • Fix when generating sales orders from Sicon Stock Reserves with traceable item but select traceable numbers are selected at despatch [“Object Reference Error”]
  • Fix for the ‘Unit Price’ column on a sales order when viewing the quantities and it would multiply the unit price with the line quantity and give an incorrect figure

Date applied: May 19, 2022

211.0.8

Issues Resolved
Issues Resolved
  • Fix for using Sicon Stock Reserves on Sales Orders when the quantities get fulfilled from multiple bins [“the quantity entered is greater than the free stock at the location”]
  • Fix for stock inspections with preallocations and when an item is received with a preallocation that requires inspection, if that item fails then the sales order is allocated to the failed warehouse which might not be ticked to be used for trading and stock will then be stuck
  • Fix to only update the ‘Unit Buying Price’ if supplier quantity breaks have been used… Issue where unit of measure changes were not updating the price
  • Fix when creating warehouse replenishment group without highlighting a group before adding a warehouse [“Object Reference Error”]
  • Fix when using the “Distribution” button on ‘Manage SOP Back Orders screen and no screens would load when on the ‘Unallocate’ tab

Date applied: April 21, 2022

211.0.7

Issues Resolved
Issues Resolved
  • Fix to enable and disable the ‘Delete Line’ button correctly on a Sicon Stock Reserve when one of the lines is completed
  • Fix for generating stock matrix items, set the max length of the commodity code 10… Issue where it would say it has generated stock items when in fact it had not
  • Fix to not save lines when a warehouse hasn’t been set or quantity when creating a Sicon reserve stock line
  • Corrected spelling of ‘Details’ when adding a Sicon Stock Reserve Line
  • Fix when selecting a stock item on Sicon reserve Stock line and it would not enable the controls on the screen

Date applied: April 13, 2022

211.0.6

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • Fix for setting the correct current container status and next status when changing tracking dates on a container
  • Fix to apply Sicon customer codes when adding new sales order lines from “Add Historical Lines” and “Copy Order Line”
  • Fix to make sure the generated stock item names are not longer than 60 characters long… Issue when the user would generate stock items and it would not generating anything but display that the items have been created
  • Fix to exclude deleted preallocations on the POP line list

Hot Fix Enhancements
  • Preallocated quantities can be exported on the purchase order header grid
  • Preallocations can be created from a purchase order header

Date applied: April 7, 2022

211.0.5

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • Fix to only open the Distribution stock settings import if the user has sub modules enabled that are relevant to the import
  • Fix to create the stock item price band if it does not exist when updating price band prices from ‘Add Historical Lines’ [“Stock item price band X does not exist”]
  • Fix do not set the SOP fulfilment method of a sales order line when adding lines through telesales, instead allow Sage to set this value
  • Fix to assign a description to generated stock items through the stock matrix
  • Fix when using landed costs that specific to warehouses and on the purchase order line it would still calculate using all landed costs values. This would also happen for the provisional landed cost values displayed on the bottom grid for landed costs
  • Fix when apportioning by volume [“Specified argument was out of the range of valid values”]
  • Fix on container manager when saving a purchase order line [“Object Reference Error”]
  • Fix when attempting to save a container with a quantity of 0 the user will get informed and it will still save to quantity as 0 when it should not
  • Fix for associating a purchase order line with a container and then associating it with a container. The user then part receives this container line and then goes to adjust the quantity for the container and it errors [“Cannot set the value of field (.StockUnitOnOrderQuantity) to -x.00000”]
  • Fix when adding historical purchase order lines to allow the user to reduce to maximum level or continue to add the line
  • Fix to correctly update the quantity for container when amending purchase order lines or receiving purchase order lines through Sage. Container lines will now be removed if the quantity for container goes to 0
  • Fix to update the correct amount landed cost when saving a purchase order line and not closing and reopening the screen
  • Fix when sorting columns when adding a container line or on the container summary screen and it would overwrite the existing value with the previous value that was there

Hot Fix Enhancements
  • Added the ‘Export with Sicon’ option on the POP order form so that supplier part numbers get exported in the grid
  • Added the customisable grid to the ‘Add Historical POP Lines’ so that the user can see the maximum level

Date applied: March 25, 2022

211.0.4

Issues Resolved
Issues Resolved
  • Fix to update the ‘QuantityForContainer’ field when a purchase order is linked to a container received through Sage ‘Confirm Goods Received’ screen
  • Fix to group sales and purchase contracts lines when they are imported by the contract name
  • Fix to create entries on SiconDistPOPOrderReturn when purchase orders are created from MRP otherwise reporting on fields like ‘Confirmed’ do not report these orders without opening the purchase order
  • Fix when viewing archived sales orders [“Object Reference Error”]

Date applied: February 3, 2022

211.0.3

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • Fixed an issue with the AllocatedQuantity on the WarehouseItem not updating correctly all other tables updated correctly when converting a proforma to a sales order and then using a Sicon Reserve Stock line to allocate the sales order line
  • Fix when splitting container lines through container manager and the quantity on the RequestedDeliveryDate table would not update correctly
  • Fix to increase the size of the ‘Item Balance’ form otherwise the bin grid gets lost off the screen
  • Corrected the spelling of ‘Purchase’ when adding a container line
  • Corrected a spelling mistake on the ‘Unresolved Problem’ message box
  • Fix to prompt users for superseded items on SOP telesales screen
  • Fix to populate the ‘Warehouse Management (Stock Transfer)’ settings… Issue where it would appear that the settings weren’t saving
  • Fix when saving a container with tracking and the user confirms tracking up to the last tracking and they would experience an error [“Specified argument was out of the range of valid values”]
  • Fixed an issue when the user would select to use a contract price for a traceable stock item and then save the order… Open the order line again and update the quantity save the order and then it would cause allocations to be removed. This would leave an allocation on the allocation table and BinItem table but not update the WarehouseItem table
  • Fix for sales contract history being displayed as ‘TBA’ when being linked to a new sales order line

Hot Fix Enhancements
  • New web API method to update multiple landed costs in one go

Date applied: January 28, 2022

211.0.2

Issues Resolved
Issues Resolved
  • Fix to generate the correct stock transfer when filtering by ‘Only display items with shortages’
  • Fix for ‘Manage SOP Back Orders’ screen when the user would enter a quantity to allocate then check that line without leaving the quantity to allocate textbox and then it would validate this twice and display a message for it not being able to be allocated

Date applied: December 24, 2021

211.0.1

Issues Resolved
Issues Resolved
  • Fix on the shipping tab on a sales order when the user would enter a non decimal character into the weight text box and would get stuck in a loop [“Total weight must be decimal”]
  • Fix when viewing the monthly trading figures usage screen when coming from the Calculate Min stock screen this will now use the corrects dates and match what is being used in the calculation ie 3 month calc will show usage from today – 3 months whereas before it would run from the 1st of the month
  • Fix for displaying the correct amount of lost orders when coming from the min stock calculation screen, previously it would run from the 1st instead of -3 month to the date run
  • Fix corrected the base form for the ‘Change Fulfilment’ method screen to be the preallocation form not the SOPManagement
  • Fix when creating transfers from the ‘Stock Replenishment’ screen and it would add incorrect items to the created transfer
  • Fix corrected the base form for the ‘Sage to Sicon SO Fulfilment’ screen to be the preallocation form not the SOPManagement
  • Fix when printing acknowledgments from the view SOP order screen and there would be sales order/quotes or proformas with the same document number and it would print all the documents rather than just the sales order
  • Fix when setting a line date on a purchase order with no delivery date on the ‘POP Expected Delivery Dates’ screen [“Object Reference Error”]
  • Check to make sure the purchase order line has saved before creating container links otherwise the linked POPOrderReturnLIneID will be stored as null and display as ‘TBA’ on the container
  • Fix to increase the months in the calculate min stock calculation when using specific dates and the “to” date is the last day of the month to increase the months in the calculation by 1
  • Fix to get the correct start date for the usage screen when viewing 1 year and 2 year drilldown
  • Fix to ignore completed preallocations when on the ‘Manage SOP Back Orders’ screen
  • Fix when using the “Details” button on a sales order and then changing the address and these changes wouldn’t be reflected on the sales order

Date applied: December 15, 2021

211.0.0

New Features Important
Important Info

ALL UPGRADES TO v21.1 REQUIRE THE “SICON DISTRIBUTION” ENABLE STRING. ADVANCED AND STANDARD ENABLE STRINGS WILL NO LONGER WORK ON v21.1


New Features
  • CONTAINER MANAGER – New POP order line desktop added to the menu structure
  • SOP MANAGEMENT and POP MANAGEMENT – New columns in ‘On Order Details’ screen to display the ‘Free Stock Qty’ and the ‘ Preallocated Qty’
  • SOP MANAGEMENT – New warehouse filter added to the ‘Usage Analysis’ tab on ‘Monthly Trading Figures’ screen
  • SOP MANAGEMENT – Ability to restrict sales order allocation based on customer customer stock batch attribute requirements

Date applied: November 15, 2021