2004-500 – Material Stock-take Method 2

Overview:
There are 3 methods of managing stock in Opto, and prior to adopting one of these methods, the user should contact OPTO Support Desk to ensure that they are using the best method for the company environment. Opto suggests that before the stocktake is commenced that all materials for existing orders/jobs be picked &/or issued and that any available material deliveries be completed.

  • Method 1. Stock in /out – Will show material usage in reports
  • Method 2. Stock Adjustment – Will not show material usage in reports
  • Method 3. Stock-take – Which can be either a full or partial process to audit stock balance

Note: The following procedure is for Method 2 only- ‘Stock adjustment’.

To assist with the preparation and execution of the physical stock-take the following procedures have been compiled as a guide only and should be used with the company’s existing stock-take procedures. The accuracy of any stock-take is a result of good planning, coordination and discipline.

There are four steps to this process:

  • Step 1 – Prepare for stock-take.
  • Step 2 – Physical stock-take (all transactions have to be completed).
  • Step 3 – Enter the count ‘total on hand’ after stock-take.
  • Step 4 – Review Stock-take data.

Check the current on hand materials before the stock-take.
At any time, the user can view the current stock on hand by clicking on the ‘Material Stock’ icon on the INVENTORY tab on the OPTO ribbon and click on the Refresh button, to generate the data. This window will show the current stock amount of each Material group. For this procedure (stock adjustment), ignore freeze and variation columns as they do not apply to this procedure.  The green highlight rows are the ‘current on hand’ figure and the red are for any item with negative on hand figures. Note the material data can also be viewed by Asset Group, Location, Bin Location and Supplier Code.

Dbl-click on a material group to show all materials in the selected group.

Step 1 – Prepare for Stock-take
Open the INVENTORY Tab and click on ‘Material Stock’ icon to open the window and click on the Refresh button to generate the material groups data. Dbl-click on the a material group to display all the materials in the selected group.  Click on the icon (circled below), to open the ‘Save Query, enter a description for the query, and save the query by clicking on the Save button. The Stock Take tick box is option and if ticked will flag the query as Stock Take in the saved query list.

Now that the USER has saved the material query for the group, they can now print the “MATERIAL – Stock-take” sheets.

Click on the Print button and select Yes to the message.

The Run Report (OIBRW) for Table – MATERIAL window opens, if the window is blank or doesn’t display Stock Take reports required click on the Add button and scroll to the list to find the report name. Click on the Report name to highlight and give the report a name then click OK. Click on the Print button to preview the report.

Click on the Print icon.

Step 2. Physical Stock-take
Physical counting of all on-hand stock can now begin.

Step 3 – Enter the Stock-take count
The following steps are a guide to process the total stock on hand figures.

  • Open the INVENTORY Tab,
  • Click on the Utilities drop-down and select ‘Material Stock Adjust’ from the menu.
  • From the ‘Stock In or Out Type’ pop-up list, ensure to click on “2 – Stock Adjustment” to highlight and click on OK.
  • Enter the Date, Adjustment Text and then your Employee Number.
  • Click on the Import icon and click on one of the query(s) saved in Step One. The material group queries are selected one at a time.

  • Use the information recorded on the stock-take sheets to enter the stock totals only. Keep in mind the following when entering the figures recorded during the physical stock-take:
    • Enter the quantity recorded on the stock-take sheet into the “Real On Hand” column noting that OPTO will perform the correction automatically.
    • Any zero quantities recorded during the physical stock-take must have a ZERO typed into the “Real On Hand” field.  OPTO will not automatically zero stock in this window.
    • OPTO will display whether the material stock is being moved IN or OUT of stock, and by the amount of the adjustment and print if required.
  • Save the Stock-take count by clicking on the Process icon, you will get are message to confirm so click on Yes. Then another message will confirm the stock adjustment count has been updated.

Step 4 – Review Stock-take Data

The variance in the material stock, as adjusted in the Material In / Out FAST window, can be reviewed by opening either the Material Stock or Stock Transaction window in the Utilities drop-down menu of the INVENTORY Tab.

 

OPTO Software Pty Ltd
Created: 4/08/2022