How to perform Stock Revaluation

How to perform Stock Revaluation


Info
The Stock Revaluation function is designed to facilitate accurate inventory cost management by allowing users to recalculate and update the average cost of items in the system. This function is particularly useful when there are discrepancies due to backdated stock entries, manual cost adjustments, or bulk import corrections.
By recalculating the average cost based on the latest stock and purchase data, the Stock Revaluation tool ensures your inventory valuation remains precise and aligned with your actual cost structure—supporting better financial reporting and inventory decision-making.

Module location

  • In order to start Stock Revaluation, go to Inventory > Stock Revaluation


Module Function Explanation

    1. Use Find Item function to add item from item master list:

    1. Besides Find Item, you can direct scan Code to add item:
    1. Select the document Type (options are shared with Stock Adjustment):
    1. Update Issued Date and Time for the Stock Revaluation:

      • The stock revaluation will assign new cost as Average Cost from the Issued Date and Time of the document
      • Users can perform backdate Stock Revaluation as well. In that case, the average cost will be adjusted starting from the issued date and time.
      • In order to review the updated record, users can go to Inventory > Stock Card and search the adjusted item code:
      • From the example above, if the Stock Revaluation is completed on 03/07/2025 and updated the item's average cost to from 10.028 to 13. The average cost will be updated to transaction after the date of Stock Revaluation.
      • Take note that the Average Cost might not update instantly. It will take a while to update the average cost to the amount from the confirmed Stock Revaluation document.
    1. User can key in Reason and Remarks for the Stock Revaluation:

    1. Users can update the verification info as Verified By and Verified Date, the value will be auto filled in when document is confirmed as well:

    1. Save this stock revaluation to update status:

    1. The status of Stock Revaluation will depend on action:
      • New : New stock revaluation
      • Saved : Document is saved and still editable.
      • Completed : Document is confirmed and uneditable. After confirmed, backend will update the average cost based on the stock revaluation document.
    1. The Confirm button is used to complete the Stock Revaluation. After pressed, we will update document status to Completed and document will be uneditable.

    1. Top left there are buttons for several functions:

      • Print : User can use this button to print document. Printing can be customized under System Configuration > Printing and Format > Current Outlet > Customization on Printing Format > Stock Revaluation.
      • Settings : User can use this button to customize the listing layout of the document.

      • Functions : In this functions list, users can generate the import format to fill in item info and import back to the Stock Revaluation.



    • Related Articles

    • Enabling Staging Mode in Xilnex Classic

      Introduction The Staging Mode function provides a controlled environment for testing, configuration, and validation before applying changes to the live production system. It allows businesses to experiment with settings, workflows, and data without ...
    • How to use replenishment module

      Introduction In Xilnex, the Replenishment Module is designed to streamline and automate the stock allocation process across outlets, ensuring optimal distribution and improved operational efficiency. Key capabilities include: Location Ranking for ...
    • What is Menu Item Availability Setting?

      The Menu Item Availability function allows businesses to control when specific menu items are available for ordering. This ensures that menus remain accurate, relevant, and aligned with operational constraints such as stock, time-based offerings, or ...
    • How to Duplicate a Menu Profile?

      The Duplicate Profile function allows users to quickly create a new menu profile by copying an existing one. This is especially useful when multiple outlets or locations share similar menus but require slight adjustments (e.g., pricing, item ...
    • Setting Up Credit Card Terminal in Xilnex ClassicPOS

      Introduction This guide explains how to configure and integrate credit card terminals with the POS system. The integration ensures smooth communication between the POS and payment devices, helping businesses process transactions securely and ...
    • Recent Articles

    • How to use replenishment module

      Introduction In Xilnex, the Replenishment Module is designed to streamline and automate the stock allocation process across outlets, ensuring optimal distribution and improved operational efficiency. Key capabilities include: Location Ranking for ...
    • Staff Meal Integration

      Staff Meal Integration User Guideline Introduction Staff Meal Integration allows F&B POS to deduct staff meal credit / wallet balance directly from a third-party staff management system when staff purchase meals. This feature is currently supported ...
    • Cancel Print of Full Tax Invoice

      Overview In Classic POS, there is a feature called Print Full Tax Invoice, which allows users to generate a full tax invoice for a completed sale. The system must maintain an auditable log whenever a Full Tax Invoice is cancelled. This guideline ...
    • Xilnex API Guide for 3rd party

      1. Objective The objective of this API guide is to provide a clear reference for developers and integration partners on how to utilize the Xilnex APIs to establish communication with the Xilnex system. The guide outlines the available endpoints, ...
    • Enabling On The Move 1.0 Access Permission (OTM1.0)

      Overview This guide explains how to enable access for users who need to use On The Move 1.0 (OTM 1.0). For OTM 1.0, only one permission is required: Allow to access on the move If this permission is not enabled for the user's assigned user group, the ...
    • Popular Articles

    • Basic - How to create a voucher-coupon

      Voucher and coupon definition Voucher can be generated in bulk and can be used once Coupon can only be created one at a time (reusable code) and can be use multiple times Pre-voucher / coupon setup There are 2 things need to be prepared before we can ...
    • Understanding DuitNow QR Payment in ClassicPOS

      Introduction This document introduces the DuitNow QR payment feature available in the Xilnex Retail POS, enabling merchants to accept payments conveniently through Malaysia's national QR payment standard. The integration of DuitNowQR simplifies the ...
    • Basic - How to change custom cost to another branch that don’t have custom cost

      Change custom cost to another branch that don’t have custom cost 1. Get the item list from the location with custom cost (Item Code, Name, Custom Cost) 2. Make sure the Show Location Price are selected 3. Export the item list in Excel 4. The file ...
    • Intermediate - How to Bill & Post to Sales from Transfer Note

      1.0 Purpose A bill is required from transfer note when an inventory transfer involves financial transactions, cost allocation, or compliance with tax and accounting regulations. It is used when stock is moved between outlets that operate as separate ...
    • Basic - How to enable E-Receipt Portal and QR Code Setup on Printing format in Xilnex

      Enable E-Receipt Portal Enable the E-receipt functionality Once Enabled, you will be getting the E-Receipt portal link Continue under Theme & Styling, enabled for the E-Invoice (LHDN) You can customize the look and feel of the E-Receipt portal ...