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

Assemblies - Record Original Assembly Settings

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.



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

 These items are only recorded for assembly builds created through Stock Control and not builds from Bill of Materials or the SOP Assemblies accessory.

Custom Fields
  • Release ID: 6.5
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Location Transfer - Stock Control
Viewed 1820 times since Mon, Jun 18, 2012
Location Stock – Increased Items Allowed for Replication
Viewed 35 times since Wed, Oct 16, 2024
Reports - Batch Tracking
Viewed 1796 times since Tue, Jun 19, 2012
Units of Issue, Pack Sizes and Price Per
Viewed 2178 times since Mon, Jun 18, 2012
Assemblies - Component Stock Check Report
Viewed 1705 times since Fri, Jun 8, 2012
Entering Stock Transactions - Batch Tracking
Viewed 1757 times since Tue, Jun 19, 2012
Component Stock Check Report - Include Notes / Comments
Viewed 4404 times since Fri, Oct 26, 2012
Set Company Details - Stock Control
Viewed 1812 times since Mon, Jun 18, 2012
Build Assembly (On-Order) - Stock Control
Viewed 1598 times since Mon, Jun 18, 2012
Stock Checking Sheet - Stock Control
Viewed 2346 times since Mon, Jun 18, 2012