Featured Post

Dynamics GP 2019 is now Released

It is now released, Microsoft Dynamics GP 2019 which moves the system to the modern product life cycle   " Beginning with the October...

Sunday, December 27, 2015

Pending Fixed Assets Purchases Report



After adding fixed assets from Purchase Order Processing or Accounts Payable, a card should be created from the Asset General Window. This is listed under the "Purchase" button on Asset General Information window as shown below:

Asset General Information - Purchase

>> Important Note !
The steps on how to proceed the fixed asset purchase cycle is illustrated on the links above, which includes either Purchase Order Processing in order to add multiple assets, or Accounts Payable to add an asset solely.

If you click on the Purchase Button shown on the Asset General Information, the Fixed Assets Purchasing Transactions window will open up, which lists all the pending vouchers with all associated details.

Asset General Information - Purchase List

This post provides an SQL view including all pending purchased assets, it will either clears out or remain after adding the assets, which is dependent on the purchasing transaction option in the Fixed asset setup window.

Fixed Asset Setup Window- Purchasing Transactions Options

The SQL view below shows the detailed list of these pending assets, some of these information is illustrated in the image below:

Report Sample

The script can be downloaded from >> Download Link


       CREATE VIEW FA_GPEssentials_PendingFAPurch
       AS
       SELECT  VENDORID VendorID,
                     DOCNUMBR DocumentNumber,
                     DOCDATE DocumentDate ,
                     ORCTRNUM ReceiptNumber,
                     PORDNMBR PO_Number,
                     Purchased_Quantity ,
                     ASSETID AssetID,
                     SHRTNAME ShortName,
                     ASSETDESC Description,
                     EXTASSETDESC Extended_Description,
                     Master_Asset_ID ,
                     STRUCTUREID StructureID,
                     ASSETCLASSID ClassID,
                     LOCATNID LocationID,
                     ACQDATE AcquisitionDate,
                     Acquisition_Cost ,
                     Orig_Acquisition_Cost ,
                     CASE ASSETTYPE
                       WHEN 1 THEN 'New'
                       WHEN 2 THEN 'Used'
                       WHEN 3 THEN 'Leased'
                       ELSE ''
                     END AS AssetType ,
                     ASSETQTY AssetQuantity ,
                     ASSETYTDMAINT ,
                     ASSETLTDMAINT ,
                     LASTMAINTDATE ,
                     ASSESSEDVALUE ,
                     CUSTODIAN Custodian ,
                     DATEADDED Date_Added ,
                     Physical_Location_ID ,
                     Asset_Label AssetLabel ,
                     CURNCYID CurrencyID ,
                     TRXSORCE TransactionSource
       FROM    FA01100
       GO



Best Regards,
Mahmoud M. AlSaadi

1 comment:

  1. BE SMART AND BECOME RICH IN LESS THAN 3DAYS....It all depends on how fast 
    you can be to get the new PROGRAMMED blank ATM card that is capable of
    hacking into any ATM machine,anywhere in the world. I got to know about 
    this BLANK ATM CARD when I was searching for job online about a month 
    ago..It has really changed my life for good and now I can say I'm rich and 
    I can never be poor again. The least money I get in a day with it is about 
    $50,000.(fifty thousand USD) Every now and then I keeping pumping money 
    into my account. Though is illegal,there is no risk of being caught 
    ,because it has been programmed in such a way that it is not traceable,it 
    also has a technique that makes it impossible for the CCTVs to detect 
    you..For details on how to get yours today, email the hackers on : (
    atmmachinehackers1@gmail.com ). Tell your 
    loved once too, and start to live large. That's the simple testimony of how 
    my life changed for good...Love you all ...the email address again is ;
    atmmachinehackers1@gmail.com

    ReplyDelete