Results 1 to 6 of 6

Thread: Sage Intelligence Reporting BIC

  1. #1
    New Member
    Join Date
    Dec 2015
    Location
    Rustenburg
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sage Intelligence Reporting BIC

    What do I need to be able to create my own BIC reports in Pastel?

  2. #2
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,329
    Thanks
    34
    Thanked 386 Times in 333 Posts
    Obviously you will need the BIC module - I assume that you have it?

    If you have not had any experience in creating BIC reports, I strongly suggest that you attend one of Pastel's BIC training courses. There is a lot of technical stuff that you need to get to grips with.

    On the other hand, I am happy to create any BIC reports that you require, if you will let me know what your requirements are.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

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

  3. #3
    New Member
    Join Date
    Dec 2015
    Location
    Rustenburg
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Neville. I just want to know the in's and out's of BIC reporting myself. I have tried googling for BIC report courses available and spotted the "Excel on Steroids" course. Is this the one I need to look at?

  4. #4
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,329
    Thanks
    34
    Thanked 386 Times in 333 Posts
    Although "Excel on Steroids" is an excellent course, and I recommend that you attend it, unfortunately it will not equip you with the intricacies of the BIC module itself.

    The BIC module involves a lot more than Excel skills, as it delves into the database structure of Pastel itself, and the SQL syntax, etc.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

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

  5. #5
    New Member
    Join Date
    Dec 2015
    Location
    Rustenburg
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yep, I am picking that up as I am going through the Report Manager. I see that I need a licence for the connector too, so obviously the BIC module add-on has not been activated. Anyhow, can you suggest a course? I have a good knowledge of SQL, ODBC, databases and of course Excel.

  6. #6
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,329
    Thanks
    34
    Thanked 386 Times in 333 Posts
    If you can open the Report Manager, then you already have the standard BIC module, which is sufficient for most users. The Connector is part of the advanced BIC module, which allows you to merge multiple Pastel databases and other external databases to compile consolidated reports. If you are interested in purchasing the advanced BIC module, let me know (by private message or email) what your base serial number is and I can send you a quote.

    I suggest that you go to the Pastel website at www.pastel.co.za and see what training courses they offer.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

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

Similar Threads

  1. [Question] Sage Intelligence reporting
    By johancsmuts in forum Accounting Forum
    Replies: 1
    Last Post: 30-Nov-16, 04:16 PM
  2. Financial intelligence for those with no intelligence
    By wynn in forum Scam Alert Forum
    Replies: 5
    Last Post: 06-Mar-14, 01:47 PM
  3. Basic Tutorial on Business Intelligence Centre
    By tebobo in forum Accounting Forum
    Replies: 2
    Last Post: 07-Oct-12, 04:24 PM
  4. National Strategic Intelligence Amendment Bill
    By Dave A in forum General Regulatory Compliance Forum
    Replies: 1
    Last Post: 27-Feb-08, 08:31 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
  •