Items created after inventory number 1000 does not show both on item displayed column and also inventory quantity summary under report but shows when the code is entererd for sales under sales invoice. Please any help, because i run a cosmetic shop and my items are over 1000 pieces. thanks.
The problem is caused because you are using an alpha numeric encoding that is usable up to 999 items.
What you actually need to do is change the item code to the format for example C1234.
Then you can use up to 9999 items. If you need more use C12345, then you can use up to 99999 items.
So the current item codes will have to be converted from, say, C998 to C0998.
Use Batch Update to achieve this in a simple way.
If necessary, see Use Batch Create and Batch Update functions | Manager
3 Likes
We can’t see from your screenshot if all your items are showing or not. We could guess what your coding scheme is, but we don’t know if you also have items named A123, B123, or using another coding format altogether. I presume you have some with different naming, otherwise we should see C998 and C999 at the bottom of your list. If you tell us what you expect to see and why you think there is a problem then we will be in a better position to help you.
My guess is that the items are showing, but just not where you are looking for them. Manager sorts the item codes alphabetically, not numerically. So, if we use a scheme of C01, C02, C03, etc, and have a total of 200 items, the first 50 items in the sequence would run like this:
C01
C02
C03
C04
C05
C06
C07
C08
C09
C10
C100
C101
C102
C103
C104
C105
C106
C107
C108
C109
C11
C110
C111
C112
C113
C114
C115
C116
C117
C118
C119
C12
C120
C121
C122
C123
C124
C125
C126
C127
C128
C129
C13
C130
C131
C132
C133
C134
C135
C136
…
If this is the case, then you should follow @ries’s guidance and add a digit to your codes so that all the codes have the same number of digits. Then the first 50 items in the above sequence would look like this:
C001
C002
C003
C004
C005
C006
C007
C008
C009
C010
C011
C012
C013
C014
C015
C016
C017
C018
C019
C020
C021
C022
C023
C024
C025
C026
C027
C028
C029
C030
C031
C032
C033
C034
C035
C036
C037
C038
C039
C040
C041
C042
C043
C044
C045
C046
C047
C048
C049
C050
…
Alternatively you could just keep using your current scheme, but be aware of how the items are sorted and change how you look for them accordingly.
We have more than 2,500 items in our inventory, and haven’t had any issues with items not showing. We use a different scheme for our item codes.