# How to Run a Physical Inventory Count in Sage X3 > Source: https://netray.co/erp-help/sagex3-how-to-run-physical-inventory-count > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: ERP Help ## Short answer Sage X3 physical counts run through Stock > Counts: create a count session scoped to a site, category, or zone, generate the count sheet to freeze theoretical quantities, enter counted quantities, review the variance report, then validate to post stock and valuation adjustments. Blocking movements against the counted locations during the window keeps the variance meaningful. ## Kind how-to ## System small-erp ## Erp Sage X3 (Sage Enterprise Management) ## Module Inventory / Stock Count ## Query How to run a physical inventory count in Sage X3 ## Alternate Queries - Sage X3 stock count process - Sage X3 count sheet entry - Sage X3 inventory count variance - Sage X3 cycle count vs full count ## Applies To Sage X3 v12 and later ## Steps ### Perform a physical inventory count in Sage X3 **Items:** - Go to Stock > Counts > Count sessions and create a new session scoped to a site, product category, or storage zone. - Choose the count type: full count, cycle count, or count by specific location range. - Generate the count sheet through Count > Count sheet edition to freeze theoretical quantities at that moment. - Distribute count sheets to warehouse staff, or use the mobile Sage X3 stock count entry if licensed. - Enter counted quantities under Count > Count entry, one line per location, lot, or serial as applicable. - Review the variance report comparing counted quantity against theoretical quantity before validating anything. - Investigate any line with a large variance (wrong location, missed lot, uncounted bin) before posting. - Validate the count to post stock adjustment movements, which also feed the stock valuation journal. - Reconcile the posted adjustments against the general ledger stock accounts at period close. ## Sections ### Choosing full count vs cycle count **Body:** A full count freezes and recounts an entire site, which is thorough but disruptive, so most operations reserve it for year-end or annual audit requirements. Cycle counts scope a session to a category, ABC class, or a subset of locations on a rolling schedule, which spreads the counting workload across the year and keeps accuracy high on fast-moving or high-value items without shutting down the whole warehouse. The count session parameters decide this scope up front, and mixing scopes carelessly, such as running overlapping cycle counts on the same zone from two different sessions, is a common source of confusing double-counted variance later. ### Why freezing quantities and timing matters **Body:** Generating the count sheet is the moment Sage X3 records the theoretical quantity that counted figures will be compared against. Any receipt, issue, or transfer that touches a frozen location after the sheet is generated but before the count is entered will distort the variance, showing a mismatch that has nothing to do with an actual counting error. For this reason, most sites block transactional movement against the locations in scope for the duration of the count window, or at minimum require staff to log any exception movement so it can be reconciled manually before validation. ### Handling lot, serial, and multi-location discrepancies **Body:** Lot- and serial-tracked items add a layer of precision to the count: a quantity match at the item level can still hide a lot-level mismatch if the wrong lot was recorded against a location. Count entry screens support entering by lot or serial directly, and the variance report should be reviewed at that granularity, not just the item total, before trusting the numbers. ### Variance posting and GL impact **Body:** Validating the count posts stock adjustment movements that update on-hand quantity and, depending on the site's valuation method, the stock valuation journal used by accounting. Large unexplained variances that get validated without review flow straight into that journal, which is why reviewing the variance report before validation, not after, is the step operations teams most often skip under time pressure. ## Pitfalls - Not blocking transactions against counted locations during the count window, letting real movement distort the frozen theoretical quantity. - Counting by product category while missing items that recently changed category and fall outside the session scope. - Skipping zero-quantity theoretical locations that may actually contain miscounted or misplaced stock. - Entering serial-tracked items without exact serial matches, which creates phantom adjustments that look like real variance. - Validating a count session before reviewing the variance report, which locks in any counting or timing errors permanently. - Running overlapping cycle count sessions on the same zone, producing conflicting frozen quantities and confusing variance. ## Ai Angle ERPray for Sage X3, grounded on the site's stock and count tables, can answer questions like 'which locations in this session have a variance over a given threshold' or 'what movements hit this location after the count sheet was frozen' directly from the data, which normally means cross-referencing the count entry screen against the stock journal by hand. Validating the count and posting adjustments remains a deliberate step taken by the person responsible for the count, since it changes on-hand quantity and the GL. ## Faq ### Can I do a cycle count without freezing the whole site? **Answer:** Yes, scope the count session narrowly to a category, ABC class, or a specific set of locations. Only the locations included in that session get their theoretical quantity frozen when the count sheet is generated. ### What happens to the variance in the general ledger? **Answer:** Validating the count posts stock adjustment movements that flow into the stock valuation journal based on the site's configured valuation method, updating both on-hand quantity and the corresponding GL stock and variance accounts. ### Can count sheets be exported to Excel and re-imported? **Answer:** Yes, standard import and export templates exist for count entry, which is common when large teams count on paper or in a spreadsheet and then bulk-load the results rather than typing each line directly into the entry screen. ### How do I count lot- or serial-tracked items accurately? **Answer:** Enter counted quantities at the lot or serial level in Count entry rather than just the item total, and review the variance report at that same granularity, since an item-level match can still hide a lot-level mismatch underneath it. ## Search terms sage x3 physical inventory count, sage x3 stock count, sage x3 count session, sage x3 cycle count, sage x3 count sheet, sage x3 inventory variance, sage x3 stock adjustment posting, sage x3 lot serial count --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json