Results 1 to 3 of 3

Thread: "Accounting Periods" Database Table in Sage Pastel Partner v19

  1. #1
    Bronze Member michellepace's Avatar
    Join Date
    Oct 2018
    Location
    South Africa
    Posts
    131
    Thanks
    15
    Thanked 3 Times in 3 Posts

    Question "Accounting Periods" Database Table in Sage Pastel Partner v19

    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
    Last edited by michellepace; 07-Sep-19 at 04:27 PM. Reason: pretty colours mean faster reading

  2. #2
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    262
    Thanks
    0
    Thanked 35 Times in 31 Posts
    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.

  3. #3
    Bronze Member michellepace's Avatar
    Join Date
    Oct 2018
    Location
    South Africa
    Posts
    131
    Thanks
    15
    Thanked 3 Times in 3 Posts
    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)

    Click image for larger version. 

Name:	1.png 
Views:	232 
Size:	68.7 KB 
ID:	7651

Similar Threads

  1. [Question] Pastel Set of Books "Removed by the Operating System"
    By ITS in forum Accounting Forum
    Replies: 1
    Last Post: 04-Apr-19, 11:28 AM
  2. [Question] Sage Pastel Xpress V17 "for dummies"
    By Hetta in forum Accounting Forum
    Replies: 2
    Last Post: 29-Aug-17, 11:35 AM
  3. Replies: 2
    Last Post: 08-Mar-16, 07:29 AM
  4. Unable to view "calculation" or "dispute" - e-filing
    By Boeriemore in forum Tax Forum
    Replies: 3
    Last Post: 14-Sep-15, 09:38 AM
  5. error "9" subcript out of range pastel partner
    By splendid in forum Accounting Forum
    Replies: 0
    Last Post: 29-Aug-13, 03:11 PM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •