Fixed Assets - Need SQL Query for the AC numbers corresponding to each account group.

(0) Share

Report

Posted on by Community Member

Hello,

I am having a difficulty to fetch account number along with account group.
We have several Account group Id’s () in GP. And we would like to have an SQL query to fetch all the account numbers and account group id corresponding to a/c group id.

Thanks in Advance.

*This post is locked for comments

All responses (2)

Answers (1)

Community Member on at

Like (0)

Report

RE: Fixed Assets - Need SQL Query for the AC numbers corresponding to each account group.

Hi Bob,

Excellent!

This is exactly what I was looking for.

Thanks a lot.
Verified answer

Community Member on at

Like (2)

Report

RE: Fixed Assets - Need SQL Query for the AC numbers corresponding to each account group.

Hello Leo,

Here is the SQL query.

SELECT A.ACCTGRPINDEX as GRPINDEX, A.ACCTGRPID as GRPID, A.ACCTGRPDESC as GRPDESC,

ISNULL(E.ACTNUMST,'') as ASSET_COST,

ISNULL(F.ACTNUMST,'') as PROCEEDS,

ISNULL(B.ACTNUMST,'') as DEPRCTN_EXP,

ISNULL(C.ACTNUMST,'') as DEPRCTN_RESERVE,

ISNULL(D.ACTNUMST,'') as DEPRCTN_PR_YR,

ISNULL(G.ACTNUMST, '') as GL_RECOGNIZED,

ISNULL(H.ACTNUMST, '') as GL_NON_RECOG,

ISNULL(I.ACTNUMST, '') as CLEARING

FROM FA41300 A

left join GL00105 B on B.ACTINDX = A.DEPREXPACCTINDX

left join GL00105 C on C.ACTINDX = A.DEPRRESVACCTINDX

left join GL00105 D on D.ACTINDX = A.PRIORYRDEPRACCTINDX

left join GL00105 E on E.ACTINDX = A.ASSETCOSTACCTINDX

left join GL00105 F on F.ACTINDX = A.PROCEEDSACCTINDX

left join GL00105 G on G.ACTINDX = A.RECGAINLOSSACCTINDX

left join GL00105 H on H.ACTINDX = A.NONRECGAINLOSSACCTINDX

left join GL00105 I on I.ACTINDX = A.CLEARINGACCTINDX

I hope this is what you are looking for.

--

@dyngp_warren