strange report output

One more thing. I have a detailed sales report by hour that I got off the NG and everything is on it. I could go through both reports and identify what's missing on the standard detailed report, but is it worth it? Tax Analysis report is fine so I won't have any issues there. Craig

Must be some code in the report itself. Open it in notepoad and see if anything is hinky.

Hi Craig,

Maybe you have deleted the item in HQ... check the item in STORE database and take note of the HQID.. the HQID of item in STORE database must match the id of item in HQ database.

to check you can run query getting the hqid in store item database....

select hqid from item where itemlookupcode='XXXXXXXXXXXX ' -->missing item sold (check store database / journal)

to check you can run query getting the id in HQ item database....

select id from item where itemlookupcode='XXXXXXXXXXXX ' -->missing item sold (check hq database)

after getting the correct id's...you can either update the store hqid or transactionentry table with the correct itemid.

let me know if it works

good luck

"Craig" wrote:

The report works fine for every other day but the 26th. I'm not running HQ and another detailed report by hour shows everything correctly. This is just really strange since the report has worked fine in the past, and still is working on every other day. For instance, I ran the report for yesterday(27th)and it is working correctly. But I run it for the 26th and the total doesn't match any other reports for the day. It's just the default detailed sales report that's off. Craig

craig,

try running ws401 dated Aug 25...then check your report...

let me know if it helps...

"Craig" wrote: