Hi, We recently highlighted a problem that whenever a 250 worksheet is run, the Location and Notes fields at the store get blanked out.
This is presumably because the HQ data is overwriting the store data.
How will it be possible in a multi-store environment, for each store to maintain its own locations, notes etc?
I imagine this is will be a huge problem for a lot of companies if this is not possible which seems to be the case?
Thanks Matt
We are on V 1.3.0203. We run HQ w 114 stores and have a fairly small db (about 10,000+ active line items). Suppliers are not centrally owned at this point, so the stores currently create and attach their own suppliers to each line item - HQ does not have suppliers. If we reissue an item via WS250 to stores, we will detach their supplier record from the ILC. No, the supplier is not deleted, but detached which is a pain when doing POs from Primary. If we had granted access to stores to edit and use Bin, and HQ Bin was blank - the bin would be deleted if the item was reissued in a WS250.
Because there is not a separate/specific Bin or Notes WS, that info all pipes down from HQ (unlike Pricing, Costing, etc). There is a specific WS for suppliers, but it still detaches if they did not reside on the item card in HQ.
Because of all of this fun stuff, we have had to try to live by the following rules:
1) Only issue WS250s for new skus, never update and reissue 2) If a sku absolutely must be updated (excluding ILC because that is way bigger), all updated to stores are done via WS51s.This is kind of a pain, but hopefully it will get better some day. How many item updates are you making, are they frequent, are you good with your scripts?
Matt, We recently created a fix for this very problem. If you are interested please contact me with the information below.
It has been a suggestion for a long time (and ignored as usual). I can't understand how Microsoft can assume that all store locations would use the same bin numbers throughout an enterprise. That is asinine.
Have something to add? Share your thoughts — no account required.
Ask the community — no account required