Account Transactions Report with Manual Payments applied to Purchase Invoices
In this Post i'm sharing a view regarding the Smartlist report of Account Transaction as i linked this view with another tables to get the Manual Payments that are applied to purchase invoices. this view contains the work and history tables. you will find the invoice number, date and the applied amount. USE [Company_NAME] GO /****** Object: View [dbo].[_AccountTransactionsVSPayementsAndInvoices_AK] Script Date: 5/21/2018 10:45:50 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO CREATE VIEW [dbo].[_AccountTransactionsVSPayementsAndInvoices_AK] AS select AccountTransactions.* , PM20100.APTVCHNM , PM20100.DOCDATE , PM20100.APTODCNM , PM20100.APPLDAMT , PM20100.APTODCDT from AccountTransactions as AccountTransactions left join PM20100 as PM20100 on AccountTransactions.[Originating Control Number] = PM20100.VCHRNMBR --where AccountTransactions.[Originating Control Number]='00000000000001094' union all select AccountTransactions....