Distribution v21

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:

210.0.38

Issues Resolved
Issues Resolved
  • Fix for duplicate lines being created on the SiconDistPOPOrderReturnLine table

Date applied: May 27, 2022

210.0.37

Issues Resolved
Issues Resolved
  • Fix when generating sales orders from Sicon Stock Reserves with traceable item but select traceable numbers are selected at despatch [“Object Reference Error”]
  • Added allowable warnings for placing orders on hold if the customer is over their credit limit or insufficient stock
  • 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 20, 2022

210.0.36

Issues Resolved Important
Important Info

REQUIRES SICON COMMON COMPONENTS v210.0.64 (Minimum)


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 to not save lines when a warehouse hasn’t been set or quantity on Sicon Stock Reserves
  • Fix to correctly enable and disable the ‘Allocate Line’ and ‘Unallocate Line’ button on Sicon Reserve stock screen
  • 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
  • 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 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 if there is a validation 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

Date applied: May 13, 2022

210.0.35

Issues Resolved
Issues Resolved
  • Fix to apply Sicon customer codes when adding new sales order lines from “Add Historical Lines” and “Copy Order Line”

Date applied: April 4, 2022

210.0.34

Issues Resolved
Issues Resolved
  • 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

Date applied: March 3, 2022

210.0.33

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • 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”]

Hot Fix Enhancements
  • Added the ‘Export with Sicon’ option on the POPOrder form so that supplier part numbers get exported in the grid

Date applied: February 25, 2022

210.0.32

Issues Resolved
Issues Resolved
  • Fix when viewing archived sales orders [“Object Reference Error”]

Date applied: February 3, 2022

210.0.31

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • 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 the SOP telesales screen
  • Fix to populate the ‘Warehouse Management (Stock Transfer)’ settings… Issue where it would appear that the settings weren’t saving
  • 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

210.0.30

Issues Resolved
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

Date applied: January 13, 2022

210.0.29

Issues Resolved
Issues Resolved
  • Fix to generate the correct stock transfer when filtering by ‘Only display items with shortages’
  • Fix when setting a line date on a purchase order with no delivery date on the ‘POP Expected Delivery Dates’ screen [“Object Reference Error”]
  • 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

210.0.28

Issues Resolved
Issues Resolved
  • Fix to ignore completed preallocations when on the ‘Manage SOP Back Orders’ screen
  • Fix to only use the WOP/MRP stock item lead time if there isn’t a stock item supplier lead time set

Date applied: December 15, 2021

210.0.27

Issues Resolved
Issues Resolved
  • 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

Date applied: December 9, 2021

210.0.26

Issues Resolved
Issues Resolved
  • 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
  • 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

Date applied: December 2, 2021

210.0.25

Issues Resolved
Issues Resolved
  • Fix to increase the max length of the additional information box on lost orders screen
  • 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 to 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 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 ‘Change Fulfilment Method’ screen to check for the ‘Preallocation module’ and not the ‘SOP Management module’

Date applied: November 19, 2021

210.0.24

Issues Resolved
Issues Resolved
  • Fix when using superseded items and then when the user would receive these items in and the stock item balances would not update correctly
  • Fix when amending Sicon stock reserves and the document date was being overwritten

Date applied: November 4, 2021

210.0.23

Issues Resolved
Issues Resolved
  • Check in place to make sure “Enable supplier min orders” is turned on, otherwise when the user amends a supplier they get an error [“Object Reference Error”]

Date applied: October 29, 2021

210.0.22

Issues Resolved
Issues Resolved
  • Fix to load the supplier minimum order value when loading a supplier
  • Fix to also check the advanced scripts to check if a template has been selected otherwise the top landed cost grid will not get populated

Date applied: October 28, 2021

210.0.21

Issues Resolved
Issues Resolved
  • Fix to the Stock replenishment when it would stop responding when there is a large number items being processed when creating transfers
  • Fix for an issue when users would try and add a problem to a container prior to them saving the container first [“Object Reference Error”]
  • Fix to correctly update purchase order line tables when splitting lines on a container. Lines were being missed off the POPOnOrderLine and POPOnOrderBalance and therefore when the user received the purchase order in it would not correctly update the WarehouseItem table and therefore left an ‘OnOrderQuantity’ on this table even though this was fully received

Date applied: October 19, 2021

210.0.20

Issues Resolved
Issues Resolved
  • Correctly filter out inactive stock items when running min stock calculations for all items
  • Split the header and line due dates into their own columns on the ‘On Order Details’ screen

Date applied: October 13, 2021

210.0.19

Issues Resolved
Issues Resolved
  • Fix when saving supplier settings with Sicon Landed Costs turned on and percentage based has been checked [“Index was out of range”]

Date applied: October 6, 2021

210.0.18

Issues Resolved
Issues Resolved
  • Fix for the “Landed cost” tab not appearing when invoicing a purchase order

