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.


Comments

Popular posts from this blog

How to Correct Dimensions in Business Central

  It is quite common that users might find out that some entries might mistakenly charge to wrong dimension, which will cause inaccurate financial reporting and analysis. The classic method of rectifying this type of error is to create a manual general journal entry to reverse it. One of the popular features which available in Business Central is “ Correction Dimension ” where it allows you to correct the dimension values in General Ledger Entries age in a simple way.     Important Note 1 : Dimension Correction apply only G/L entries. They do not change the dimensions that assigned in other ledgers for the same transaction. There will be mismatch between the dimensions assigned in the general ledger and the sub-ledgers. Important Note 2 : If you need to do Dimension Correction in a large scale, say more than 100 transactions, it is advised to schedule or perform during the non-peak hours as it may cause Table Locking during posting of other transactions by other use...

Why business central fixed asset depreciation amount is different from my calculation

  Upon data migration to Business Central, customers often wonder why the monthly depreciation amount is different from their calculations. The only explanation we've identified so far is that the data provided for the migration inadvertently caused either over- or under-depreciation of depreciation amounts. The following example illustrates how BC's depreciation amount will differ from your calculated amount.           1.        The following asset was migrated to BC with the cut-off date till 31 st August 2022.           2.        You can print the Projected Value report to check on the future depreciation and book value of the asset. Page: Projected Value           3.        According to your book, the trend of monthly depreciation from now until December 31, 2022 is $1,000, but BC is recording ...

Intercompany Setup in Business Central

Before you able to create a Sales Invoice or Purchase Invoice to your intercompany partners, there are some configurations need to complete in between the company you administer and the company your partner is managing.      1.        Setup Intercompany Partner Code   This setup will allow the system to differentiate which entity under the same Business Central should the invoice direct to. The Intercompany Partner Code should be unique and agreed upon by all companies. Page:  Intercompany Setup i.           Enable the “Auto Send Transactions” which allows system to send out to intercompany partner once there is transaction posted.     2 .        Setup Intercompany Partners Code This setup will configure the intercompany partners that will involve in the whole intercompany setup in BC. In another word, you will need to create a Intercompany...