Discussion Forum: Thread 269204 |
|
|
| | Author: | bigboxobricks | Posted: | Jun 5, 2020 09:12 | Subject: | Consolidating lots already on inventory | Viewed: | 70 times | Topic: | Inventories | Status: | Open | |
|
| I parted out several sets without using the consolidate feature. Now I have multiple
lots of the same part. I’d love an automated way to 1) consolidate all similar
lots in my inventory and 2) price average the my cost field for each consolidated
lot.
Is this possible? Thanks!
|
|
| | | | | |
| | | | Author: | popsicle | Posted: | Jun 5, 2020 09:45 | Subject: | (Cancelled) | Viewed: | 15 times | Topic: | Inventories | |
|
| (Cancelled) |
|
| | | | | |
| | | | Author: | popsicle | Posted: | Jun 5, 2020 09:47 | Subject: | Re: Consolidating lots already on inventory | Viewed: | 48 times | Topic: | Inventories | |
|
| In Inventories, chrislebrun writes:
| I parted out several sets without using the consolidate feature. Now I have multiple
lots of the same part. I’d love an automated way to 1) consolidate all similar
lots in my inventory and 2) price average the my cost field for each consolidated
lot.
Is this possible? Thanks!
|
Don’t know of an “automated way” but there’s an easier way to perform the inventory
clean-up task that is consolidating lots…
First: go to: https://www.bricklink.com/inventory.asp
Second: within “Seach My Inventory” upper right section of the page, select Parts,
New and Non-Unique, before hitting the Go! tab (see screenshot
below)
Third: set Sort Items By: to Item No, Color Name (see other screenshot)
At this point it’s fairly easy to see any lots that need consolidating, and to
do so.
I perform this and other tasks every month or so, to help maintain inventory
integrity of our store.
|
|
|
|
| | | | | |
| | | | Author: | BigFish | Posted: | Jun 5, 2020 10:34 | Subject: | Re: Consolidating lots already on inventory | Viewed: | 34 times | Topic: | Inventories | |
|
| In Inventories, chrislebrun writes:
| I parted out several sets without using the consolidate feature. Now I have multiple
lots of the same part. I’d love an automated way to 1) consolidate all similar
lots in my inventory and 2) price average the my cost field for each consolidated
lot.
Is this possible? Thanks!
|
If you use BrickStock, you can select all lots and choose Consolidate.
|
|
|
|
|
|