You’re offline. This is a read only version of the page.
I have a client who is adding an asset via Fixed Assets - when we go to Routines to create the GL Batch it comes up with zero. Looking at Financial Detail Inquiry for the asset, the Batch Number is blank and it shows a Transaction Acct Type of Cost and of Clearing - the two GL accounts are unique. Depreciation does post via the routine. Any idea what is missing?
*This post is locked for comments
I don't see anything in the results, which explains why the transactions would fail to interface with the General Ledger. I figure this is also something you've done, but if you could make sure the Financial Series is open for posting for 2014-010. Knowing your depreciation entries were processing rules out your FA Calendar not being configured correctly. If no one else has any ideas, I would suggest logging a support incident with Microsoft.
FINANCIALINDX ASSETINDEX BOOKINDX TRANSDATESTAMP TRANSTIMESTAMP FISCALYRADDED FAYEAR FAPERIOD DEPRFROMDATE DEPRTODATE AMOUNT TRANSUSERID SOURCDOC TRANSACCTTYPE INTERFACEGL GLINTTRXDATE GLINTDATESTAMP GLINTTIMESTAMP GLINTACCTINDX DEX_ROW_ID
------------- ----------- ----------- ----------------------- ----------------------- ------------- ------ -------- ----------------------- ----------------------- --------------------------------------- --------------- ----------- ------------- ----------- ----------------------- ----------------------- ----------------------- ------------- --------------- - -----------
2117 113 1 2014-11-04 00:00:00.000 1900-01-01 07:34:12.000 2014 2014 10 2014-10-31 00:00:00.000 2014-10-31 00:00:00.000 5000.00000 sa FAADD 3 1 1900-01-01 00:00:00.000 1900-01-01 00:00:00.000 1900-01-01 00:00:00.000 7 2117
2118 113 1 2014-11-04 00:00:00.000 1900-01-01 07:34:12.000 2014 2014 10 2014-10-31 00:00:00.000 2014-10-31 00:00:00.000 -5000.00000 sa FAADD 7 1 1900-01-01 00:00:00.000 1900-01-01 00:00:00.000 1900-01-01 00:00:00.000 79 2118
Would you share these records please ..
Yes it did - there are two transactions
Does this return any value for a specific new asset id (which did not post to GL)
Share
Report
All responses (
Answers (
SELECT *
FROM FA00902
WHERE ASSETINDEX = ( SELECT DISTINCT
ASSETINDEX
FROM dbo.FA00100
WHERE ASSETID = '#ASSETId'
)
Your feedback is highly appreciated,
Thanks but I've already verified the accounts and interface periods which is why I'm confused that it is not working as it should. Thanks!
The first thing you're going to want to check is Cards > Fixed Assets > Account for each asset to ensure the accounts are set up correctly. Not having the required accounts configured would prevent the GL Interface from creating the Fixed Asset Addition (FAADD) transaction(s).
Second, you need to make sure your GL Interface period range contains the fixed asset acquisition date. If an asset was added last month, and GL Interface was performed for this month, nothing would be interfaced.
I have found users do not run the GL Interface for prior periods - this can lead to an accumulation of Fixed Asset transactions, which were never properly interfaced with the GL. In order to catch all these prior period transactions, select a starting period and year of 0000-000.
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156