fryeguy

I have a custom PO report that helps us maintain continuity between engineering and purchasing with regard to product cost and price.

Sometimes we use the same Model for a part that is generic, like a dimmer. Once we are in contract and fully engineer the lighting system, I may enter the proper SKU for these items without changing the model number. When I run my PO report the SKU is effectively ignored and all items of the same Model are grouped. This also holds true for items where we may adjust the price on a particular item. For example we may be giving an extra dimmer to the client at no cost. Again, the report may either group all these like dimmers and show zero dollars for the price or the actual price. I'm guessing that the value which is displayed is simply a matter of which item is iterated through last.

Any thoughts on how to show like items with different SKU and/or price in the same PO report?