Results 1 to 2 of 2

Thread: Report writer in Pastel

  1. #1
    Gold Member Martinco's Avatar
    Join Date
    Oct 2008
    Thanked 136 Times in 108 Posts

    Report writer in Pastel

    Hi Neville,

    I have never used report writer and would like to know how to write a report that can give me the following:
    1) Customer names
    2) Total sales for a specific period
    3) When last the customer bought
    4) What products the cust. bought
    5) Customer tel #

    Can you give me an example ?
    Martin Coetzee
    Supplier of Stainless Steel Band and Buckle and various fastening systems. Steel, Plastic, Galvanized, PET and Poly woven.
    We solve your fastening problems.

    You may never know what results will come from your actions, but if you do nothing, there will be no results... Rudy Malan 05/03/2011

  2. #2
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Morningside, Durban
    Thanked 346 Times in 304 Posts
    Hi Martin,

    Two points I wish to make regarding Report Writer:

    • Report Writer only works with General Ledger accounts, not Customer/Supplier/Inventory codes;
    • I personally do not like Report Writer - it is old, clunky and limited in its application, as I've pointed out above. The Business Intelligence Centre (BIC) module is FAR more flexible and elegant for customised reporting, as it pulls any data (not just GL data) from the Pastel database into Excel, which can then be manipulated to the nth degree.

    I am aware that you do not have the BIC module and that you would need to upgrade your system in order to get it, so I have another option for you.

    Even without the BIC module, I can set up an ODBC data link between your Pastel database and Excel, and design an automatically populated report along the lines of your request.

    This is not to be confused with printing reports from Pastel to Excel - this "pulls" raw data from Pastel into a pre-designed Excel template report.

    Let me know if you want to proceed further with this, and we can go off-forum with the detail.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    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. Replies: 2
    Last Post: 14-Apr-11, 11:22 AM
  2. inspection report query
    By murdock in forum Electrical Contracting Industry Forum
    Replies: 7
    Last Post: 31-Mar-10, 09:52 AM
  3. AIA inspection report - how do I reply?
    By Man1 in forum Electrical Contracting Industry Forum
    Replies: 4
    Last Post: 27-Dec-09, 09:24 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