Item Info From SO to HQ

Hi,

I have two questions:

1) I have a multi-store RMS setup with an HQ, a couple of SO Stores and a seperate SO Warehouse system for our inventory. This week we entered about 1,000+ new items into our Warehouse SO RMS thinking that we would do an HQ sync and the HQ would pick up on the new inventory that is in the Warehouse SO. That doesn't seem to be working. This is the first time that I've added inventory since our initial setup last month so any help would be much appreciated. How does a SO level inventory addition make it to the HQ? What if I need to add new items at my store level? Do I have to put them into the HQ to start out and then transfer to the store and add inventory quantities there? Do we have to re-enter all 1,000+ items into our HQ? I'd really like to not have to re-enter the 1,000 items again if I don't have to.

2) In HQ Manager, when I view a Department Sales Report under Reports--> Sales--> Dept. Cost/Sales, I get a beautiful report that shows how much we've sold this month in sales, but all of the cost lines for each item are just $0.00. Which really screws the report up because we can't compare our costs to our sales. Each item has on the first page of its item properties, a cost that has been entered by us. Where else is there a cost box that needs filled in for this report to function properly?

Thank you in advance for any assistance you can give me. - Ryan

Reply to
Ryan
Loading thread data ...

Ryan,

Sorry to tell you this, but you cannot add new items at the Store Ops level and have them picked up by Headquarters. They will have to be re-added in HQ , then downloaded to the store using the 260 - Download Items worksheet. That download will also create/update the ItemDynamic record for that item at that store.

I'm sure you're not the first person who has done this, so someone here may have a SQL query to read the new items from the Store.Item table and insert them into the HQ.Item table. However, this is only recommended if you are somewhat tech-savvy and are comfortable with working with the raw back-end data. If not, you'll have to re-enter the items.

As for the department sales report, are you sure the items sold had costs at the time they were sold? IF you created the item but left off the cost, sold it, then went back and updated the cost on the item, that will NOT be reflected on your sales report, since at the time of the sale, the item had a cost of 0.00.

Bill Yater The Worth Collecti> Hi,

Reply to
Bill Yater

Hi,

I have two questions:

1) I have a multi-store RMS setup with an HQ, a couple of SO Stores and a seperate SO Warehouse system for our inventory. This week we entered about 1,000+ new items into our Warehouse SO RMS thinking that we would do an HQ sync and the HQ would pick up on the new inventory that is in the Warehouse SO. That doesn't seem to be working. This is the first time that I've added inventory since our initial setup last month so any help would be much appreciated. How does a SO level inventory addition make it to the HQ? What if I need to add new items at my store level? Do I have to put them into the HQ to start out and then transfer to the store and add inventory quantities there? Do we have to re-enter all 1,000+ items into our HQ? I'd really like to not have to re-enter the 1,000 items again if I don't have to. 2) In HQ Manager, when I view a Department Sales Report under Reports--> Sales--> Dept. Cost/Sales, I get a beautiful report that shows how much we've sold this month in sales, but all of the cost lines for each item are just $0.00. Which really screws the report up because we can't compare our costs to our sales. Each item has on the first page of its item properties, a cost that has been entered by us. Where else is there a cost box that needs filled in for this report to function properly?

Thank you in advance for any assistance you can give me. - Ryan

Reply to
Jeff

Jeff,

Which is of the add-ins at Retail Realm is the one I want? I don't see any that specifically list they take items from SO to HQ?

Also, I am the reseller/trainer as I purchased and did the install myself. So no-one to blame there but me and the stack of Microsoft RMS manuals that I have which don't point out this fact.

Lastly, I did figure out last night the issue with the cost report. I had to add a Supplier and a cost to each item, and then the report worked correctly for the couple of items I test sold last night. That doesn't fix the rest of the month for the items that were sold with no Supplier and no Supplier cost, but at least next month will be correct.

Thanks aga> Ryan,

that will allow store creation of items.

TransactionEntry.Cost after the sale. Seems like someone posted a SQL query here recently to update the costs after the fact

Reply to
Ryan

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.