Enhancement Pack Help and User Guide – Stock


Table of Contents

Product overview

This Help and User Guide includes enhancements that are specific to the Sage Stock module. It looks like any other Sage 200 module, making it easy to use for anyone already familiar with the Sage 200 environment.


What is the Sicon Enhancement Pack?

Sicon have produced a number of small utility products and enhancements for Sage 200 that we do not qualify as a full products.  These integrate with the various standard Sage 200 modules and are included in our Enhancement Pack.

The module may be configured to enable/disable utilities (functions) as required using a series of tick-box selections on the Settings screen.

To view a brief description of each function included in this module, please select a Sage module from the menu to the left.  Enhancements that integrate with several modules are listed in the Multi-Module Functions section.



1. Stock


1.1. STK001: Stock Item Maintenance Enable Country of Origin

This function allows the stock item Country of Origin to be maintained despite the Sage system not being set with a base currency of ‘Euros’.

Sicon Enhancement Pack maintain country of origin


1.2. STK002: Stock Item Customer Codes

This function allows maintenance of additional customer specific codes and descriptions against stock items.Warning – Use of Sage Sales Order/Return Line Record ‘Spare’ FieldsThis function uses the following Sage sales line ‘spare’ fields to store customer stock codes and descriptions.  This module should NOT be installed until checks have been made to ensure that these ‘spare’ fields are not used by other/third-party bespoke functions.

SpareText1 is used to store the stock item customer code
SpareText2 is used to store the stock item customer description (see configuration option below)
SpareNumber1 is used to store the customer stock code record ID

Customer codes and descriptions are also shown on the View Stock Item Details (enquiry) screen.

Customer code details are stored in a bespoke database table named SiStockItemCustomerCode.

The customer code and customer description entries can be up-to 256 characters in length.

Sales Order Processing

When adding a new item to a sales order a button is available to allow selection by customer codes.

 Sicon Enhancement Pack stock item customer codes 2

For reporting purposes, when a sales order is entered/amended, stock item related customer code and description will be automatically written to the SpareText1 and SpareText2 fields on the standard Sage database table SOPOrderReturnLine.

If a customer code or description is longer than 100 characters, it will be truncated when stored at this point.

This value is stored at the point of the sales order being saved, therefore subsequent changes to customer stock item codes/descriptions will not be applied to this sales order unless the order is edited/re-saved.

The customer code unique record ID (SiStockItemCustomerCodeID) will be stored in the sales order line SpareNumber1 field.  This may be used in reports to link to current customer code data should the truncation or code/description update restrictions above cause an issue.

Configuration Option ‘SOPCustomerCodesDontUpdateSpareText2′

(added v2011.0.7)

This configuration option was added to suppress the stock item customer description being written to the SpareText2 field on the sales order/return line record.  This may be useful if the SpareText2 field is used for other reasons.  To suppress this field being written/updated, set the option to Yes.

Import Customer Stock Codes

(added v2011.0.2)

The Sicon Enhancement Pack, Stock, Import Customer Stock Codes can be used to import both customer codes and description from a .csv file in a specified format; i.e. Sage customer code, Sage stock item code, customer stock code, customer stock description.

A sample/template .csv files is provided with the module installation components and you can download this directly from the product.

NB: please be aware that any old templates that you may still have will no longer work, they have to be generated using the Example Import File button within the Sicon Enhancement Pack product.

You will initially be prompted to select the import .csv file and all import file records will be validated with any invalid Sage customer or stock codes shown on-screen as errors.

Sicon Enhancement Pack stock item customer codes 3

If errors have been found the Show errors only tick-box is useful in filtering the list to display only invalid records.

The import will add any new customer stock codes and update customer codes for any customer and stock item combinations which already have a code setup.


1.3. STK003: Stocktake Extended to Use .csv Files

NB: it is not possible to use this function with traceable batch/serial controlled stock items.

NB 2: this feature currently takes into consideration any stock Min. Max limits set against stock records  and will not import any over / under’s ( We are looking to allow Act Qty to be higher or lower than Min. Max in a release due late 2016)

Part 1 – Stocktake Generation

Before using the extended stocktake function, a new standard stocktake should be created using the Sage Stock Control, Adjustments, Manage Stocktake screen.

Sicon Enhancement Pack Extended Stocktake

Click the New List… button to create a new stocktake list, on the following screen select a warehouse and then click Display.  Choose the items to be included in the stock take using the on screen functions/buttons.

Sicon Enhancement Pack Extended Stocktake 2

The new stocktake must be printed using either the Print List button on the Manage Stocktake screen or the Save & Print… button on the Create New Stocktake List screen.

Once generated and printed, please go to the Enhancement Pack module, sub menu Stock Control.  The new stocktake will appear when the Load Stocktakes button is clicked on the Enhancement Pack Extended Stocktake screen.

Sicon Enhancement Pack Extended Stocktake

Select the required stocktake from the list of warehouses and then click the ‘Export’ button to write the details to a .csv file (which will be editable using Microsoft Excel).

If the stocktake has not been printed the message ‘No items have been selected for the stock take, ensure that sheets have been printed’ will be displayed.

Sicon Enhancement Pack Extended Stocktake

Following the export the resulting .csv file may be edited (using Microsoft Excel or similar) to stock item update ‘Actual Quantities’ in stock.

Sicon Enhancement Pack Extended Stocktake

NB: It is essential that only the Actual Quantity column values are updated and columns or rows are not added, removed or re-sequenced.  Any such amendments could result in the failure of the import process.

Part 2 – Stocktake Import

Once all actual stock levels have been updated on the .csv file, these values may be imported back into Sage.

Select the Stock update method (see below) and then click the Select button on the Stocktake screen Import tab, then select the updated stocktake file using the file/open screen.  The screen list will import all stocktake records from the selected file.

Sicon Enhancement Pack Extended Stocktake

Click the Validate button.  The system will check that all stock items and warehouse locations still exist in the Sage database.  Once validated, text may be entered in the Narrative: field.  This text will be stored against all stock movements associated with the stock take.

When the Import button is clicked, stock movements will be automatically posted to the Sage stock system to adjust stock levels based on recorded and actual stock quantities.

Sicon Enhancement Pack Extended Stocktake

All stock adjustments will be shown on the standard View Stock Item History (enquiry) screen.

Sicon Enhancement Pack Extended Stocktake

Stock Update Methods

Option 1: Based on stock take recorded quantity (default)

When using this method stock levels will be updated based on the actual stock level on the import file and the stock level at the time that the stocktake was recorded. For example:

Stocktake recorded quantity = 12
Actual quantity counted/entered = 8
Current stock level = 11

Result = The stock level will be reduced by four items (i.e. 12 ­ 8)

Option 2: Based on current stock quantity

Stock levels will be updated based on the actual stock level on the import file and the current stock level at the time of import.  For example:

Stocktake recorded quantity = 12
Actual quantity counted/entered = 8
Current stock level = 11[/checklist]

Result = The stock level will be reduced by three items (i.e. 11 ­8)


1.4. STK004: Stock Location Wizard

This function may be used to add/remove warehouse and bin locations for single or multiple stock items. It’s a three/four-stage wizard that will lead you through this process. The menu option can be found within the Stock Control folder in the Sicon Enhancement Pack menu options.

Sicon Enhancement Pack Help and User Guide - STK004 Image1

Add Warehouses Locations to Stock Items

This option allows you to add a new warehouse location to multiple stock items. The reorder, minimum and maximum level values can be copied from any existing warehouse. You would tick the appropriate checkbox in this section, and select the relevant warehouse from the dropdown.

Once you have selected the warehouse that you wish to add to the stock items and confirmed the checkbox for reorder and stock levels, then you progress to the second stage using the Next button.

The second stage is to select the desired stock codes that you wish to add the new warehouse location to. All active stock codes are displayed and ticked by default. A separate check box at the top of the screen allows you to also include inactive stock codes in the list. When you are happy that you have selected the desired stock codes, then you click Finish.

Remove Warehouse Locations from Stock Items

This option functions in an identical manner to the previous option, apart from the specified warehouse is removed from the stock code instead of being added.

Stock codes that currently have any non-zero stock level in the selected warehouse will not be displayed, as you can’t remove the location from that item if this is the case.

Add a Single Bin Location to Stock Items

This option needs you to either select an existing bin name from the Bin location name to add or remove drop-down list, or free type a new bin name into that field.

When adding bin locations, a default allocation priority can be set for the new bin.

You can also specify to just add the bin location to a single warehouse by selecting the appropriate warehouse in the Add or remove bin locations for a single warehouse field, having ticked the box to the left of the drop-down list. If you don’t do this, then the new bin will be added for all warehouses for the selected stock items.

You can also choose to filter the stock codes to be updated via a csv or txt file, see details below.

Remove a Single Bin Location from Stock Items

This option functions in an identical manner to the previous option, apart from the specified bin is removed from the stock code instead of being added.

It is not possible to remove bin locations which currently hold a non-zero stock level. You also can’t remove the only bin for a stock item in a warehouse.

Filter Affected Stock Items Using Import File

It is possible to filter the stock items that should have the selected warehouse/bin location added (or removed) using either a .csv or .txt file.

The import file must have a single column which contains a list of valid stock items to be maintained.  All stock item codes will be validated against the Sage database before the filter is applied. When you tick the box to select this option, you will be prompted to browse to your .csv or .txt file. You then click Next to go to the next stage of the wizard which will confirm the stock items that will be selected.

