Path : Inventory and Warehouse > Stock Take and Variance Analysis

Image : Stock Take and Variance Analysis

Purpose :

This option used to count the quantity of stocks and compare with the quantity that physically available. Then the variance if any can also be calculated.

Apart from that this option can be used to add/in Stock into the system.

A user who has the Access Level as Initiate,Analyse & Cancel in Stock Takes of System Roles.

Administration>System Security>System Roles>

Select the role of the user(A) who is going to appoint another user(B) to do the count >  Stock Takes > Initiate, Analyse & Cancel

Data Input

The user can query details pertaining to Purchase Orders giving;

• Stock take Number        
• Status
• Store
• Date
• All Locations

And press <Find Transaction> Button.

(*) To raise stock Count Transaction press <New Transaction> button and it enables the user to proceed forward to Stock Take Details dialog box.

Stock Take No :

Once Stock Take Transaction is initiated, Stock Take No is generated in a sequence.

Store :

Select the Store of which Stock to be count.

Rack : 

Select the Rack of which stock to be count.

Bin :

Select the Bin of which stock to be count.

Supplier :

If user selects the Supplier, the stock count is done for the selected item in the stocks of this supplier only.

If Suppler is not selected, the user counts the quantity of the item in stores from all the suppliers.

Note :

The user can enter an appropriate note or remark on the stock count.

Expand to view  the Data entry Team; Press the Plus mark to enter/appoint a user to do the stock count.

<Add New Member> : 

Press the button to add a new member for counting.

Team Member : 

Select a user to do the count.

Status : 

Select the Status of the User as Active/Inactive to do the count.

<Save> : Press the button to entered data of Counting member/members.

•  As discussed in the top,Purpose Once a user(B) is appointed/nominated to do the count, the data is saved.

To enter the data of counting records of the stocks, the appointed User (B) requires to log in.

E.g., User A Appoints User B for Counting.

Therefore User B requires to log in, select the product/item and enter the count figures and finally save. See below for field description;

Stock Count : 

The User B above select the item/product that he is appointed for to count.

Lot No : 

Select the lot no of count.

Bin  No : 

Select the Bin No of the Count.

Product Name : 

The selected Product is appearing the product Name here.

UOM : 

The Unit of measure is appearing here.

Quantity : 

The User enters the Physical quantity as per count.

<Save> : 

Press the button to save the entered count details.

• Once Saved, then user can generate Variance Report in PDF or Excel Format.
• Now the Count is at enter level. Another user (C) with Approval level can Approve the Count.

And finally a user (D) with Authorization level can Authorize to finalize the count.

• Please note that there shall be four users to execute the Stock Count Transaction.

1. A User(A) to Appoint/Nominate another User(B) to Count the Stock.
2. A User to Count the stock.
3. A User to Approve the count
4. A User to Authorize the count.