— The Forums are now read-only —
— All new activity now takes place here: —
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.
I managed to get the inquiry to run. I ended up dropping the BAccount table. Here's what I used.
Glad to hear that you were able to get it working.
By using this website, you agree to our Terms of Use (click here)