Bear in mind that if you are not setting all of the expected stock items in the file, it may be because you are also filtering for a single warehouse, and some of the stock items may not exist in that warehouse. These stock codes would be ignored, so wouldn’t appear in the second step.

If you also wanted to include stock items that are currently inactive, you have the opportunity of checking the box in the second step at the top of the screen to include them.

Sicon Enhancement Pack Help and User Guide - STK004 Image2

Remove Unused (Deletable) Stock Item Bins from Warehouse

Using this option, you can tidy up the bins in your warehouse location and remove any that can be deleted. You can only do this one warehouse at a time (selecting the relevant warehouse in the drop down), and have two options available to tick.

  • Include ‘Unspecified’ bins
  • Only include bins that have never had stock

A Deletable bin is one that doesn’t currently have any stock in it. This wizard will ensure that at least one bin remains per stock item for the selected warehouse.

Add Multiple Bin Locations to All Stock Items

You can use this routine to add one or more bins to manually selected stock items, either for a single warehouse or all warehouses.

This process currently doesn’t allow for filtering of stock items using a .csv or .txt file to select the stock items. However, manual selection/de-selection of stock items may still be made using tick-boxes.

If adding multiple bins, then in the second stage of the process you can either add the name of each bin, or import the bin names. The import file can be either a .csv or a .txt file, and just needs to contain the bin names on separate rows.

If adding more than five bins, the following warning message is displayed: –

Sicon Enhancement Pack Help and User Guide - STK004 Image3

This warning message is displayed for two reasons. The first is that the time required for the process of adding bins could be a long time if you are adding multiple bins to a large amount of stock items. The second is that having a large number of bins against stock items can make some screens in Sage difficult to use. For example, having 500 bins on a stock item can make it very difficult to select the correct bin during allocations, and can make the stock balances screen difficult to use to find which bins have the stock that you are looking for.

Click the Next button to display a list of stock items that will have new bins created for them. At this point it is possible to selected/deselect the stock items.

You can also select whether you are adding the bins in all warehouse locations, or specify a single warehouse location.

The Include stock items flagged as ‘inactive’ box may be ticked if locations should be added (or removed) for inactive stock items.  This tick box is not available when stock items have been filtered using a .csv file (as described above).

You can also specify an allocation priority which will be applied to all of the bins that you are about to create.

The third stage of the wizard will display a list of all stock item/warehouse/bin locations that are about to be created. This process could take some time if you are creating a large number of bins.

Sicon Enhancement Pack Help and User Guide - STK004 Image4

When the Finish button is clicked, locations will be added to the checked/ticked stock items and a confirmation message displayed.

Add Multiple Bin Locations to A Single Stock Item

This feature works the same as the previous feature, but only for a single stock item that is specified at the start of the wizard.


1.5. STK005: Import Stock Item Supplier Buying Prices

This feature enables an import routine that allows you to import Stock Item Supplier information from a csv file. It is possible to use this routine to import new records, and to update existing ones. There is a sample csv file provided with the installation folder for the enhancement pack.

The required columns in the import file are:

  • Stock code
  • Supplier Account number
  • Buying Price
  • Supplier Part code
  • Lead Time
  • Lead Time Units (Days/Weeks/Months/Years)
  • Usual Supplier Order Quantity
  • Minimum Supplier Order Quantity
  • Pricing Source ( 0 = Last Buying Price, 1 = List Price)

The menu option to perform the import can be found in the Stock Control folder within the Sicon Enhancement Pack menu group. When opening the screen, use the Select File button to open a new window where you can browse to your csv file. Once this has been selected, the screen will refresh to the following:

STK005

If you leave the ‘Set preferred supplier by price’ ticked, then when you import the file, any records where there is more than one supplier against that stock item will be updated so that the supplier with the cheapest buying price will then become the preferred supplier. If any errors are reported, then you can filter just onto these using the Show errors only checkbox in the bottom left hand corner.The option in the bottom right hand corner allows you to select either ‘Last Buying Price’ or ‘List Price’ as a default for the rows where this has not been populated in the csv file.

Once you have resolved any reported issues, click the Import button in the bottom left hand corner to import the file.


1.6. STK006: Stock Item Update from .csv

This function may be used to update various stock item details from a .csv file in the format described below. Select the Sicon Enhancement Pack\Stock Control menu, Stock Item Update From .csv menu item to start the function.

Within the screen you can browse for a csv file to import. If you need to generate an example file to import, then the Example Import File button at the bottom can be used for this process. This requires you to have Excel installed on the computer that you are using, and will open both an example file and then another file clarifying the columns – the field types and whether the field is optional or not. Even if you are not intending to import values into some of the columns, you should leave all of the columns in your import file.

