News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics SL forum pjptdsum and pjptdact ...

Microsoft Dynamics SL forum

Suggested answer

pjptdsum and pjptdact tables

(0) Share

Report

Report

Posted on by BettyB

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.

All responses Img

All responses (2)

Answers Img

Answers (0)

coen@profoundsoluti... 45 on at

Like (0)

Report

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 1,642 on at

Like (0)

Report
RE: pjptdsum and pjptdact tables

The pjptdsum and pjptdrol tables includes data from several sources:

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.

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.

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.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 228,647 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans