465
Hi,
I want to review a particular GL account and I want to see the names of all the vendors for that particular GL account that I have paid or coded to. How can I go about doing that? Thanks
*This post is locked for comments
Nothing more valuable to add up, just a simple script which can deliver the desired output.
Here is the result data set:
Replace the #AccountPayableNumber in the WHERE below, with the required account number like 000-2100-00
Share
Report
All responses (
Answers (
SELECT B.TRX_Year ,
A.ACTNUMST ,
B.JRNENTRY ,
B.DEBITAMT ,
B.CRDTAMNT ,
B.ORMSTRID AS VendorID ,
B.ORMSTRNM AS VendorName
FROM ( SELECT *
FROM dbo.GL00105
WHERE ACTNUMST = '#AccountPayableNumber'
) AS A
LEFT OUTER JOIN ( SELECT OPENYEAR AS TRX_Year ,
ACTINDX ,
JRNENTRY ,
DEBITAMT ,
CRDTAMNT ,
ORMSTRID ,
ORMSTRNM
FROM dbo.GL20000
UNION ALL
SELECT HSTYEAR ,
ACTINDX ,
JRNENTRY ,
DEBITAMT ,
CRDTAMNT ,
ORMSTRID ,
ORMSTRNM
FROM dbo.GL30000
) AS B ON A.ACTINDX = B.ACTINDX
Your feedback is highly appreciated,
Tayket, I would start with this SQL view from Victoria Yudin - victoriayudin.com/.../sql-view-to-show-all-gl-distributions-for-ap-transactions. You can use the view to create a Smartlist, Excel, or SSRS report.
I mean how can I go about printing a report that has all the names of the vendors that I have used to that particular GL account?
