While Select SalesId, SalesName, PurchOrderFormNum from salesTable join InvoiceAccount, InvoiceDate, invoiceId, SalesId, CurrencyCode, SalesBalance from custInvoiceJour where salesTable.SalesId == custInvoiceJour.SalesId && custInvoiceJour.InvoiceAccount == custVendPaym.ledgerJournalTrans().AccountNum Exists Join custTrans where custTrans.Invoice == custInvoiceJour.InvoiceId && custTrans.AccountNum == custInvoiceJour.InvoiceAccount && custTrans.TransDate == custInvoiceJour.InvoiceDate Exists join custTransOpen where custTransOpen.AccountNum == custTrans.AccountNum && custTransOpen.RefRecId == custTrans.RecId Exists join specTrans where specTrans.RefCompany == custTransOpen.dataAreaId && specTrans.RefTableId == custTransOpen.TableId && specTrans.RefRecId == custTransOpen.RecId Exists join ledgerJournalTrans where specTrans.SpecCompany == ledgerJournalTrans.dataAreaId && specTrans.SpecRecId == ledgerJournalTrans.RecId && specTrans.SpecTableId == LedgerJournalTrans.TableId && ledgerJournalTrans.AccountNum == custVendPaym.ledgerJournalTrans().AccountNum
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.