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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,558 Super User 2024 Season 2
Martin Dráb 228,647 Most Valuable Professional
nmaenpaa 101,148