Home » Categories » Solutions by Business Process » Stock Control and Batch Tracking |
Assemblies - Record Original Assembly Settings |
Article Number: 32 | Rating: Unrated | Last Updated: Thu, Jun 22, 2023 at 11:36 PM
|
Datafile Software 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. Notes These items are only recorded for assembly builds created through Stock Control and not builds from Bill of Materials or the SOP Assemblies accessory. |
Attachments
![]() There are no attachments for this article.
|
Batch Code Enquiry - Batch Tracking
Viewed 1676 times since Tue, Jun 19, 2012
Transaction Control Numbers - Stock Control
Viewed 1535 times since Tue, Jun 19, 2012
Batch Optional 2 - Batch Tracking
Viewed 1372 times since Wed, Jun 20, 2012
Trans Mandatory - Batch Tracking
Viewed 1500 times since Wed, Jun 20, 2012
View a Stock Record - Stock Control
Viewed 1478 times since Mon, Jun 18, 2012
Print / Value Assemblies - Stock Control
Viewed 1427 times since Mon, Jun 18, 2012
Document Design Manager - Save and Exit - Stock Control
Viewed 1430 times since Tue, Jun 19, 2012
System Status - Batch Tracking
Viewed 1504 times since Tue, Jun 19, 2012
Assemblies - Bulk Stock Items
Viewed 1729 times since Fri, Jun 8, 2012
Flag Component Records to Omit Cost Price
Viewed 1620 times since Tue, Jun 12, 2012
|