Assemblies - Record Original Assembly Settings

When building a stock assembly into physical stock the option exists to amend the component lines before the build is processed. New for Release 6.5 additional options have been added to the stock transaction file to allow recording of the default assembly and component quantities as recorded on the assembly files together with the original build requirements for the assembly and component files (based on the pre-amend qty of the assembly required) before amendment.

Installation

Database Changes

Four new data items are required on the Stock Transaction file to allow recording of the original assembly detail. To add this new item select Installation from 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 Transactions 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

STT DEF-ASS-QTY K, L, M Holds the default build qty for the assembly according to the assembly record at time of build.

STT DEF-COM-QTY K, L, M Holds the default issue qty for the component according to the component record at time of build.

STT ACT-ASS-QTY K, L, M Holds the build quantity entered when originally select to build the assembly

STT CALC-COMP-QTY K, L, M Holds the calculated component quantity required based on assembly set-up and build requirements before any manual amendments.

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 UPDATE button 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.

Set Database Profiles

The new data item needs to be referenced within the Database Profiles. To update these settings select Installation from the main menu followed by Application Manager and Set Database Profiles. Choose the Stock Control application as required before selecting the Retail/Other Trans parameter screen.



On the left of the screen are the prompts Default Assy-Qty,Default Comp-Qty, Actual Assy-Qty and Calc’d Comp-Qty – against these items reference the data item number of the equivalent items created above, <F4-Select> is available if required.

 Notes