Product overview

Help and User Guide maintained for Sicon Distribution | Container Management version 220.0.0 and upwards


The Container Manager module allows containers to be created and maintained. They are linked to Purchase Orders, with the ability to create container tracking profiles and update actual tracking information.  Where a container is not being used, tracking profiles can be created and updated for individual Purchase Orders. The tracking status of both can be viewed in a List view, and also within the Sicon Stock Movements screen.

When used in conjunction with the Sicon MRP Module, Stock Item weights and dimensions are used to calculate whether selected Suggested Purchase Orders exceed a containers Max Volume and Payload.

Dis Container Management - Section 1 image 1

Product Installation

Within Sage Admin, Distribution Scripts should always be enabled when adding the individual Features to the User Role.

Dis Container Management - Section 1 image 2


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. SC - Enter New/Amend Stock Item Details

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

Dis Container Management - Section 1.1 image 1

Dimension fields – The Stock Item weight and dimensions are added here. The volume will automatically be calculated.  These will be used to determine the available capacity of a container when Purchase Order Lines are added.


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.

Dis Container Management - Section 1.2 image 1


1.3. SC - View Monthly Trading Figures

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

Dis Container Management - Section 1.3 image 1


1.4. POP - Enter New/Amend Order

Tracking Dates tab – When abled in Distribution Settings, this allows you to track the shipment of the Purchase Order using a PO Tracking Profile, defined in the Tracking Profile Maintenance screen within the Maintenance menu.

Dis Container Management - Section 1.4 image 1

Vessel Name and Forwarder can be entered manually or selected from pre-defined lists set in Distribution Maintenance.

Each stage will have a provisional date calculated back from the Requested Delivery date of the Purchase Order.  The Actual dates can be amended and marked as confirmed as updates on the progress of the order are received.

For more details on the Notes and Problem buttons.

Dis Container Management - Section 1.4 image 2

Default container – A previously defined container can be selected, or a new container can be created.  This will be used to add each Purchase Order Line to the container.

Dis Container Management - Section 1.4 image 3

wDis Container Management - Section 1.4 image 4

The Container within the Purchase Order line can be amended or removed if required.

Dis Container Management - Section 1.4 image 5

Container Tracking (PO Line) – This will display the Tracking details for the container associated with the Purchase Order line.  The details can be amended and all other Purchase Order lines associated with the container updated via the ‘Update PO Lines’ button.


2. Container Manager Menu

Dis Container Management - Section 2 image 1


2.1. Container Management List

The Container Management List displays all previously created containers.

Dis Container Management - Section 2.1 image 1

The Current Tracking and Next Tracking are pulled through from the Tracking Info tab. Once the last Tracking Stage has been Confirmed, both columns will be displayed as Completed.

The Status will remain as ‘New’ until the first stage of the Tracking Profile has been Confirmed, at which time it will move to ‘In Progress’. Once the container has been received, the status will be ‘Completed’.

There is also the ability to ‘Receive Container’ from this screen.


2.2. New Container

New containers can be created here or within the Container Management list.

Dis Container Management - Section 2.2 image 1

Internal container number – This will be automatically created on saving the container.

Actual container number – Where known, the actual container number can be entered.

Container size – These can be selected from a drop-down list of container sizes created in Container Size Maintenance.

Requested Delivery Date – This date will be used to calculate the Provisional dates in the Tracking Profile.  The Requested Date of Purchase Order lines added to the container, can also be updated to reflect this date.

Volume/Weight – These fields will display the total volume and weight of items added to the container, where the values have been added in the Stock Item Details.  If either value takes the container over its capacity, the field will be highlighted in red.

Dis Container Management - Section 2.2 image 2

Add Container Line – Purchase order lines can be linked to the container by using the Add Container Lines button.

Dis Container Management - Section 2.2 image 3

Search – Clicking on the Search button, within the Add Container Lines screen, will display all undelivered Purchase Order lines.  This screen can be filtered by Supplier Code and Purchase Order, and can also be sorted by clicking on the relevant column header.  Order lines in red have already been assigned to a container and cannot been selected.

Add Lines – Items required for the container can be added by ticking the relevant line, or the Select All button can be used.  Purchase Order Lines that are already associated with a container are displayed in red and cannot be selected.  The Add Lines button will then save the lines to the container.

Dis Container Management - Section 2.2 image 4

Quantity for Container column – The Quantity for Container value can be reduced if the full quantity is not required in the container.  On saving the container a screen will be displayed and the user has the opportunity to create a new order line for the balance, which can then be added to a future container.  If No is selected, the balance on the order line will not be available to add to a container, and the Purchase Order line will not show the split between what is in a container and what is outstanding.

Dis Container Management - Section 2.2 image 5

The screenshot below, shows the item split out between the quantity in a container and the balance remaining.

Dis Container Management - Section 2.2 image 6

Once a line has been added to a container, the Internal Container number will show on the Purchase Order line, within Purchase Order Processing.  The Container Tracking can also be viewed here.

Dis Container Management - Section 2.2 image 7

Values button – This changes the screen to display the order line values. The Unit Price can be amended and any change will be reflected in the relevant Purchase Order.

Dis Container Management - Section 2.2 image 8

Tracking Info tab – This can be used to add a new Tracking Profile (see section 2.5.2).  A Vessel Name and Freight Forwarder can be selected from the drop-down list (see sections 2.5.3 & 2.5.4), or entered as free text.

The ‘Docs to forwarder’ and ‘Processed?’ tick boxes can be used for information purposes.

Dis Container Management - Section 2.2 image 9

When adding a new Tracking Profile, if the Container Requested Delivery Date cannot be met by the timeline required for the Tracking Profile, a warning screen will be shown and a new date will be set on the Container Summary screen.

Dis Container Management - Section 2.2 image 10

Dis Container Management - Section 2.2 image 11

Notes – A Note can be added to the container tracking stage.  If a note has been added, the button will be displayed as ‘*Notes*’.

Dis Container Management - Section 2.2 image 12

Problems – When a Problem is added, the subsequent Problem buttons are greyed out and the container cannot be moved onto the next stage until the Problem has been resolved.

The text will be displayed in the POP Order Line List and, where Sicon MRP is installed, the Future Stock Movement screen.

Dis Container Management - Section 2.2 image 13

Dis Container Management - Section 2.2 image 14

Attachments tab – Can be used for saving attachments against the container.

Dis Container Management - Section 2.2 image 15

Memos tab – This can be used to save general information against the container.

Analysis Codes tab – Analysis Codes created within the Distribution Settings screen can be selected here.

Save Container – On saving the Container, a screen will pop up asking the user if they would like to update the PO lines.  If yes is selected the PO lines will be updated with the Actual Date on the Tracking Info tab.

Dis Container Management - Section 2.2 image 16

History button – Once the Container has been saved, the History button will display all the transactions that have been processed against the Container. Where an adjustment has been made after the initial creation, a Reason can be added to the history line. In order to add a Reason, the setting of ‘Enable container history reasons’ must be enabled in Distribution Settings.

Dis Container Management - Section 2.2 image 17


2.3. Amend Container

The Amend Container sub section, can be used to display a list of containers, highlight those that are overloaded and those that have requested delivery dates that will not be met. The tracking status can also be seen in this window.

Dis Container Management - Section 2.3 image 1

Amend Container – A container can be amended by highlighting the line and clicking Amend Container.

Delete Container – A container can be deleted by highlighting the line and clicking Delete Container.

Dis Container Management - Section 2.3 image 2

Once the container has been deleted, the container will no longer be linked to any Purchase Order lines that were associated with it.

Dis Container Management - Section 2.3 image 3

Dis Container Management - Section 2.3 image 4


2.4. Receive Containers

This allows all Purchase Orders in the container to be received in one screen.  Receiving the container in this screen will also set the container status to Complete.

Dis Container Management - Section 2.4 image 1

Filters can be applied for Container and Supplier. Clicking Display will list all containers with a status of New or InProgress.

The containers are split by Supplier, and the individual Purchase Order numbers displayed in the POP Order Nos column.

Highlighting a container in the Containers section will display all Purchase Order lines, for that Supplier, in the Container Lines section.

Tick any containers that require receipting.

Dis Container Management - Section 2.4 image 2

Here the Quantity received can be amended, and the destination Bin selected.

In the below example, the Bin has been changed and the Quantity reduced to 6.

Dis Container Management - Section 2.4 image 3

Before clicking Receive Containers, the Supplier GRN will need to be populated, for all containers that have been ticked in the top section of the screen.

Dis Container Management - Section 2.4 image 4


2.5. Tracking Enquiry

Allows enquiry and maintenance of tracking stages linked to purchase orders or containers.

For purchase orders, select the purchase order tab, then select the vessel and tracking stage, purchase orders linked to the vessel at this stage then show.

Dis Container Management - Section 2.5 image 1

The tracking stage date, delivery date and booked in time can be amended for all purchase orders on the vessel.

Dis Container Management - Section 2.5 image 2

Clicking on update, then updates the tracking dates and booked in time linked to the purchase order.

Dis Container Management - Section 2.5 image 3

Docs to Forwarder and Stage Confirmed can also be updated from this screen.

For containers, select the containers tab, then select the vessel and tracking stage, containers linked to the vessel at this stage then show.

Dis Container Management - Section 2.5 image 4

The tracking stage date, delivery date and booked in time can be amended for all containers on the vessel.

Dis Container Management - Section 2.5 image 5

The stage can also be confirmed.

2.6. POP Order Line List

This displays Purchase Orders by order line.

Container No.’s associated with the PO line are displayed, with the Quantity and Requested Delivery Date. Where a Container Tracking Profile has been added, the current and next status are displayed.

The Tracking Profile Status for both PO Tracking Dates and Container Tracking Info, is displayed. If a ‘Problem’ has been added to the profile line, this text will also be displayed in the column.

Dis Container Management - Section 2.6 image 1

Where the Sicon Preallocations module is installed, the preallocated quantity is also displayed.


2.7. Maintenance

Dis Container Management - Section 2.7 image 1

Container Size Maintenance – The two most common container sizes have been added as default, but additional sizes (e.g. High Cube) can be added here.

Dis Container Management - Section 2.7 image 2

Tracking Profile Maintenance – Tracking Profiles for Purchase Orders and Containers can be created here. An existing Tracking Profile can be copied by highlighting the profile and clicking ‘Copy’.

Dis Container Management - Section 2.7 image 3 - Left

Dis Container Management - Section 2.7 image 4 - Right

A total of 8 stages can be added to each profile. Each stage can be given a Description, the number of Days Until Next Stage, whether the days are to include Working Days Only and what the POP Status for each stage is. Where a POP Status is not changing, it does not need to be repeated for each line as the last status will be used.

The total number of days for each profile will calculate back from the Requested Delivery Date and populate the date fields accordingly, showing when each stage needs to be started.

Dis Container Management - Section 2.7 image 5

Dis Container Management - Section 2.7 image 6

The status is used on the Tracking Info tab to show what stage the container is at.

Dis Container Management - Section 2.7 image 7

Once the ‘Confirmed’ box is ticked it shows the status line has been completed, and has moved on to the next stage in the Amend Container screen and the POP Order Line List.

Dis Container Management - Section 2.7 image 8

Dis Container Management - Section 2.7 image 8.1

Forwarder Maintenance – A list of Freight Forwarders can be created here.

Dis Container Management - Section 2.7 image 9

These can used in the Tracking Info tab for additional information.

Dis Container Management - Section 2.7 image 10

Vessel Maintenance – This allows for the creation of vessels that will appear in the drop-down list in the Tracking Info screen.

Dis Container Management - Section 2.7 image 11

Dis Container Management - Section 2.7 image 12

POP Order Status Maintenance – The Purchase Order/Container statuses can be added and amended in this screen. There are 4 default statuses, for which the colour can be amended. An additional status can be added by clicking on the Add button, and then selecting a status colour. Where Sicon MRP is installed, these are also used in the Container Status and PO Line Status columns in the Future Stock Movements screen.

Dis Container Management - Section 2.7 image 13 - Left

Dis Container Management - Section 2.7 image 14 - right

Import Containers – Container details can be imported via a .csv file, rather than being created manually in section 2.2. Clicking on the ‘Example Import File’ button provides the user with the Excel sheet to populate, and subsequently save as a .csv file.

Dis Container Management - Section 2.7 image 15

Dis Container Management - Section 2.7 image 16

The Check File button will check the data for any errors.  Lines with errors will be highlighted in red.

Once all the data is correct, the Import button will no longer be greyed out and the data can be imported.

NB

  • If the import has an actual container number, and a container has already been created with that number, the import will use that container.
  • If the import contains items that have already been assigned to the same container it will not duplicate them
  • An import with no Actual container number will use a previously created empty container if there is one
  • Where there are no empty containers created, an import with no Actual container number will create a new one
  • If the import has a mixture of actual container numbers and no container numbers, the import will split them out

3. Reports

Consignment Transfer – Only available with Warehouse Replenishment

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

Purchase Orders Outstanding Tracking Dates – Shows any Purchase Order tracking dates that are still outstanding (yet to be confirmed).

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

Dis Container Management - Section 5 image 1


4.1. Settings

Dis Container Management - Section 5 image 2

Enable Purchase Order Tracking – Enabling this will display the Tracking Dates tab on the Purchase Order screen, allowing the user to add a PO Tracking profile.

Dis Container Management - Section 5 image 3

Use actual date when updating purchase order – When using the option to update the PO lines in the Tracking Dates tab, the actual date set by the Tracking Profile will be used.

Dis Container Management - Section 5 image 4

Enable container history reasons – This allows for users to add a reason when making any adjustments to a container.  The reason will be displayed against the line in the History screen of the container.

Maintain reasons – This screen displays the types of adjustments that can be recorded against the container, and whether they need to be tracked and a reason entered.

Dis Container Management - Section 5 image 5

Analysis Codes – These will be displayed in the Analysis Codes tab of the New/Amend Container screens.


4.2. Sage to Sicon SO Fulfilment

This screen allows you to update existing Sales and Purchase Orders to use the new fulfilment methods in Distribution. You can click the Run button to apply the switch to all live and on hold orders, or alternatively specify individual sales or purchase order numbers and click the relevant run button next to the order number field.

Dis Container Management - Section 5 image 6


4.3. Import Stock Item Settings

The Distribution Settings, required within the Stock Item Details screen, can be imported via a .csv file. Clicking on the ‘Example Import File’ button provides the user with the Excel sheet to populate, and subsequently save as a .csv file.

Dis Container Management - Section 5 image 7

The Check File button will check the data for any errors. Lines with errors will be highlighted in red. Hovering the mouse over the Stock Item will display the reason for the error. Please note, the Stock Item data must be in the exact format as the data in Sage, i.e. capitals/lowercase/spaces.

Dis Container Management - Section 5 image 8

Once all the data is correct, the Import button will no longer be greyed out and the data can be imported.


4.4. Enable Module

The Enable Strings supplied by Sicon are displayed here.

Dis Container Management - Section 5 image 9


5. New Features & Important Information

Distribution New Features & Important Information

Sicon Main Menu