Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Najeem JanatAli]

Hi All

Below is the fixed asset (FA) Disposal sale parameter posting set up:

Computer	Depreciation (prior years)	160120	150120
Computer	Depreciation (this year)	160120	150120
Computer	Net book value	150120	150120

where account # 150120 is ?Computer  cost & 160120 is accumulated dep-Computer  

Assets are disposed off at NBV

Posting work perfectly in subleger but now GL balance is not agreeing with FA sub ledger

Another question is in the report: FA movement report, there is field credited named Profit/loss $$$, but there is no impact on P&L as FA was disposed off on NBV, not sure where this heading P&L make impact

Please advise is this posting set up is incorrect or GL to be adjusted manually

Thanks and kind regards

——————————
Nazim Lalji
Dynamics AX Analyst

——————————

[Ludwig Reinhard]

Hello Nazim Lalji,
In regards to your difference between GL and FA:
Can you check whether some manual postings have been made on the FA summary accounts that are setup in your FA posting profile?
Also make use of the GL reconciliation reports – in your case the transaction origin report – that can help you identifying differences between GL and the other subledgers.
About the P&L posting:
What will be posted when you sell fixed assets depends on the fixed asset posting profiles. It is possible that you simple post the sales revenue and expense the NBV without posting the profit/loss from the sale separately on a specific ledger account. Per se, there is nothing wrong if you do not have a specific posting on a profil/loss account for fixed asset sales. However, it is of course better splitting up the sales related postings when selling fixed assets but this depends on your company’s requirements.
Best regards,
Ludwig

——————————
Ludwig Reinhard
Sycor
Goettingen
——————————
——————————————-

[Najeem JanatAli]

Hi Ludwig

thanks for your quick response, here are the responses to your email

-there is no manual posting to FA

-under GL recon reports. couldnt find GL recon report for FA, please can you share the screen shot or path

-So far we dont have any sale of FA, thats why no parameters are set up for Gain and loss on FA

please feel free to let me know any queston

thanks and kind regard

——————————
Nazim Lalji
Dynamics AX Analyst

——————————
——————————————-

[Ludwig Reinhard]

Hello Nazim Lalji,
There is no standard FA-GL reconciliation report available.
You can, however, make use of the transaction origin report to identify differences between FA and GL.
Alterantively, the voucher transaction form can help identifying the root cause of those differences by filtering the transactions on account, posting type and transaction type.
Best regards,
Ludwig

——————————
Ludwig Reinhard
Sycor
Goettingen
——————————
——————————————-

[Daren Phillips]

It looks like your account postings are incorrect for the net book value posting.  You selected the Asset account but you also selected the Asset account as the offset account.  You should have taken this to the Gain / (Loss) on FA Disposal.  It looks like you wrote off the asset but posted it back to the asset account.

——————————
Daren Phillips
Manager
RSM US LLP
Dallas TX
——————————
——————————————-

[Najeem JanatAli]

Hi Daren

Please can you suggest the posting profile set up for disposal

Assets are disposed off at NBV, there is not gain / loss

Looking forward to hear from you

thanks and best regards

——————————
Nazim Lalji
Dynamics AX Analyst

——————————
——————————————-

[Daren Phillips]

You should use a posting profile like the what is shown below:

You should use a posting profile like the what is shown below:

                                                                      Main Account                   Offset

Depreciation (This Year)                               15500                                  15100

Depreciation (Previous Years)                      15500                                  15100

Depreciation Adjustment (This Year)            15500                                  15100

Depreciation Adjustment (Prior Years)          15500                                  15100

Net Book Value                                              15100                                  87000

 

15500 Accumulated Depreciation

15100 Fixed Asset

87000 Gain / Loss on Disposal of Fixed Assets.

——————————
Daren Phillips
Consulting Manager
RSM US LLP
Dallas TX
——————————
——————————————-