NOTE: The first step of the stock take is to print the Stock Take report. 


NOTE: Learn How do I print a stock take report?. This report/ sheet will be used to do the stock count. 


NOTE: It is very important to trade manually while counting the stock and performing a stock take in Back-office. This will prevent confusion when stock is sold while counting and entering the stock take figures. 


If you have access to the Stock Take module in Back-office, you will be able to complete the stock take. 


Once the stock count has been completed, the sheet should look something like the image below:

1. As a safety measure, create / make a backup of the Advantage database you are going to complete the stock take on.

2. In Advantage Back-office, click the left sidebar menu.

3. Click on the Products menu. 

4. Open the Stock Take module.  

5. Go to the "Create a Stock Take" tab.

6. Create a stock take using the exact same Product Filters that was applied when report 210 - Stock Take was printed: 

This will ensure that the same products that are on the Stock take sheet, are affected with the Stock Take. 

7. Change the Stock Take Description.

8. Click on the "Create new Stock Take" button. 

9. A system message will appear: Stock Take was created successfully.

10. Click on "OK"

11. Click on the filter button in the navigation bar:

12. Select the Stock Take you would like to reconcile.

13. Go to the "Reconcile a Stock Take" tab. 

14. If required, you can apply product filters to the list.

NOTE: When filters are applied in the "Reconcile a Stock Take" screen, they should only be used to search for products. DO NOT CLICK ON THE "Post Stock Adjustments" BUTTON BEFORE REMOVING ALL FILTERS FROM THIS SCREEN.     


15. Click on the Fetch button. 


16. VERY IMPORTANT: The following 3 consecutive steps, must be performed TWICE:
- Click on the "Set Count - On Hand" button.
- A system message will appear: Confirm to Set Count as On-Hand (Will assign Count = On Hand for all items with no count)
- Click on "Yes"
- A system message will appear: Set Count from Variance was successful.
- Click on "OK"



NOTE: VERY IMPORTANT, ONLY CONTINUE IF THE VARIANCE TOTAL EQUALS/ IS 0.00 :


17. Enter the final quantities you have counted (the quantity you physically have in your store/ storeroom/ warehouse) in the "Count1" column. 

NOTE: After the stock take has been saved, the system will display the quantities entered into the "Count1" column, as the new quantity on hand. 

For example: While performing the stock count, you saw that you have 18 of 155/65R14 75T EcoContact 6 products physically in your store. While entering the stock in the Stock Take module in Back-office, search for product 155/65R14 75T EcoContact 6 in the list, and change the quantity in the "Count1" column to 18. 


NOTE: To save your progress, without posting the Stock Take, click on the save button in the navigation bar:

18. Once the correct quantity for each product has been entered, ensure that any "Filter Products" is removed, i.e. ensure that no filters are applied. 

19. Select the month and year from the Accounting Period drop down date pickers. (This will post the reconciled Stock Take to the appropriate accounting period which must be the current month the counting takes place)

20. Check the Variance total:

  • If there is a negative variance, the excess stock will be issued as wastage: 
  • If there is a positive variance, stock will be added to your stock on hand: 

21. Click on the green "Post Stock Adjustments" button:

22. NOTE: A system message will appear: Stock Take variance Adjustments will now be posted to Stock Adjustments, Inventory, and Cost-of-Sales General Ledger account(s) in the Accounting Period ___ from Stock Take procedure ___ dated ___ dated ___ Do you wish to continue?


23. Click on "Yes"

24. A system message will appear: Post Stock Adjustments was successful.

25. Click on "OK"

NOTE: The "Post Stock Adjustments" button should now have changed to a red color: 
Once a Stock Take has been completed and has been posted, you will not be able to post it again. You can now delete the Stock Take.


NOTE: Learn How do I delete a stock take?