1. Home
  2. Point-Of-Sale Software
  3. HQID in headquarters database

HQID in headquarters database

I'm hoping I can get a confirmation / clarification on the purpose of the HQID field.

My understanding is that HQID is only zero in store ops databases that don't talk to Headquarters. When there is a Headquarters, the HQID value in say the item table must match the ID value in the item table of the HQ database. Right?

In addition, all HQID values should also be zero in all headquarters databases, right?

I'm trying to figure out why some of my HQ tables like cashier have HQID values in some rows that are greater than zero.....

Thanks for any help on this -

Reply to
convoluted
Loading thread data ...

I believe HQID is irrelevant in the HQ database.

The HQID in the store database should match the Item.ID of the same item in the HQ database. Your items in stores will only have an HQID if the item was created by HQ because HQ puts the HQID in the field before sending it with a WS250 or WS260. The only reason you would have a 0 in the HQID at the store is if the item was created at the store, and that may be good or bad depending on your implementation.

There is no way to resolve 0's in the store op's database HQID field except through SQL or manually, which can be very un-fun. I speak with experience.

Maybe you can elaborate on your situation so we can try to assist further.

Reply to
Jason

Hi Jason - thanks for the quick reply.

The situati> I believe HQID is irrelevant in the HQ database.

Reply to
convoluted

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.