'Beg Balance Payment' AND [AP PAY Type] <> 'Credit Memo' AND [AP PAY Void] = 0 UNION SELECT [SYS COM Company Name], [AP PAY Check No] as [Doc #], [AP PAY Transaction Date] as [Date], [AP PAY Vendor No] as [Description], 'Refund' as [Type], [AP PAY Amount] as [Amount], [AP PAY Bank Account] as [BANK ID], [AP PAY Reconciled] as [Cleared] FROM [SYS Company], [AP Payment Header] WHERE [AP PAY Posted YN] =1 AND [AP PAY Type]= 'Credit Memo' AND [AP Pay Credit YN]= 0 AND [AP PAY Void] =0 UNION SELECT [SYS COM Company Name], [AR PAY Check No] as [Doc #], [AR PAY Transaction Date] as [Date], [AR PAY Customer No] as [Description], 'Cash Receipt' as [Type], [AR PAY Amount] as [Amount], [AR PAY Bank Account] as [BANK ID], [AR PAY Reconciled] as [Cleared] FROM [SYS Company], [AR Payment Header] WHERE [AR PAY Posted YN] = 1 AND [AR PAY Type] <> 'Beg Balance Receipt' UNION SELECT [SYS COM Company Name], [BANK TRANS Ext Document No] as [Doc #], [BANK TRANS Date] as [Date], [BANK TRANS Reference] as [Description], [BANK TRANS Type] as [Type], [BANK TRANS Amount] as [Amount], [BANK TRANS Bank Acct 1] as [BANK ID], [BANK TRANS Cleared YN] as [Cleared] FROM [SYS Company], [BANK Transaction] WHERE [BANK TRANS Posted YN] =1 ORDER BY [Date]"!>

 

Bank Transactions
Account Type Date Doc # Description Amount
         
 
       
  Account Total:  
  Grand Total: