Fixed Asset Reconcile to GL Report

(0) Share

Report

Posted on by Community Member

Hi GP Community,

I changed the GL account from the General tab, click GOTO>click Account and update the Asset Cost account but when I reviewed the Reconcile to GL report it's not updated, it is still showing the old asset cost account.

I also ran the Check Link Master Data from Financial and clear "Report Option" from Utility under FIxed Asset it's not updated the report.

Please assist.

Thanks,

Syed

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (7)

Answers (0)

Hokuminaria 2,950 on at

Like (0)

Report

Hello Syed,

With your question, are you wanting what was already posted to the General Ledger and Fixed assets to change for what activity has already been done? If so, it will not. The changes will only be reflected going forward by changing the account.

If the above is not correct, can you provide additional detail on the issue you are seeing vs what you are expecting?

Thank you!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Brandon,

Thanks for your response, The FA record entered as a master data, edit the GL account in AG and not run Posting to GL yet.

We are in process of implementing FA and I uploaded all master data and recalculated the screen to save it. When realized few of the Asset IDs attached to the wrong Account Group, and changed it, its updated the Account Group on Inquiry window as well when open the Asset ID its also updated and shows the right AG but only in the Report "Reconcile to GL" its still shows the old accounts which was attached initially.

I believe this report could you update once I ran the Reconcile to GL.

Please advice and hope I explained what is your question.

Thanks,

Syed

shasan@innergex.com

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Brandon,

Thanks for your response, The FA record entered as a master data, edit the GL account in AG and not run Posting to GL yet.

We are in process of implementing FA and I uploaded all master data and recalculated the screen to save it. When realized few of the Asset IDs attached to the wrong Account Group, and changed it, its updated the Account Group on Inquiry window as well when open the Asset ID its also updated and shows the right AG but only in the Report "Reconcile to GL" its still shows the old accounts which was attached initially.

I believe this report could you update once I ran the Reconcile to GL.

Please advice and hope I explained what is your question.

Thanks,

Syed

shasan@innergex.com

Was this reply helpful? Yes No
Hokuminaria 2,950 on at

Like (0)

Report

Hello Syed,

Thank you for your response. I greatly appreciate it!

Based on your response, i am getting that the only place you see it wrong is on the Reconcile to GL Report. Can you confirm this and provide a screenshot as well with what you are seeing vs what is wrong?

What do you see that is wrong. Is it the Fixed Assets Side or the GL Side on the Reconcile to GL? Is the report not using the new Account at all? Have you added the new Account in the Accounts section of the Reconcile to GL?

This report is going to look at what activity has already been done. If you changed the account after this activity, it will not go back and change what was already done.

If you need this to change, you will need to delete the asset and re-enter it with the correct information from the start. You can either just delete the book and re-assign it then redo any activity that was done or you can use the Delete utility. The GL would also need to be corrected if it was updated by the Asset that was deleted.

I recommend you test deleting one asset in test and re-enter it to see if that gives you desired results. If not, i will need the information above to full understand what has been done and what you are seeing.

Brandon Jarrett | Microsoft Support Engineer

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Brandon,

Thank you very much for your detail response,

The report I am referring is Financial >> Reports >> Fixed Assets >> Activity "Fixed Asset to General Ledger Reconciliation" once I made changes AG in existing Asset ID and update/change AG (Account Group) its does not update the accounts on the report.

Asset General Info and Asset Account

The Report still picked the old GL Account which was initially assigned with this Assist ID when I changed to different Account Group,

Fixed Asset to General Ledger Reconciliation report

This is the updated AG window "Electrical" which suppose to show the 221010-7122-00-000 the Asset Cost

This following window is initially assigned the AG called "ARO", please check "Asset Cost" account which still shows on the report.

Please let me know if you need more details.

Thanks

Syed

Was this reply helpful? Yes No
Hokuminaria 2,950 on at

Like (0)

Report
Hello Imirfan,

I tested the scenario provided and i get the same issue.

Once you have assigned the Book to the Asset, it creates the Add record in the FA00902.

Changing the Account in the General Window will not go and update the FA00902 record once it has been created. It will only use that account going forward.

What you will need to do is:

Delete the Asset Book.

Financial >> Cards >> Fixed Assets >> Book

Select the Asset.

Select the Book.

Click Delete

Correct anything that was pushed to the General Ledger.

You can either back out the JE or create entries to back out the amounts.

Verify the correct accounts are assigned to the Class that will be used on the Asset.

Recreate the book record.

Financial >> Cards >> Fixed Assets >> Book

Select the Asset.

Select the book.

Change any information that needs to be updated.

Click Save.

Run you report now to verify that the Account is correct.

If the above is not an option, then you will need to look at update the FA00902 and FA00905 (If pushed to GL) to reflect the correct Account Index. If stuff was pushed to the GL, then you would also need to adjust the Account Index in the GL table that is resides in as well.

I hope this helps!

Brandon Jarrett | Microsoft Support Engineer.

Was this reply helpful? Yes No
StefanieC 434 on at

Like (0)

Report

Hello,

I was searching for something and came across this. I know this is an old post but thought I'd comment in case someone else came across this.

Any time you have already added and interfaced an asset using certain GL accounts, you have an option to change those GL accounts either "going forward" or "as of point in time". To move them going forward, you use the Account Maintenance window as described above (Fixed Asset General - Goto - Accounts). This would be used, for example, if you wanted depreciation expense to start going to a new account the next time you run depreciation. If you want to move an asset historically you use the Transfer window under the Transactions menu. For instance, if you added the account to the wrong Cost account and you want it fixed from the initial date, then use this window. After entering the header information and choosing the asset on the line, you can click the expansion arrow next to Accounts and update only the accounts you want changed. It will transfer the asset based on the date you put on the transaction. The GL to Fixed Assets Reconciliation Report will now reflect this information.

Was this reply helpful? Yes No