Store Ops Quantity

How can I update the store ops quantity from HQ. We do our receiving at HQ level, so I need to send store quantities to SO from HQ.

Reply to
Mike
Loading thread data ...

You could use WS260, I guess, but RMS is not designed for central receiving.

You may receive inventory at your physical headquarters, but you definitely don't 'receive' inventory with RMS HQ.

Inventory can only be rec'd by Store Operations. You could set up a Store Ops database at HQ (for a few thousand dollars) and use the inter-store transfer process to distribute inventory. You would still have to train someone at the stores to receive the transfer orders.

I wish I had something more encouraging to offer, Tom

Reply to
Terrible Tom

How can I update the store ops quantity from HQ. We do our receiving at HQ level, so I need to send store quantities to SO from HQ.

Reply to
CptSoft

Sorry, A little more info would have probably helped.

We handle inventory actually through Navision 3.6a. We import sales from RMS into Navision for Accounting/Inventory purposes. All of our purchases and Inventory adjustments are doen in Navision. We then run a process to load HQ with Beginning of Day inventory so that the "Check Stores" function can get inventory from HQ. I'd like to take it one step further and "Push" each stores inventory back to the SO database.

Does that make more sense?

"Terrible Tom" wrote:

Reply to
Mike

Sorry, A little more info would have probably helped.

We handle inventory actually through Navision 3.6a. We import sales from RMS into Navision for Accounting/Inventory purposes. All of our purchases and Inventory adjustments are doen in Navision. We then run a process to load HQ with Beginning of Day inventory so that the "Check Stores" function can get inventory from HQ. I'd like to take it one step further and "Push" each stores inventory back to the SO database.

Does that make more sense?

"Jeff @ Check Po> Mike,

reports what the other stores have.

and transfer.

transfers to send to the other stores based on sales, quantity or re-order information.

Reply to
Mike

You can populate a 307 worksheet, but what i think jeff is saying is that in normal instances you would have a warehouse store from ehich transfer happen from one store to another, we have done this with great plains, we have a trigger that creates a worksheet 330 with the pertinant information an administrator then issues this transfer and thus the stores are update accordingly, but the user still has to physically receive that inventory trasfer, we have also gone and written a sql trigger that auto receives and closes off the transfer once received at store.

The correct qty's in hq are sent up with each 401 worksheet. Thus what you have ion Navision should be checked maybe once a month or week to see if they are still in ballance.

Hope this helps.

Stephen Zwarts IMMIX Solutions (South Africa)

Reply to
Stephen Zwarts

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.