General ledger and vendor information

(0) Share

Report

Posted on by tayket1285

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

I have the same question (0)

All responses (4)

Answers (0)

tayket1285 465 on at

Like (0)

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?

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
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

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,

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

tayket1285

Just following up, is this settled ?

Your feedback is highly appreciated,

Was this reply helpful? Yes No