Date applied: October 1, 2021

210.0.17

Issues Resolved
Issues Resolved
  • Fix better loading and saving speeds with sales orders with large amounts of lines

Date applied: September 29, 2021

210.0.16

Issues Resolved
Issues Resolved
  • Fix when using the “Print Acknowledgement” button on a sales order when the user has CRM [“Unable to cast object of type ‘Sicon.CRM.DBO.SiconCRMSOPOrderReturn’ to type ‘Sage.Accounting.SOP.X”]
  • Fix to get the correct weight each for apportioning landed costs
  • Fix when setting the container status when saving a container [“Object Reference Error”]
  • Fix the issue where the user would not be able delete saved forecasts
  • Discontinued and inactive items are now excluded from the sales forecasting screen

Date applied: September 23, 2021

210.0.15

Issues Resolved
Issues Resolved
  • Fix to increase the number of characters that can be stored on a container memo
  • Fix when splitting lines on a container to use the same warehouse as the line that has been split
  • Fix to handle opening “Archived” purchase orders [“Object Reference Error”]

Date applied: September 17, 2021

210.0.14

Issues Resolved
Issues Resolved
  • Fix on container manager to correctly set the ‘OnOrderQuantity’ when adjusting purchase order lines

Date applied: September 8, 2021

210.0.13

Issues Resolved
Issues Resolved
  • Fix when amending and saving a purchase ledger account with POP Management [“Index out of range”]

Date applied: September 6, 2021

210.0.12

Issues Resolved
Issues Resolved
  • Fix to correctly handle free text lines when the user tries to add them to containers, currently users are unable to add free text lines to a container
  • Fix to set the document number when using a reserve so that on the stock item history it doesn’t display “TBA”
  • Fix to not allow the user to over preallocate a reserve line
  • Fix to allow a reserve line to be part allocated on entry

Date applied: August 31, 2021

210.0.11

Issues Resolved
Issues Resolved
  • Fix to be able to remove container lines when on the ‘Values’ option when amending a container
  • Fix when viewing POP On Order Lines and it was including lines that are completed
  • Fix to display the serial numbers that are associated with a reserve when there is traceable stock allocated to it
  • Fix to correctly check the right user permission when overriding the price of a sales order line being added through the telesales screen
  • Fix to allow the user to select warehouses to exclude from the “Usage” calculation in Monthly Trading Figures

Date applied: August 26, 2021

210.0.10

Issues Resolved
Issues Resolved
  • Fix when using Sicon SOP Fulfilment methods to correctly populate the fulfilment method box on a SOP line when a stock item is selected using the stock item fulfilment method
  • Fix to store the correct purchase order number when create preallocations off the back of back to back orders

Date applied: August 18, 2021

210.0.9

Issues Resolved
Issues Resolved
  • Fix when saving the price of a sales contract line and it was rounding it up after 2dp, this will now go to 5dp
  • Fix when adding a new reserve line [“Object Reference Error”]
  • Fix when using sales contracts to make sure the user has permission to change sales order prices
  • Fix to not display contract lines that do not have a balance when it comes to selecting a contract line
  • Fix to disable the header fields when amending a sales or purchase contract
  • Fixed issue when maintaining purchase order delivery addresses [“Object Reference Error”]
  • Landed cost fixes… Issues with the landed cost tab not repopulating when amending a purchase order
    Issue on the purchase order line where the landed cost value would remain as 0
  • Fix to check the correct SOP user permission when on the telesales screen to allow the user to override the price on a line
  • Fix to filter out inactive stock items on the “Calculate Min Stock” screen
  • Fix to make sure the stock item is selected when removing a line from a SOP and the user comes to enter a lost order reason. Occasionally the stock item wouldn’t be populated and then the user would not be able to save the lost order
  • Fix for Sicon Stock Reserves to allow then to be returned to the originating reserve when deleted from a sales order
  • Fix to correctly update the purchase order status when it gets confirmed without any tracking
  • Fix when using Sicon SOP Fulfilment methods to correctly populate the fulfilment method box on a SOP line when a stock item is selected using the stock item fulfilment method
  • Fix to store the correct purchase order number when create preallocations off the back of back to back orders

Date applied: August 16, 2021

210.0.8

Issues Resolved
Issues Resolved

Fix for loading and saving distribution stock item settings when adding new items or changing existing items


Date applied: August 3, 2021

210.0.7

Issues Resolved
Issues Resolved
  • Fix to Sicon reserve stock to correctly set order status’, the default quantity when reducing a reserve down,
  • Fix when editing reserve lines to get the correct quantities for free stock etc and also fix when allocating a sales order [“the quantity entered is greater than the free stock at this location”]
  • Fix when viewing on order details for a stock item, to pull through the purchase order header requested delivery date if there isn’t one set on the line
  • Fix to adjust the invoiced quantities of purchase order lines when they are split on containers

Date applied: August 2, 2021

210.0.6

Issues Resolved
Issues Resolved
  • Fix for stock transfers to display all transfer types
  • Fix on container manager when viewing the purchase order values with a discounted percentage or value and it would keep discounting the line, new column added for the actual unit buying price

Date applied: July 19, 2021

210.0.5

Issues Resolved
Issues Resolved
  • Fix for incorrect landed cost actual totals when there is multiple lines added to a purchase order
  • Fix to supress inactive stock items from the stock lookup filter on ‘Manage SOP Back Orders’, ‘Calculate Min Stock’ and ‘Stock Inspections’ form
  • Fix to correctly update the allocation status of an order when using the ‘Manage SOP Back Orders’
  • Fix when checking the confirmed button on container tracking [“Object Reference Error”]

Date applied: July 8, 2021

210.0.4

Issues Resolved
Issues Resolved
  • Fix when amending/viewing purchase orders with supplier part numbers [“Index was out of range”]
  • Fix when adjusting actual tracking dates on a tracking line and it would then adjust the requested delivery date even though no requested delivery tracking dates were altered

Date applied: July 1, 2021

210.0.3

Issues Resolved
Issues Resolved
  • Fix when viewing purchase orders from the “View Purchase Order” screen on a stock item, to not display the message box to “Confirm all lines on the purchase order”
  • Fix moved the “Amend Batch/Serial Numbers” to the unallocate tab on “Manage SOP Back Orders” as the stock needed to be allocated before you can amend any of the serial numbers
  • Fix when adding traceable stock items to a sales order from a SOP template [“Object Reference Error”]
  • Fix when reducing a Distribution stock reserve down from a sales order, check the user is able to set the allocated amount [“Input string was not in a correct format”]

Date applied: June 29, 2021

210.0.2

Issues Resolved
Issues Resolved
  • Fix when attempting to post purchase orders without landed costs [“The given key was not present in the dictionary”]

Date applied: June 22, 2021

210.0.1

Issues Resolved
Issues Resolved
  • Added a new export routine for the supplier KPI screen
  • Fix to load the Distribution tab on a suppliers account
  • Fix to recalculate landed cost values when making changes to any line on the purchase order
  • Fix to add POP header buttons to a new Sicon button panel just below the grid
  • Fix added an export routine for the sales forecasting screens
  • Fix to not allow tracking to be confirmed if there is a problem at that stage or a stage previous to that one that is not resolved
  • Fix updated the POP expected deliveries screen, loading data improvements
  • Fix to correctly get the number of months between two dates. Issue with min stock where it wasn’t displaying the correct values as it wasn’t dividing by the correct number of months
  • Fix to set the actual total for landed costs when they haven’t been set, Issue when the user would amend the actual total close and reopen the screen and it would overwrite this value
  • Fix to display the outstanding preallocated quantity on the sales order header grid in the “Preallocated” column
  • Fix when displaying the quantity on the “Values” tab of the container manager screen to use the “Quantity for container” field rather than the purchase order line quantity field
  • Fix changed the event that fires for the “Undespatched Sales Orders” form to be displayed when selecting a customer… This wasn’t beig displayed when entering a new sales order from the customer desktop list
  • Telesales fixes with strange highlighting
  • Fix to check the “Advanced” enable string so the relevant stock matrix tables get updated when converting a proforma to a sales order
  • Fix improvements when filtering by supplier on the ‘Calculate Min Stock’ screen
  • Fix for nothing being displayed on the Analysis codes tabs on a sales order
  • Fix for Distribution contracts when increasing contract quantities, also fixed the issue when the user wouldn’t change anything on the line and it would display the contract message
  • Fix when posting landed costs that are across multiple warehouses
  • Fix when posting landed costs with different currencies
  • Fix on “POP Expected Delivery” screen when the user removes the order quantity [“Input string was not in the correct format”]

Date applied: June 18, 2021

210.0.0

New Features Hot Fix Enhancements Important
Important Info

v21 RELEASE


New Features
  • Landed Costs Template–These can be created and used as an alternative to the Supplier Landed Costs settings. In the PO header there is a new field where a template can be selected.
  • Container History–This allows for the tracking of changes to the container.

Hot Fix Enhancements
  • Where Sicon MRP is installed, when creating a Suggested PO that is linked to a Supplier Contract, the user can reduce down the contract quantity.
  • The ‘Save, Allocate and Despatch’ button is now enabled within the Distribution settings.
  • Manage SOP Back Orders–Sales Order Analysis codes are now available on the Unallocate screen and can be used to filter the SO’s.
  • Import Containers–Container details can be imported via a .csv file.
  • Commodity Codes, Country of Origin and Weights can now be added when creating Stock Matrix codes.

Date applied: May 4, 2021