Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

pjptdsum and pjptdact tables

(0) ShareShare
ReportReport
Posted on by 10

Does anyone know how these tables are poplulated?  I have a  custom report that pulls data from these tables and some of the data is missing from them.

  • RE: pjptdsum and pjptdact tables

    Hi, as far as I remember , specifically for the pjptd....tables, the previous period balances are only rolled forward to the next period  when the PC closing process is run.

    When the project tick-box "Balance forward at YE" is ticked. Then the balances will also populate the opening balances for the following year.
    When transactions are entered into previous periods or years then all periods from those transaction period must be rolled up to the current period.

  • Suggested answer
    Erich Strelow F Profile Picture
    Erich Strelow F 1,642 on at
    RE: pjptdsum and pjptdact tables

    The pjptdsum and pjptdrol tables includes data from several sources:

    1. The "actual to date" data (act_amount, act_units) should be updated each time a project transfer process is run. If your setup is on "auto project transfer", then it should be updated for each project-borne transaction. Your project related actual expenses and incomes should end up here.
    2. The budget data (total_budget_amount, total_budget_units, eac_amount, eac_units, fac_amount, fac_units) comes from the main project project screen on the budget tab. If your setup includes the project budget module, this data must be populated via the module. 
    3. The commitments data (com_amount, com_units) should be updated each time a commitment recalculation process is run. There is a screen for this process. You must run the process in order to get the commitment data, but scheduling execution is available. In turn, the commitments comes from several sources.

    In order for the above to work, a set of project accounts must be setup in the first place.

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

News and Announcements

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans