Planning from locations with same name

[cmcintos]

Hi,

Because of the way we have our VPD and users defined in the system, we have ended up with multiple location gids. We may integrate orders with 4 different location_gids but the location name is the same.

Does any one know of a trick to bulk plan where the location name is used?

[AMM]

Re: Planning from locations with same name

Do you mean bulk plan orders from the same location (name, but different location GIDs) together in the same bulk planning process, and not consider orders from different locations with different names?

You could probably do something with saved queries to select orders with the same location name although unless there were only a few locations, this would be a mess to configure/maintain/use.

If you are only bulk planning these same locations together, and not considering any other orders from different locations within each bulk plan, then you could perhaps use the "Ship With Group" functionality on the order release > constraints tab. You'd need to run a background process to do an sql insert into the Ship With Group field on all of your orders, with the process identifying which orders have the same location name/different location GIDs - you could, for example, insert the location name as the Ship With Group field value. Then, when you select all of your orders for bulk planning (could be your entire set of orders), orders will only plan together with orders that have the same Ship With Group value, and thus your orders with different location GIDs but the same name, will end up planning together.

I hope I understood your problem, because it's a bit of an ugly solution...

[LourensGlog]

Re: Planning from locations with same name

Use Substitute Locations - check out online help for details

[AMM]

Re: Planning from locations with same name

Substitute locations could work. But you'd still need to dynamically monitor/update/maintain any new locations created with the same name but different GIDs with your substitute location, as well as define which location GID is your "true" location to be used as that subsitute location.
And if the users still want to see "their" location GID as the location GID on the shipments once bulk planning has been performed, this wouldn't help there.

[cmcintos]

Re: Planning from locations with same name

Thanks LourensGlog & AMM. We looked at the online help for substitue locations and it sounds promising.

In our current environment we end up with a shipment of multiple pickups to the same physical location and we want to get rid of these and make it a single pick up shipment.

Chris