Univiz - Sitemap
Univiz.net - Supporting Businesses since 1984 Sage 50 Training & Consultancy - Your Premises, Your Data, Addressing Your Issues Business and Marketing Resources at Univiz Ltd Login to the Univiz Online Accounting
A range of over 20 indispensible 'must have' Sage 50 Addon programs
Online Accounting - DIY or WDIFY (We Do It For You)
Univiz Online Accounting - More Invoice
Payroll Bureau - Fast, Flexible, Efficient and Cost Effective
Univiz Ltd - Tel: 0871 218 0494
Struggling with your accounts? Outsource to Univiz and let us take the strain
Univiz - telephone 0871 218 0494 / 07870 661405
Home > Sage Add-ons > Sage 50 Stock Split Addon Program

Sage 50 / Sage Line 50 Stock Split Addon (£69+VAT)

Like a BOM in reverse. It allows you to transfer stock from one stock code and create multiple new items under another stock code.

Sage Line 50 Stock Split Addon Program - Main Window

A typical example would be a wine merchant who has one stock code for a case of a particular wine and another that represents a single bottle. When a case is taken from the cellar and the bottles are put out on the shelves, this program will take one case out of stock in Sage Line 50 and adjust in the appropriate number of bottles.

The same principle applies to any products purchased in outers of 12, 24 etc e.g. groceries, ice cream and confectionery or in bulk and repackaged in smaller quantities e.g. coffee, tea, ironmongery, nails, screws etc.

  • Use the bulk / outer product code for ordering from your supplier/s which solves the problem of your supplier/s sending 25 x 25kgs, when all you wanted was 1 x 25kgs etc.
  • Use the individual (split) product code for selling to your customers

Feature Summary:

  • The split quantity and product code are held in the Line 50 product file.
  • A search facility will locate splittable products by code or a word within the product description.
  • The program will create the correct transactions in the Line 50 product history.
  • A list shows the products that you have already split in the current session.
  • Auto Split option will automatically split enough stock to clear negative stock levels - NEW
  • The program can be run from a button in the Line 50 product module (Financial Controller only).
  • Compatible with Sage 50 Accounts Professional / Sage Line 50 Financial Controller versions 8 to 16 (2010).
  • Only £69.00 + VAT for a company wide licence.
  • Thirty day Free Trial available

Works with:

  • Sage Line 50 Financial Controller | Sage 50 Accounts Professional
  • Sage Client Manager
Sage 50 / Sage Line 50 Stock Split Addon - free 30 day Trial
£69.00
(£79.35 inc VAT)
Download a free 30 days trial of the Line 50 Stock Split Program
Email a friend about this Sage 50 addon
Sage 50 / Sage Line 50 Addons FAQ's
Ref: S50-004

Sage 50 Accounts / Sage Line 50 Stock Split Addon - Products Toolbar

You can run the program from either the:

  • Stock Split button on the Sage 50 / Sage Line 50 Product module tool bar (as shown Above)
  • Or, from the Windows Start Button > Programs Menu

Stock Split
Program Options

Sage Line 50 Stock Split Addon - Options

Stock Split Info Field

Select which of the three custom fields you are using by clicking the down arrow next to the "Stock Split Info Field" box.

Renaming Sage Line 50 Product Custom Fields in Settings > Configuration

  • The Line 50 Product File has three custom fields that can be found on the "Web" tab of the Product Record.
  • Decide which one of the three you want to use and change it's title to "Split Info" by selecting the Line 50 menu option "Settings" and then "Configuration".
  • You will find the custom field labels on the "Products" tab.

Enter Split Information for each Splittable Product.

Sage Line 50 Stock Split Addon - Entering Split information for products

  • For each product that can be split enter the quantity and code of the product that will be created by the split into the product record's custom field set up previously
    • Enter the quantity first followed by an X and then the product code.
    • For example the entry above means that if this product is split the program will create 48 of Part B000
    • N.B. the X can be either upper or lower case and the spaces around it are optional
  • Note: if your outer / bulk product is split into various selling quantities e.g. cans of beer / lager purchased in outers of 24 but sold in 4-packs and individually:
    • First, split the 24 outer into 6 x (code for the 4-pack)
    • and then split the (code for the 4-pack) into 4 x (code for the individual product).

Cache Product List

  • If the "Cache Product List" box is ticked the program will keep it's own list of splittable products to allow for a quick startup. You will need to select the "Refresh" menu option whenever a change is made to the "Split Info" in the Line 50 product file.
  • If this option is not ticked the program will search the Line 50 product file for splittable products each time it is started up.

Search Descriptions

  • If the "Search Descriptions" box is ticked you will be able to search for splittable product by entering a word from the product description.
  • Unticking the box will turn this feature off.

Min Search Length

The "Min Search Length" is the number of characters that have to be entered before the search facility is activated. If you have a large number of products you may need to increase this to 4 or more.

Calculate New CP

If the "Calculate New CP" box is ticked the program will recalculate the Cost Price of the split product from the Last Cost Price of the splittable product.

Stock Split - Main Program Screen

Sage Line 50 Stock Split Addon Program - Main Window

The window can be resized by dragging the corners or edges. The status bar at the bottom of the window will display a progress bar when the program is busy. When the program is idle, the number of splittable products are displayed.

Split Box

  • Enter the code of the product to be split in this box.
  • Alternatively you can enter a word from the product's description and a list of matches will be displayed (Unless this feature has been turned off in the program's Options)
  • Click on an entry in the list to select it. If only one match is found the product will be automatically selected.

Split Qty Box

  • Enter the quantity of product that you want to split.
  • You can also change the quantity by clicking on the up and down arrows or by pressing the up and down keys.

Result Box

Displays the code and description of the product that will be created by the split.

Result Qty Box

Displays the quantity of product that will be created by the split.

Split Button

Click this button to carry out the split.

Menu Button

Click this button to show the program's menu (see discussion below)

The History List

Each time a split is carried out the program will enter the split details at the top of the list. If necessary you can scroll the list up and down with the scroll bar that will appear at the right hand side.

The columns in the history list are:

Qty The quantity that was split.
From Product The product that was split
Qty The quantity that was created by the split.
To Product The product that was created by the split.

Program Menu

To show the program's menu click the Menu Button or right click any grey part of the program's main window.

  • Refresh
  • Options
  • Datat Path
  • user Name
  • Licence
  • About
  • Help

Sage Line 50 Stock Split Addon - Menu

Refresh

  • Select this option to refresh the list of splittable products held in the programs cache.
  • This menu option will only be displayed if the "Cache Product List" option has been selected on the Options dialog.

Options - Select this option to display the Options dialog. (See Program Options above)

Data Path - Displays the Data Path dialog (to your Sage Data - See Installation)

User Name - Displays the User Name and Password dialog (for your Sage Data)

Licence - Displays the Licence dialog (See Installation).

About - Displays information about the program.

Help

  • displays help documentation.
  • The documentation viewer window may be resized by dragging it's edges or corners with the mouse

(Video Tutorials - coming soon!)

Sage 50 Stock Split Addon - Version Numbers and Change Log

v15.0.10 Small Stacked Toolbar icon
v15.0.10 Web Updates
v15.0.11 Auto Split option will automatically split enough stock to clear negative stock levels.
v16.0.12 Common Library
v16.0.12 Sage 50 v16 2010 Compatibility
v16.0.13 Move Options file to sub folder of ACCDATA
v16.0.14 Ask before running Auto Split
v16.0.14 Hide Auto Split menu option if Allow Negative Stock is turned off
v16.0.14 Refresh if read from cache fails

Simple and Straightforward

Installation of the Stock Split for Sage Line 50 / Sage 50 is simple and straightforward and should take no more than a few minutes. Comprehensive step-by-step instructions are provided.

Prior to installation you will need to:

  • Ensure that you have installed all the appropriate patches and updates from the Sage update site for your version of Sage (comprehensive notes are provided with the download)
  • Obtain from Sage a Serial and Activation key to enable '3rd Party Integration'.
    Notes and telephone numbers are provided with the download but Sage will want to know the main serial number for your copy of Sage and the version number - found by going to Sage 50,'s HELP / ABOUT menu option.
    N.B. The same 3rd Party Integration keys can be used for all addons that require them

  • A fully functional 30 day free trial of Sage 50 Stock Split is available.
  • The trial can be unlocked by purchasing a full licence - you will not loose any settings
  • Still got questions? Checkout the FAQ section
Ref: S50-004

Sage 50 Stock Split Addon Program

£69.00
(£79.35 inc VAT)
Download a free 30 days trial of the Line 50 Stock Split Program
Email a friend about this Sage 50 addon Sage 50 / Sage Line 50 Addons FAQ's

Home > Sage Add ons > Sage 50 Accounts / Sage Line 50 Stock Split Addon Software


Your Shopping Cart
View Cart | Checkout
Subscribe to the Univiz Newsletter
First Name *
Last Name *
Company
Email *
Follow Univiz on ...
Follow Univiz on Twitter Subscribe to the Univiz RSS News Feed Follow Univiz on Facebook Follow Univiz on MySpace Add Univiz to you Google Page

Quick Links to other Sage Add-ons ..

Sage 50 Addons Summary
Sage 50 Addons FAQ's
Sage 50 Addons Resellers

Addons that View Data ..

Sage 50 Company Viewer Lite
Sage 50 Product Viewer Mid
Sage 50 Order Viewer Pro

Addons that Manipulate Data ..

Sage 50 Back to Back Ordering
Sage 50 Credit Note Creator
Sage 50 Document Explosion
Sage 50 Multi Location Stock Tools
Sage 50 Payment Allocations
Sage 50 Product & Account Code Changer
Sage 50 Product Duplicator
Sage 50 Product Memos Backup Program
Sage 50 Sales Price Updater
Sage 50 Stock Adjustments In
Sage 50 Stock Split Program
Sage 50 Stock Transaction Editor
Sage 50 Subscriptions

Addons that Import Data ...

Sage 50 Address CSV Import
Sage 50 Customer CSV Import
Sage 50 Fixed Assets CSV Import
Sage 50 Invoice CSV Import
Sage 50 Price Lists CSV Import
Sage 50 Product CSV Import
Sage 50 Project Charge CSV Import
Sage 50 Purchase Order CSV Import
Sage 50 Sales Order CSV Import
Sage 50 Transaction CSV Import

Addons that also work with ..
Sage Instant* &/or Sage Instant Plus*

Sage 50 Company Viewer Lite
Sage 50 Customer CSV Importer
Sage 50 Product & Account Code Changer
Sage 50 Product CSV Import
Sage 50 Product Viewer Mid
Sage 50 Order Viewer Pro

 

Unlimited Remote Backup for 4.95 The Way Mozy Should Be

Panda Security 2010

 

home | training and consultancy | online accounting | payroll bureau | Sage add-ons | Xtra | about us | contact us | site map
privacy policy | terms & conditions | terms of use | disclaimer

Univiz Ltd, Blackpool, Fylde Coast, Lancashire
tel: 0871 218 0494 - fax: 0871 218 0495 - Email

Reg in England & Wales: 6633575 - VAT Registration: GB 937 6438 85 - Copyright © Univiz 2001 - 2009