Skip to main content

Change of Fixed Asset Useful Life in Dynamics GP

1.       Suppose an asset assigned with 5 years of useful life and depreciation has been performed since the asset is bought. According to the company depreciation policy, it need to change to 3 years and the depreciation need to be recalculated from the beginning of the Fixed Asset calendar year through the dates that the asset has already
been depreciated.

2.       In the Asset Book, change the number of years in <Original Life Year, Days>. Click <Save>.

3.       In the following message, select [Yes].

Extract from Microsoft Dynamics GP's Help
When you change a depreciation-sensitive field in the Asset Book window in Microsoft Dynamics GP, you receive the following message:“You have changed a depreciation sensitive field. This will result in depreciation values being recalculated. Do you wish to continue?”You will receive this message because depreciation amounts must be recalculated when a depreciation-sensitive field is changed for an asset. When you click Yes, the following options are available:•Life•Year•Recalculate 

         [Life] The Life option recalculates depreciation beginning with the Place in Service date through the dates that the asset has already been depreciated. If depreciation amount adjustments are needed for any period, the adjustments will update the Financial Detail file. Prior year depreciation amounts are posted to the current fiscal year to the prior year depreciation account. Prior year deprecation amounts do not post to the prior year. 

         [Year] The Year option recalculates depreciation from the beginning of the Fixed Asset calendar year through the dates that the asset has already been depreciated. If depreciation amount adjustments are needed for any period, the adjustments will update the Financial Detail file. 

         [Recalculate] The Recalculate option calculates a new rate of depreciation by using the new cost basis. The Recalculate option does not make adjusting entries for depreciation amounts already taken. The system will use the new rate of depreciation the next time that the depreciation routine is run.

4.       In the following message, select [Year]. This option will allow the depreciation to be recalculated from the beginning of the Fixed Asset calendar year through the dates that the asset has already been depreciated. Then select [Yes] to close the window.


5.       To update the general ledger, post the transactions that have not been posted yet. (Microsoft Dynamics GP menu >> Tools >> Routines >> Fixed Assets >> GL Posting)
In the Fixed Assets General Ledger Posting window, specify the Period field for the transactions that have not been posted, enter the required information, and then click Process.

6.    Post the Fixed Assets batch to the general ledger.
(Transaction > Financial > Batches)

Comments

Popular posts from this blog

Reprinting GP Posting Journal after Posting in Dynamics GP

As there is no shortcut to reprint the posting journal from one screen, you need to know the original screen location. Financial and Bank 1. To reprint General Journal entries.      Path: Reports > Financial > Cross-Reference > Select "Journal Entries"             Take note that the document printed from here will include transaction posted from other source too like Payables, Receivables, and Fixed Assets and etc. 2. To reprint Bank Posting Journal/ Bank Recon Reports      Path: Reports > Financial > Bank Posting Journal Sales Order Processing and Receivables 3. To reprint Sales Transaction Entry      Path: Reports > Sales > Posting Journal > Select "Sales Posting Journal" 4. To reprint Receivables Entry      Path: Reports > Sales > Posting Journal > Select "Receivable Posting Journal" 5. To reprint Cash Receipt Entry      Path: Reports > Sales > Posting Journal > Select "Cash Receipt Posting Journal" Pu

GP How to Reconcile Payable/ Receivable Ledger to General Ledger Control Account using "Reconcile to GL"

The “Reconcile to GL” tool helps you find differences between Payables Management (and GL) and Receivables Management (and GL) automatically by coming out a report. The Rule of Thumb, GL balance for the AP Control Account should match up with the total on the Payable Ledger report and the GL balance for the AR Control Account should match the total on the Receivables Ledger report.  "Reconcile to GL" will match each transaction between GL and Sub-ledger based on the setup account and posting date.  Any transactions that don’t match and users have to start digging through detailed transactions to see what went wrong, “Reconcile to GL” can be helpful in this scenario. To perform Payable/Receivable Reconciliation Path: Microsoft Dynamics GP > Tools > Routines > Financial > Reconcile to GL     1.       Type in your date range.     2.       Select “Module”, either Payable Management or Receivable Management.     3.       Put in all your A/P or A/R account number.     

How to Create Recurring Transaction in Dynamics GP

If you have a handful of journal entries to be created in regular basis, whether for  numerous accruals and reversals,  allocation, or reclassification entries, setting up Recurring Transaction in Dynamics GP will be helpful and speed up your month end process. Step 1 - Setup Recurring Batch Path: Transaction > Financial > Batches  i.    After entering the " Batch ID " and " Comment ", setting up the " Frequency " is the most important part for recurring transaction. " Single Use " is the one we use all the time for single posting, once posted, the batch will remove from Batch ID. But if you set the Frequency to " Monthly ", which means the batch automatically becomes a recurring batch, the batch will be there forever for multiple posting. ii.    There is another useful option here, " Clear Recurring Amounts ", which will clear the amounts in journal entries after the posting. You can then later enter the amount in the j