Home » Categories » Solutions by Business Process » Stock Control and Batch Tracking

Assemblies - Decimal Precision for Component Quantity

Datafile Software

Assemblies - Decimal Precision for Component Quantity

When maintaining Stock Assemblies the component quantity is recorded to either 2 decimal places or 4 decimal places depending on configuration of the system. This new feature allows you to record a ‘decimal precision’ value on the stock record which limits the component quantity that can be entered to that number of decimal places.

If the decimal precision is 0 then component quantities must be entered in whole numbers (1 / 2 / 3 etc.), if 1 then 1 decimal place is allowed (1.1, 1.2, etc.) and so on. Note that values are still recorded and printed as 2 decimal places or 4 decimal places – i.e. 1.00 or 1.0000 – this option limits what can be entered for the decimal values. Also note that if component quantity data items are 2dp then decimal precision is a maximum of 2dp, if 4dp for component data items then maximum decimal precision is 4dp.

Within Bill of Materials Works Order Entry the system will also apply the decimal precision value when adding or amending works order details.


Database Changes

A new data item is required on the Stock file to allow recording of the decimal precision value.To add this new item select Installationfrom the main menu followed by Application Manager and then Restructure A Database. Select the Stock Control application. Elect to update the Live Files and then select the Stock File. The existing data items are then displayed on screen, scroll-down to the next available blank entries and create the following items: File, Item, Name, Type, Description

 STA COMPONENT-DP N Holds the decimal precision required for the quantity when used as a component within assembly maintenance and works order entry.

To insert a new item press <Enter> against a blank entry, enter the title as required and press <Enter>, select the item type (using the drop-down list if required), and depending on item type select the size required.

Once the additional item has been recorded press the <ESC> key and select the UPDATEbutton to save the database changes.When prompted respond ‘Y’ to the prompts to ‘Extract Existing Data to New Database Structure’ and, if appropriate, ‘Copy Table Entries from Old Database to New Database. Final prompts ask to ‘Remove (.OLD) Database’ and to ‘Carry Out the Same Restructure on the BASE File as Well’ – respond as required.If you select to update the base file you need to manually insert the new items at the same data item positions as on the live file.

Application User Facilities

The Stock record maintenance screens need to be updated to allow entry of the decimal precision value. To update the screen layout(s) users can sign on as the SYSTEM user-id (or if Premier any user with Installer rights) and right-click on the Stock Records menu option, select the Configure Option action before selecting the Add New Stock Screen. Alternatively users can select the Installation option from the main menu followed by Application Manager and then Application User Facilities. Select the Stock Control application before selecting Maintain Stock and then Add New Stock Screen.

To insert the decimal precision item you’ll first need to add a text label of ‘Component Decimal Precision’ (or similar), to do this use the mouse to position the cursor where required and then type the required text. To insert the data items position the cursor where required and press the <F4-Select> key and choose the data item required. Set whether items are view-only, mandatory or require uppercase input as required.

Once complete choose File and then Save & Exit.

System Profiles

To reference the newly added data item a new parameter has been added to the Stock System Profiles.To update the profiles select Installation from the main menu and lock out the system before selecting the System Profiles option and the Stock Control application. The new parameter setting has been added to screen 3 of the parameters.

Stock Item for no-of-decimals to use in build - select the newly added data item on the stock file that identifies the decimal precision of the stock item when used as a component within assembly maintenance.


 If adding this item to an existing stock database you may want to globally update this item to contain ‘2’ or ‘4’ (depending on whether component quantities are 2dp or 4dp currently) as otherwise the stock code will be set so that components can be whole quantities only.

Custom Fields
  • Release ID: 6.5
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
System Status - Stock Control
Viewed 723 times since Tue, Jun 19, 2012
Standard Costing
Viewed 996 times since Mon, Jun 18, 2012
Average Cost Updating - Replace Cost if Stock Cost is Zero
Viewed 808 times since Fri, Jun 8, 2012
Recalculate Cost of Assemblies - Stock Control
Viewed 767 times since Mon, Jun 18, 2012
Assembly Items - Stock Control
Viewed 789 times since Tue, Jun 19, 2012
Delete a Stock Record - Stock Control
Viewed 834 times since Mon, Jun 18, 2012
Goods Returns - Update FIFO Cost Table
Viewed 1699 times since Fri, Jun 8, 2012
Set Auto Expand Data Files - Stock Control
Viewed 748 times since Tue, Jun 19, 2012
Stock Valuation and Cost Prices
Viewed 7980 times since Mon, Jun 18, 2012
Multiple Locations
Viewed 857 times since Mon, Jun 18, 2012