By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Generic Inquiries & Pivot Tables
4
Posts
2
Users
0
Reactions
1,780
Views
September 27, 2019 4:28 pm
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?
3 Replies
October 31, 2019 11:35 pm
Your 3rd join looks good. Try this for your 1st join:
I'd also be curious to see what your 2nd join looks like.
November 1, 2019 10:07 am
I managed to get the inquiry to run. I ended up dropping the BAccount table. Here's what I used.
December 9, 2019 9:21 pm
Glad to hear that you were able to get it working.