web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Dates for creating new asset record

(0) ShareShare
ReportReport
Posted on by

Hi,

I need to record an asset acquired in previous year. If I use the actual invoice date (purchase date) as acquition date in fixed asset register, will I be able to post journal for depreciation of prior year in current year?

For example, asset was acquired in period 9 last year but paperwork is only received in period 3 this year. If I use purchase date xx/09/2014, will a journal be created for depreciation for Period 9, 10, 11 and 12? Can I post the journal in current year? Will journal batch fail to be posted as last year has been closed?

Is there any difference of "Acquisition Date" and "Place in Service Date" in Fixed Asset Register?

Thanks,

Rachel

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Redbeard Profile Picture
    12,931 on at

    Rachel,

    My experience is, it is possible to enter an asset with a historical "Acquisition Date," and depreciate it up to the current period and post the entry into the current period.

    You can also run the depreciation and GL Interface period by period, to post into prior periods, even in a closed year, if the financial module is not checked as closed in fiscal period setup (and posting in the year is still possible)

    I would recommend setting up a test database to validate this, prior to implementing it in your production database.  

  • Suggested answer
    Mahmoud Saadi Profile Picture
    32,738 on at

    Hello Rachel

    I believe that this is a practical case that occurs quite often, nothing new or unusual about it.

    Initially, allow me to distinguish between three different date; which are the keys to the process of adding an asset from the purchasing module.

    1- Payable | Invoice Date: the date of the payable invoice based on which the liability of the company will be calculated. The due date will be calculated according to the document date as well, and more importantly the GL posting date (taking your setup into consideration)

    2- Fixed Assets | Acquisition Date: it is simply the date at which the asset was acquired (regardless of the depreciation calculation and details). When adding an asset from the Purchasing module, the acquisition date will default from the payable invoice date explained above.

    3- Fixed Asset | Place in Service Date: which is the driver for your depreciation calculation, based on which the depreciation amounts are calculated regardless of when the asset was acquired. So if you acquire an asset at 01/09/2014, the place in service data can simply be changed to 01/01/2015, and the depreciation of this asset will calculate starting from the place in service data accordingly.

    Now back to your case, we all agree that the invoice date is xx/09/2014. and the Acquisition date will be xx/09/2014 as well. For the place in service date, you are the one that should know when the asset should start depreciation, and here I suppose two different scenarios

    Scenario One

    The asset should start depreciation from 01/01/2015. Therefore, you may simply change the place in service date to 01/01/2015.

    Scenario Two

    The asset should start depreciation from xx/09/2014, but the GL journals should be posted in 2015. In this essence, put the place in service date as xx/09/2014.

    To generate the journal at the current year, change the posting date of the (GL POSTING) window (Microsoft Dynamics GP > Tools > Routines > Fixed Assets > GL Posting). The date at this window determines the posting date of the associated journal entry in the GL level. Here is a screen shot for the FA GL posting window and the associated date:

    For further information, you may refer to the following detailed posts on how to add assets from the purchasing and payable module on a step by step bases

    Adding Fixed Asset from Payable Management

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

    Your feedback is highly appreciated,

  • Verified answer
    Community Member Profile Picture
    on at

    Thanks Harry.

  • Community Member Profile Picture
    on at

    Thanks Mahmoud.

    What if the journal batch for depreciation is accidently deleted? There will be variance between LTD accumulated depreciation in Fixed Asset Module and G/L. Do I have to do a manual general journal to fix? Or there will be some steps I can do in FA module to re-create a journal batch?

    Regards,

    Rachel

  • Verified answer
    Mahmoud Saadi Profile Picture
    32,738 on at

    Hello Rachel

    Well, there is definitely a solution to that, and you will not be doing it manually :)

    Technically speaking, the Fixed Asset GL posting has a staging area at which the lines are prepared for being posted to GL, they got a flag to indicate at which status they are. So if you mistakenly deleted the batch, you will have to manually change this status on the SQL level. This has been thoroughly illustrated by Mark Polino in his Weekly Dynamic: Rerun FA GL Post Routine

    Please let us know if you have any further inquires,

    You may kindly be asked to close the thread once it is fully fulfilled and just in case you don't have any further concerns,

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans