Pages

Sunday, September 28, 2014

Adding Fixed Asset from Purchase Order Processing (Multiple Assets per Shipment)

In a previous post, adding fixed asset from the Payable Management has been thoroughly illustrated. Although, this is not efficient in case you want to add multiple assets. Suppose you want to define a hundred computers, if you go through the AP process then you will post one hundred invoices ! Alternatively, you can consider another approach by adding several line items on the Receiving Transaction Entry window.

Adding FA-POP Chart

Again, it is a common mistake that the “Purchase” process is directly applied from the Fixed Asset module. The truth is, the invoice (Receiving or AP invoice) initiate the process and specifically the distribution accounts.

Receiving Transaction Entry

The first step is to create a receiving transaction entry with several line items. Go to Transactions > Purchasing > Receiving Transaction Entry window.

  • Choose the vendor ID
  • Enter the vendor document number
  • Enter the document date
  • On the line items grid, enter as many line items as required which will be created later on as assets on the fixed asset module.

Receiving Transaction Entry - FA

For each line item, you have to consider the following options:

  • The item filled in this line is a non-inventory item, which means that it should not have be defined on the item card maintenance window
  • In order for the item to be considered as a FA, you should check the “Capital Item” option. To do so:
    • Place the mouse cursor on the line item
    • Click the arrow highlighted in the screen show below to reach the Receiving Item Detail window

      Receiving Line
    • Now on the receiving item detail window:

Receiving Line Item Details  

 

Helping Note !
On the example above, we have included a quantity received of (5) for the first line item. When clicking the “Capital Item” checkbox, the system will consider the 5 pieces as one asset. If you want to split the 5 pieces into five assets, click on the arrow next to the “Capital Item” to reach the FA PO Additional Information.

The Fixed Asset clearing account is an offset account which is used between the Purchasing and Fixed Asset module. It should be setup first  on Microsoft Dynamics GP> Tools > Setup > Fixed Asset > Purchasing Posting Account.

FA Po Additional Details

The final step is to check the document distribution and make sure that the “Fixed Asset Clearing” account number is included under the “PURCH” distribution line. Then, you can proceed with posting the receiving transaction once all the line items are configured accordingly.

Receiving Distribution

 

Fixed Asset – General Information Window

As you move on to the Fixed Asset window, the “Purchase” button will be activated indicating that there are pending purchases to be defined as assets. In my example above, the first line item was checked to split quantity received into multiple assets.

Go to Cards > Fixed Asset > General

05 

06

You will have to add the assets one by one and they will inherit any FA details that were defined initially on the receiving transactions along with the acquisition cost.

Then, you will have to move on with the usual cycle of FA GL Posting, then General Ledger posting which have been thoroughly illustrated on the previous post Adding Fixed Assets from Payable Management

Best Regards,
Mahmoud M. AlSaadi

20 comments:

  1. I am not getting Purchases field on Asset General Information window , what is it I am missing?

    ReplyDelete
  2. Okey got it, it says for purchase exist in work for the asset, posted the receipt and it's appearing. :)

    ReplyDelete
    Replies
    1. Hello Almas
      It seems I have missed the track for your question, I have just noticed it along with the answer ;)

      Best of luck,
      Mahmoud M. AlSaadi

      Delete
  3. yeah it's the charm of great Saadi, that answer come to me itself. :P
    Nice Post(Y)

    ReplyDelete
  4. how do i activate the select button in the fixed asset purchasing transactions window? which setups do i need to do?

    ReplyDelete
    Replies
    1. Go to Microsoft Dynamics GP > Tools > Setup > Fixed Assets Setup > Company

      Under Purchasing Options, Make sure that POST POP through FA is checked.
      Under which, choose by Receipt Line (and include matching invoice)

      Best Regards,
      Mahmoud M. AlSaadi

      Delete
  5. Hi,

    I tried this but still the select button did not activate.

    Go to Microsoft Dynamics GP > Tools > Setup > Fixed Assets Setup > Company

    Under Purchasing Options, Make sure that POST POP through FA is checked.
    Under which, choose by Receipt Line (and include matching invoice)

    -any suggestions? thank you

    ReplyDelete
    Replies
    1. Let me clarify, are you talking about the "Select" button in the Fixed Asset Purchasing Transactions ? Or the "Purchase" button on the Fixed Asset Maintenance Window ?

      IF the purchase button appears, then you will have to provide an Asset-ID before clicking on the Purchase, and then the Select will be active.

      Never hesitate to share any further inquiries,

      Best Regards,
      Mahmoud M. AlSaadi

      Delete
    2. Dear Mahmood Your contribution to Dynamics GP community are highly valuable. In my case there is no capital item field is appearing in the Receiving items detail entry window.
      Why is this happening.
      Regards
      Rashid Anwar

      Delete
  6. Does anyone know if, when you delete an asset using the Delete utility, the item will re-appear in the purchase dropdown in the General window?

    ReplyDelete
    Replies
    1. Hello Alex
      No, it will not appear.

      Best Regards,
      Mahmoud M. AlSaadi

      Delete
  7. Hello Mohamood,
    I am so close to being able to use this wonderful feature but, I cannot make the Capital Item Checkbox show up on the
    Receivings Item Detail form. I have reviewed the FA setup and made sure it was correct. I am using(trying to setup) GP 2016.

    Best regards,
    John Forma

    ReplyDelete
    Replies
    1. Well it looks like there is a step needed for my setup which is,
      You have to make sure that the item that you are targeting to be a FA needs to be on the Receivings Item Detail Entry form. When I tried it it didn't carry over from the Receivings Transaction Entry form. I added the item to the RIDE form and the Capital Item option showed up.

      Thanks, John

      Delete
    2. You do need to make sure that all of the steps above are followed in details.

      Please let me know if you have got any further inquiries or concerns.

      Best Regards,
      Mahmoud M. AlSaadi

      Delete
  8. In my case, Invoice voided, but item still appear in FA purchase section. any idea?

    ReplyDelete
  9. Hello everyone I want to introduce you guys to a group a private investigators who can help you with information you need in any situation in life and they are ready to follow you step by step until your case is cleared just contact +17078685071 and you will happily ever after

    Premiumhackservices@gmail.com

    ReplyDelete
  10. There are many definitions of "asset management", although most deal primarily with financial considerations. Some are based on evolving maintenance management systems; some on the management of factory floor equipment configurations; and some for the purposes of monitoring network equipment or even railway car and container locations. Andrew Fanelli

    ReplyDelete
  11. I would like to get Item Number and description from PO window to FA General screen. Is it possible?

    ReplyDelete
  12. In the PO >> Item detail entry window the moment I mark the capital item check box, is there any way to setup in GP to pick the FA clearing account automatically?

    ReplyDelete
  13. We have a scenario like we will be buying same item frequently, can I setup a master for user to pick it, so they do not need to enter description every time in PO line screen ?
    If I setup those as inventory items then stock is increasing in inventory module, I am not expecting this.

    ReplyDelete