Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Fixed Assets: What Ass...
Microsoft Dynamics GP (Archived)

Fixed Assets: What Assets Make Up What Amounts

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello:

The Fixed Assets to GL Posting Routine shows what assets make up the amounts held within each general ledger account.

But, is there another way of obtaining this information?

I'm trying to find a way of determining what assets make up the amount held within the Fixed Assets Clearing Account.

Thank you!

John

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Fixed Assets: What Assets Make Up What Amounts

    Thanks, Jo!

    John

  • Suggested answer
    JodeRuiter Profile Picture
    JodeRuiter 978 User Group Leader on at
    RE: Fixed Assets: What Assets Make Up What Amounts

    Hi John:  There are a couple I use  - One that looks at activity that has happened - as you seem to  have done on your own, and one that looks at what will be happening based on the Accounts in the FA Cards.

    Here is the one for financial data:

    SELECT        FA00100.ASSETID, FA00100.ASSETIDSUF, FA00100.SHRTNAME, FA00100.ASSETDESC, FA00100.ASSETCLASSID, FA00100.LOCATNID, FA00100.ACQDATE, FA00902.FINANCIALINDX, FA00902.ASSETINDEX,

                            FA00902.BOOKINDX, FA00902.FA_Doc_Number, FA00902.TRANSDATESTAMP, FA00902.TRANSTIMESTAMP, FA00902.FISCALYRADDED, FA00902.FAYEAR, FA00902.FAPERIOD, FA00902.DEPRFROMDATE,

                            FA00902.DEPRTODATE, FA00902.AMOUNT, FA00902.TRANSUSERID, FA00902.SOURCDOC, FA00902.TRANSACCTTYPE, FA00902.INTERFACEGL, FA00902.GLINTTRXDATE, FA00902.GLINTDATESTAMP,

                            FA00902.GLINTTIMESTAMP, FA00902.GLINTACCTINDX, GL00105.ACTNUMST, GL00100.ACTDESCR, FA00902.GLINTBTCHNUM, FA00902.FA_Reset_Offset_Index, FA00902.FA_Reset_User_ID, FA00902.FA_Reset_Date,

                            FA00902.FA_Reset_Time, FA00902.Ledger_ID, FA00902.REFRENCE, FA00902.DEX_ROW_ID, GL00105.ACTNUMST AS Expr1

    FROM            FA00902 INNER JOIN

                            FA00100 ON FA00902.ASSETINDEX = FA00100.ASSETINDEX INNER JOIN

                            GL00105 ON FA00902.GLINTACCTINDX = GL00105.ACTINDX INNER JOIN

                            GL00100 ON GL00105.ACTINDX = GL00100.ACTINDX

    Here is the one I did to see what accounts will be used in future:

    SELECT G.ASSETINDEX "ASSET_INDEX"

         ,G.ASSETID    "ASSET_ID"

         ,G.ASSETIDSUF "SUFFIX"

         ,G.ASSETDESC "DESCRIPTION"

         ,G.EXTASSETDESC "EXT_DESCR"

         ,G.ASSETCLASSID "ASSET_CLASS"

         ,G.ACQDATE "ACQUIRED"

         ,CASE G.ASSETSTATUS  WHEN 1 THEN 'Active' WHEN 2 THEN 'Deleted' WHEN  3 THEN 'Partial Open' WHEN  4 THEN 'Retired' END AS "STATUS"

     ,DE.ACTNUMST "DEPR_EXP_ACCT"

     ,DED.ACTDESCR "DEPR_EXP_DESC"

         ,RE.ACTNUMST "ACCUM_DEPR"

     ,RED.ACTDESCR "ACCUM_DEPR_DESC"

         ,PR.ACTNUMST "PRIOR_DEPR_EXP"

     ,PRD.ACTDESCR "PRIOR_DEPR_DESC"

         ,ASS.ACTNUMST "ASSET_COST"

     ,ASSD.ACTDESCR "ASSET_COST_DESC"

         ,PRO.ACTNUMST "PROCEEDS"

     ,PROD.ACTDESCR "PROCEEDS_DESC"

         ,REC.ACTNUMST "REC_GAIN_LOSS"

     ,RECD.ACTDESCR "REC_GAIN_LOSS_DESC"

         ,NON.ACTNUMST "NON_REC_GAIN_LOSS"

     ,NOND.ACTDESCR "NON_REC_GAIN_LOSS_DESC"

         ,CLE.ACTNUMST "CLEARING_ACCT"

     ,CLED.ACTDESCR "CLEARING_ACCT_DESC"

     FROM FA00100 G right outer JOIN

          FA00400 A ON G.ASSETINDEX=A.ASSETINDEX  JOIN

      GL00105 DE ON A.DEPREXPACCTINDX = DE.ACTINDX JOIN

      GL00105 RE ON A.DEPRRESVACCTINDX =RE.ACTINDX JOIN

      GL00105 PR ON A.PRIORYRDEPRACCTINDX =PR.ACTINDX JOIN

      GL00105 ASS ON A.ASSETCOSTACCTINDX=ASS.ACTINDX  JOIN

      GL00105 PRO ON A.PROCEEDSACCTINDX = PRO.ACTINDX  JOIN

      GL00105 REC ON A.RECGAINLOSSACCTINDX = REC.ACTINDX  JOIN

      GL00105 NON ON A.NONRECGAINLOSSACCTINDX =NON.ACTINDX JOIN

      GL00105 CLE ON A.CLEARINGACCTINDX=CLE.ACTINDX  JOIN

      GL00100 DED ON A.DEPREXPACCTINDX=DED.ACTINDX  JOIN

      GL00100 RED ON A.DEPRRESVACCTINDX=RED.ACTINDX JOIN

      GL00100 PRD ON A.PRIORYRDEPRACCTINDX = PRD.ACTINDX  JOIN

      GL00100 ASSD ON A.ASSETCOSTACCTINDX = ASSD.ACTINDX  JOIN

      GL00100 PROD ON A.PROCEEDSACCTINDX = PROD.ACTINDX  JOIN

      GL00100 RECD ON A.RECGAINLOSSACCTINDX = RECD.ACTINDX  JOIN

      GL00100 NOND ON A.NONRECGAINLOSSACCTINDX = NOND.ACTINDX JOIN

      GL00100 CLED ON A.CLEARINGACCTINDX = CLED.ACTINDX

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Fixed Assets: What Assets Make Up What Amounts

    I derived what I needed through the following query:

    select GL00105.ACTNUMST, FA00100.ASSETID, FA00100.ASSETDESC, FA40200.BOOKID,

    FA00902.FA_DOC_Number, FA00902.GLINTTRXDATE, FA00902.AMOUNT,

    * from FA00902

    INNER JOIN GL00105 on FA00902.GLINTACCTINDX = GL00105.ACTINDX

    INNER JOIN FA00100 on FA00902.ASSETINDEX = FA00100.ASSETINDEX

    INNER JOIN FA40200 on FA00902.BOOKINDX = FA40200.BOOKINDX

    where FA00902.TRANSACCTTYPE = '7'

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans