[jlopez]

Hello,

I need to import about 1,000 Lot items related to 6,000 bins, every Lot item will have related the 6000 bins Any ideas?

Jaime Lopez

Consultor Netsoft
This is a cached copy. Click here to see the original post.

[khultquist]

That’s a lot of bins! I would do it like this:

Create a custom Item checkbox called ‘Add 6000 bins’

Import the 1,000 items via CSV, making sure the above checkbox is checked

Write a scheduled script that finds items with checkbox checked, load the item records one at a time, add each bin, uncheck the box and submit

Schedule it to run every 15 minutes

Wait a long time for the whole job to complete

Remove the checkbox field

[jlopez]

Hello Khultquist thank you for you answer, Im going to try this.

[dansteg]

I’m not sure what the business process is here, but here is my suggestion:

Are the items always On Hand in these bins or this more to allow bin transfers without having to edit the item record and add the bin, when it is introduced to a “new bin”. If the latter, I would create a user event script for your bin transfers that checks to the see if the item is already associated with the bin that it is being moved to. If not, then add the bin and THEN complete the move.

This is how we handle this at our company and it works great. It helps us keep the Bin Numbers sublist clean as well. Again, though, I’m not sure what your business process is or how your item-bin relationships are designed.

[JCirocco]

Would turning on Advanced Bin Management work here? You would not need to associate a Bin to an Item ahead of time. Just curious.

[Author]

Posts