I did find this bug – 589 – first reported in 4.50, but it was fixed in 5.50:
1) OM - Sales Orders - create several sales orders for items with no Qty Available using different Buyers and sites.
2) OM - Early Warning Report - set Report Format = By Item/Site, By Buyer/Item/Site, or By Site/Item - Print/Preview.
3) Note that on all three Report Formats, the Preview Tree displays all item, site, or buyers that should appear on the report, however the report only displays one page. Also note that the Page counter on the upper left hand corner displays "1 of 1" and the page browse buttons are disabled.
Expected Behavior:
Report must display all qualifying item, site, or buyer combinations as listed in the Preview Tree.
That’s the only bug I ‘m seeing reported on this 40.790 report
Site/Item – 40790c and as you stated, it only pulls a single item HON-672L-P in site LA.
But there is a checkbox on the Options tab for "Include All Items with Activity”. If this check box is selected, the report will print all items that had activity in this period.
So while I can say it seems to be working with regards to only displaying one item vs many (when you select that checkbox), I’m not able to dig into the data right now to determine why that particular part showed up versus all the other parts). It might have to do with this particular part is the one that is most often used in transactions in that database. The OM User Guide says this about that report:
With Customer Priority Scheduling (CPS) on, this report lists items that need to be evaluated for possible inventory issues concerning the amount of inventory-on-hand and the amount of demand. The report compares the planned shipment date against the sales order request date to provide an early warning of potential shortages in inventory.
Report Format
Specifies which report layout to print. The options are:
• • By Item/Site — Prints a report arranged first by inventory item ID, and then by inventory site ID.
• • By Buyer/Item/Site — Prints a report arranged first by buyer, then by inventory item ID, and then by site ID.
• • By Site/Item — Prints a report arranged first by site ID, and then inventory item ID.
Options Tab
Include all items with activity
If this check box is selected, the report will print all items that had activity in this period