Distribution Help and User Guide | Warehouse Replenishment

1. Changes to Standard Sage screens

In addition to the new menu options described later in this help and user guide, there are also changes to standard Sage screens, which are detailed in this section.

1.1. 1.1 SC - Enter New/Amend Stock Item Details

The Distribution setting relating to the stock item can be found in the Sicon tab.

Auto Issue Item When Received – If this is set, on receipt of the Stock Transfer the item will be automatically issued, as per a standard Sage Internal Stock Issue.  The nominal for the Issue can be set in the Distribution Settings.

1.2. 1.2 SC – View Balances

By clicking the Distribution button at the bottom of the View Stock Item Balances screen, you can access the standard Sage View Stock History screen.

2. Warehouse Replenishment Menu

2.1. Stock Shortage Transfers

This feature greatly enhances the standard Sage Transfer Stock option to move stock between warehouses. It provides a means of allocating stock, printing a picking list, despatching it (with a despatch note) and moving it to an In Transit warehouse before receiving at the destination warehouse.  Where Sicon Barcoding & Warehousing is installed, the Stock Transfers can be processed on the handheld devices.

Each Stock Transfer is a separate record, with its own Transfer Reference. A single transfer reference can contain as many different stock items as required, but must have a single destination warehouse.

The window on the left-hand side of the screen displays a summary of the transfer details.  The Ready to Pick column shows whether a transfer has the ready to pick flag set.

The window on the right-hand side of the screen will display all the transfer items for the highlighted transfer on the left-hand side, with columns displaying the Quantity, Allocated quantity, Despatched Quantity and Received Quantity.

You can filter the transfers displayed using the filters at the top.  By default, all transfer Statuses other than Received are displayed.

A new transfer can be generated using the New Transfer, Copy Transfer or Transfer Templates buttons.

Edit Transfer – Highlight the transfer that requires editing and click on the Edit Transfer button.

Delete Transfer – A New transfer can be deleted here, once any transfer lines have been unallocated.

View Transfer – A selected transfer can be opened and viewed.

Copy Transfer – This will copy a highlighted transfer and add it to the Stock Transfers list.  Lines can be added/removed, and quantities amended, by using the Edit Transfer button.

Transfer Templates – Click on the Transfer Templates button and select the template required.  A new template can be added by clicking on the New button and following the procedure laid out in New Transfer.
*Action buttons are dynamic and will only be available to select if you are able to complete that action on your selected transfer.

New Transfer

Description – This field is optional and will appear on the Picking List, Despatch Note and in the Description column of the main Stock Transfers screen.

Transfer Destination – Determines the type of transfer.  This will default to ‘Deliver to Warehouse’.

‘Deliver to Warehouse’ requires the transfer to be received in at the ‘To’ Warehouse.
‘Transfer directly into Warehouse’ does not require the transfer to be received in at the ‘To Warehouse’ and is shown as received at the point of dispatch.  Stock will be shown in the ‘To Bin’ specified when the transfer was created.

From warehouse – A ‘From’ default warehouse can be set in Distribution Settings.

Despatch Date – Enter the date for the despatch of the transfer.

To warehouse – Select a warehouse that has been created in Sage Stock Maintenance.  A postal address needs to have been set against the location, in order for the Stock Transfer to be created.

Requested Date – The date the transfer is required, which will be displayed on the Picking List and Despatch Note.

Special Instructions – This will be displayed on the Picking and Despatch notes.

Courier/Delivery Code – These are optional and are created within Distribution Settings.

Priority – If required, a priority of 1-5 can be set to indicate the picking/despatch priority.  This will be displayed on the Picking List and Despatch Note.

Add – Once you have added the first line, it’s possible to tab across the fields to add subsequent lines.  You can select the bin that each transfer line will come from (if the ‘Enable bin selection’ setting is set), record the required quantity and choose how many you would like to allocate.  The lines can also be allocated at a later date.

Distribution Button – This gives access to the View Item Balances and View Stock History screens.

Print Picking List – If the transfer lines have been allocated, the Picking List can be printed.  The picking list can also be printed after the transfer has been saved.

If the Picking List is printed at this stage, before saving the transfer, the following 3 buttons will be displayed:

Despatch Transfer – The Transfer can despatched and a Despatch Note printed.

Cancel Pick – This will cancel the Pick and take the Transfer Status back to ‘New’.

Reprint Picking List – The Picking List can be reprinted if the Transfer needs to go back to the ‘Picking’ status.

NB  The fields of ‘Ready to Pick’ and ‘Was created from a device’ are for use when Sicon Barcoding and Warehousing is installed.

On saving the transfer it will show with a status of ‘Picking’ in the Sicon Stock Transfer screen. If the transfer is not Picked in the Create/Edit Stock Transfer screen, it will show with a status of ‘New’.

Allocate – Transfers can be selected and allocated.  Once the transfer has been allocated, the Ready to Pick column will be set based on the selected distribution setting.

Print Picking Lists – Once the transfer has been allocated, the Picking List can be printed.  The status will then be displayed as Picking.

Despatch – After the Picking List has been printed, the transfer can be depatched.  This will move the stock out of the ‘From’ warehouse and into the warehouse specified in the Stock Transfer Transit Warehouse field, in Distribution Settings.  The quantity for despatch can be reduced before the Despatch Note is printed.

A new transfer will be created for any un-despatched items, using the original transfer number and a sub header number, e.g. 0000015/001. Clicking the search button will refresh the screen to include the new transfer created.

Receive – This will fully receive all of the items despatched on the transfer into the ‘To’ warehouse and change the status of the transfer to Received.   If the despatched quantity differs to the quantity received, a manual stock adjustment will be needed to return the items to the ‘From’ warehouse.

Stock Transfer History

In the Create/Edit Stock Transfer screen there is an additional History tab displaying the history of each transfer line.

Depending on the status of the transfer, action buttons are also available in this screen.

New – Print Picking List.

Picking – Despatch Transfer, Cancel Pick and Reprint Picking List

Despatched – Receive Transfer and Reprint Despatch Note.

The View Item Balances and Stock History screens are also available via the Distribution button.

2.2. Archived Stock Shortage Transfers

Stock Shortage Transfers that have the status of Received, can be archived within Stock Shortage Transfers screen.

The Stock Transfer list can be filtered to show Received transfers only.  On selecting a transfer, the Archive button will appear.  More than one transfer can be selected using the tick boxes.  Once the transfer has been archived, it will be removed from the list and be displayed in the Archived Transfers list within Warehouse Replenishment Menu.

The list can be filtered by Reference, Description, From Warehouse and To Warehouse. Alternatively, these can be left blank and, on clicking the Search button, all archived transfers will be displayed.

2.3. Stock Replenishment

This allows for the system to suggest replenishments from one warehouse to another based on the stock item minimum levels set on the warehouse. You can select a source warehouse to supply the stock to and a destination warehouse that needs replenishing.  A warehouse group can also be used to replenish multiple warehouses (see below).  The replenishment list can be filtered to ‘Only display items with shortages’.

Warehouse Group – If a central warehouse holds the stock that replenishes a number of other locations, a Warehouse Group can be created within the Distribution Maintenance menu.  In the example below, the group is using geographical locations.  This can also be used to replenish, e.g., service vans.

Source Warehouse – The warehouse the stock items need to be replenished from.  If a Warehouse Group has been selected, this field will be populated based on the details entered in the group maintenance screen.

Despatch Date – Enter the date for the despatch of the transfer.

Destination Warehouse – The warehouse that requires replenishing.  If a Warehouse Group has been selected, this field will remain blank.

Required Date – This will be used as the Stock Transfer Requested Date.

Edit Dates – Where a Warehouse group has been selected, the Edit Dates button will be displayed.  This allows the Transfer dates to be modified for the individual locations within the Group.

Stock Replenishment screen

This will display all stock items associated with the Destination Warehouse/Warehouse Group.

Source Warehouse Stock – This displays the Available free stock in the Source Warehouse, as well as the Minimum Stock quantity. Where there is not enough stock at the source Warehouse to fulfil the shortage requirement the Transfer Quantity will be zero and displayed in red.  Where there is no Shortage, the Transfer Quantity will be Zero, and can be filtered out using the ‘only display items with shortages’.  If required, the Transfer Quantity can be amended.

