MSDyn365FO: Setting up posting profile for Fixed assets
Often, a customer comes up with a lot of questions for a fixed assets sales entry. So, let’s see how we can set up posting a profile and see the accounting impact in the books, based on the setup.
Let’s set up fixed assets posting profile.
Step 1: Create fixed assets posting a profile
Fixed assets > Setup > Fixed assets posting profile
Step 2: Add ledger accounts for Acquisition
- Main accounts - will be the main account of assets for that group.
- Offset account - sales proceeding account (cash or any asset account)
Step 3: Add ledger accounts for Depreciation
Step 4: Add ledger accounts for Disposal - sale
Step 5: Add disposal accounts for sale
Additional to ledger accounts, we need to assign disposal accounts for sales
- Depreciation (prior year)
Main account – Accumulated dep (This entry will adjust accumulated depreciation for previous year)
Offset account – Gain/loss account
- Depreciation (This year)
Main account – Accumulated dep (This entry will adjust accumulated depreciation for current year)
Offset account – Gain/loss account
- Acquisition value
Main account – Asset account (This entry will adjust the Acquisition value of an asset)
Offset account – Gain/loss account
- Net book value
Main account – Gain/loss account (This will adjust Net book value of an asset)
Offset account – Gain/loss account.
Now, let’s see the example with accounting impact
Acquisition |
1500 |
Depreciation |
-281.94 |
Sale |
-1000 |
Profit/loss |
-218.06 |
Acquisition entry
Depreciation entry
Sales entry
Below are the ledgers, that’s impacted based on the accounting transaction
Ledger 10005 (FA proceeds) 1 |
Debit |
Credit |
Sales value |
1000 |
|
Total |
1000 |
|
Ledger 13000 (Main asset) 2 |
Debit |
Credit |
Sale of main asset |
|
1500 |
Acquisition entry |
1500 |
|
Total |
1500 |
1500 |
Ledger 14000 (Accumulated dep) 3 |
Debit |
Credit |
Depreciation reversal |
281.94 |
|
Initial depreciation entry |
|
281.94 |
Total |
281.94 |
281.94 |
Ledger 32000 (P&L acc) 4 |
Debit |
Credit |
To adjust sales |
|
1000 |
This is to adjust Net book value |
|
1218.06 |
This entry is to adjust Accumulated dep |
|
281.94 |
This is to adjust Net book value |
1218.06 |
|
This is to adjust asset purchase |
1500 |
|
Difference amount is loss |
|
218.06 |
Total |
2718.06 |
2718.06 |
That’s it for the post. Thank you
*This post is locked for comments