Currently I have a BAQ report on the Vendor Change Log…works perfect. Accounting wants to start tracking some changes on the VendBank table. I have the change log set up with no problem.
My question is can I add the VendBank logs to the current Vendor report?
I tried to add it but it didn’t return any rows.
My current BAQ looks like this…
I thought I would just need to add the VendBank Table then Ice.ChngLog2 and do a join but that didn’t work…
Anyone have suggestions or do I need to have 2 seperate reports?
Banderson
July 10, 2019, 3:50pm
2
did you change your filter on the change log to show Vender OR VenBank?
do I want OR or AND?? I thought it was and since I need logs from both.
Banderson
July 10, 2019, 3:52pm
4
that’s the requirement. The row will only have one or the other. You are picking each individual row. To pick that row with an AND, that row would have to have Vendor AND VendBank, which is mutually exclusive. If the row has Vendor OR VendBank, it can pick a row that has either, and your list ends up with both of them.
2 Likes
that was my issue…I was trying to use AND not OR. Thank you.
1 Like
No OR only showed the VendBank Changes. I need to see both Vendor and VendBank Changes.
When I make it and i get no results.
Banderson
July 10, 2019, 5:24pm
7
Can you show me a screen shot of what you have now? Specifically your filter.
yes… this is what I have… and AND has no results
Banderson
July 10, 2019, 5:26pm
9
You are in your join, not your filter. Click on the change log table and look at your filter there.
Banderson
July 10, 2019, 5:30pm
11
That one needs to be OR, not AND
Also you need the join to be a right join. One that includes all of the the change log. The vendor table isn’t going to match the VendorBank table.
Or is not giving me both change logs. It is only showing changes on Vendor. I am missing the changes I made on VendBank.
here are the changes I made…
Banderson
July 10, 2019, 5:37pm
13
That’s because your join is an inner join on the Vendor table. The VendBank table isn’t going to match. You need to make that a right join
Which one is consdider Right?
Banderson
July 10, 2019, 5:39pm
15
The one that says “All Rows from ChgLog”
Now I am missing data and it seems to be all over the place…
Banderson
July 10, 2019, 5:41pm
17
Let me see that join. I think you picked outer, or show all from both.
Banderson
July 10, 2019, 5:42pm
19
yeah that’s an outer join. pick a different on in the list.
Still missing data…I did try all the joins before and couldn’t get them to work.
