Home » Categories » Solutions by Business Process » Stock Control and Batch Tracking |
Merge Stock Codes Utility |
Article Number: 238 | Rating: Unrated | Last Updated: Thu, Jun 22, 2023 at 11:31 PM
|
Datafile Software Merge Stock Codes Utility Where you have multiple operators maintaining the stock system and adding new records you may end up with the same stock item having been added into Datafile under two different stock codes.This utility, new in Release 6.1, allows the system to merge the data from one stock item into another before either deleting the ‘from’ item or marking it for year-end deletion. Selecting the Merge
option asks for the Stock Codes to merge from / to. On selecting the FROM / INTO Stock items the system will display the stock maintenance screen for you to confirm you are selecting the correct items. After selection the system will perform a ‘comparison’ check between the two stock records to ensure they are compatible. Items compared are: Batch/Serial - Flag values must be identical (i.e. both blank, both B-Batch, S-Serial etc.) Batch-Format - Formats for batch codes must match Batch-Prefix - Flag for batch format to be pre-fixed with stock code must match Non-Stock Flag - Flag value must be identical Discount Group - If in use must match If values do not match then the merge is rejected, if match then you are
asked whether you wish to proceed with the merge. Stock Transactions – including the batch code if set to record on stock transactions Batch Records – including the batch code if set to prefix. System will reject merge if would end up creating two batch/serial records with same prime-index Batch Transactions – including the batch code if set to prefix Stock Assemblies – optionally including the assembly code where assembly code matches the ‘from’ item being changed and updating wouldn’t result in two assemblies with the same code. Stock Components – again including the assembly code if appropriate Sales Order Details – all records, including completed order lines, are processed. If pre-allocating batch/serial numbers then the batch code is updated where appropriate. Purchase Order Details – as above Works Order Header – again including assembly code and pre-allocated batches were appropriate. Works Order Detail – as above but also including any ‘sub-assembly’ settings. Job Costing Transaction file – updating the stock file. The merge process will update the pointer chains between the stock/stock transactions and stock/batch files were appropriate. On the stock record itself if the system will accumulate the quantity, demand, sales and cost value settings from the from-item to the to-item before zeroing the from item. If set to use the year-end delete processes then the from-item is marked for year-end delete, if year-end not configured the from-item is deleted. With regards to the Discount Matrix and Supplier Matrix the assumption is made that entries for the to-item will be kept as is and any from-item entries will be deleted. Note The process requires exclusive locks to all databases updated; the system will not proceed with the merge unless all locks can be placed. The process is a global change to all application files – it is strongly recommended that you take a full backup before proceeding with a merge. If you have your own databases containing the stock code – a ProFiler database for example – then these databases will not be updated automatically and must be changed separately via other routines (i.e. a ProFiler global update etc.) Installation The new reporting options will need to be added to the stock menu – suggest the ST.D03 or the STTAK.D03.Sign on as the CONFIG user and amend the required application menu to add the new reports with the following parameters Merge Stock Codes P-Program ST.EXE Parameter 1901 |
Attachments
There are no attachments for this article.
|
Import Batch Tracked Stock Lines
Viewed 1035 times since Fri, May 20, 2016
Batch Enquiry - Batch Tracking
Viewed 1290 times since Wed, Jun 20, 2012
Transaction Entry - Additional Options for User 1/2 Items
Viewed 1330 times since Fri, Nov 22, 2013
Forecasting and Stock Replenishment
Viewed 1505 times since Mon, Jun 18, 2012
Copy Batch Items to Stock Transactions
Viewed 1380 times since Fri, Jun 8, 2012
Document Design Manager - Batch Tracking
Viewed 1228 times since Wed, Jun 20, 2012
Purchase Orders Received - Stock Control
Viewed 1324 times since Mon, Jun 18, 2012
Stock Transaction - Select Stock by Alternate Item
Viewed 620 times since Mon, Mar 2, 2020
List of Stock Codes - Stock Control
Viewed 1294 times since Mon, Jun 18, 2012
Update Existing Stock Record - Stock Control
Viewed 1782 times since Mon, Jun 18, 2012
|