Stock-Pratique FAQ
Frequently Asked Questions
- I can't use the software, a red message indicates: "Microsoft has blocked macros from running because the source of this file is untrusted". What to do?
This is a security feature of Office that blocks macros from files originating from the Internet.
However, you can easily unblock the file in a few clicks:
Close the file, right-click on the file > Properties > Check "Unblock," confirm, and then reopen the file.
- I cannot use the software, I am stuck on a sheet where it is written: "The activation of macros is essential to be able to use this application". What to do?
This means that the macros (which are essential to the operation of the application) have not been activated.
To be able to use this application, start by activating the macros in your Excel options and then restart Excel.
You will find on the following page useful information for activating macros:
www.excel-pratique.com/en/vba_tricks/enable-excel-macros - How to obtain the inventory on December 31?
Go to the first tab (Inventory), enter the desired inventory date (for example, 12/31/2024) and click on the export function button (the symbol with the arrow pointing down, located to the left of the delete button).
Note: if you want to export all your items, leave the other search fields empty.
- How to display the stock value?
Go to the first tab (Inventory) and use the export function (accessible by clicking on the symbol with the arrow pointing down) without forgetting to check "Stock value".
- How is the stock value calculated?
The software calculates the stock value by considering the different purchase prices (from the most recent to the oldest).
For example, an item has the following 3 movements:
- 1/12/2024: entry of 15 units at 50 per unit
- 1/18/2024: entry of 5 units at 30 per unit
- 1/25/2024: exit of 10 units
So, the remaining stock is 10 units and its value here will be 400.
For this calculation, the software takes into account each entry until the current stock is exhausted:
- In this case, there are 10 units left
- The most recent entry is that of 1/18/2024 with 5 units at 30. (so it's already 150 for these 5 units)
- The value of 5 remaining units still needs to be determined
- The value of these 5 remaining units is obtained thanks to the previous entry (that of 1/12/2024) where the units were at 50 per unit (which therefore makes 250 for the 5 units)
- So, the stock value is 400 (5 units at 30 per unit + 5 units at 50 per unit)
- How is the initial stock value of an item calculated?
When adding an item, the software allows you to enter an initial stock but it is not possible to enter the value of this initial stock from this form.
Here is how the software determines the value of this initial stock:
- If in the list of movements of this item you have no other entries, the software will not have any value information for this item and the value of the initial stock will therefore be 0.
- If in the list of movements of this item you have an entry, the value of the initial stock will be calculated based on the unit price of this entry.
- If in the list of movements of this item you have several entries, the value of the initial stock will be calculated based on the unit price of the first entry (the first one considering the date).
If it suits you, you can of course leave the initial stock field empty when adding the item and create an entry movement to add the initial stock and indicate the value of your choice as for any other entry.
- Why does the stock of this item not match the movements displayed below?
By clicking on an item, its movements are displayed in the list below.
If you notice a difference between the displayed stock of the item and the stock calculated from its movements, it means that you had defined an initial stock when adding the item and the difference comes from there (the initial stock is taken into account in the stock calculation but is not displayed in the list of movements).
To view or modify the initial stock of an item, click on the "Modify the item" button.
- Which items, movements or contacts are exported using the export feature?
All items, movements or contacts that are displayed in the list are exported (so leave the search fields empty to export all results or use the search fields to refine the results).
- How to replace the "Location" field if I don't need it?
You can rename this field by simply clicking on its name:
- How to easily clear the content of search fields?
Simply double-click on "SEARCH".
- How many items, movements or contacts can be entered at most?
You can enter up to 65,000 items, movements or contacts in the full version (instead of the 20 entries in the trial version).
- How many groups, categories or locations can be created at most?
You can create as many as necessary.
- How to delete a group in the "Customers & Suppliers" tab?
The group is one of the few mandatory fields in this tab. For this reason, when you want to delete a group, you must transfer the contacts from this group to another group.
To delete a group containing contacts, modify this group by giving it the name of an existing group. In this way, the contacts will be transferred to the new group and the old group will be deleted.
To delete a group that contains no contact, modify this group by giving it the name of any other existing group.
- How to recover the data entered in the trial version after purchasing the full version?
At the first start of the full version, the application will automatically offer you to recover all the data you had already entered in the trial version (optional). The import of these data takes only a few seconds.
- Is the VBA password provided in case of purchase?
Yes, provided you choose the full version WITH access to the VBA code.
- Can several users work simultaneously on the same Excel workbook?
The possibilities of using the Excel workbook are the same as with any other Excel workbook.
Only one person can work on the workbook and save the changes. If another user tries to open the file while it is already open elsewhere, the file will be opened in read-only mode (the user will therefore have access to the data but will not be able to modify the file).
- What are the usage restrictions of this application?
A copy of the terms of use is available in the last tab.
- Is it possible to get the invoice for this purchase?
Yes, an invoice is automatically issued at the time of purchase (the link to this invoice is indicated in the purchase confirmation email).
- How much does this application cost?
The prices are displayed on the purchase page (accessible by clicking "Buy" in the right-hand menu).
- How many licenses do I need?
You need one license per file (backup copies not included).
For example, for 2 branches that would each need a stock management file, 2 licenses are required (one license is valid for a single file).
Note: simultaneous purchase of several licenses allows you to benefit from decreasing prices.
- Is it possible to move the Excel file to another computer?
Yes, you can move the Excel file of this application to another computer (as long as it has a compatible version of Excel).
This will not pose a license problem as long as you only use one file of this application per license purchased.
- What is the difference between the version without VBA access and the version with VBA access?
Both versions are complete and have identical features.
The only difference between the 2 versions is that the version with VBA access allows you to access the VBA code of the application.
This can allow you in particular:
- to modify the VBA code and/or the UserForms and controls
- to have access to add your own macros
- to access the VBA code to try to understand the operation of the application (the VBA code of this version is indented and contains some comments in English, however the names of the variables, functions and procedures are in French, as the software was originally developed in French)
- etc.
Note that if you are the end user of this application and you did not know what VBA access was, it is likely that the standard version (without VBA access) is the version more suitable for your use.
- Is the application compatible with Mac or LibreOffice, OpenOffice?
No, this application is compatible only with versions of Excel for Windows.