BUG? HQ Items Reports returning duplicate items

Mar 09, 2006 3 Replies

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


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

You posted a Suggestion not a Tech request.

Rob

formatting link

>

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.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required