Destination Warehouse Stock – The replenishment will check the Minimum Stock requirement and, based on the In Transit, Allocated and Free Stock quantities, calculate whether a transfer is required.  Ticking the ‘Only display items with shortages’ will remove all stock items where a transfer is not required.

‘>’ Function – Where a Warehouse Group has been used, highlighting the line and double clicking on the > will display a screen showing a breakdown of the shortage’s by each warehouse in the group.  If required, the Transfer Quantity can be amended.

Create Transfer – This will create the Transfers for the warehouses, which will then be available in the Stock Shortage Transfers screen for processing.

2.4. Transfer Small Stock Item Batches

This screen is designed to allow you to easily deal with batch items that remain in stock, but are unlikely to be sold or used due to the small batch quantity.

Product Group – Select the Product Group the batch items belong to.

Maximum Batch Quantity – This filters the Stock Item batch quantities requiring Write Off/Transfer.

Warehouse Transfer – The batch quantities can be transferred to a warehouse selected here.

Write Off – The stock write off type can be selected from the drop down list.

Proceed – This will process the Transfer/Write off once the stock items have been selected.

2.5. Maintenance

Warehouse Replenishment Group Maintenance – The Warehouse Groups, as described in the Stock Replenishment section, are created here.  Each Group must have a Name and a Source Warehouse.  The destination Warehouses for the Group can then be added.

2.6. Warehouse Management Dashboard

A dashboard has been created to display the details of Live Stock Transfers.  This dashboard can be amended by using the settings button.

2.7. Dashboards

Additional dashboards can be created here.

3. Reports

Consignment Transfer – Once despatched, this reports the Transfer details and status.

Purchase Orders and Returns Linked to Sales Orders – Only available with POP Management module

Purchase Orders Outstanding Tracking Dates – Only available with Container Manager.

Purchase Orders Awaiting Confirmation Detail – Only available with POP Management.

Purchase Orders Awaiting Confirmation Summary – Only available with POP Management.

Discontinued Stock Items – Only available with SOP Management.

4. Utilities Menu

4.1. Settings

Warehouse Replenishment – Stock transfer settings

Last Transfer Number – The number for the next Transfer can be changed using the Unlock button to allow edits to this field.

Default origin warehouse – When creating a new Transfer, this location will be pre-populated in the ‘From Warehouse’ field.

Stock Transfer Transit Warehouse – The warehouse to be used as the In Transit location, when the Transfer has been despatched but not received.

Stock Transfer Internal Area – The internal area to be used for the Stock Transfers.  This is created within the Sage Stock Settings and requires a nominal code for the value of the In Transit stock.

Enable Courier Selection – Activates the Courier field on Stock Transfers. The Maintain Courier’s button is used to manage a list of couriers.

Enable Delivery Code Selection – Activates the Delivery Code field on Stock Transfers. The Maintain Delivery Codes button is used to manage a list of delivery types.

Enable bin selection – Additional columns are added to the Create Transfer screen, allowing the selection of bin locations within the ‘To’ and ‘From’ warehouses .

Set the default “To Bin” to the highest priority bin (Excluding priority 1) – This will automatically choose priority bin 2 or above.

Internal Area To Use When Auto Issue Items On Receipt – If the item is set to Auto Issue on receipt within the Stock Item Details Settings, this is the Internal Area the stock will be issued to, as per a standard Sage Internal Stock Issue.

NB> The ‘Ready to Pick’ options are for use when Sicon Barcoding and Warehousing is installed.

4.2. Enable Module

The Enable Strings supplied by Sicon are displayed here.

5. Release Notes

The release notes page shows which release of the system includes new features or issues resolved.

At the release of Sicon v21 we announced that going forward, we will only be supporting Sage 200c and as such we are able to drop the year from our version numbers. We moved from 201.201.0.0 to 210.0.0.

New features detailed in the Release Notes relating to Pre-Release versions will not be detailed in the current Help and User Guide until the end of development phase.

6. New Features and Important Information