BUG? HQ Items Reports returning duplicate items

Posted by Terrible Tom on March 8, 2006, 7:42 pm

Please log in for more thread options

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
--
The worst words in business:
"We''ve always done it that way"
--
Stop Fishing for eMail.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=57ec4577-3536-4afd-a825-03be58a81cc0&dg=microsoft.public.pos

Posted by Terrible Tom on March 10, 2006, 11:38 am

Please log in for more thread options

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.

> 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

> --

> The worst words in business:

> "We''ve always done it that way"

> --

> Stop Fishing for eMail.

> ----------------

> This post is a suggestion for Microsoft, and Microsoft responds to the

> suggestions with the most votes. To vote for this suggestion, click the "I

> Agree" button in the message pane. If you do not see the button, follow

> this

> link to open the suggestion in the Microsoft Web-based Newsreader and then

> click "I Agree" in the message pane.

http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=57ec4577-3536-4afd-a825-03be58a81cc0&dg=microsoft.public.pos

Posted by Rob on March 10, 2006, 2:14 pm

Please log in for more thread options

You posted a Suggestion not a Tech request.

Rob

> 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.

>> 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

>> --

>> The worst words in business:

>> "We''ve always done it that way"

>> --

>> Stop Fishing for eMail.

>> ----------------

>> This post is a suggestion for Microsoft, and Microsoft responds to the

>> suggestions with the most votes. To vote for this suggestion, click the

>> "I

>> Agree" button in the message pane. If you do not see the button, follow

>> this

>> link to open the suggestion in the Microsoft Web-based Newsreader and

>> then

>> click "I Agree" in the message pane.

http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=57ec4577-3536-4afd-a825-03be58a81cc0&dg=microsoft.public.pos

Posted by Glenn Adams [MVP - Retail Mgmt on March 10, 2006, 2:35 pm

Please log in for more thread options

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 HQReports 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.

--
--
Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information

> 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.

>> 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

>> --

>> The worst words in business:

>> "We''ve always done it that way"

>> --

>> Stop Fishing for eMail.

>> ----------------

>> This post is a suggestion for Microsoft, and Microsoft responds to the

>> suggestions with the most votes. To vote for this suggestion, click the

>> "I

>> Agree" button in the message pane. If you do not see the button, follow

>> this

>> link to open the suggestion in the Microsoft Web-based Newsreader and

>> then

>> click "I Agree" in the message pane.

http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=57ec4577-3536-4afd-a825-03be58a81cc0&dg=microsoft.public.pos