Updating Bin Locations

I am trying to figure out if running a worksheet from Head quarters will update bin locations at store level. Ideally what I would like it to do is everytimme I run a worksheet 250 it will only update quantities and prices while leaving the bin location unchanged. Any one with any ideas??

Thanks, Siddharth

Reply to
Sid
Loading thread data ...

Hi Sid

quantities and prices are considered to be dynamic data by RMS and are not updated by Worksheet 250 - if you want to update them you would need to use Worksheet 260, which updates both static data (for example, item descriptions) as well as dynamic data (prices, quantities, costs). See the help file in RMS that talks about this. It explains what each worksheet does, look under 'styles, worksheet'.

I'm assuming that if you run either a 250 or a 260 worksheet, since the bin location is a static item attribute, it will be changed in the store to match what is in HQ. if you want to test this yourself, trying doing a worksheet style 250, and on the select items window of the worksheet wizard, select add items manually, and just add one item to your worksheet. process the worksheet and see if the bin location in the store was changed to match the bin location in HQ.

hth kev> I am trying to figure out if running a worksheet from Head quarters will

Reply to
kskinne

Running 260 is very dangerous as you also override quantity and cost at store. I suggest for price change you use the 300 series worksheet and not

260 [worksheet of last resort - to be used only in case of catastrophies.

Retail Realm has an HQ Misc Utility with a lot of programs in it that I would recommend you look into. One of these is a set of 36 new wizards amongst which BIN location update is one. This will create a custom worksheet to go to store and update the BIN location.

For more information contact my email.

Afshin Alikhani - [ snipped-for-privacy@retailrealm.co.uk] CEO - Retail Realm

Reply to
Afshin Alikhani

Hi Afshin,

Do you have an utility to add bin location in a batch? working like this, scan all items from on shelf, then give a bin location code together, instead of one by one to open each item's property.

Regards, Jas> Running 260 is very dangerous as you also override quantity and cost at

Reply to
Jason

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.