When your import file is prepared, it will need to be saved as a csv file.
Then, you can use the Find button within the Stock Item Update screen to search for that saved file. Once you have found the file, use the Check File button to validate that the file is ready for import. If any errors are reported, they will be displayed in red in the main window. If it’s not clear what the fault is with a particular line, then we would recommend editing the csv file in Notepad as that can sometimes immediately draw attention to any unexpected issues.

Once the file has passed the Check File step, then the Import button will become available in the bottom left hand corner and this button can then be used to update the specified stock items.

The ignore first row check box is ticked by default, and instructs the import to ignore the first row where the column headings are expected.

The stock item update also has check boxes available for updating open sales and purchase orders. So, for example, if you are using this routine to update a stock code to a new value, do you want the new code to be reflected on open orders. Note that this does not update completed orders.

Sicon Enhancement Pack Help and User Guide - STK006 Stock Item Update from csv (002)

Fields That Can Be Updated Using This Feature

  • Item Code
  • Item Name
  • Product Group (as long as traceable type or stock item type is the same)
  • Average Buying Price
  • Standard Cost
  • Asset of Stock Nominal Account/Cost Centre/Dept
  • Revenue Nominal Account/Cost Centre/Dept
  • Accrued Receipt Nominal Account/Cost Centre/Dept
  • Issues Nominal Account/Cost Centre/Dept
  • Search Category Names/Values
  • Spare Text Fields
  • Spare Number Fields
  • Item Status
  • Manufacturer Part Number
  • Commodity Code
  • Country of Origin
  • Weight
  • Uses Supplementary Unit
  • Supplementary Unit Ratio

1.7. STK007: Stock Item Maintain Spare Text 1 Field (see Options and Maintain Item T)

This feature enables you to add an extra field into the Amend Stock item screen that can have a drop down list maintained for it. This field is stored in the SpareText1 field in the StockItem table.

From within the Enhancement Pack Settings screen, click the Options button.
STK007 Image 1

The setting to rename the field label is called StockItemSpareLabel1

STK007 Image 2

By editing the text in the value box, you can change the label that appears on the Amend Stock Item screen.

STK007 Image 3

A drop-down list of values can also be stored to be selected against this field.

These are maintained via the menu option in the Enhancement Pack menu group, within the Stock Control folder in a screen called ‘Maintain Stock Types’.


1.8. STK008: Record Previous Year Sales Quantities Utility

This routine reads stock transaction history for each stock item, accumulates total sales order (and return) quantity and then writes these quantities to StockItem.SpareNumber1, thereafter which can be added to reports or included within custom workspaces and thereafter send to excel.

Once enabled, this feature is accessed via the enhancement Pack menu, Stock Control, record Previous Years Sales Utility.

stk008-menu-option

When Selected the screen will pre populate with the companies previous year’s start and end date; If this routine has previously been run , it will display in the ‘This routine was last run’ field.

previous-year-dates-pre-populated

Select Run, whilst preparing progress bar will display.

sicon-enhancement-pack-stk008-run

Once complete the system will confirm how many Stock records have been updated.

previous-year-dates-complete-message


1.9. STK009: Retrospective Stock Valuation by Single Warehouse

Use this feature to display, drill down on a stock valuation report for a past date and by a single warehouse.

Please note that this feature uses the SpareNumber1, SpareNumber2 and SpareNumber3 fields in the StockItem table, so do not use this feature if you are already using these fields for another purpose.

This feature was withdrawn from the module in previous versions when Sage themselves introduced a ‘Retro Stock Valuation’ but Sage’s version does not have the feature to run by single warehouse so it has been re-introduced back into Sicon’s Enhancement Pack for this reason

Select the retrospective stock valuation screen from within the Sicon Enhancement Pack Menu.

sicon-ep-menu

Select the previous period end that you wish to display, and the given warehouse and select ‘Display’.

If balances have remain unchanged from current stock Qty and you do not wish to display them select ‘Hide unchanged’.

retrospective-stock-valuation-screen

Other features within this module include:

Double click on a stock code line to bring up stock transactions.

stk009-retrospective-stock-valuation-double-click-on-line

Highlight a stock code, and select View transactions to ‘View Transactions of selected stock code.

stk009-view-transaction-screen

Highlight a stock code, and select Stock Item Details to bring up the Stock Record for the selected item.

stk009-retrospective-stock-valuation-view-item-details


1.10. STK010: New Stock Item Warehouse/Location Assignment Prompt

When a new stock item is entered, the user will be prompted to automatically assign this item to existing warehouse locations.

New Stock Item Warehouse Location Assignment Prompt (added v2011.0.21)

If selected the user is given the option to select which warehouse locations should be assigned.

New Stock Item Warehouse Location Assignment Prompt (added v2011.0.21)


1.11. STK011: Rapid Stock Level Maintenance

This function may be used to quickly update stock item / warehouse minimum, maximum and re-order levels.
Sicon Enhancement Pack rapid stock level maintenance

1.12. STK012: Hide Bins with No Stock (On View Stock Item Balances Screen)

When viewing the stock item balances screen bin locations with zero (confirmed/unconfirmed), stock will be omitted from the bin locations list at the bottom of the screen.Without function enabled …
Sicon Enhancement Pack hide bins with no stock
With function enabled …
Sicon Enhancement Pack hide bins with no stock 2

 


1.13. STK013: Generate Report Following Stock Transfer (see Options)

This function automatically generates a Stock Transfer Report document following entry of one or more Transfer Stock transactions.When the stock transfer screen is closed, this report will automatically be displayed on-screen.

Sicon Enhancement Pack stovck transfer report

Configuration Options

(see Settings, Options)

Before using this function, it is essential that a report file is set on the Sicon Enhancement Pack, Settings, Options screen.

A sample/template .csv files is provided with the module installation components and you can download this directly from the product.

NB: please be aware that any old templates that you may still have will no longer work, they have to be generated using the Example Import File button within the Sicon Enhancement Pack product.

This report file may be amended as required and manually copied to the preferred report file location within the Sage\Reports folder.  Once the file is in place, the setting below should be amended to reflect the file location and name.

Sicon Enhancement Pack stovck transfer report

If no report file is set, a message will be displayed when the stock transfer screen is first displayed.


1.14. STK014: Maintain Stock Item Barcode

This new functionality allows users to enter a barcode against each Sage stock item.

Enhancement Pack Stock Item


1.15. STK015: Stock Item Analysis Codes

Using this feature, you can assign up to 150 Analysis Codes to Stock items. These codes can be defined as being of the following types:

  • Text
  • Date
  • Drop-Down List
  • Numeric Value
  • Tick Box

Each code can be marked as being mandatory when a stock code is created or amended.

The values on the stock codes are then stored in a custom table in the database called SiconStockItemAnalysis, while the field labels are stored in SiconStockItemAnalysisSetup. The stock item values are available in the data model, so can be added to reports using the Sage report designer.

The analysis codes are set up via a menu option in the Enhancement Pack menu group, in the Stock Control folder, called Stock Item Analysis Setup.

STK015 Image 1

Put a tick in the first column for the fields that you want to use, then enter a label against them. The second tick box is to tag the fields that are mandatory, and the next field is a drop down where you can choose from the available data types. If you have selected a Drop-Down list, then click on the small box containing the three dots to open a new screen where you can edit the values for the list.

The fields that you have configured are then available on a new tab in the Create/Amend Stock Item screen called ‘Analysis Codes’.

STK015 Image 2

Any field that has been marked as being mandatory will have an asterisk next to the field label. If you attempt to save the stock item without populating this field, then a warning message will be displayed and it will need amending before the stock item can be saved.

STK015 Image 3

Once configured, the population of analysis codes can be imported.

STK015 Image 1a Menu for Import STK015 image5 Stk Analy code on stock code

Before the import can commence, within the Enhancement Pack settings on the Stock Tab, the feature ‘Stock Item Analysis Codes’ needs to be ticked

Then within the Enhancement Pack, Stock Control , ‘Stock Item Analysis Setup’ set up the Analysis Codes required, (up to 150) and specify the Label , whether  they are one of the following:

  • ‘Text’
  • ‘Date’
  • Drop-Down List (if this option applies create the list)
  • ‘Numeric Value
  • ‘Tick Box’

Once created the Import template can be populated

NO headers required for this import, headers can’t be set on the import as default as Sicon would not know how you have configured the ‘Stock Analysis Setup’ and therefore cannot provide an example.

First Column will always be the Stock code.

The following columns ( up to 150 off) will be the data you wish to populate the analysis code fields with making sure that for each one it matches the type selected.

  • Text – Text
  • Date – Column should be formatted to a date format  xx/xx/xxxx
  • Drop Down List – should be one of those listed within the configured drop down list (and spelt the same otherwise import will fail)
  • Numeric  – UP to 20

Tick Box  Enter True in Column if you want a Tick or False if no Tick


1.16. STK016: Advanced Stock Item Traceable Attributes

This feature provides the facility to import attribute values against traceable items in stock. These attributes can be added to existing traceable items already in stock, or to update them if the information in the import file is more current. The import file must have columns formatted in the following sequence:

  1. StockItemCode
  2. IdentificationNo
  3. AttributeTitle1
  4. AttributeTitle2
  5. AttributeTitle3 etc

The menu option to run the Import can be found in the Imports folder in the Enhancement Pack menu group. When you select the csv file to import, the file is checked and then any errors are displayed. For example, the attributes must exist on the relevant product groups, and the specified batch/serial numbers must already be in stock.

STK016 Image 1 STK016 Image 2

You can force the import through regardless of the errors using the tick box in the bottom right hand corner of this screen, although the rows with an error will then be ignored.


1.17. STK017: Import Stock Item Traceable Opening Balances

This feature enables you to import batch/serial numbered/Multiple batch quantities for the same stock item, warehouse/location & batch number

Unlike the standard Sage Import Batch/Serial No Opening Balances routine, you can use this routine to import additional quantities of a stock items that have had previous quantities imported.

The menu option for the import screen can be found within the Imports folder in the Sicon Enhancement Pack menu. An example .csv file is provided within the Enhancement Pack installation folder.

STK017

Any lines that have generated validation errors will be displayed in red. You can use the ‘Show errors only’ checkbox in the bottom left hand corner to only display the red lines if there are lots reported.

Any errors will prevent the Import button in the bottom left hand corner from being available, unless you check the ‘Force import ignoring all records with errors’ box.

As these are expected to be opening balances, there will be no nominal postings generated by this import unless you also check the ‘Update Nominal Ledger’ checkbox in the top left hand corner.


1.18. STK018: View Stocktakes By Stock Item

NB: this feature requires STK019 to be enabled.

This feature enables you to view the current stocktake situation for a particular code across all of the warehouses defined on that stock item.

The screen is accessed via the Stock Control folder in the Enhancement Pack menu group.

STK018

 


1.19. STK019: Stocktake Item History

When standard Sage 200 stock take function is used (StockControl->Adjustments->Manage Stocktake), with this feature enabled once you complete a stocktake the details will be stored within two tables, which can be used for reporting.  These tables are as follows:

  • SiconCountSheetItemHistory
  • SiconStockTakeItemHistory

1.20. STK020: Import/Export Re-Order & Minimum Stock Levels

This enables an import routine that will update the re-order and minimum stock levels figures for existing stock code and warehouse combinations. You can also use this routine to export the same information into an Excel file.

The screen can be found in the Import/Export folder, within the Stock Levels folder in the Enhancement Pack menu group.

STK020

You can filter the codes displayed using the Stock Item, Product Group or Warehouse filters at the top of the screen and then clicking the Filter button. The Clear Filters button then reverts you back to the complete list.

To export, select the relevant stock items using the check boxes on the left, or use the Select All or Select None buttons to update these boxes in bulk. Then click the Export button to send the selected items to an Excel spreadsheet. This file can then be easily updated in Excel, saved as a regular Excel file (csv format not required), and then reimported.

To import, click the import button and then browse to the file. A confirmation message will be displayed that the import is complete, and then the values visible in the Stock Levels screen will update to reflect these new values (which have now been applied to those stock items and warehouses).


1.21. STK021: Allow Attribute Amendment on View Batch/Serial no Details Screen

This function adds the ability to amend any attributes recorded against traceable stock items via the standard Sage View Batch/Serial no screen.

A new Attributes button is added, which then gives access to the Batch attributes screen for the highlighted batch, enabling those attributes to be updated as required.


1.22. STK022: Traceable Stocktake

This feature enables you to carry out a stocktake on traceable stock items. You still manage the stock take in the normal manner through the Manage Stocktake routine within Stock Control. Having this feature enabled simply results in stock level and nominal posting adjustments for traceable stock items, which would be left alone in standard Sage.

When entering your stocktake counts, an internal area for traceable adjustments has been added to this window. This internal area will then be used for any adjustments to the stock level, and also the nominal code on it would be used for any nominal postings. You will not be able to complete the stocktake without selecting the relevant internal area.

There is also a checkbox added to this screen called ‘Accept serial numbers where there is no variance’. This checkbox is only relevant if you have pre-filled your Actual Qty column, usually this would be done by saying Yes to this Sage prompt that appears the first time you click Enter Values for a particular stocktake.

If you have selected Yes to this, then the Actual quantity will be updated with the expected values. If you then check the ‘Accept serial numbers where there is no variance’ box, then you will not need to record any batch/serial numbers as the stocktake will use the existing ones. You can still change entries against required stock codes where there is a variance from this expected quantity.

Note that if you do not want to change anything against a code, saying No to the prompt above will leave the Actual Qty empty. If you don’t change anything against a stock item, then nothing will happen to the stock level of that item as a result of this stocktake.

With this feature enabled, you will not be able to enter the found quantity in the Actual Qty field for traceable items. Instead, you use the Enter Traceable Nos. button against the highlighted stock code to record these details. This will then display the following window:

This screenshot is for a batch numbered stock code. You can amend the details against the batch numbers before the stocktake (note that existing batches all default to zero as their found quantity), although you can use the Set Actual as Expected button to confirm that expected batches have all been found with the same quantity.

You can also use the Add and Delete buttons to modify the contents of the Unexpected batch items found window to reflect some new batches being found during the stocktake.

