In BOS Enterprise, inventory is managed by creating items. Items can be created for parts, finished goods, services or outsourced supplies. Physical items that are kept in stock are marked as Inventory Items. Organisations should create items for every product they buy, manufacture or supply. For example, a motor-vehicle manufacturer may have an item for the base car, items for all the optional extras and items for all the spares.
If the option to search by code is selected, this field is mandatory, otherwise it is optional.
Unit
The Base Unit (Inventory Unit) for the item (defaults to ea for each).
Inventory
Select:
None: Item is not an inventory item. This option cannot be selected if Inventory Locations are selected on the Inventory tab.
Fixed Locations: The inventory item is kept at a fixed location. The location must be specified on the Inventory tab.
All Locations: The inventory item can be stored at any of the Inventory Locations.
Customer
Select a customer from the dropdown list of customers (used when the item is linked to a specific customer and not generally used otherwise).
Make
Only applies to Assembly and Material items. Create lookup lists to provide more information about the item (Konica Minolta).
Model
Only applies to Assembly and Material items. Create lookup lists to provide more information about the item (e.g. Bizhub C651I).
Type
Select a type of product:
Assembly: The item contains a Costing.
Material: A tangible item that can be kept in Stock.
Service: A labour item that is based on an Hourly Rate and Time.
Other: Used for items that are not one of the above. Items of this type cannot be added to Estimates.
Tracking
A dropdown list from which to select tracking options:
N/A: Not tracked.
Batches: The item is tracked in Batches from receipt to final product.
Serial No.: The item is tracked using its Serial Numbers (e.g. electronic goods).
Yield: The item is tracked by its Yield Quantity (as entered).
Yield Quantity: Enter the quantity that the item should Yield. (If Yield Quantity is selected as a tracking option, click Save (button) to make this field appear.)
Resolve
A dropdown list from which to select the action to take when the item is part of a transaction. The options are:
N/A
Receive: Items are received into stock.
Issue: Items are issued from stock.
Order: Items are ordered.
Reserve: Items that are in stock are reserved for a specific order.
You can right-click inside the block (in Edit mode) and select Load.
Images can be loaded from the local or cloud server or copied and pasted by taking a screenshot.
Images must be below 150 KB.
Once loaded, the image appears in the Image block.
Actions (button):
Check Image Size: Checks and displays the image size next to the word Image.
Resize Image: Resizes the image to be equal or below the number of kb entered in the block. This process changes the resolution of the image and cannot be undone. Images can only be downscaled, not upscaled.
When the Base Unit or Unit Conversions are changed, this warning appears: An Inventory Rebuild is required to reflect changes made to the Base Unit or Unit Conversions. On leaving the screen, a popup lets you rebuild the report.
See Inventory Reports for instructions on how to rebuild the inventory report manually.
If the X of either unit is blank or 0, the quantity is not converted (BOS uses a factor of 1).
BOS converts a quantity from one unit to another with the X of each unit: the quantity x the X of the unit it converts from ÷ the X of the unit it converts to.
For example, with the base unit ea (X = 1) and a unit box (X = 100), three boxes convert to 300 ea, and a price of 500.00 per box converts to 5.00 per ea.
BOS converts units in these places:
Stock and inventory values: Stock is kept in the base unit. Quantities and unit prices on transaction lines in another unit are converted to the base unit.
In stock on a transaction line: The quantity in stock is shown in the line's unit.
Copied lines: When a line is copied to a line with another unit, the quantity of the original line is converted to the new line's unit.
Prices: Supplier prices and purchase prices in another unit are converted to the base unit for the item's pricing and inventory price.
Batches: A batch received in one unit and issued in another (for example, received in kg and issued in m) is converted between the two units.
Stock Check: The estimated quantity is converted to the count unit.
Replenishment and Production Planning: Quantities for materials and outwork are converted to the supplier's unit and rounded up to a whole unit.
Estimates and costings: Material quantities are converted to the base unit, or to the unit of the costing.
Sales per product: Quantities are added up in the base unit.
This tab is only available if a Class and Category are created for Assets.
Depreciation can be recorded in the ledger if a Transaction Type is created for depreciation, and that Transaction Type is identified in a general setting.
A dropdown list of Assets from which to select one (e.g. Vehicles, Equipment, Machine).
Identification
Serial No.: Enter the Asset's Serial Number.
Reg No.: Enter the Asset's Registration Number (e.g. motor vehicle licence plate). This field only appears if Vehicle is selected as the Asset Type and Save (button) is clicked.
Sizes and weight
Size: Fields to enter the dimensions in mm (L x W x H).
Weight: Field to enter the Weight in kilogram.
Dates
Manufactured: A calendar to select the Manufactured Date.
Purchased: A calendar to select the Purchased Date.
Meter Data
A checkbox. If checked, Meter Data is enabled. Click Save (button) to display these additional fields:
Unit: A selection of available units to select the Meter's Unit.
View Meter Data: Opens a screen where Meter Data can be entered or viewed.
Purchase Detail
Date: A calendar to select the purchase date.
Value: Enter the purchase price or current value of the vehicle.
Depreciation (Straight Line)
Note: Straight Line means the asset is written off in Equal Instalments over its expected lifetime.
Starting Date: The date on which depreciation should start.
Starting Value: The current book value for accounting purposes (that is, the net book value as at the starting date).
Residual Value: The value of the asset after it is depreciated. For example, it is customary to retain an asset at a value of R1 on the books when it is fully depreciated so that the asset remains listed on the financial statements. In this case, the residual value is R1.
Months: The number of months over which the asset is depreciated. The number could represent the useful life of the asset, or the number of months allowed by the tax authorities.
Amount/Month: The monthly depreciation amount that is automatically calculated when Save (button) is clicked.
Creates an entry for every unit so prices can be created for all the units.
Fields Explained
Info
Fields marked in blue (✎) can be edited.
Field
Description
ID
A system-generated number for the price.
Status
The status of the entry. It defaults to Active and can be changed to Inactive.
Est
A checkbox. If checked, the price can be used in Estimating.
Unit
A dropdown list of created units to select the unit for the price.
CUR
A dropdown list with available Currencies for Cost purposes.
Barcode
Enter a Barcode.
Cost Price
Select how the Cost Price is calculated. Once selected, click Save (button) to autofill the fields where applicable. The options are:
Manual: You must manually type in and change the cost price.
Highest Costing: The highest costing price is selected.
Lowest Costing: The lowest costing price is selected.
Suppliers: All the suppliers entered under Supplier Prices are listed for you to select a specific supplier.
Costing / Estimate: All the estimates or costings in the Costing section are listed for you to select a specific Estimate or Costing.
Cost Adj %
Enter a percentage that must be added to the Cost Price selected in the Cost Price column.
Fixed Cost
Enter a Fixed Cost (e.g. a fixed despatch cost).
Unit Cost
Enter a Unit Cost.
/
Enter the number of items that are included in the cost.
Sell Price
Select how the Sell Price is calculated. Once selected, click Save (button) to autofill the fields where applicable. The options are:
Manual: You must manually enter the Sell Price and edit it when it changes.
Highest Costing: The highest cost price is selected.
Lowest Costing: The lowest cost price is selected.
Suppliers: All the suppliers under Supplier Prices are listed. You can select a specific supplier to use that supplier's price.
Costing / Estimate: All the estimates or costings in the Costing section are listed for you to select a specific Estimate or Costing to base the sell price on.
VAT Type
Select the VAT Type applicable to the Sell Price.
VAT
Select whether the price Excludes (Exc) or Includes (Inc) VAT.
Sell Adj %
Enter the percentage of the Cost Price that must be added to reach the Sell Price. See the examples below:
-100% = Selling price is zero (not calculated).
0% = The product is sold at cost.
Fixed Qty
Enter the Fixed Quantity (e.g. if the item is only sold in groups of 5).
Round
Enter an integer to which the Selling Price must be rounded (e.g. if the price is 121 and 5 is entered in the Round column, the price becomes 125 because it is rounded up to the nearest 5).
/
Enter the number of Units included in the Sell Price.
Min Qty
Enter the Minimum Quantity that can be sold in a single transaction.
GM%
Calculates the Gross Margin percentage.
Updated by
Auto-filled with the user who last updated the price.
Updated
The date on which the transaction was last updated.
Menu
Click the button or right-click a price for these options:
Specify for which Categories the Estimate can be used. This process involves including or excluding category IDs.
Status
Select a status. The options are:
Inactive
Active
Active – Don't Adjust
Budget
Budget – Don't Adjust
Qty
Enter the quantity and then select a Quantity Type from these options:
Fixed: Fixed quantity.
x: Costing is multiplied by the number of items (x) produced.
x Size: The quantity is calculated based on the size of the item.
/: The quantity included in one unit.
x Hr/s: The number of hours it will take: Est Qty x Hours.
Qty Calc
Used in General Estimate Types: Enter a stored procedure to update Estimate Quantities on the Input table (e.g. select a product (item) on the Estimate Type which adds all the materials and services which are linked to a costing. The stored procedure in the Qty Calc field will update the quantities of the materials and services based on other input valued such as depth and width.)
Adj %
An adjustment that is made to the price on a General Estimate that uses Cost Prices. The adjustment can be a markup (positive) or discount (negative).
Waste %
The percentage wasted during production.
Round
The integer to which the price must be rounded up.
Size (mm)
Fields to enter the size: Depth x Width x Height.
Weight
Enter the Weight and select the Weight Metric from a dropdown list of metrics in the next block.
Description
Select whether to include the Description in the Estimate Description. The options are:
N/A: The Description is not included in the estimate.
Description: The Description is included in the estimate description.
1 x Description: The quantity and Description are included in the estimate description.
Caption
Specify a custom header for the estimate (e.g. recipe).
Hours: The duration of the event is measured in hours.
Days: The duration of the event is measured in days.
24 Hrs: The duration of the event is measured in 24-hour days.
Resource Group
Select the resource being used (e.g. Users, Machinery).
Resource
A dropdown list of available Resources as per the selected Resource Group. A person or machine can be selected to complete the task.
From
A calendar from which to select the Start Day for the event in the first block and the time of the event in the second block.
To
A calendar from which to select the Day the event ends in the first block and the time the event ends in the second block.
Duration
Shows the Duration of the event which is automatically calculated when Save (button) is clicked. The duration can also be manually entered in which case the end (To) date and time are adjusted.
Use this tab to allocate item transactions to specific general ledger accounts (including Sales, Cost of Sales and Inventory). These settings override the Transaction settings.
Fields marked in blue (✎) are prefilled but can be edited if the costing's status is Draft or Review. (The fields are not marked in blue in BOS Enterprise.)
Field
Description
Field Chooser (*)
Add or remove columns.
Item
A system-generated number allocated to each line of the costing.
ID
The system-generated number that was allocated to the item.
Type
A code indicating the Item's Type (e.g. MAT for Material or ASM for Assembly).
Desc
A dropdown list from which to select Description options:
Blank: The Description is not included in the estimate.
Description: The Description is included in the estimate description.
1 x Description: The quantity and Description are included in the estimate description.
Variable
Whether a variable is mandatory.
Caption
Enter a custom Caption for the costing.
Status (Item)
The Status of the Item.
Status (Costing)
The Status of the Costing if the linked item is an assembly (has a costing) and a dropdown list to select a status.
Description
The item's Description.
Reference
The item's Reference.
Code
The item's Code.
Length (mm)
The item's Length in mm.
Width (mm)
The item's Width in mm.
Height (mm)
The item's Height in mm.
Size
The Item's Size and Size Metric.
Category
The Item's Category.
Subcategory
The Item's Subcategory.
In Stock
The Quantity In Stock.
On Order
The Quantity Ordered but not yet received.
Reserve
The Quantity Reserved for current orders.
Available
The Quantity Available.
Qty
The quantity included.
Qty Type
The quantity type.
W%
The percentage that is Wasted during production.
Round
The integer to which the price must be rounded up.
Total Qty
Calculates the Total Quantity included in the Estimate.
Unit
An abbreviation indicating the Unit.
Fixed Price
Displays the Fixed Price for the line item.
Unit Price
Displays the Unit Price for the line item and allows up to 4 decimal places.
Total Cost
The Total Cost of the line item.
Menu
Click the button or right-click a line item for these options:
Move Up: Moves the line one line up.
Move Down: Moves the line one line down.
Open linked Item: Opens the linked item's setup page.
View Item Summary: Opens a summary on the right showing some of the item's setup pages and transactions.
Set Costing Status to Draft: Sets the Status of the selected line item(s) to Draft.
Remove from Assemblies: Removes the selected item(s) from Assemblies that are still in a Draft status.
Add to Assemblies: Opens a popup with a list of Assemblies in Draft status. The selected assemblies are added as dependencies if the information at the bottom of the popup is provided.
Add to Assemblies (Option): Displays a list of Assemblies with Draft status, so you can add the selected items as an option. Users must also select the specific item in the Costing for which they are adding the option.
Add to Assemblies (Replace Item): Opens a list of assemblies for you to choose the Assembly and line Item to replace with the selected line item.