BUG? HQ Items Reports returning duplicate items

The HQ Items Master Quantity List and Items Master Price List reports are returning incorrect results.

If an item is included in an assembly, that item is listed twice. If an item is included in seven assemblies, that item is listed eight times. I presume that the report is listing the item once and then repeating the entry for each assembly the item is part of. Each entry counts the full inventory, so your totals for cost, etc. are way off.

Ideally, assembly items would not appear at all in either of these reports. At worst, a line item for the assembly ILC might appear but with a quantity of zero.

This is not good.

I did not see a 'fixed' report in the CustomerSource Reports Library. The problem is not addressed by the most recent HotFix.

Is this a known issue?

Tom

Reply to
Terrible Tom
Loading thread data ...

So where's my newsgroup management?

No replies in 24 hours, right?

I'm paying 18% for upgrade protection and what else, exactly?

The report is defective.

formatting link

Reply to
Terrible Tom

You posted a Suggestion not a Tech request.

Rob

formatting link

>
Reply to
Rob

It's 48 hours for the managed group...

That's an odd problem. It's happening because the HQ Item Quantity report is including the ItemClass and ItemClassComponent tables. I say it's odd, because most reports exclude those tables for exactly this reason! Someone must have asked to show the Matrix lookup codes in the report....

I'm pretty sure that you can just copy the Store Ops version of Item Quantity List to the HQ\Reports folder nad get what you are after. Either rename the original report first, or copy the Store Ops version using a filename that begins with "Custom - " (note the spaces around the dash)... Other than not including ItemClass and ItemClassComponent, the Store Ops version adds a couple of supplier specific fields, but should only have a single row per item.

Reply to
Glenn Adams [MVP - Retail Mgmt]

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.