Adding Additional Cost to an Existing Fixed Asset

A laptop is purchased at $4,800 on 1^st March 2020. The depreciation method is Straight-line for over 4 years.

On 31 March 2020, the depreciation was calculated as: -

(Asset Cost/Useful Life)/Monthly Depr.

(4800/4)/12=100

Run the Projected Value report to view the calculated future depreciation and book value.

On 12^th April 2020, an invoice was posted for upgrading the laptop spec with additional RAM, the invoice amount is $480.

12 Days of depreciation (from 1/4/2020 to 12/4/2020) for the existing asset is calculated as: -

(Monthly Depr./30 Days)*Number of Depreciation Days

(100/30)*12=40

12 Days of depreciation (from 1/4/2020 to 12/4/2020) for the additional cost on existing asset is calculated as: -

(Monthly Depr./30 Days)*Number of Depreciation Days

(10/30)*12=4

To account the depreciation for the additional asset cost into the 1^st depreciation in March’20, you will need to select Depr until FA Posting Date and Depr. Acquisition Cost check box together on the Fixed Asset G/L Journal before posting, the following calculation is made:

The additional acquisition cost is depreciated by

Mar’20 Depreciation + April’20 Depreciation

Without select the Depr. Until FA Posting Date and Depr. Acquisition Cost check box, the asset would lose March’20 depreciation and the 12 Days of depreciation, because when the Calculate Depreciation batch job run on 30/4/2020 would only calculate the depreciation from 13/4/2020 to 30/4/2020.

Once the additional cost is posted, when Projected Value report is run, it should show the remaining 18 Days of $66 depreciation for the April’20.

The full details of the activity can be found in FA Ledger Entries.

Comments

Foreign Currency Revaluation in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central (BC) allow users to account for foreign currency transactions. BC also able to translate the registered foreign currency amount into functional currency that setup in the entity using the conversion rates which setup in Exchange Table. Due to the exchange rates fluctuate constantly, as a dollar worth in foreign currency today might not equivalent to the same foreign currency worth the next day. Hence, users are required to adjust the open documents that transact in foreign currency which include open invoices, credit memos, and advance payments. Once the open documents transacted in foreign currency is revalued, the gain and loss which calculate after comparing the closing rates at the period end will be posted to profit and loss as unrealised gain and loss, ensuring that the subledgers and general ledger can be reconciled. This process can be done using Adjust Exchange Rate in BC, a batch job to adjust the exchange rates fo...

How to Reverse Posted Documents in Business Central

If you need to amend or change a posted documents in Business Central, there are few ways to do it instead of having you to manually create a reversal journal or Credit Memo to rectify a Posted Document. Before you proceed to Correct or Cancel any document that posted in Business Central, you need to identify the origin of the posted document, as the method of cancellation depends on the document type. There are 2 types of documents that posted in Business Central. i. Journals – E.g., General Journals, Purchase Journals, Payment Journals, Sales Journals, Receipt Journals etc. ii. Documents – E.g., Purchase Invoice, Purchase Credit Memo, Sales Invoice, Sales Credit Memo etc. A. A. C orrecting ...

How to Change Item's Based Unit of Measure in Business Central

It is quite frequent that user need to change the existing based unit of measure of an item to another scale in order to fit the operation requirement. But do take note that once there is remaining quantity in the item, an error message will pop up to prevent user from changing the unit of measure in Item Cards. Refer to the following scenario where the user need to change one of the item, from "Box" to "Pcs" with quantity still sitting in it. User will need to setup a UOM conversion where 1 "Box" of Apple is equivalent to 50 "Pcs" of Apple. 1. You will need to perform an negative adjustment on the item quantity. Generate the Inventory Valuation Report to c onfirm the total quantity that need to adjust out. This is to make sure that the adjustment will not impact the item valuation after the quantity adjustment, as it should remain the same value before and after the adjustment. Report Path: Search > Items > More Options > Report ...

Microsoft Dynamics 365 Business Central Self-Help Place

Search This Blog