On the main tab, in the select grid:
When I select the field status is equal to Open and on the options tab to include unapplied transactions, it does not pull anything or give a message like there are no records to pull.
I ran a trace on the database side to see what was going on and it's running this query:
SELECT DISTINCT tapVendPmt.VendPmtKey, SessionID = CONVERT(integer, 764) INTO #Unapplied FROM tapVendPmt WITH (NOLOCK), tapVendor WITH (NOLOCK), tapVendClass WITH (NOLOCK) WHERE tapVendPmt.Status = 1 AND tapVendPmt.CompanyID='ASD' AND tapVendor.VendKey=tapVendPmt.VendKey AND tapVendClass.VendClassKey=tapVendPmt.VendClassKey AND tapVendPmt.CompanyID = 'ASD' AND tapVendPmt.TranDate <= '2012-01-15'
However, there is not a field named status in tapvendpmt, so I figure that is why this is not pulling any results.
Does anyone else have this issue and if so, what field should it be using in the where clause?
Can someone pull a trace on this report (on this specific piece) and let me know if their SQL matches what I have, if not, can they post it, so I can use that query to build a report off of?
Your help would be greatly appreciated.
Thank you,
MGalvan801
