Distribution v20.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 Change in Functionality Important Only

Know the release number? Use quick search:

201.0.56

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

Date applied: February 17, 2022

201.0.55

Issues Resolved
Issues Resolved
  • Fix to add historical lines to purchase orders whether there is free stock or not
  • 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

Date applied: January 28, 2022

201.0.54

Hot Fix Enhancements
Change in Functionality
  • New Web API method to update multiple landed costs in one go

Date applied: January 25, 2022

201.0.53

Issues Resolved
Issues Resolved
  • Corrected a spelling mistake on the ‘Unresolved Problem’ message box

Date applied: January 25, 2022

201.0.52

New Features
New Features
  • Added a new web API method to create or updated landed costs

Date applied: January 19, 2022

201.0.51

Issues Resolved
Issues Resolved
  • Corrected the spelling of ‘Purchase’ when adding a container line

Date applied: January 13, 2022

201.0.50

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

Date applied: January 4, 2022

201.0.49

Issues Resolved
Issues Resolved
  • Fix to set the document number when using a reserve so that on the stock item history it doesn’t display “TBA”

Date applied: December 23, 2021

201.0.48

Issues Resolved
Issues Resolved
  • 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 22, 2021

201.0.47

Issues Resolved
Issues Resolved
  • Fix to generate the correct stock transfer when filtering by ‘Only display items with shortages’

Date applied: December 17, 2021

201.0.46

Issues Resolved
Issues Resolved
  • Fix to ignore completed preallocations when on the ‘Manage SOP Back Orders’ screen

Date applied: December 13, 2021

201.0.45

Issues Resolved
Issues Resolved
  • 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 creating transfers from the ‘Stock Replenishment’ screen and it would add incorrect items to the created transfer

Date applied: November 25, 2021

201.0.44

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 to read the correct Distribution sub module enable string

Date applied: November 19, 2021

201.0.43

Issues Resolved
Issues Resolved
  • Fix corrected the base form for the ‘Change Fulfilment’ method screen to be the Preallocation form not the SOPManagement, so will open for the correct Distribution sub module

Date applied: November 18, 2021

201.0.42

Issues Resolved
Issues Resolved
  • Fix to allow the max length of the additional information box on the lost orders form
  • 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”]

Date applied: November 15, 2021

201.0.41

Issues Resolved
Issues Resolved
  • Fix when amending Sicon stock reserves and the document date was being overwritten

Date applied: November 9, 2021

201.0.40

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

201.0.39

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

Date applied: October 14, 2021

201.0.38

Issues Resolved
Issues Resolved
  • Fix to get the correct weight each when apportioning landed costs

Date applied: September 21, 2021

201.0.37

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

201.0.36

Issues Resolved
Issues Resolved
  • Fix when amending and saving a purchase ledger account with POP Management [“Index out of range”]
  • Fix on container manager to correctly set the ‘OnOrderQuantity’ when adjusting purchase order lines

Date applied: September 8, 2021

201.0.35

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

201.0.34

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

Date applied: August 16, 2021

201.0.33

Issues Resolved
Issues Resolved
  • Fixed issue when maintaining purchase order delivery addresses [“Object Reference Error”]

Date applied: August 12, 2021

201.0.32

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

Date applied: August 5, 2021

201.0.31

Issues Resolved
Issues Resolved
  • 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: July 28, 2021

201.0.30

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

Date applied: July 8, 2021

201.0.29

Issues Resolved
Issues Resolved
  • Fix when amending/viewing a purchase order with supplier part number [“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

201.0.28

Issues Resolved
Issues Resolved
  • 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 30, 2021

201.0.27

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

Date applied: June 25, 2021

201.0.26

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

201.0.25

Issues Resolved
Issues Resolved
  • Fix when posting landed costs that are across multiple warehouses

Date applied: June 21, 2021

201.0.24

Issues Resolved
Issues Resolved
  • Telesales fixes with strange highlighting
  • Fix for nothing being displayed on the analysis codes tab on a sales order
  • Fix improvements when filtering by supplier on the ‘Calculate Min Stock’ screen
  • 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

Date applied: June 17, 2021

201.0.23

Issues Resolved
Issues Resolved
  • Fix to check the “Advanced” enable string so the relevant stock matrix tables get updated when converting a proforma to a sales order

Date applied: June 14, 2021

201.0.22

Issues Resolved
Issues Resolved
  • 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 being displayed when entering a new sales order from the customer desktop list

Date applied: June 4, 2021

201.0.21

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

Date applied: June 3, 2021

201.0.20

Issues Resolved
Issues Resolved
  • Fix updated the POP expected deliveries screen to load the data faster

Date applied: May 18, 2021

201.0.19

Issues Resolved
Issues Resolved
  • Fix to export the supplier KPI grid

Date applied: May 6, 2021

201.0.18

Issues Resolved
Issues Resolved
  • Fix to prompt the user to update purchase order line when changing a containers header requested delivery date
  • Fix to update the correct stock matrix tables when converting a proforma to a sales order
  • Fix when copying purchase orders [“Unable to cast object of type ‘Sage.Accounting.POP.X’ to ‘Sage.Accounting.POP.POPStandardItemLine’]
  • Fix to correct the rounding errors in the base value of landed costs [“The posting does not balance in method …GenerateJournal_Post()”]

Date applied: April 26, 2021

201.0.17

Issues Resolved
Issues Resolved
  • Fix to reload the landed cost grid on a stock item when the stock time is saved or changed on the ‘Amend Stock Item’ screen
  • Fix to correctly load the default container on a purchase order header
  • Fix when changing a stock item on the amend stock item screen without ‘SOP Management’, ‘Container Manager’ and ‘Future Sales’ sub modules enabled [“Object Reference Error”]

Date applied: April 19, 2021

201.0.16

Issues Resolved
Issues Resolved
  • Fix for posting landed costs from suppliers in different currencies
  • Fix to update the requested delivery date quantity correctly when adding a new delivery date to a purchase order line
  • Fix to load saved attachments on containers

Date applied: April 9, 2021

201.0.15

Issues Resolved
Issues Resolved
  • Fix to correctly calculate landed costs when part invoicing a purchase order
  • Fix for Sicon sales and purchase contract lines to allow the price and quantities to be stored down to 5dp

Date applied: April 7, 2021

201.0.14

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • Fix for SOP management menu items being displayed when Container manager features are turned on
  • Fix to display the preallocated quantity on the preallocation button when viewing/ editing a purchase order line
  • Fix to correctly check what sub modules are installed when adding buttons to the Distribution button (“View Previous Sales Orders” was being displayed when the user didn’t have SOP Management sub module)
  • Fix to allow lost order enquiry grid to be sorted by column
  • Fix for the X axis being in an incorrect order on the lost order analysis graph and sales analysis graph on the ‘Monthly Trading Figures’ screen
  • Fix to copy landed cost values across when copying purchase order through Sage
  • Check to see if the preallocation button has been created on the purchase order line screen [“Object Reference Error”]
  • Fix for correctly checking the free stock available at trading warehouses when making a stock item Discontinued

Change in Functionality
  • Added a graph to the purchase analysis tab to follow the same layout as all other tabs on that screen

Date applied: March 26, 2021

201.0.13

Issues Resolved
Issues Resolved
  • Fix for checking stock quantities when an item is discontinued to check whether any warehouse with stock are trading warehouses
  • Fix to allow the user to select a write off category on the “Transfer Small Stock item Batches”
  • Fix for incorrectly formatting numerical item codes when on viewing the “Summary” part of a container
  • Fix to allow the users to update existing matrix group sequences from the matrix group settings screen, this was because matrix groups would sometimes appear in wrong sequences

Date applied: March 23, 2021

201.0.12

Issues Resolved
Issues Resolved
  • Fix to only enable the default container selection when the purchase order is a new order this follows Sages default warehouse selection
  • Fix when loading landed costs when posting a purchase order invoice [“Sequence contains no elements”]

Date applied: March 9, 2021

201.0.11

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • Fix to break down landed costs dependant on what is being invoiced
  • Fix to set the sequence when creating stock matrix groups
  • Fix when generating stock matrix groups and the user would get the error [“Input was in an incorrect format”]
  • Fix on the ‘Manage SOP Back Orders’ screen to filter out preallocated lines correctly
  • Fix for duplicate purchase and sales contracts being created when the user prints the contract first before saving and then saves the order
  • Fix to set the max length of the inspection bin names to 20
  • Fix when a stock item is no longer discontinued to allow the stock item to be selected on sales orders
  • Fix to clear the default container value in the static container field when the purchase order form is closed
  • Updated the supplier account settings to be displayed dependant on what sub modules the user has enabled
  • Fix to make sure the user can allocate can and despatch sales order before adding the “Save, Allocate and Despatch” button
  • Fix to store the shipping information on BeginSave so that order acknowledgements have the shipping details correctly populated

Change in Functionality
  • Sales forecasting exclusions can be saved and therefore reused when the user closes and reopens the sales forecasting screen

Date applied: March 4, 2021

201.0.10

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • Fix when using the “Copy Order Lines” function on SOP to copy the original lines tax code to the new line
  • Fix when using SOP copy lines feature and the user attempts to copy a line that was direct to the customer and the line would not get added to the new order
  • Fix on sales forecasting when the chart has been hidden to remain hidden until the user selects to display it again
  • Fix on sales forecasting when generating MRP forecast to only generate ones with values
  • Fix to no longer calculate a discount percent from the line if the selling price has been changed through the telesales screen
  • Fix to post the POPOrderReturnLine after the Update otherwise if it is a new line then the POPStandardItemLink if the user closes the screen

Change in Functionality
  • Added a delete forecast button when viewing saved forecasts

Date applied: February 24, 2021

201.0.9

Issues Resolved
Issues Resolved
  • Fix for container lines being deleted when exiting a purchase order from the view mode
  • Fix for telesales screen stock item search control to now use a view [“Database timeouts”]
  • Fix to filter by supplier on the unallocate tab on ‘Manage SOP Back Orders’
  • Fix when adding lines to a sales order return from the stock matrix [“Object Reference Error”]
  • Fix when loading a sales order in view mode order [“Object Reference Error”]
  • Fix for preallocations to validate against the StockUnitLineQuantity rather than the LineQuantity
  • Fix to not display a warning message when viewing a sales order on the old enable strings [“Would you like to change all order line promised dates (excluding those fully despatched) to this date”]

Date applied: February 17, 2021

201.0.8

Issues Resolved
Issues Resolved
  • Fix to stop duplicate lines being created on the SiconDistPOPOrderLineProblem table and to store and reload the associated problem with a container
  • Fix for displaying the POP order line list
  • Fix to display the “Customise” button on the grid context menu when the minimum stock levels have been calculated
  • Fix to display unit of measures for the container manager stock item settings
  • Fix to sort the SiconDistPrevSalesOrderView by document date to get the correct quantity from the last sale on the “Add Historical Lines” screen
  • Fix for displaying the purchase and sales contracts popup when adding lines to a sales order when the price of the line was the same as the contract price

Date applied: January 28, 2021

201.0.7

Issues Resolved Hot Fix Enhancements
Issues Resolved
  • Fix for “Stock replenishment” screen creating duplicate stock transfers and to also correctly set the transfer values when there is multiple warehouses being transferred to for the same stock item
  • Fix to correctly validate preallocation quantities with UOM
  • Fix to allow the purchase order line list to display lines where the item name/description is longer than 64 characters long
  • Fix to correctly save the “Enable Supplier Minimum Orders” setting
  • Fix when amending SOP quotations without the “Add Historical Lines” button enabled [“Object Reference Error”]
  • Fix to display the supplier part numbers when on a purchase order
  • Fix when amending a SOP quotation and the totals box would not be placed in the correct position [REQUIRES COMMON COMPONENTS v201.0.20]
  • Fix to display the “Check Containers” button on the suggested purchase order tab in MRP
  • Fix to set the “Import Distribution Stock Settings” feature to be under utilities so all sub modules can use it
  • Fix for base forms to not cause the screen to freeze if the modules are not enabled
  • Fix on the “View Stock Balances” screen to only display “View Previous Sales Orders” button in context menu for the distribution button if the user has SOP management sub module enabled

Change in Functionality
  • Fix for purchase contract to integrate with MRP when purchase orders are created, users can now select purchase contracts to associate these with [REQUIRES COMMON COMPONENTS V201.0.20 AND MANUFACTURING V201.0.13]
  • Added the maintenance screen for supplier quantity breaks to the distribution menu

Date applied: January 19, 2021