Announcements
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.
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.
The pjptdsum and pjptdrol tables includes data from several sources:
In order for the above to work, a set of project accounts must be setup in the first place.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156