/
4.0 Stock Take Report

Welcome to BigLedger Knowledge Center!

4.0 Stock Take Report

Owned by Ghada Amgad
Last updated: 2024-Nov-12
4 min read

The Report section of the Stock take Applet providesThe Report Page provides clear and complete reporting, offering management a centralized platform to review, validate and download stock take sessions.

4.1 Report Tab

Once the stock take session is completed, navigate to the Report tab and press the Generate button to create a report.

 

stock-take-13.png

Upon generating the report, the system will automatically list all the items for that specific branch by default. However, users can also generate different report types using the Advanced Search feature. The available options include:

  • Report Type: Scanned Items, Active Items, and All Items

  • Item Code

  • Item Name

The RESET button clears the filters, and the SEARCH button applies the selected filters.

stock-take-14.png

4.1.1 The Report Columns

In the Report tab, several columns help track inventory and identify discrepancies:

  • Total Quantity: Shows the total number of items scanned during the session.

  • EMP Quantity: Represents the expected quantity based on external EMP system records.

  • Variance: Displays the difference between the Total Quantity and EMP Quantity, helping identify discrepancies.

  • System Serial Number: Lists serial numbers in the system that were not scanned during the stock take, indicating potentially missed items.

  • Stock Serial Number: Shows serial numbers that were scanned but do not exist in the system, which signals an error.

  • Serial Number Variance: This is the difference between the System Serial Number and the Stock Serial Number, helping track mismatches.

  • Cost Value: Refers to the Moving Average (MA) Cost from the system.

  • Total Cost: The variance multiplied by the cost, allowing users to assess the financial impact of stock discrepancies.

 

4.1.2 Managing Variances with Reasons:

If a variance is found, users can investigate and document the cause. They can add reasons for discrepancies using the Reason column or the Upload Reason feature:

  • Direct Entry: Fill in the reason directly in the Reason column for each item with a variance.

Uploading Reasons:

  • Click the Upload Reason button, and a new window will open.

  • Choose the Report Type and Export the report.

 

In the exported Excel sheet, add reasons for the variances and save the document.

Return to the system, upload the updated file, and click Fill the reason.

The system will automatically update the Reason column based on the uploaded data.

If changes are made to the session or item records, the user must regenerate the report from the Report tab to ensure the updates are reflected.

4.1.3 To Export the Report

  • Click on the Upload Reason button, choose a Report Type, and click on the Export button.

4.1.3 To Export the Report

  • Click on the Upload Reason button, choose a Report Type, and click on the Export button.

 

The Finance team can extract the Variance Report to perform stock adjustments, if necessary, ensuring accurate inventory records and addressing any discrepancies identified during the stock take.

4.1.4 To Close the Session

  • Go to the Details tab and change the report Status to Closed, to lock the report and prevent further modifications.

4.1.4 To Close the Session

  • Go to the Details tab and change the report Status to Closed, to lock the report and prevent further modifications.

This means none of the tabs, including the Device, Records, or Report tabs, can be edited for this session.

4.2 Report Listing

The Validation of the Stock Take Session is a step for management to review stock take sessions. This can be done from the Report Listing page, which is accessed through the third icon in the side menu

Key Features

  1. Report Listing: The management can view all completed sessions in one place. Reports are organized by Location, and each location has its sessions listed under it.

  2. Session Selection: By clicking on a location, a list of all sessions conducted at that location will expand. Selecting any session will allow management to review the session details.

  3. Edit Session: Once a session is selected, the management can navigate to the Edit Session tab to review detailed information. This tab contains multiple sub tabs for further details such as devices used, records, and reports generated

Key Features

  1. Report Listing: The management can view all completed sessions in one place. Reports are organized by Location, and each location has its sessions listed under it.

  2. Session Selection: By clicking on a location, a list of all sessions conducted at that location will expand. Selecting any session will allow management to review the session details.

  3. Edit Session: Once a session is selected, the management can navigate to the Edit Session tab to review detailed information. This tab contains multiple sub tabs for further details such as devices used, records, and reports generated

 

Powered by: Bigledger Sdn Bhd