How to Perform Inventory Multi-Counting in Sage X3

Inventory multi-counting reduces the risk of errors during the stock count process. Allowing users to count the same stock multiple times and track each stock count ensures any variances are identified and guarantees the accuracy of the complete count. The multi-count process is exactly the same as the original single count process except that you have the option to enter multiple individual counts for the same stock. In this blog we will review the steps involved to create multi-stock counts in Sage X3.

STEPS TO CREATE MULTI-STOCK COUNT

1. Navigate: All > Stock > Counts > Stock count session
2. Go to Stock count session
3. Click on New
4. Enter Stock site
5. Enter mandatory fields
6. Select the Multiple counts checkbox at the bottom of the page

7. In the Selections tab, select the Category to be counted
8. Create Stock count session
9. Now generate lists by clicking on the Generation button
10. Check the generated lists from the Lists tab

11. The next step is to enter our count. Use the Actions button, the list grid line, or navigate to the Stock count screen and select a list to count
12. On the Stock count screen, you can see that new column fields have been added to the header to keep track of multiple counts
13. On the lines grid, a new column labelled with an asterisk (*) is added when you are doing multiple counts

• When the value of column * is +, that means there is multi-counting to do
• When the value of column * changes to +1, that means the count is being counted by first count manager
• If the value of column * is changed to *1, that means the count is counted by first count manager
• When the value of column * changes to +2, that means the count is being counted by second count manager
• And if the value of column * is changed to *2, that means the count is completed by both the count managers
• When the multiple count is over, this column is cleared

14. You can delete the lines you don’t want to count by using the Actions button and selecting Product deletion
15. To begin your count, the first thing you need to do is assign the count manager. Enter the name of Count manager 1 and then enter that count managers stock count in the Counted stock STK 1 column

16. Click Save
17. Follow the same process for Count 2

18. If there is a discrepancy between the two counts, a third Count manager can be added to enter the final count

19. Note you can make modifications to the final count until it has been validated. Once validated, no changes can be made to the count
20. To complete the process, do your Validation
21. Now you can Close the count to restrict further processing

Once the counting process is complete, you can print the final count report. In V11, Sage added a new report specifically for printing multi-counts.

1. Select INVBORA

2. Go to Stock line selection

3. You will find different options here to print the report:

• All – allows you to print all lines
• Counted – only print the lines counted in the final count
• To be counted – print the lines to be counted
• Counted with variances – only prints the lines where a variance exists between the counts
• Counted 1 – prints count 1
• Counted 2 – prints count 2

4. For now, Select the All option
5. Click Print

6. Finally we can see the adjusted stock count in stock movement inquiry screen
7. Navigate: Stock > inquiries > stock transaction by date
8. Here you will see the stock changes for increased/decreased stock.

For more information on inventory multi-counting in Sage X3, please contact us.