Jump to content


Photo

Mass Bin and Department Assignment


  • Please log in to reply
1 reply to this topic

#1 newmomuser

newmomuser

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 02 April 2012 - 11:39 AM

I am a very new user to MOM and i was told there isn't a way to assign your inventory's bin locations and/or departments amongst the initial excel form for upload using the import/export wizard. We have roughly 1300 items and many more to come and we are looking for a way to batch assign our products to their departments and assign bin locations without having to go through item by item and place them with their departments and their correct bin locations. The initial excel form has a column for bins but we sometimes have multiple bin locations and when we did and upload some would have partial bins, no bins at all, and none had multiple locations. If we could find a way to batch assign these things it would save us days of work, and would have a hard time understanding why something like this could not be implemented. Any help or information would be greatly appreciated. We are running MOM version 8 in conjunction with Sitelink.

Thanks for any info.

#2 dseibold

dseibold

    Advanced Member

  • Moderators
  • PipPipPip
  • 137 posts
  • Gender:Male
  • Location:Stockton, CA

Posted 02 April 2012 - 12:18 PM

I am a very new user to MOM and i was told there isn't a way to assign your inventory's bin locations and/or departments amongst the initial excel form for upload using the import/export wizard. We have roughly 1300 items and many more to come and we are looking for a way to batch assign our products to their departments and assign bin locations without having to go through item by item and place them with their departments and their correct bin locations. The initial excel form has a column for bins but we sometimes have multiple bin locations and when we did and upload some would have partial bins, no bins at all, and none had multiple locations. If we could find a way to batch assign these things it would save us days of work, and would have a hard time understanding why something like this could not be implemented. Any help or information would be greatly appreciated. We are running MOM version 8 in conjunction with Sitelink.

Thanks for any info.


Can it be done in the initial setup? NO
MOM doesn't create the bins in the initial import of data. You have to open each item separately and create the bins. This is something that MOM should have done but never did. The new crew at Dydacomp hopefully will tackle this problem soon.

Can it be done after the bins are setup? YES
Is it easy? NO

I presume you are using the FoxPro version of MOM. Unless you know how to program in FoxPro, you will need to pay someone to write a module to upload the bin locations.

If you are using the SQL version of MOM and know SQL, you can write a query in SQL to upload a data file and edit the bin locations.

Hope this helps.
David Seibold
Wild Horses, Inc.
Operations Manager




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users