Hello,
When we run the FA routine GL Posting Journal Entry after running depreciation a journal entry is not created to post to the ledger.
What could be wrong with the process?
Thank you in advance for any response that might offer a solution.
Donnette
*This post is locked for comments
Mamoud,
There is a repetitive batch 'FATRX00000089' that is in the FA00902 table for periods 8-12, but not the batch does not exist in the FA15000 table. Every time we run GL Posting it recreates the same batch number, but does not create the post to GL. Period 8 is the last successful period that posted to the GL.
Mark's posting deletes the batch number from both tables to re-create it. Should I try updating the batch number in period 8 to be 'FATRX89' and deleting the batch number from periods 9-12 from the FA00902 table only?
Thank you
Donnette
looking at the asset card batch number FATRX00000089 is associated with the FADEP for the last 4 periods. If I run this query it shows the same results.
select * from FA00902
where FAYEAR = '2013'
and SOURCDOC = 'FADEP' and GLINTBTCHNUM ='FATRX00000089'
Why is the same batch number associated with all 4 periods? Could this be the problem?
After review Mark's post to reset the GL batch id to blank to process a new GL Posting.
** Resets the Batch ID to '' (blank) for the selected Batch ID in
** the Financial Detail File (FA00902) so that the GL Interface can be run again
** to pick up those details.
I queried the FA00902 table and I found there is no batch number associated with the FADEP source documents for the 4 periods missing on the GL
select * from FA00902
where FAYEAR = '2013' and FAPERIOD = '12'
and SOURCDOC = 'FADEP' and GLINTBTCHNUM = ''
Returned 1635649 blank rows with similar results for the other 4 periods missing.
Due to the large volume of assets the post to GL process takes days to run and no GL posting is created. Is GP designed to handle this many assets?
GP2010 sp2
Donnette,
What version of GP are you on? The process has changed for GP 2013 and so the answer to your question may be different, as well.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156