Does anyone know how to have the sales price from the “Sales Prices” show up as a column on the Inventory Items query?
I have been able to do it, but it duplicates the inventory items many times. Here is how I built the relationships:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/65ee264d-0f24-436b-a317-5b21f3fa22fe.png)
What am I missing?
Best answer by bzelinski
View original