User Tools

Site Tools


training:usedgoods

Handling Bulk Materials in System Five

If your business purchases goods by the Ton, Tonne, Cubic Yard or Meter etc, and you sell this product by smaller units of measure, such as .1, .25, ½ of this purchased product unit of measure, then System Five has an excellent way of handling this for you.
 


 System Five Version:     6.1.x.xHandling Bulk Materials in System Five
Stocking Bulk and Selling Portions of materials.


 

 


Table of Contents

Objective of this instructional document 3

Create a list of products that will be purchased in bulk. 4

Create an inventory item for the Bulk Product 4

Using Kits to Sell Portions of Bulk Products. 5

Create the Selling Items for this product, see the examples below. 5

Create a Selling Part that is a Kit 5

Sell the Kit Item on an invoice. 7


 

Objective of this instructional document

         Create a list of products that will be purchased in bulk, and sold in portions of that bulk qty.

         Create an inventory item for each of the Bulk Products, that will be for Receiving and Stock Control only

         Create the Selling Items for the bulk product that will be sold in fractional amounts

         Edit the Selling Items and Create the Kits and Enter the Percentages of the Bulk Items.

         Check the List Pricing of the Selling Items

         Sell the items


 

Create a list of products that will be purchased in bulk

Create an inventory item for the Bulk Product

 

 

This item will be for Ordering, Receiving and Stock Control only

 

Note the Important Numbers

 

1.             The Item or Part Number is noted as BULK for clarity

2.             The Cost is Per Base Unit of Measure in this case Cubic Meters

3.             The List or RRP/MSRP is for ONE cubic meter

4.             The Units show the Unit of Measure and will optionally print on invoices and orders

5.             The High and Low is the Max to Order and Min Stock to Trigger Reorder

 

This item now created will be used for Purchase Ordering and Stocking of Bulk White Sand, and is the main focus for stock control as it will have the purchase history, and sales history both.

 

 

 

Using Kits to Sell Portions of Bulk Products

 

To better handle the selling of bulk stock, and allow higher percentage markups for smaller quantities, we recommend the following method,  using the Kits feature of System Five.

 

The first step, creating the Part Number or SKU which will be used to sell the Portion of the Bulk product.  There may be several of these different only in the part number and kit settings.

 

 

Create the Selling Items for this product, see the examples below.

To handle sales of a bulk product, we can sell a specific qty of the bulk product by attaching that quantity to another item as a kit.  The first item, WWS .25 which will sell .25 or ¼ of a cubic meter of the Bulk sand part, BWWSAD-BULK.

 

Use the Add New Part to create the Selling item.  The only information at this point is the Item Number and Description.

 

 

 

Create a Selling Part that is a Kit

 

Now click on the Kits tab and click on Change Kit Type icon to see the following setup dialog.

 

 

 

1. Select Dynamic

2. Select Type 2 Non-Exploding

3. Select OK to Exit

 

 

Now on the Kit Setup screen click on the Add New Item icon, and enter the Part to Attach, in this case the BWWSAD-BULK  part.

 

After using the Partfind selection window, and selecting the part, you will return to this screen.

 

 

1.  Enter in the Quantity of the Bulk Stock for this part, in this example 0.25

2.  Note the Cost of the whole unit and the price

3.  The Qty and the Part Number shows in the kit

 

Click back on the Inventory tab, the Cost for ¼ or .25 of one cubic meter of BWWSAD-BULK will now show as $5.75 in the Cost field, this is a calculated value based on the kit settings.

 

 

You can now set the List or RRP to be what you want to charge for ¼ of a Cubic Meter of BWWS-BULK.  As an example this item is set to a List of $14

 

 

Repeat this process for other Kit items such as .5 or ½, 1.0 or 2.0 items, remembering to create the kits and the amount of bulk product for each, and the selling price.

 

Now if we sell White Washed Sand by typing in WWS on the invoice, the selection will appear.

 

 

 

Note that there is a little group of boxes symbol in the Multi Select column, this means a kit, the Quantity column has a ? and a numeric Qty.

 

 

This numeric value shows how many of each kit are available to sell based on the number of cubic meters of bulk product in stock at the time of selection.     

 

Sell the Kit Item on an invoice.

 

Selection one on the invoice will prompt for how many to sell, usually for kits like these the default qty of 1 is correct unless you are prepackaging them into bags to sell, the it makes sense to sell 4 x .25 cubic meter bags.

 

Each time one of these items is sold, it will take the Qty Set in the kit out of stock, just as if you sold .25 of a Cubic Meter of the BWWS-BULK item , and the cost is ¼ of the cost of the Cubic Meter.

 

training/usedgoods.txt · Last modified: 2018/01/15 09:25 (6 years ago) by pwright