+234 704 588 5541   

How to Create a Stock Count in Sage X3


  • 05 May, 2018
  • Consultingbord Administrator

How to Create a Stock Count in Sage X3

How to Create a Stock Count in Sage X3

Stock count is a process of counting inventory on a periodic basis throughout the year.

This is a two-step process as explained below-
1. A stock count session is generated to select the products and /or locations to be counted along
with other parameters and selection criteria.
2. A Count screen is used to check the count.

To generate stock count sessions
Navigate: Stock > Counts > Stock count sessions
1. Enter the site in which product is present and enter the name of the session.
2. Enter several parameters to define the stock count conditions which are- Count by product or by
location, Count mode The sorting criteria for lists, The processing type, The number of products
in each class to be counted, Sizing information of the stock count lists etc.
3. Enter selection criteria to select the products based on Product range, lot range, product category
range, buyer range, location types, location, Business partner etc.
4. Click on create button.
5. Once created, a session can be immediately created, by clicking on Generate button.
6. Or a simulation of the session can be created by clicking on Simulation button.
o The system will calculate the number of lists, respective stock lines and number of
o To match the result of this simulation, the filters can be modified in order to adjust the
products to be counted.
7. The Generation button is used to generate the stock count list(s) which are then displayed in the
grid of session tab Lists.
o Once lists are generated, the session filters will freeze, all the buttons at the bottom of
the screen become inactive except for the Delete and End buttons.
o Delete button can be used to delete all the generated lists. The selection criteria then
become active again.

To check the count of the product
Navigate: Stock > Counts > Counts
1. Select the worksheet under the left list of Stock count function and proceed the counting of the
selected stock.
2. A stock count list can have one of the following statuses,
o To be counted: The list has been generated, but is not yet counted or is only partially
o Validated or partially validated: The count of all or a part of the stock count lines have
been made and validated, the stock count variance movements have been posted
therefore the validated lines can no longer be modified, only new stock count lines can
be added to the list.
o Closed: the counting process is complete, all stock count lines have been validated, and
the [Close] button can be used to close the stock count list to prohibit the addition of any
new stock count line.
3. Enter the counted quantity for a line either in packing units or in stock units i.e. the stock on ‘Stock
STK’ field and the stock count on ‘Counted stock PAC’ fields
4. The entry of a null stock can be entered using the “zero stock” indicator for the line concerned.
5. If the product is serial numbers managed, the quantity for each stock count line is automatically
set to 1, and cannot be modified.
6. During the stock count, if a product, or a lot, sub-lot etc. is found physically in stock whilst it is
non-existent in the theoretic stock, then the count for this stock can be added using following
a) By the entry of a new line during the count entry in the detail window
b) By right-clicking on a grouping line to use the ‘Insert line(s)’ function.
c) Or also by entry of a new line directly at the level of the group screen.
7. After checking the quantity click on ‘Save’
8. Click on the ‘Validation’ button to validate the stock count
9. The stock count will be updated in the system.

The stock count lines are valued according to the rule assigned for issue valuations in the product
The variance movements for a stock count are valued according to the rule retained in the product
valuation method



Consultingbord Administrator