1. Home
  2. Point-Of-Sale Software
  3. Item Table Madness - HELP!

Item Table Madness - HELP!

I wish I could explain this one...

I have HQ & four stores.

These are real examples.

HQ Item Table: ID ItemLookupCode Description

2505 29464/D827022 RECLINER, LZBOY 3503 29464/D827022 RECLINER, LZBOY

406 45202/WACOCOA LOVESEAT, WARNER COCOA

7044 45202/WACOCOA LOVESEAT, WARNER COCOA

3144 AUNATURALLE/Q MATTRESS, QUEEN, WICKLINE

3204 AUNATURALLE/Q MATTRESS, QUEEN, WICKLINE

Store #1 Item Table: ID, HQID, ItemLookupCode, Description

4631 2505 29464/D827022 RECLINER, LZBOY 2505 2505 29464/D827022 RECLINER, LZBOY 9140 0 29464/D827022 RECLINER, LZBOY 9141 0 29464/D827022 RECLINER, LZBOY

406 7044 45202/WACOCOA LOVESEAT, WARNER COCOA

7042 7044 45202/WACOCOA LOVESEAT, WARNER COCOA 9144 0 45202/WACOCOA LOVESEAT, WARNER COCOA 9145 0 45202/WACOCOA LOVESEAT, WARNER COCOA

3255 3144 AUNATURALLE/Q MATTRESS, QUEEN, WICKLINE

3175 3144 AUNATURALLE/Q MATTRESS, QUEEN, WICKLINE 9142 0 AUNATURALLE/Q MATTRESS, QUEEN, WICKLINE 9143 0 AUNATURALLE/Q MATTRESS, QUEEN, WICKLINE

All four stores have these six items with HQID = 0.

I have re-indexed both HQ and Store DBs.

What do I do to fix this? Tom

Reply to
Terrible Tom
Loading thread data ...

Well the below data seems that you have not followed any instruction of Microsoft, i.e. create the template database, and store specific databse first and then run the sync.

What I have noticed that your store database was already c> I wish I could explain this one...

Reply to
Akber Alwani

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.