Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Suggested answer

pjptdsum and pjptdact tables

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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,647 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans