Home » Categories » Solutions by Business Process » Stock Control and Batch Tracking |
Stock Take - Stock Control |
Article Number: 442 | Rating: 4/5 from 2 votes | Last Updated: Thu, Jun 22, 2023 at 11:16 PM
|
Datafile Software Stock Take - Stock Control The Stock Take facility allows you to record and analyse stock takes. These options would normally be used at the end of a period or year but can be run at any time. The first stage in the stocktaking process is to save the current physical stock values for later comparison. This allows you to continue your day-to-day operations on the computer whilst you are taking stock. You can choose to omit stock codes from the stock take procedures – non-stock items are omitted automatically. When you’ve taken physical stock then you must record the stock-take quantities onto the stock system.You can add to, or overwrite stock take values during this stage. If any stock items are batch/serial tracked then you are prompted to record these details as well. Next, print a report showing then stock take values compared
to the physical stock values on the computer at the time of stock take. You may now need to investigate any
discrepancies and decide by how many you are in fact going to adjust stock. Finally, record stock-take differences
through the stock-take adjustment facility. Running this option saves the present value of physical stock as a ‘compare’ quantity for later use.On selection of this option you will be asked for the type of initialisation:
This option allows entry of the counted details. The layout of the screen is as per standard transaction entry screens, although in actually no transactions are generated through this process and the stock file is updated as the entry line is input. In common with transaction entry you are prompted for the date and reference in the transaction header.If batch tracking in use, you are prompted for both the stock reference and the batch reference if configured.After entering the reference you are able to enter the counted details. Stock CodeEnter the stock code you wish to enter the counted quantity for; <F4-Select> is available if required.If you enter a code for which a quantity has already been entered you will be prompted if you wish to add to the existing quantity, if respond ‘No’ you will be prompted to replace the existing counted quantity. QuantityEnter the counted quantity. Qty-CompThis (optional) display item shows the quantity the system was recording as physically available at initialisation. Some users prefer not to see this item as it unduly influences the quantity you are entering. Stock System Profile parameters allow control over whether this quantity is displayed. Qty-DiffThis display item shows the variance between the quantity counted and the comparison physical quantity. DescriptionThis display item shows the first line of the stock description Batch DetailsFor batch/serial tracked details there are two methods of entering stock take details – if entering by stock code you are prompted for the batch record after entering the quantity as you would for normal stock transactions. If you enter a batch code that doesn’t exist you are warned but you have an <F7-Option> key available to create the batch serial record entered if that is the code required. A second method of entering stock take details for batch
tracked items is to change the primary input to be the batch code rather than
the stock record – as batch details are entered the counted quantities on the associated
stock item are incremented for you. To
switch to ‘batch entry’ mode you can press <F7-Option> on the stock code
input. The Stock Take report lists all items which have been initialised for stock take. It shows the counted and compare quantities together with the differences between them. For batch or serial tracked items the system lists the batch details following each item.The run-time parameters have the standard reporting options of selection criteria etc. but also include: Report Only Stock DiscrepanciesWhen set only those stock items where a discrepancy exists
between the counted quantity and the compare quantity are reported. The Stock Take Adjustments process generates a ‘stock take adjustment’ transaction (type 8) for the discrepancy between the counted quantity and the compare quantity. The adjustments can either be processed manually or, if set in Stock System Profiles, automatically. Again a similar style of screen to transaction entry is displayed with prompts in the ‘header’ area for Date, Reference and Adjust-Type. These are the same prompts as in the standard ‘Adjustment’ transaction entry screens. Automatic AdjustmentsSelect CriteriaIf using the automatic stock take process you will be asked to enter ‘Selection Criteria’ – typically the minimum criteria you would enter is that the stock take status is equal to ‘E’ for ‘Entered’ (the other status codes are I-Initialised and ‘ ‘ for uninitialised / complete (i.e. was never processed for stock take in the first place or the adjustment has been processed). You may also restrict further by entering additional criteria. Manual AdjustmentsIf entering the adjustments manually you enter each stock code in turn that you wish to adjust. Stock CodeSelect the stock code you wish to enter the adjustment for. <F4-Select> is available if required. QuantityThe quantity defaults to the discrepancy between the compare quantity and the entered counted quantity, confirm this quantity. DescriptionEnter a description for the stock take adjustment. Batch DetailsAs with entry of the counted quantity the batch details can be entered in two separate ways. If entering by stock code after confirming the description you are asked for batch details related to the confirmed quantity (the system defaulting to the appropriate code). Alternatively, pressing <F7-Option> on the stock code switches to ‘Batch/Serial’ mode allowing selection of the batch codes and accumulating the adjustment details for the appropriate stock code. Stock File UpdatingWhen the stock files are updated the following actions occur for each item adjusted: The physical stock level is increased by the adjustment quantity (so if the adjustment quantity is negative it is in fact reduced) The last transaction date is updated If FIFO in use then the FIFO table is updated where the quantity is increased – the cost being as per the latest FIFO receipt A stock take adjustment transaction is written to the stock transaction file The cost written to the stock adjustment transaction is the cost price on the stock record unless FIFO in use where a negative adjustment issues at the oldest cost in the FIFO table and a positive adjustment at the latest cost price When batch/serial stock items are adjusted the following actions occur: The physical stock level is increased by the adjustment quantity A stock take adjustment transaction is written to the batch transaction file
|
Attachments
There are no attachments for this article.
|
Catalogue of Stock Prices - Stock Control
Viewed 1372 times since Mon, Jun 18, 2012
Audit Pointers: Stock to Transactions & Audit Pointers: Assembly to Component - Stock Control
Viewed 1531 times since Tue, Jun 19, 2012
Merge Stock Codes Utility
Viewed 1558 times since Tue, Jun 12, 2012
Database Audit - Batch Tracking
Viewed 1453 times since Tue, Jun 19, 2012
Stock Sale Values - Stock Control
Viewed 1286 times since Tue, Jun 19, 2012
Stock Issues - Batch Tracking
Viewed 1374 times since Tue, Jun 19, 2012
Stock Mandatory - Stock Control
Viewed 1358 times since Tue, Jun 19, 2012
Record Batch Transactions on Stock Transaction File
Viewed 1391 times since Wed, Jun 13, 2012
Select Key Definition - Stock Control
Viewed 1377 times since Tue, Jun 19, 2012
Assemblies - Record Original Assembly Settings
Viewed 1483 times since Fri, Jun 8, 2012
|