Help!! HQ reports

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi all,

This is my first time here.. I hope someone can help. I have a client running HQ 2.0. When I run a detaild sales report out of HQ the Department, Category, Item lookup code and description colums are all BLANK. When I do a search in the HQ database for theitems they are indeed there but do not show up in the report. All I can see on the report is the price of the item and total sales ????

I am Baffled!!!

*This post is locked for comments

All responses (6)

Answers (0)

Peter A.R. Johnson 80 on at

Like (0)

Report

Re: Help!! HQ reports

well, I'm sure that there is an explanation, just a matter of how much is it worth to you to figure it out. It is something as a Microsoft Partner that we do frequently, sleuthing out what happened, and more importantly, where to go from here. Something happened. Somebody or something changed the data. The data should give clues as to when it happened and how.
Community Member Microsoft Employee on at

Like (0)

Report

Re: Help!! HQ reports

The items are already in the HQ databse. It's just now after last month the items descriptions are not showing up on the detailed sales report. I don't understand how these fields just vanish, but they were populated a month ago??
Peter A.R. Johnson 80 on at

Like (0)

Report

Re: Help!! HQ reports

Items created at the store, will not have an HQID in the Items table.

when sales of those items are brought up to HQ, an HQ report will show the $ amount, but no description.

Peter Johnson

American Retail supply
Community Member Microsoft Employee on at

Like (0)

Report

Re: Help!! HQ reports

This has happened just last month When I run the same report for last month the fields are there and contain data?? Now when I run the report the only items that show data are ones that were just put into HQ. I checked her worksheets and she did nothing out of the ordinary.
Peter A.R. Johnson 80 on at

Like (0)

Report

Re: Help!! HQ reports

I agree, the items where entered into store first, and not into HQ. You need to set them up properly, get back to the basics.

Peter A.R. Johnson

American Retail Supply
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

Re: Help!! HQ reports

Sounds like the store sold items not in the HQ database (hence the blank references)

Query the store database - item table - see if the items sold in that time period have an HQID of zero; if they do, there's your answer.