You’re offline. This is a read only version of the page.
Hello,
I have been tasked with trying to develop an SQL query that would list all outgoing payments (Check, ACH, EFT, etc.) with the associated GL expense account string. I do not see any similar reporting available in AX 2012, and have been trying to determine which tables to use and how to build the query.
So far, I am have this:
select VT.DATAAREAID, VT.ACCOUNTNUM, VT.TRANSDATE, VT.INVOICE, VT.TXT, VT.VOUCHER, VT.DOCUMENTDATE, VT.PAYMREFERENCE, VT.PAYMMODE, GJAE.TRANSACTIONCURRENCYAMOUNT, DAVC.DISPLAYVALUE
FROM
[DynamicsAXProd].[dbo].[VENDTRANS] VT,
[DynamicsAXProd].[dbo].[GENERALJOURNALACCOUNTENTRY] GJAE,
[DynamicsAXProd].[dbo].[DIMENSIONATTRIBUTEVALUECOMBINATION] DAVC
WHERE
VT.CREATEDTRANSACTIONID = GJAE.CREATEDTRANSACTIONID
AND GJAE.LEDGERDIMENSION = DAVC.RECID
AND GJAE.POSTINGTYPE = 14
AND VT.TRANSDATE BETWEEN '04-01-2016' and '04-30-2016'
AND VT.DATAAREAID = '8032'
ORDER BY VT.DATAAREAID, VT.TRANSDATE, VT.PAYMMODE, VT.PAYMREFERENCE
It gets me close, but I am certain there is a missing piece. Any help would be appreciated.
*This post is locked for comments
I have the same question (0)
you can see existing logic and way how it is presented in ax.
pay a visit to following navigational path
Accounts payable/Common/Vendor invoices/Open vendor invoices
Share
Report
All responses (
Answers (
49,668
