When reconciling the sub-module Fixed Assets Current Deprecation to what posted to the General Ledger Fixed Assets Current Depreciation . The General Ledger is showing a higher amount. What would cause the amount to increase on the General Ledger side?
Looking for a report that would assist with finding the difference.
Current Build of Microsoft Dynamics GP 2010 SP3
Regards,
Kevin
*This post is locked for comments
Kevin,
We just ran into the same problem. The Depreciation Ledger report printed fine until the depreciation entry was posted. After that all fully depreciated assets show up with $0 Current depreciation, causing the report to show less than the GL. As you found the Depreciation Expense to GL report shows the right amount.
We are unable to get the Depreciation Ledger report to match the GL after posting. When we specify a date it picks up assets that don't even have current depreciation.
I don't understand this behavior and have no explanation for it - but it sure looks wrong!
Thank you both for getting back to me.
Here is what I am able to figure out.
The Report Depreciation by Class was not reflecting the full amount of the Current Depreciation, but the Accumulated Depreciation was accurate on this report.
When reviewing the Depreciation Expense to General Ledger report that is showing the correct figure that flowed into the General Ledger.
The Depreciation by Class when selecting the ranges doesn't allow you to select by GL account number. In this situation it seems to be missing some assets for the current Depreciation amount.
Regards,
Kevin
Kevin, we can't tell you without more information. As I asked in my previous post, what is the amount of each of the two entries in the Depreciation Account in August?
The Depreciation Expense account for the Month of August only has two entries. Both of these entries show that they originated as FATRX as the source.
What I am looking for is a reason the General Ledger is showing a higher number then what the Fixed Asset module is stating from the Depreciation Ledger by Class Report.
The FA Posting Journal shows the same amount as the Depreciation Leger by Class.
In SmartLists > Financial > Account Transactions setup a search to identify all the transactions for your depreciation account for the period(s) you are having a problem with - make sure you add the Source Document column. Anything without an FA source document type originated outside the Fixed Asset module. If there are transactions for this account without a Source Document type of FA, then you will likely have identified the problem transactions.
If you require detailed instructions on how to setup this SmartList, let me know.
What is the amount of each of entries posted to the account in August?
The Detail Inquiry window for the Depreciation Account from the Financial Module is showing 14,000.00. Which is higher then what the Fixed Asset module is stating from the Depreciation Ledger by Class Report for the month of August.
The Report from Fixed Assets is stating 13,552.00
Trying to understand what would cause a higher figure on the general ledger side.
Regards,
Kevin
So the account balance is correct but the report shows the wrong amount?
Thank you for getting back to me so quickly.
The Fixed Asset Depreciation Expense account only has two entries that got posted on 08/31/2014. The Accumulated Depreciation account is accurate.
Using the Depreciation Ledger by Class for the current Depreciation amount for August. This figure is lower then what was posted into the General Ledger.
Regards,
Kevin
The first thing to check is whether there are any transactions in the account that didn't originate from a FATRX batch. Use the Account Transaction SmartList and filter it for the account/period you see the difference in. Add the Batch ID to the SmartList and scan for anything other than FATRX. That should get you headed in the right direction.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (