Product overview

Help and User Guide maintained for Sicon Distribution | POP Management version 220.0.0 and Upwards


The POP Management module enhances the Purchase Order Processing procedures including the ability to view and filter expected PO deliveries by date and time.  Supplier Catalogues can be created, enabling speedy entry of Free Text items (eg Consumables) from a pre-defined list.  Supplier KPI’s can be produced, showing KPI scores for Early, On Time, Late and Very Late deliveries.  Values can be drilled into, in order to view individual Supplier Order lines and Stock Item KPI’s.  Stock Items can be flagged as requiring inspection on receipt, and will automatically be placed in an inspection area in the system.

Dis POP 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 POP 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. PL - Enter New/Amend Account Details

A Sicon tab and a Distribution sub category has been added to these screens with the fields shown in the screenshot below.

Where Sicon Landed Costs are to be used, and they have been setup within the Maintain Landed Costs screen, these fields allow you to record the appropriate settings for this Supplier. For more details see the Maintain Landed Costs section.

Dis POP Management - Section 1.1 Image 1

On the Company tab in the Supplier Details there is an additional Minimum order value field. When this is populated, a Purchase Order cannot be saved until the minimum order value has been reached.

Dis POP Management - Section 1.1 Image 2


1.2. SC - Enter New/Amend Stock Item Details

Dis POP Management - Section 1.2 Image 1

  • Inspection required when receiving purchase order – With this item ticked, the Stock Inspections process can be used, whereby the item must go through the Inspection process on booking in.

Suppliers tab – This has additional fields, used by the Landed Costs functionality.

Dis POP Management - Section 1.2 Image 2

The Landed Costs section in the top right allows you to record whether landed costs are applicable for the purchase of this stock item from this supplier, and whether they will be percentage based or value based. See the section on Maintain Landed Costs for more information about this functionality.

Landed Costs tab – This tab shows the values recorded against each Supplier defined on that stock item and allows them to be edited on this screen. The total cost is updated onto the supplier landed cost figure and used on the Purchase Order.

Dis POP Management - Section 1.2 Image 3


1.3. SC - View Stock Item Balances

Fields have been added to this screen to show the quantity of this stock item on current SOP Proforma’s and Quotations. The Forward Order box shows how many are required for Sales Orders that have yet to be allocated.

Dis POP Management - Section 1.3 Image 1

Drill down is provided on the fields in blue in the screen: Click on any of these areas to drill down into a list of the orders that are contributing to these figures. If you double click on an order in the list, then the appropriate order enquiry screen will open.

Dis POP Management - Section 1.3 Image 2

Show details will amend the sales order.

Clicking on Quantity allocated will display the allocations.

Dis POP Management - Section 1.3 Image 3

The Quantity On Order screen shows the Due Date for the Line and the Header.  Where Sicon Preallocations is installed, the Preallocated and Free Stock quantity are also displayed.

Dis POP Management - Section 1.3 Image 4

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

View Monthly Trading Figures will open the standard Sage screen, where there are additional Usage Analysis and Lost Order Analysis tabs. The Lost Order tab is used in conjunction with the Sicon SOP Management module. Graphs have been added in each tab and a filter for warehouse location.

Dis POP Management - Section 1.5t Image 5

Dis POP Management - Section 1.3 Image 6


1.4. SC – Locations

We have added a new tick box to the Edit Warehouse Details screen when maintaining Locations within Stock Control Maintenance. This controls whether landed costs will apply to Purchase Order lines that are being delivered to this warehouse.

For details on the Distribution tab, please see the section on Landed Costs.

Dis POP Management - Section 1.4 Image 1


1.5. POP - Enter New/Amend Order

A number of new fields and buttons have been added to the Purchase Order screen. These are detailed below.

Confirmed – The check box on the Purchase Order allows you to record that the supplier has acknowledged and confirmed the order details and dates for the order.

N.B. – If the Supplier KPI function is to be used, the Purchase Order must be Confirmed before the Purchase Order is booked in.

Dis POP Management - Section 1.5 Image 1

