Skip to main content

Notifications

Microsoft Dynamics SL (Archived)

Project - Reconciliation

Posted on by Microsoft Employee

I have an experience with AP vs GL, AR vs GL and Bank Reconciliation activities. How to do Project module transaction balance tallied with GL balances? Any Specific method is there? Else execute the FTT is quite enough ?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Project - Reconciliation

    Hi Carolyn

    Thanks for your reply.

    I have already identified the scenarios and resolved the Project reconciliation successfully.

    Thanks

  • Verified answer
    RE: Project - Reconciliation

    Hello Santhosh D,

    The Project – GL Reconciliation (PA.230.00) report provides the ability to reconcile transactions posted to both General Ledger (in table GLTRAN) and Project Controller (in table PJTRAN). You can run the report at the project level or at the project-task level. In both cases, the report shows balances and variance amounts at the account category level. You can also choose whether to run the report for all account categories or to suppress lines in which the variance amount is zero.

    If the two modules are out of balance, here are some possible causes:

    Here are a few common causes.

    1. You posted the account in GL or another financial module and used the non post project

    2. You entered project charge entry batches- they will not update GL

    3. You have not posted allocator or Flex bill batches in GL for the current period.

    4. You have unposted batches in the Post transaction screen in GL and they are project related.

    Please let me know if you have additional questions.

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