Results 1 to 5 of 5

Thread: Pastel Payroll ODBC

  1. #1
    Junior Member
    Join Date
    May 2012
    Location
    Somerset West
    Posts
    21
    Thanks
    0
    Thanked 1 Time in 1 Post

    Pastel Payroll ODBC

    Hi,

    Is it possible to create an ODBC link to the Pastel Payroll Database. I am a new Pastel Payroll user. Used to work with VIP and created customised reports in Excell via ODBC and need to do the same with Pastel Payroll.

    Regards,
    Jenine

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Hi Jenine,

    Yes, it is possible. Open the Pervasive Control Centre to set up the data link.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  3. #3
    Junior Member
    Join Date
    May 2012
    Location
    Somerset West
    Posts
    21
    Thanks
    0
    Thanked 1 Time in 1 Post
    Thank you very much for the info. I have never worked with the Pervasive Control Centre before. I will give it a try and post again if I do not get it right.


  4. #4
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    You can open the Pervasive Control Centre by typing PCC in the "Run" box, just above the Windows Start button.

    Once you have created the database link, open Excel and then go to Data...From Other Sources...From Microsoft Query. You will then see your database link listed - select it and start playing!
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  5. #5
    Junior Member
    Join Date
    May 2012
    Location
    Somerset West
    Posts
    21
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hi,
    Thanks. The link works perfectly. Now I just need to get familiar with the structure of the database. Do anyone know where I would be able to find a guide indicating which information is stored in which table? I am specificly looking for the table with the current periods payslip information. I need to generate the following report in Excell:

    Employee Code,
    All employee earnings listed seperately,
    All deductions listed seperately,
    Nett pay amount.

Similar Threads

  1. How to run IRP5's on Pastel Payroll?
    By J7J in forum Tax Forum
    Replies: 16
    Last Post: 20-Mar-18, 03:37 PM
  2. [Question] Pastel Payroll Outsourcing
    By Red Pepper in forum General Business Forum
    Replies: 7
    Last Post: 28-Apr-16, 06:08 PM
  3. [Question] Pastel Payroll
    By Raene in forum Accounting Forum
    Replies: 2
    Last Post: 09-Apr-13, 10:31 PM
  4. [Question] Help with Pastel Payroll Partner
    By celly007 in forum Tax Forum
    Replies: 3
    Last Post: 17-Sep-09, 10:25 AM
  5. [Question] Pastel ODBC
    By Cassie in forum Accounting Forum
    Replies: 2
    Last Post: 09-Jul-09, 08:26 AM

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
  •