Enterprise users utilizing the Stock module are able to run a Stock Inventory Report, which displays columns of information about your inventory in Stock. One of the columns displayed in this report is the "Cost" column. When running this report, you may notice that the cost of some items in the "Cost" column are showing a value of $0. This can happen when adding an item to Stock and:
the item is in your company database, but does not have a cost in your company database, or
the item is not in your company database and is not connected to dealer pricing.
1. When an item is in your company database, but does not have a cost.
For an example, here is a Stock Inventory Report showing an item that is in the company database, but does not have a cost in the company database:
To have the cost of this item populate in the "Cost" column of the report, you can follow this quick process:
Go to Vendors>All Products>"Company Name"
Type in or copy/paste the Model name of the item in the search bar and click Search
The item will appear, and click anywhere on the item
Click Edit
Enter the cost of the item in the "Cost" field and click Save
Now, when you run the Stock Inventory Report, the item will appear with the cost you inputted for this item:
(NOTE: Alternatively, when you want the cost to populate in the "Cost" column of the Stock Inventory Report for an item that is in the company database, but does not have a cost in the company database, you can use the Push/Pull function on the item if you are currently using the item in a Project.)
2. When an item is not in your company database and is not connected to dealer pricing.
For this situation, you can do one of two things:
You can upload a price sheet that contains the exact item on it, which will connect your pricing, thereby updating the cost for that item, or
You can follow steps that are almost identical to the steps outlined in the first part of this article (with a minor variation in the first step - see below)
Because uploading and being connected to a price sheet is not immediate, and you may need this Stock Inventory Report right now with accurate costs, it is recommended that you follow the steps outlined in the first part of this article, with one change to the first step. Here is the process:
Go to Vendors>All Products
Type in or copy/paste the Model name of the item in the search bar and click Search
The item will appear, and click anywhere on the item
Click Edit
Enter the cost of the item in the "Cost" field and click Save
When you run the Stock Inventory Report, the item will appear with the cost you inputted for this item
We hope this helps! Please reach out to us in support chat if you need further help 😀