Note: this feature is available on the Business and Unlimited plans.
WholeCell can automatically record your inventory value at specific day/week/month intervals throughout the year. At the chosen recording time, WholeCell records your inventory value from each inventory status (so that you can exclude anything that doesn't represent current inventory --- like "Lost" or "Vendor Return" states).
This is most useful for updating inventory value in accounting software (Quickbooks, Xero, etc) at the end of the week, month, or year. Without this feature, you or your accountant will need to record these values manually from the inventory analytics page.
Setting up your Inventory Value Capture configuration
To set it, go to 'Settings' on your left sidebar menu, then look for 'Inventory Value'.
From there, you can select the frequency you want WholeCell to record your inventory values: daily, weekly, monthly, or on a specific day of each month
Accessing Inventory Value History
This is not retroactive so you have to wait for some time, depending on the frequency you chose to show you the values. To access them, go to 'Analytics', then click on the 'Inventory Value History' tab. You can use filters to show the values of inventory items under the statuses that you want to see.
If you click the drop-down button, you can expand the view to show all the different inventory statuses in your account, so you can select the statuses that you only want to view or contribute to the total value that's shown on the first line. To select multiple statuses, press the CTRL key on your keyboard while clicking the different statuses in the 'Statuses' box above the table.
The difference between the Initial Price Paid Value and the Total Price Paid Value is that the Total Price Paid Value includes cost line items that you have added to your inventory items.