Thanks Leanne. Your report helped me figure out why mine wasn't working. 👍 I found that using =IsNull([SOShipLine.LotSerialNbr],[SOShipLineSplit.LotSe...

Thanks John. A customer price class is too wide a net. We have nearly 50,000 items in our inventory and several thousand customers. Basically, this ...

@timrodman Hi Tim. You beauty! That's working for me too now I've found my problem; I was using the CROpportunity.OpportuntiyID, not the CROpportunity...

@shaunz Hi Shaun. Do you mind elaborating on the joins that you used?Tim's post has put me in the ballpark but I'm obviously missing something.All sol...