[Solved] Inventory ID on AP Invoice
I'm trying create a similar report to the Daily Sales Profitability report but for the AP side. We are tracking Marketing Campaign expenses by Inventory ID. I am having a hard time getting results to show.
The results on the inquiry should show one charge to the Item. I wonder if the table relations are not correct. I am pretty confident the conditions are fine, but maybe not?
Your 3rd join looks good. Try this for your 1st join:
I'd also be curious to see what your 2nd join looks like.
Glad to hear that you were able to get it working.