Zeroing Inventory

Learn how to zero out your inventory in Autodesk Prodsmart.

Vânia Lourenço avatar
Written by Vânia Lourenço
Updated yesterday

Autodesk Prodsmart gives you the possibility to import inventory movements in bulk, which allows you to zero out your inventory. You can either set to zero all your products, or just a subset.

Zeroing all inventory

To do this follow these steps by:

1. Going to the Inventory page. Click (1) ‘Excel (Whole list)’ to download the whole inventory from Prodsmart.

Note: if you use products variable parameters, click (2) 'Excel (Whole List) Parameters'.

You will get an Excel named “exportStocks” with the stock per lot on the second tab.

2. Now you should get the template to import the inventory, which is also available on the stocks page, after clicking Import (1) and Import Inventory Fix (2).

3. Now get the template by clicking on ‘Excel’ link and you will get the import template named “prodsmart-import-stock-fix".

4. Afterwards, you should copy the information that you got previously from the current inventory export (“exportStocks”) to match the columns on the inventory import (“prodsmart-import-stock-fix"). Make sure to copy the product code, lot, warehouse, and warehouse location.

Column C – Quantity should be set to zero. If applicable, you should also set the column F – Cost to zero.

5. Finally import your “prodsmart-import-stock-fix" file, check that everything is correct and confirm.

Other columns in the import:

  • Product Parameters (Column B): Variable Parameters (if they exist) for the product you are creating a movement for.

  • Date (Column D): Date of the movements that will be created, if not filled the current date will be used:

    • Depending on your User ‘locale’, creation date format varies. It is possible to verify the date format of your company in the creation page of a inventory movements.

  • Cost (Column F): Total cost for the movement or total cost for the Product / Lot / Warehouse Location after the import (according to the import type that you chose).

  • Comment (Column G): In this field you can leave a comment that will be in the inventory movement created. This way you can easily afterwards identify the imported movements in your “Inventory Movements” tab.

Zeroing inventory for a family of products or warehouse

For zeroing stocks for a family of products or a Warehouse go back to step 1. However, before extracting the ‘Excel (Whole list)’, now you must filter accordingly before extracting the excel file.

At this point just follow the same steps from 2 - 5 previously mentioned.

If you still have some doubts about the ‘Bulk Inventory Import’, feel free to reach out in our live-chat feature or directly to your CSM.

Need help? Request a Prodsmart expert to contact you here.

Did this answer your question?