And did this allow for Gross Profit to be easily seen? All of our scripting makes it look like we are receiving a negative margin for all sales to applicable customers.

What custom record/contract are you talking about? I would love to hear where you found this in the system. I am having this exact same issue.

I created a new search with a criteria of name, preferred vendor, and on hand quantity greater than 0. The preferred vendor was only because I am looking for one specific vendor and is not mandatory for the sake of the search. I added results of name, on hand, and last quantity available change. Hopefully this helps.

John, Did you ever resolve this? I am fighting through the same situation with thousands of parts. My best plan is duplicating many items and concatenating the item id with the customer name (ie: itemA as my standard part and itemA_customername as my item name/number associated with a customer). Is scripting the only…