Results 1 to 4 of 4

Thread: Bill of Material report Pastel Partner 11

  1. #1
    New Member
    Join Date
    Jun 2014
    Location
    Bela Bela
    Posts
    2
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Bill of Material report Pastel Partner 11

    Hi

    I'm busy implementing Qlikview at an engineering company. I've extracted the inventory master etc from pastel and now I need to export a report regarding the Bills of Material. There is a Bill of Material module but not an existing report. What I need is a simple list with all the parent and kit (child) items. So 2 columns - Parent Item and Child Item. How does one go about this please.

    Kind regards

    Danie

  2. #2
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,374
    Thanks
    35
    Thanked 392 Times in 339 Posts
    Hi Danie,

    Try the following report: View...Manufacturing...Components Used in BOMs / Kit Item Codes.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    *** 20% DISCOUNT ON PASTEL XPRESS / PARTNER SOFTWARE UNTIL 15 DECEMBER 2017 ***

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

  3. Thanks given for this post:

    DaniePosthumus (19-Jun-14)

  4. #3
    New Member
    Join Date
    Jun 2014
    Location
    Bela Bela
    Posts
    2
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thank you - that helped. It was in a format that I still needed to copy and paste the info to different columns so that I could import it into a table which took a few hours but hey it's done.
    I'm not familiar with pervasive and I'm battling to get data from pastel apart from running the reports available. Is there any way that one could access the tables in the database?

    Kind regards

    Danie

  5. #4
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,374
    Thanks
    35
    Thanked 392 Times in 339 Posts
    Hi Danie,

    I suggest that you create an ODBC database link, using the Pervasive Control Centre, and then use Excel's MSQuery add-on to pull the necessary data fields into Excel.

    The specific data table for the BOM components is BOMLines.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    *** 20% DISCOUNT ON PASTEL XPRESS / PARTNER SOFTWARE UNTIL 15 DECEMBER 2017 ***

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

Similar Threads

  1. Pastel Tax Report
    By Mike C in forum Accounting Forum
    Replies: 7
    Last Post: 02-Jun-15, 08:04 AM
  2. Pastel v11 Tax Report Difference
    By Sasha in forum Accounting Forum
    Replies: 5
    Last Post: 02-Apr-13, 11:46 AM
  3. [Question] Pastel Tax Box Report & Vat Detail report giving different figures!
    By Cin8 in forum Accounting Forum
    Replies: 3
    Last Post: 22-May-12, 03:57 PM
  4. Report writer in Pastel
    By Martinco in forum Accounting Forum
    Replies: 1
    Last Post: 23-Jun-11, 02:29 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
  •