In rare cases, a negative status may appear in the Stock Quantity column on an inventory card. Under normal circumstances, this should not occur.
For these cases, there is a function that finds items with a negative balance. You can find it under inventory cards.
When running this function, you must always be in the period from which you want to list the items.
Example of possible cause No. 1
1. I perform an initialization from 2018 to 2019; the inventory card shows a positive balance of 10 pcs (in both periods)
2. In 2018, I issue 10 pcs
3. In 2019, I issue 10 pcs
4. I run the transfer from 2018 to 2019 again; the inventory card now shows a balance of -10 pcs in 2019
A negative stock balance can be corrected by receiving the corresponding number of pieces.
This can be achieved, for example, by performing a retroactive inventory count as of 31/12/20xx at a time when an issue has already been recorded in the following year, which, after generating the inventory difference, causes the negative balance.
Example of possible cause No. 2
If you insert a positive value via API into the Quantity column on an issue note that generates an issue request (i.e., the number of MJ is in the Requested MJ column), this will result in a negative balance in the Stock Quantity MJ column on the inventory card.
By default, the value in the Quantity column is only entered once the corresponding receipt is recorded, which settles the request.
Note
Listing items with a negative balance is not a standard feature. To activate it, please contact our sales department (371 124 321; obchodflexi@abra.eu).
Back to the overview.
If you have trouble running this feature in the application, you can also run it directly in the database.
szkontrolujsklad(i_ucetobd integer, i_typvypisu integer, i_idsklad integer, i_datumod date, i_datumdo date)