| Discussion Forum: Thread 353538 |
|
 |
| | | Author: | GranthamBricks  | | Posted: | Feb 4, 2024 16:52 | | Subject: | Number of parts in inventory | | Viewed: | 109 times | | Topic: | General | |
|
| Hi all,
Is there a way to see how many different parts are in your stores inventory?
And to be precise...In this instance I count all colours as 1 part, e.g. if you
had 3 x red 3001 and 6 x blue 3001 this would only count as a total as 1 (being
a 3001)
|
|
| | | | | |
| | | | | Author: | peregrinator | | Posted: | Feb 4, 2024 17:05 | | Subject: | Re: Number of parts in inventory | | Viewed: | 28 times | | Topic: | General | |
|
| In General, GranthamBricks writes:
| | Hi all,
Is there a way to see how many different parts are in your stores inventory?
And to be precise...In this instance I count all colours as 1 part, e.g. if you
had 3 x red 3001 and 6 x blue 3001 this would only count as a total as 1 (being
a 3001)
|
You could export and then get a count of distinct item numbers, but I don't
know of a way to do it with BL's existing toolset
|
|
| | | | | | | | | |
| | | | | | | Author: | GranthamBricks | | Posted: | Feb 4, 2024 17:13 | | Subject: | Re: Number of parts in inventory | | Viewed: | 29 times | | Topic: | General | |
|
| In General, peregrinator writes:
| | In General, GranthamBricks writes:
| | Hi all,
Is there a way to see how many different parts are in your stores inventory?
And to be precise...In this instance I count all colours as 1 part, e.g. if you
had 3 x red 3001 and 6 x blue 3001 this would only count as a total as 1 (being
a 3001)
|
You could export and then get a count of distinct item numbers, but I don't
know of a way to do it with BL's existing toolset
|
Ah yes why didn't I think of exporting to excel and removing duplicates...a
job for the tomorrow me thinks
|
|
| | | | | |
| | | | | Author: | 1001bricks | | Posted: | Feb 4, 2024 17:09 | | Subject: | Re: Number of parts in inventory | | Viewed: | 28 times | | Topic: | General | |
|
| In General, GranthamBricks writes:
| | Hi all,
Is there a way to see how many different parts are in your stores inventory?
And to be precise...In this instance I count all colours as 1 part, e.g. if you
had 3 x red 3001 and 6 x blue 3001 this would only count as a total as 1 (being
a 3001)
|
Free, open source...
https://www.brickstore.dev/
|
|
| | | | | | | | | |
| | | | | | | Author: | Stellar | | Posted: | Feb 5, 2024 04:07 | | Subject: | Re: Number of parts in inventory | | Viewed: | 27 times | | Topic: | General | |
|
| In General, 1001bricks writes:
| | In General, GranthamBricks writes:
| | Hi all,
Is there a way to see how many different parts are in your stores inventory?
And to be precise...In this instance I count all colours as 1 part, e.g. if you
had 3 x red 3001 and 6 x blue 3001 this would only count as a total as 1 (being
a 3001)
|
Free, open source...
https://www.brickstore.dev/
|
Import your inventory, select all and left click on the color column, then change
all to the same and use the button to consolidate all parts. You can also change
all conditions to the same too if you list both.
|
|
|
|
|
|
United Kingdom, England
USA, New Jersey
France, Provence-Alpes-Côte d'Azur
Spain, Comunidad Valenciana