Hi Experts,Actually we are doing incoming payments on Invoice doc based but sometimes when down payments are done we do payment on account. Now i need a query how to relate invoice to payment of account.SELECT T0.[DocNum] as [InvNo] , Convert(varch...