"Accounting Periods" Database Table in Sage Pastel Partner v19

[michellepace]

Hello there,

I'm looking for a table in Sage Pastel Partner v19 which defines my accounting periods. If you take a look at this video https://youtu.be/kAxHRD7Lq7I?t=30 the person talking speaks about the Accouting Periods Table in Sage 50.

Does anyone know which table would be the equivalent in Pastel Partner v19?

Thanks in advance,
Michelle

[Kevin Smith]

Hi Michelle

It is not a pretty "table" to work with. The data you are looking for is stored in the ledger parameter file accprmgl.dat. It contains the number of periods per year, then the period start dates this and last year, then the end dates this and last year, then the names of the periods and which period is your current period. There are also a whole range of other data stored in that table, and if modified incorrectly, you won't be able to open your company. I hope you are only using it for read only purposes.

[michellepace]

Hi Kevin, thanks very much for your reply. PowerBi never ever changes the source data. The table is secure


I'm querying against the LedgerTransactions table to form my Income Statement. I decided to just derive my accounting period from the DDATE column. I know, I know - it might not be 100% accurate (due to people using out of period dates)... but 95% accurate isn't bad. If anyone else is going down this PowerBI path, this is how I created a dynamic date table: https://youtu.be/iWsL5gM962U?t=1042

This is how far I have gotten. It's ugly and raw but at last I'm in the pastel database with PowerBI and have the beginnings of a pivot-style-interactive income statement (sort of)