Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

FA GL Posting

Posted on by Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: FA GL Posting

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: FA GL Posting

    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?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: FA GL Posting

    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?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: FA GL Posting

    GP2010 sp2

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: FA GL Posting

    Check this out;

    Rerun FA GL Post Routine

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    RE: FA GL Posting

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans