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.
Installation
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.
Notes
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.
Article ID: 30
Created On: Fri, Jun 8, 2012 at 11:42 AM
Last Updated On: Thu, Jun 22, 2023 at 11:37 PM
Online URL: https://kb.datafile.co.uk/article/assemblies-decimal-precision-for-component-quantity-30.html