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.
|
Copy Item Facilities - Batch Tracking
Viewed 1843 times since Wed, Jun 20, 2012
Stock Issues - Batch Tracking
Viewed 1413 times since Tue, Jun 19, 2012
Maintain Matrix Templates - Batch Tracking
Viewed 1561 times since Tue, Jun 19, 2012
Stock Optional 3 - Stock Control
Viewed 1757 times since Tue, Jun 19, 2012
Stock Valuation and Cost Prices
Viewed 8764 times since Mon, Jun 18, 2012
Revise Cost / Selling Prices on Generated Stock Transactions
Viewed 1729 times since Fri, Jun 8, 2012
Batch Optional 1 - Batch Tracking
Viewed 1471 times since Wed, Jun 20, 2012
Excess Stock Report - Stock Control
Viewed 1729 times since Mon, Jun 18, 2012
List of Stock Codes - Stock Control
Viewed 1448 times since Mon, Jun 18, 2012
Database Audit - Batch Tracking
Viewed 1495 times since Tue, Jun 19, 2012
|