Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Sharon Hine]

?Hello,

I am looking for a report or Smartlist configuration that will provide the data in the Fixed Assets General Ledger Zoom window (see below). 
I need to start with the FATRX batch and summarize by Asset ID to determine whether the correct depreciation has been taken for each asset.  We have a Fixed Assets expense GL anomaly that cannot be explained by any of our direct entries – so something must be off with one of the FATRX depreciation transactions.

Thanks for any help you can give,
Sharon

——————————
Sharon Hine
Manager, Program and Financial Systems
CANARIE Inc
Canada
——————————

[Matthew Arp]

I would try this SL configuration and see if it provides you with what you need.

——————————
Matthew Arp
Business Systems Developer
Hunton Group
Houston TX
——————————
——————————————-

[James Hummer]

?Hey Sharon

You can also use BI360 in which we just added a FA to GL Reconcile View.   Note BI360 Report Composer is now Free.    Just sign up here.   

https://register.gotowebinar.com/register/1997299541128818691

Dynamics GP FA to GL Reconcile – Community Forums

Solverglobal		remove preview
Dynamics GP FA to GL Reconcile – Community Forums View this on Solverglobal >

——————————
Jim Hummer
Consultant
Solver
Los Angeles CA
——————————
——————————————-

[Windi Epperson]

Sharon,
If you’re looking at specific assets, then maybe start with the InquiryFinancial Detail window.  You can set some parameters in there and then when you print you get a decent report by asset.

If you’re looking for a group of assets, then you might try the FA to GL reconcile report.  It’s under FinancialReportsActivityFixed Assets to General Ledger Reconciliation.  You can put date and asset parameters on it if you’d like.

Thanks
Windi

——————————
Windi Epperson
President/GP Senior Consultant
Advanced Integrators, Inc.
Norman OK
405-946-1774 Ext 102
——————————
——————————————-

[Sharon Hine]

?Thank you all.  Your suggestions helped me find the problem.

Cheers,

Sharon

——————————
Sharon Hine
Manager, Program and Financial Systems
CANARIE Inc
Canada
——————————
——————————————-

[Kimberly Lomax]

Glad you found your issue.  We have a SmartList that we use quite a bit when researching the GL transactions.  You may find it useful for future reference.

——————————
Kimberly Lomax
Manager, Financial Systems
Rayonier
Jacksonville FL
——————————
——————————————-