System Five Add-Ons & Integrations help simplify the way you do things.
Our catalog of services has topic-based, role-based, or technical plans that can help you maximize your software investment.
Copyright © 1984-present
Windward Software Systems Inc.
All Rights Reserved.
Privacy Policy
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.
This item will be for Ordering, Receiving and Stock Control only
Note the Important Numbers
The Item or Part Number is noted as BULK for clarity The Cost is Per Base Unit of Measure in this case Cubic Meters The List or RRP/MSRP is for ONE cubic meter The Units show the Unit of Measure and will optionally print on invoices and orders 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.
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.
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.
Click on the Kits tab and then click on Change KitType icon to see the following setup dialog.
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.
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 box 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.
Selection one of the kits 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, then 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.