Skip to main content

How to Record Disposal of Fixed Asset and Acquisition in the same time (Trade-In) Business Central

 

A company is going to acquire a new car for $100,000. However, the supplier agrees to give a discount of $5,000 if the company agree to trade-in an old car with the new car. The cost of the old car is $ 120,000 and accumulated depreciation of $ 112,500.

It means the company sells an old car for $ 5,000 and buys a new car that costs $ 100,000. They end up paying $ 95,000 only. The total loss of disposal will be as follows: -

Loss from disposal = $ 5,000 – ($ 120,000 – $ 112,500) = $ 2,500

Account

Debit

Credit

New Vehicle

100,000

Accumulated Depreciation – Old Vehicle

112,500

Loss on disposal

2,500

Fixed Assets – Cost of old Vehicle

120,000

Cash

95,000

Business Central able to capture the activities without hassle.


    1.       To record the Disposal of asset with a loss

Page: Sales Invoice

i.                     You can select the customer that the fixed asset is selling to and select the fixed assets that you are disposing.

ii.                   The Amount will be the discount amount that the supplier is offering for the asset trade-in. 

           


iii.             Checking in Preview Posting, the accounting entries will be as per screenshot below. The old asset cost and accumulated depreciation is reversed, and loss of disposal is recorded.

iv.               You may print the Sales Invoice/Tax Invoice from this page as source documents.

v.                 Post the sales invoice once details are recorded according to the agreed terms.




    2.       To capitalise the new asset to Fixed Asset during the Trade-In

 

Page: Fixed Asset Card

i.                     Create the new asset detail for the new asset in Fixed Asset card



Page: Fixed Asset G/L Journals

i.                     Record the Fixed Asset Cost with the original acquisition cost.

ii.                   In the next line after the acquisition cost, enter the discount of the new asset for the trade-in of old asset. Note that the Account Type here will be the “Customer”, the supplier that offering discount for the old asset trade-in.

iii.                 Following with the next line will be the balance amount of the acquisition after the discount. The Account Type here will be the “Vendor”, the supplier that you purchase the new asset from.



iv.                     Check the accounting entries for this transaction from Preview Posting.

v.                       Proceed to post the entry in Fixed Asset G/L Journals.



vi.                     The balance in receivable in “AR Aging” should be offset after the posting.



 vii.                     The amount payable after the discount will be as follows in “AP Aging”.



viii.                     Do remember to change the old asset status to “Inactive” in Fixed Asset Card.


Labels:

Comments

Post a Comment

Popular posts from this blog

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 ...
Post a Comment
Read more

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...
Post a Comment
Read more

Disposal of Fixed Asset in Business Central

You can perform Fixed Asset Disposal in Business Central in Fixed Asset G/L Journals . The reason for performing fixed asset disposal may be result of several events: i.                       An asset is fully depreciated and must be disposed of ii.                        An asset needs to be removed due to unforeseen events (EG., theft) iii.                     An asset was captured with wrong information and need to be reversed   In the following example here, the user has registered the asset in the fixed asset book, and there is depreciation being perform too, but later identified that the asset was registered with wrong date. It will be easier to dispose this asset and capture again using new Fixed Asset ID...
Post a Comment
Read more