This is the same screenshot for a serial numbered item.

You can indicate whether the previously existing serial numbers before the stocktake have been found, although you can use the Set Actual as Expected button to confirm that expected serial numbers have all been found.

You can also use the Add and Delete buttons to modify the contents of the Unexpected serial items found window to reflect some new serial numbers being found during the stocktake.

When you complete the stocktake, you are presented with the following summary screen to confirm before the traceable adjustments occur.

When you click Proceed then the stock will be adjusted and any resulting nominal postings will occur. If there is something on this screen that you wanted to review then the View/Amend Details button takes you into the relevant Enter Batch/Serial Numbers screen; the View Balances and View History buttons will take you to the relevant Sage 200 stock screen.


1.23. STK023: Sicon Stock Transfer

This feature within EP is designed for those users whom have Sicon Enhancement Pack Only.

This feature enables you to manage transferring stock to other locations.

If you are wanting to move stock between Warehouses, then this feature greatly enhances the standard Sage Transfer Stock option, to provide a means of allocating stock, print a picking list, then despatch it (with a despatch note), move it to an In Transit warehouse before receiving it I the receiving warehouse.

Please ensure that there is an address configured on the Sage 200 Stock Warehouse, this will be printed on the picking and despatch notes  generate d

It is a shared feature with Sicon Projects, Service and Barcoding & Warehousing modules as it also appears within those products, so if you have these modules installed you would use this feature within the relevant module.

Use of this feature is via a new screen within the Stock Control menu within the Sicon Enhancement Pack menu structure.

STK023 Sicon Stock Transfer image 1

Each Stock Transfer is a separate record, with it’s own Transfer Batch No reference. A single transfer reference can contain as many different stock items as desired, but must have a single origin warehouse and a single destination. The window on the right hand side of the screen will show all of the transfer items for the selected transfer batch on the left hand side, with columns displaying the Quantity, the Allocated quantity, the Despatched Quantity and the 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 batch reference can be generated using the New Transfer button.

STK023 Sicon Stock Transfer image 2

The Stock transfer reference numbers are automatically generated, and you will receive the next one. The Description field is optional.

The options available for the Transfer destination are as follows:-

Deliver To Warehouse If you are transferring from one warehouse to another
Transfer directly into Warehouse If you are transferring from one warehouse to another and want a quicker process where despatching and receiving steps are not required
Free text

If any of the allocated stock items are traceable, and your Sage system is set to assign the batch/serial numbers on allocation, then these details will be included in the picking list.


1.24. STK024: Stock Type Conversion

This is an unsupported Sage change and should be used with caution and we strongly recommend you contact your Sage Business Partner to work with you on this if this is a feature you wish to make use of.

We strongly recommend before using this feature in live that you make a copy of your live company into a test company and test it through first before using on you live Sage 200 Company.

This feature enables you to change the traceable types against existing stock codes. So items that are not currently marked as serial or batch numbered can become so via the use of this utility. Alternatively, items that are serial or batch numbered can be altered to become non-traceable.

This feature works by updating an entire product group at the same time. So if you only want to update a few items, they would need moving into a new product group in order to do so. This new product group would need to match the traceable type that the stock items currently have – either using batch/serial numbers or not.

In order for the stock type to be changed, then there can’t be any outstanding allocations against the selected product group.

The utility can remove SOP allocations via a button in the next screen, but any other stock allocations (including stock allocated to Sicon Works Orders for example) will need to be removed manually first.

The standard Sage report of ‘Allocations Outstanding’ in Stock Control is useful for identifying these. Note that after the conversion, all allocations will need to be reapplied outside of this process – either SOP or other Stock allocations.

Use of this feature is via a new folder within the Stock Control menu within the Sicon Enhancement Pack menu structure.

There are two screens within this Stock Type Conversion folder:

Stock Check-Out: The first screen to use as it will book out all of the stock in the selected product group to enable the type to be changed. This screen will store the current costs against the stock items, in order to ensure that the new stock is booked back in at the same cost price.

Stock Check-In: The second screen to use which allows you to select what you would like the new stock type to be, and it will then convert the stock codes within that product group to be of the new stock type and then book them back into stock at the same cost price that they were booked out. Note that if you had several different cost prices against a particular item, then when checked back in that item will all be at the average cost for that item when checked out.

Stock Check Out

Sicon Enhancement Pack Help and User Guide - STK024 Stock Type Conversion 1

Select a product group using the drop down at the top of the window. Then all of the stock codes within that product group are displayed, with the current traceable type shown to the right of the drop down. Any items that have current allocations will be highlighted in red, and all SOP allocations for the items in this product group can be removed through the button near the bottom left corner. Any stock allocations will need be removed elsewhere in Sage (including Sicon works orders) before the Check Out process will complete. If you click the Check Out button while there are any allocations outstanding, then you will receive the following error message:

Sicon Enhancement Pack Help and User Guide - STK024 Stock Type Conversion 2

Once all of the allocations have been removed, the Check Out button will book all of the stock out of this product group, but the cost information will be stored. The stock is booked out as if written off, with the same nominal postings if applicable.

Stock Check In

Sicon Enhancement Pack Help and User Guide - STK024 Stock Type Conversion 3

This screen is where you specify whether the product group should be changed to be either non-traceable, Serial numbered or Batch numbered. Once you have made your selection, click the Check In button and all of the stock that was previously booked out will be added back into stock at the same cost price as was recorded at time of the Check Out routine.

If you select to check the items in as Serial numbered, then the following options are made available:

As can be seen, the items will have serial numbers auto-assigned to them, and you have the option of setting the Record Numbers on goods received flag against the stock items.

If you select to check the items in as Batch numbered, then the following options are made available:

You can specify what you would like to call the opening batch numbers that will be used against each stock item, the default is Unspecified. So all of the quantity of each stock item would be added back into stock in the same batch with a batch no of ‘Unspecified’. As with the serial numbers, you have the option of setting the Record Numbers on goods received flag against the stock items.

The checking in of the stock will be recorded in transaction history as if it were an Add Stock transaction. If stock is integrated with the nominal ledger then this will generate the same nominal postings as if it were done manually. Note that depending upon the nominal code specified against your stock write off category, this could be a different nominal code to that used as the Issues nominal code on the stock items. In which case, you may need to do a nominal journal after checking stock out and then back in again, as although the balance of your stock nominal code in your balance sheet will remain the same, the other side of the postings will be split between the nominal codes specified for your stock write off category and the issues nominal accounts on the stock items.

Once the items are checked back in with the new traceable type, you can then move them into other product groups that match the new traceable type using the standard Sage screens. Any allocations that previously existed for these items will then need to be manually redone.

Reminder: This is an unsupported Sage change and should be used with caution and we strongly recommend you contact your Sage Business Partner to work with you on this if this is a feature you wish to make use of.

We strongly recommend before using this feature in live that you make a copy of your live company into a test company and test it through first before using on you live Sage 200 Company.


2. Enhancement Pack Settings

In the current version of Enhancement Pack, the modules settings are collectively for all Sage 200 companies , so beware that if you change a setting within one company, it will apply to all installed Sage 200 Companies.

Sicon Enhancement pack settings are stored in an XML file , and this file (stored in C:\Sage\Logon\Sicon.Sage200.Addons.xml   – C if sage was on C:     Change C:\ to whichever drive or share the sage folder is)   will need to be copied over from the current LIVE sage server to the test server , in order for the EP features and settings to be the same.

To Enable / disable the features detailed in full in sections 1 – 9.20 above , simply tick the relevant feature you wish to enable in each area.

ep-settings

Against each feature, detailed within the help and user guide you will see a feature number such as COM001 – Which enables the Sales/Purchase Order Processing Trader and Stock Item Pop Up Notes , currently on the Settings page as shown above it does not list the feature code.

If however you  double click in the ‘Enabled Functions Box’ highlighted above where in screen shot it shows 41 it details functions enabled and the feature code which is handy when you are logging a support call to your Business Partner.

ep-settings-2


3. Enable Module

Following installation the enhancement will automatically be activated with a single function for a 30-day trial period.

If additional functions are required or this period expires will be necessary to fully activate the module using an enable string provided by the Sicon Customer Services team.

Summary of Sicon Enhancement Pack Enable Module

  • Start the Sage 200 application and log-in with a user whose role has access to this feature.
  • Open the Settings screen from the Sicon Enhancement Pack menu.
  • Click the Change button, which is displayed to the right of the enable string field.
  • Enter (or paste) the module enable string provided by Sicon, then click OK.
  • Click the Apply button to save and activate the enable string, the expiry date and number of licenses functions should be displayed.

Sicon Enhancement Pack Enable Module

Enable String Expiry Warning Messages

When the module enable string is close to expiry, a warning message will be displayed each time a function is used.  These warning messages may be suppressed by adjusting the ModuleEnableStringWarningDays setting in the ..\Logon\ Sicon.Sage200.Addons.xml file.


4. Release Notes

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

With the release of the Sicon v19, our version numbering has changed slightly. Previously our add-on versions were numbered in the format 201x.18.0.1.  From Sicon v19, our modules will be numbered in the format 201x.190.0.1  This is because we have three Sicon releases planned per year and we will use the second group of digits to reflect these as xx1 and xx2. We use the third set of digits to reflect whether it is a release or a pre-release build and the fourth set then give the build number.

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.

Enhancement Pack Release Notes


6. New Features & Important Information




6.3. Sicon v19.2

There are no new features in Sicon v19.2 for Enhancement Pack.