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 ...

    • 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 ...

    • POS Hold Bill Feature (Coming Soon!)

      Hold Bill Feature – Retail POS 1. Overview The Hold Bill feature allows cashier to temporarily save an ongoing transaction and resume it later. ✅ Enabled by default for Retail POS Designed to improve queue efficiency Prevents loss of sales when ...

    • Recent Articles

    • How to Cancel an E-Invoice on Dashboard

      Overview Sometimes cancelling an e-invoice is inevitable. Common situations include: Incorrect buyer information (e.g., wrong name, TIN, or address) Transaction was voided or order was cancelled after invoice issuance Duplicate e-invoice issued for ...

    • Guidelines to Set Up Promotion for Walk-in (System Default)

      Guidelines to Set Up Promotion for Walk-in (System Default) Previously, the system did not have a specific indicator for walk-in customers. As a result, all promotion rules applied equally to all customer types, including walk-in customers. However, ...

    • How to Update Client Record in Classic POS

      Overview Updating client information is an essential function in ClassicPOS, enabling users to maintain and update existing client records. This ensures that client data remains accurate and up to date for daily operations, reporting, and effective ...

    • How to Create a New Client in Classic POS

      Overview This function is created to centralize and manage client information in ClassicPOS. The Client Form allows users to create, update, and maintain customer records, supporting the management of personal information, transaction history, ...

    • POS Hold Bill Feature (Coming Soon!)

      Hold Bill Feature – Retail POS 1. Overview The Hold Bill feature allows cashier to temporarily save an ongoing transaction and resume it later. ✅ Enabled by default for Retail POS Designed to improve queue efficiency Prevents loss of sales when ...

    • 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 ...