1. Home
  2. Point-Of-Sale Software
  3. Why doesn't HQ work right when it comes to Inventory?

Why doesn't HQ work right when it comes to Inventory?

Maybe I'm too stupid to use it right.

I just ran a test, and in my opinion HQ failed miserably.

The test:

From Store Ops, generate a test PO. One line item, an ILC that had zero on hand and a prior cost of $12.50. Change cost on PO to $10.00, receive & commit.

Store Ops behaves as expected - cost changes to $10, reorder cost changes to $10, quantity on hand, last ordered, last received - everything updates just like you'd expect.

Wait for HQ to process the next regularly scheduled WS401. Check item properties at HQ.

Quantity on hand - updated OK. Last ordered - updated OK. Last received - NOT UPDATED. Cost - NOT UPDATED. Reorder cost - NOT UPDATED.

As a result: HQ Inventory value report INCORRECT.

I didn't go so far as to sell the item at the store, but I'm willing to bet that if I did...

HQ Detailed Sales report would show INCORRECT cost & profit figures.

At this point, I have more or less lost all faith in HQ as a reliable tool.

I would LOVE to have somebody restore my faith, but am not exactly holding my breath here.

Tom

Reply to
Terrible Tom
Loading thread data ...

It gets better.

I went ahead and sold the test item. Store Ops behaves as expected - reports show the correct costs, quantities update, last sold updates, etc.

HQ fails. Last received never did update. Last sold DOES NOT UPDATE. Cost & reorder cost NEVER UPDATED. Master Value List report - WRONG COST. Master Price List report - WRONG COST.

*SURPRISE*! The HQ Detailed Sales w/Cost & Profit report actually does reflect the correct cost from Store Ops. But wait - this is a custom report I got from CustomerSource--because the default report is, you guessed it, *defective*.

Bottom line: don't trust HQ.

"Terrible Tom" wrote:

Reply to
Terrible Tom

I wish I could edit my posts...

HQ Item Properties Store Cost info does update.

I do have 'Calculate HQ Item Cost as weighted average' checked in my HQ Configuration.

With zero quantities on hand in all stores, the cost at HQ should average to the last received cost when an item is received in any store. Right? HQ quantity goes from zero to one, the cost of that one should be the HQ cost.

I expect a slightly more reliable tool from a company like Microsoft. There's a reason I didn't buy some POS software built and supported by some rinky-dink outift--I couldn't trust the product or the company behind it to effectively manage my business. I trusted MS to deliver a product that would help me manage my business effectively, and it seems my trust was misplaced.

This has been a very expensive mistake.

"Terrible Tom" wrote:

Reply to
Terrible Tom

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.