RKL eSolutions Blog Trends and Insights

Enhanced Stock Valuation Report in Sage X3 V12

Version 12 has several improvements like the ability for users to run as  of specific date, an inquiry so data can be exported to Excel, and a resynchronization tool to identify and correct balance issues by period. 

These improvements help with:

  • Tracking stock valuation by financial period
  • Tracking historical changes to the product-site valuation method
  • Populating new tables with existing stock values
  • Stock valuation inquiry by period
  • Identifying  potential issues and recalculate balances by period



General Parameters:
  • Accounting Interface - STO – ACC – ACCIFA = YES (FUNSTKACC)
  • Work Order Wip Account Interface - GPA – ACC – OPEIFA = YES (FUNWIPACC)
  • Subcontract - ACH – ACC – SCOIFA = YES (Sub-contract WIP posting is carried out via the Wip Account interface)

Stock Valuation Report:
  • Stock > Periodic Processing > Valuation > Stock Valuation Report
  • Specify the accounting date and select either “Primary issue method” or “Secondary issue method” as the Cost method. (Last Cost is not supported)
  • The Start date is used to find the closest Point-In-Time history record that is less than the start date. (Suggested to use the beginning of the month)
  • The End date is the “Point-In-time” or “as of” date

Sage X3 Stock Valuation Report


  • The Point-In-Time tables are used as the starting point for calculations. If monthly accounting close includes a stock to GL reconciliation, the valuation starts with balances validated by accounting.
  • The output is designed to align with information provided in the general ledger making it easier for accounting to reconcile their operational and GL balances.

**The valuation calculates by taking the Beginning balance +/- the activity +/- variance not absorbed**



Stock valuation summary



Stock Valuation by Period inquiry


Stock Valuation by Period Inquiry:
  • Stock > Inquiries > Movements > Stock Valuation by period
  • Displays summarized stock valuation by period
  • Export results to Excel

Stock valuation by period inquiry


Stock valuation period resynchronization tool:
  • Stock > Utilities > Valuation > Stock valuation period resync
  • Recalculate valuation balances
  • Any corrections will be updated on the balance table which is used for the report and inquiry.
  • Does not post anything to the general ledger

Stock valuation resync


LeeAnn Segan

Written by LeeAnn Segan

LeeAnn Segan is an ERP Support Specialist with RKL eSolutions LLP. She supports Sage 500 ERP and Sage X3. LeeAnn specializes in the financial and distribution modules. Her background includes managing distribution and warehousing for ecommerce based companies. When not working, LeeAnn enjoys working out, volunteering with groups that support special needs, and spending time at the beach with family and friends.