This information is also available when drilling into the Purchase Orders from within the Stock Item Balance screen. There is also the option to set the individual PO lines as confirmed.

Dis POP Management - Section 1.5 Image 2

The Confirmed flag can also be seen in the Distribution, Purchase Orders List Extended screen.

Dis POP Management - Section 1.5 Image 3

Amount Remaining – This field is based on the Minimum Order Value (MOV) set against the supplier. Until the MOV has been reached and the amount remaining reaches zero, the Save button is greyed out and the order cannot be saved.

Dis POP Management - Section 1.5 Image 4

Add Hist. Lines – Enables you to search for Stock Items ordered previously from the supplier, using a range of months set in the Distribution Settings.

When Adding Historical items to the Purchase Order you can see the Average Buying Price, Last Buying Price and Last Discount. The New Quantity, Buying Price and Discount can be amended before adding the lines to the current Purchase Order.

Dis POP Management - Section 1.5 Image 5

Item Order History – This button, on the Order Item Line screen, displays previous order lines for the Stock Item.

Dis POP Management - Section 1.5 Image 6

Set PO line date based on header date – With this enabled in Distribution Settings, if the Purchase Order date is amended a prompt will be displayed and all item lines can be updated to the new header date.

Dis POP Management - Section 1.5 Image 7

Zero Value Order Lines – Where a Purchase Order line has a zero value, on saving the item a prompt will be displayed to ensure the user wishes to continue.

Dis POP Management - Section 1.5 Image 8

Delivery & Invoicing tab – Where the Distribution Setting is enabled, the Purchase Order Delivery Address can now be amended.

Landed Costs tab – This additional tab shows the Provisional landed costs breakdown and allows you to record Actual landed costs, apportion them across the relevant lines and then tick the box to confirm the landed costs, so these are included in the stock value when the PO is booked in.

Dis POP Management - Section 1.5 Image 9

The Provisional Totals give you the totals for all landed costs on the order, based on the information entered in the Stock Item Details for this supplier. You can then populate the Actual totals as the costs are received and apportion these Actual costs across the multiple lines on the order, apportioned either by Percentages, the Weight or the Volume.

Once you have used the Apportion button to split the costs between the lines, click the Update PO Lines button to update the landed costs on the order lines.

When using Landed Costs, the Purchase Order cannot be received in until the Landed Cost Confirmed box has been ticked. This ensures that if item costs are updated on Goods Receipt, the landed cost will be included. If the box is ticked and no Actual costs have been entered, the Provisional values will be used for the Nominal postings.

When the invoice is matched to the order, the landed costs Nominal postings will be split between the designated Nominal control accounts for the landed costs types.

See the section on Maintain Landed Costs for full information on the configuration required for this functionality.


1.6. POP – Record Purchase Invoices

We have made a change in the functionality of the nominal coding on invoices being matched to purchase orders where landed costs are involved. Standard Sage200 landed costs functionality adds the landed costs to the value of the stock, so a posting is made to the default landed costs nominal account to correspond with the increase of the stock value. With our enhanced landed costs functionality, we reverse this posting out of the default landed costs nominal account, and instead split it between the nominal accounts specified against the landed costs types (defined within the Maintain Landed Costs screen in the Stock Control menu).

In the example below £21 of landed costs have been added to the stock cost and posted to the landed cost control nominal, we then reverse out the posting to the control nominal and split the cost between the 6 nominal codes as detailed.

Dis POP Management - Section 1.6 Image 1

Dis POP Management - Section 1.6 Image 2


1.7. PL – Supplier Transaction Enquiry

View Invoice Items – Within the Supplier Transaction Enquiry screen, this button allows you to view all the order lines associated with that transaction.

Dis POP Management - Section 1.7 Image 1

When a row in the list which has a source of POP is selected, you can open a screen which displays the order lines for the transaction.

Dis POP Management - Section 1.7 Image 2

In this view you can then drill down to the actual Purchase Order it relates to by double clicking the row or clicking the View Order button.


2. POP Management Menu

Dis POP Management - Section 2 Image 1


2.1. POP Management Dashboard

With this screen you can setup Dashboards. When first opening this screen there are no active dashboards. Click on the Settings icon next to the refresh button.

Dis POP Management - Section 2.1 Image 1

Dis POP Management - Section 2.1 Image 2

Refresh timer: Sets how often the dashboard updates

Number of panels: This is the number of dashboard panels that can be displayed. This ranges from 1 to 4.

Panel: Select the dashboard you want to see.

Dis POP Management - Section 2.1 Image 3

Expected deliveries today is the most relevant dashboard for POP Management. The dashboards can easily be modified or added via the Maintains Dashboard Panels menu option.


2.2. Supplier Catalogue

The Supplier Catalogue can be used to create a catalogue of items that can be added as free text items to Purchase Orders. The purpose of the catalogue is to speed up the entry of frequently purchased free text items e.g. consumables.

Dis POP Management - Section 2.2 Image 1

Catalogue items can be entered into the catalogue by adding items or via the Import button in the Stock Item Catalogue screen. The item description needs to be populated as this is copied into the POP free text description.

Dis POP Management - Section 2.2 Image 2

When in a Purchase Order line and adding a free text item, the catalogue can be searched and an item from the catalogue added to the order.

Dis POP Management - Section 2.2 Image 3


2.3. Supplier KPI

The Supplier Key Performance Indicator (KPI) screen allows you to view and analyse the delivery performance of your suppliers and can be filtered by supplier and date range. All KPI screens can be exported, facilitating further reporting via Excel.

Dis POP Management - Section 2.3 Image 1

The number of Purchase Order lines included in the calculation is displayed, alongside columns showing the percentage of Early, On Time, Slightly Late and Late deliveries.  The KPI Score shown is the average of the order lines.

Double clicking on the Supplier name will display the Supplier KPI’s Stock Item screen.  This shows a list of all the Stock Items received from the supplier and the average KPI score.  As the information displayed on this screen may result in the Supplier Lead time requiring amendment, a button to access the Amend Stock Supplier Details has been added.

Dis POP Management - Section 2.3 Image 2

View Order Lines – This screen displays all the lines used in the calculation, with the item Quantity, Value, the relevant Purchase Order dates and the KPI Score for each line.

Dis POP Management - Section 2.3 Image 3

The Purchase Order view screen can be accessed by either double clicking on the required line or clicking on the View Order button.

View Monthly Breakdown – This screen shows the KPI breakdown of all deliveries by month.

Dis POP Management - Section 2.3 Image 4

The colour coding and criteria for the Supplier KPI’s can be set in ‘Supplier KPI Band Maintenance’, within the POP Management Maintenance screen.

Dis POP Management - Section 2.3 Image 5

Important: Please note that only Purchase Orders that have a status of ‘Confirmed’ will be included in the KPI calculations.


2.4. Purchase Order Expected Deliveries

This screen displays a list of deliveries expected for outstanding Purchase Orders.

Dis POP Management - Section 2.4 Image 1

The screen can be filtered by Stock code, Supplier and Due date. You can also include deliveries without order line due dates.

Purchase Order Lines can also be marked as ‘Confirmed’. If the Supplier KPI’s feature is being used, this screen can be used to ensure the order line has been confirmed before the items are booked in.

Amend Details – When a line is selected, this button will open the Edit Order Item Line screen.

Amend Order – When a line is selected, this button will open the Amend Purchase Order header screen.

If the Sicon Container Management module is also installed, the Expected Time from the order line will pull through to the Exp. Time column.


2.5. Stock Item Location Wizard

This feature allows you to more easily add a Warehouse location created within Sage, to multiple Stock Items.

Stock Selection tab – This allows you to select a number of Stock Items and assign a Warehouse location, Reorder, Minimum and Maximum stock levels. The Stock Items can be filtered by Product Group. To add the stock items to the Warehouse, select the Destination Warehouse and one or more stock items to add to it.

Dis POP Management - Section 2.5 Image 1

Copy from Warehouse tab – This feature has been created to enable you to quickly add all Stock Items from one Warehouse location to another. The Reorder, Minimum and Maximum stock levels will be copied from the source warehouse to the destination warehouse. This will update existing records, or add the destination warehouse to the stock items that are missing it.

Dis POP Management - Section 2.5 Image 2


2.6. Stock Inspections

This screen allows you to Pass or Fail stock items that have been flagged as requiring inspection within the Stock Item Details, and have been receipted into the inspection bin specified in the Distribution Settings.

Dis POP Management - Section 2.6 Image 1

Once the stock has been received into the inspection bin, the Stock Inspections screen can be used to inspect the item and Pass or Fail it.

Dis POP Management - Section 2.6 Image 2

Failed items are transferred to the Warehouse and Bin as set in the Distribution Settings. If the stock is passed the user can select the bin to transfer it to.

Dis POP Management - Section 2.6 Image 3


2.7. Maintain Supplier Price Lists with Quantity Breaks

This function allows Supplier buying prices to be set up against each stock item, based on multiple quantity breaks.

Dis POP Management - Section 2.7 Image 1

List stock items for suppliers – Filtering here will display all stock items that have price breaks applied for the selected Supplier.

List suppliers for stock items – Filtering here will display all Suppliers that have price breaks applied for the selected stock item.

Add button

Where the screen has been filtered by Supplier, stock codes, quantities and prices can be entered.

Dis POP Management - Section 2.7 Image 2

Dis POP Management - Section 2.7 Image 3

Where the screen has been filtered by stock item, Suppliers, quantities and prices can be entered.

Dis POP Management - Section 2.7 Image 4

Dis POP Management - Section 2.7 Image 5

Delete button – This will delete the highlighted line on the screen.

Export button, upper – This will export the buying prices of the displayed stock items/Suppliers (depending on the filter) to a .csv file.

Dis POP Management - Section 2.7 Image 6

Dis POP Management - Section 2.7 Image 7

Import button – Buying prices can be imported from a .csv file. An example import file can also be downloaded from this screen.

Dis POP Management - Section 2.7 Image 8

After populating the .csv file, it can be selected and checked for errors. Any errors will be highlighted in red, with a reason for the error.

Dis POP Management - Section 2.7 Image 9

Once any errors have been corrected, the Import button will no longer be greyed out and the file imported.

Dis POP Management - Section 2.7 Image 10

Export button, lower – This will export all stored Supplier/stock item buying prices.

Dis POP Management - Section 2.7 Image 11

Clear button – This can be used to reset the Supplier and stock item filters. The displayed list will also be cleared.


2.8. Purchase Orders List Extended

The extended Purchase Order list, shows the confirmed flag of the Purchase Order in addition to the standard Purchase Order information.

Dis POP Management - Section 2.8 Image 1


2.9. POP Order Line List

This displays the individual Purchase Order Lines. Where Sicon Container Manager is being used, the Container details and POP/Container Line status is shown. If Sicon Preallocations is being used, a column displays the quantity Preallocated to the purchase order line.

Dis POP Management - Section 2.9 Image 1


2.10. Maintenance

Supplier KPI Band Maintenance

The colour coding and criteria of the supplier KPI can be set in this screen. The number of days late that contribute to each category can be user defined.

Dis POP Management - Section 2.10 Image 1

Update KPI’s – This button pulls through all historical data, prior to the installation of the Sicon Distribution module. In order for this data to be included in the KPI’s, the Update KPI’s function must be run.

Maintain Landed Costs

With enhancements to the standard Sage functionality, you can break Landed Costs down into more detailed types and have Landed Costs posting to multiple nominal codes, to reflect the breakdown of the costs. The split of the nominal postings is covered in section 1.6 POP – Record Purchase Invoice screen.

Estimated Landed Cost totals pull through to the Purchase Order, based on values entered for the Template/Supplier and Stock Item. Actual Landed Costs can also be entered on the Purchase Order, and apportioned between the relevant item lines on that order. See section 1.5 POP – Enter New/Amend Order section.

Landed Costs must be ‘Confirmed’ on the Purchase Order before the items can be received into stock.

There are a number of areas that require configuring in order to use Sicon Landed costs. Those marked with * are required for the Landed Costs Templates.

 


3. Maintenance

These options allow you to maintain information used in the functionality of the Distribution module.


3.1. Supplier KPI Band Maintenance

The colour coding and criteria of the supplier KPI can be set in this screen. The number of days late that contribute to each category can be user defined.

Dis POP Management - Section 2.10 Image 1

Update KPI’s – This button pulls through all historical data, prior to the installation of the Sicon Distribution module. In order for this data to be included in the KPI’s, the Update KPI’s function must be run.


3.2. Maintain Landed Costs

With enhancements to the standard Sage functionality, you can break Landed Costs down into more detailed types and have Landed Costs posting to multiple nominal codes, to reflect the breakdown of the costs. The split of the nominal postings is covered in section 1.6 POP – Record Purchase Invoice screen.

Estimated Landed Cost totals pull through to the Purchase Order, based on values entered for the Template/Supplier and Stock Item. Actual Landed Costs can also be entered on the Purchase Order, and apportioned between the relevant item lines on that order. See section 1.5 POP – Enter New/Amend Order section.

Landed Costs must be ‘Confirmed’ on the Purchase Order before the items can be received into stock.

There are a number of areas that require configuring in order to use Sicon Landed costs. Those marked with * are required for the Landed Costs Templates.

Nominal Codes – You can configure up to 6 cost elements that make up the total Landed Cost. For each cost type, you can select a nominal code that the Landed Costs will be posted to. These will need to be set up in the Nominal Ledger.

Dis POP Management - Section 2.10 Image 2

Stock Control Settings – Within Sage Stock Control Settings, ‘Use landed costs’ must be enabled and the Landed Cost control account entered.

Dis POP Management - Section 2.10 Image 3

Maintain Landed Costs – The Nominal Codes created in 2.1 are entered in the Landed Cost Maintenance screen. This will define what codes are available for steps 2.6, 2.7 and 2.8.

Dis POP Management - Section 2.10 Image 4

Distribution Settings – The ‘Use Sicon landed costs’ setting must be enabled.*

Dis POP Management - Section 2.10 Image 5

Product Group – For Stock Items that will be using Landed Costs, their Product Group must be enabled to ‘Use Landed Costs’ within the standard Sage Stock Maintenance>Product Groups screen.

Dis POP Management - Section 2.10 Image 6

Locations – Warehouses containing Stock Items that will be using Landed Costs must be enabled to ‘Apply Landed Costs’, and the Landed Cost types made ‘Active’. These settings are found in the standard Sage Stock Maintenance>Locations screen, within the Warehouse Details tab and Distribution tab respectively.

Dis POP Management - Section 2.10 Image 7

Dis POP Management - Section 2.10 Image 8

Purchase Ledger – Suppliers to which Landed Costs will apply, require the settings within the Sicon>Distribution tab in the Supplier Details to be populated. Where ‘Percentage Based’ is being used, provisional values can be entered. These will be used to calculate the Provisional Landed Costs value in the Purchase Order.

The Update Stock Item Supplier Landed Costs button would be used to update the details of Landed Costs recorded on Stock Items, where this account has been setup as a supplier of that item, and you’ve made a change to the setting regarding Value or Percentage based.

Dis POP Management - Section 2.10 Image 9

Stock Control – The relevant Supplier Account needs to be added to the Stock Item as a Supplier, and have Landed Costs set correctly in the Supplier Details screen.

A * in the Landed Costs tab of the Stock Item Details screen, the value type must be set. * where values have been set in 2.7, these are pulled through and can be amended if required.

Dis POP Management - Section 2.10 Image 10

Dis POP Management - Section 2.10 Image 11

Templates – Landed Cost Templates can be created and added to a Purchase Order. This enables the user to add set costs from, e.g., a certain country, without the need to set the values for each Supplier. The settings above marked with a * will still need to be set.

Dis POP Management - Section 2.10 Image 12

Dis POP Management - Section 2.10 Image 13

New templates can be created in this screen, using the nominal codes set up in 2.1.

When entering a Purchase Order, the template can be selected from a dropdown list on the PO header.

Dis POP Management - Section 2.10 Image 14

Dis POP Management - Section 2.10 Image 15

N.B. When using the Landed Costs Templates, the hierarchy for which values will be used on the PO are:

  • Stock Item Supplier (set up on the Stock Item grid)
  • Stock Item (set up on the Stock Item grid)
  • Landed Cost by Commodity Code (see below)
  • Landed Cost Template value

3.3. Update Landed Costs Per Commodity

A percentage duty can be added to a list of Commodity Codes. This will be used as a default value for all Stock Items in the Commodity Code and can be applied to each code via the ‘Update’ button. Any duty set for the Supplier or Stock Item will override the default value. In order to use the default Commodity Code value, the Supplier and Stock Item duty values should be zero.

Dis POP Management - Section 2.10 Image 16

Dis POP Management - Section 2.10 Image 17

Dis POP Management - Section 2.10 Image 18

In the below example a ‘Duty’ Template has been created with a zero value. The Supplier and Stock Code do not have a Duty value.

Dis POP Management - Section 2.10 Image 19

Dis POP Management - Section 2.10 Image 20

Dis POP Management - Section 2.10 Image 21


3.4. Import Landed Costs

This function allows the user to import each of the 6 cost elements per Supplier for a Stock Item, as shown in Maintain Landed Costs.

The file needs to be in a .csv file format, with columns setup as per the column headings in the import. Click the Find icon to select the relevant csv file. The Check File button can be used to validate the file. Once the file has passed the validation step, the Import button is available for the import.

Dis POP Management - Section 2.10 Image 22


4. Reports

Consignment Transfer – Only available with Warehouse Replenishment module

Purchase Orders & Returns Linked to Sales Orders – Lists Purchase Orders and any outstanding Sales Orders linked to them

Dis POP Management - Section 3 Image 1

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

Purchase Orders Awaiting Confirmation Detail – Shows any purchase order that have yet to be confirmed.

Dis POP Management - Section 3 Image 2

Purchase Orders Awaiting Confirmation Summary – Shows purchase orders that are unconfirmed with less detail than the report above.

Dis POP Management - Section 3 Image 3

Discontinued Stock Items – Only available with SOP Management.


5. Utilities Menu

Dis POP Management - Section 5 Image 1


5.1. Settings

Dis POP Management - Section 5.1 Image 1

POP Management

  • Use confirmed option on purchase orders – This displays a check box on the Purchase Order to show it has been acknowledged by the supplier. If Supplier KPI’s are to be used, this check box must be enabled.
  • Use Sicon landed costs – This setting enables the Landed Costs functionality within Distribution.
  • Display supplier part number on POP orders – A Part ref. field is displayed in the PO Order Item Line screen, showing the Supplier stock code (as set in the Stock Item details, Supplier details screen).
  • Set purchase order line dates based on header date – Updates the PO lines based on the PO header date.
  • Enable forward order enquiry – This feature adds the Forward Orders, Quotes and Pro-Forma fields to the Stock Item Balances screen.
  • Enable supplier minimum order values – Allows a PO minimum order value to be set in the Supplier Details screen
  • Enable ‘Add Historical Lines’ button – Displays the button in the PO header screen, allowing users to add items previously purchased from the Supplier.
  • Past POP order line range in months (Historical) – Determines how many months to include when displaying POP Historical Lines.

Inspection

  • Items requiring inspection go to bin – This determines which bin items requiring inspection will go to on booking in the PO.
  • Warehouse for failed inspected items – If items fail inspection they are transferred to this Warehouse.
  • Bin for failed inspected items – Items that have failed inspection will be put on this bin, within the above Warehouse location.

Excluded Warehouses

  • Warehouses selected here will be excluded from the usage calculation in View Monthly Trading Figures screen.

5.2. Sage to Sicon SO Fulfilment

This menu option is not available with POP Management.


5.3. Import Stock Item Settings

This menu option is not available with POP Management.


5.4. Enable Module

The Enable Strings supplied by Sicon are displayed here.

Dis POP Management - Section 5.4 Image 1


6. New Features & Important Information

Distribution New Features & Important Information

Sicon Main Menu