Alpha DevCon 2018
Results 1 to 7 of 7

Thread: help needed with table query

  1. #1
    Member
    Real Name
    k baig
    Join Date
    Aug 2013
    Posts
    4

    Default help needed with table query

    Hello
    I need some assistance.
    we would like to extract a report that gives:

    Customer contact details
    Bill To customer details
    Outstanding Balance
    Invoice Ref number
    Due Date
    Item Description


    I have got close by using:
    Customer table
    Invoice table
    Item table

    but I cannot extract the data correctly

    could you please help by advising how to setup up this query and table
    linkages, using any other query method if better

    ALSO:

    please advise if there is another way to run the 'report genie' or
    'quick report' when modifying an existing query - I cannot work it out

    many thanks in advance for any help anyone can provide

    kamran

  2. #2
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,481

    Default Re: help needed with table query

    Welcome.

    what is missing from your current attempt?

    What contact information are you looking for?
    Some new fields have been added to Quickbooks but not added to the sdk so we can read them.

    The quick report and genie are a create only tool. Use the report editor to edit a saved report.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  3. #3
    Member
    Real Name
    k baig
    Join Date
    Aug 2013
    Posts
    4

    Default Re: help needed with table query

    Quote Originally Posted by Al Buchholz View Post
    Welcome.

    what is missing from your current attempt?

    What contact information are you looking for?
    Some new fields have been added to Quickbooks but not added to the sdk so we can read them.

    The quick report and genie are a create only tool. Use the report editor to edit a saved report.
    Many thanks for your reply Al.

    currently, the report doesn't pull out outstanding balance or item description - those fields are all blank, despite being fully populated in the tables when in browse data table mode

    the customer details needed are in billto fields and shipto fields

    many thanks

  4. #4
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,481

    Default Re: help needed with table query

    I'm guessing that the linkage of the tables is not correct...

    Would have been a great topic at the webinar a few hours ago...

    Can you send me an image of the set linkage or describe the fields that are linked?
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  5. #5
    Member
    Real Name
    k baig
    Join Date
    Aug 2013
    Posts
    4

    Default Re: help needed with table query

    Quote Originally Posted by Al Buchholz View Post
    I'm guessing that the linkage of the tables is not correct...

    Would have been a great topic at the webinar a few hours ago...

    Can you send me an image of the set linkage or describe the fields that are linked?
    sure, see attached:
    Last edited by kamey; 08-22-2013 at 07:05 PM.

  6. #6
    Member
    Real Name
    k baig
    Join Date
    Aug 2013
    Posts
    4

    Default Re: help needed with table query

    sorry AL there is some fault where vBulletin will not uplaod image or any other files, giving error 2038 - can I email them or PM the images to you?

  7. #7
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,481

    Default Re: help needed with table query

    Quote Originally Posted by kamey View Post
    sorry AL there is some fault where vBulletin will not uplaod image or any other files, giving error 2038 - can I email them or PM the images to you?
    Email them. Use the address you sent the other message to.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

Similar Threads

  1. Help needed with basic Ajax callback and SQL Query in Dialog2
    By WindForce in forum Application Server Version 11 - Web/Browser Applications
    Replies: 1
    Last Post: 02-01-2012, 10:22 PM
  2. Table design help needed...
    By djldc in forum Alpha Five Version 8
    Replies: 50
    Last Post: 05-11-2007, 08:21 AM
  3. Help needed creating query filter
    By sicomputerguy in forum Alpha Five Version 7
    Replies: 7
    Last Post: 02-25-2007, 01:32 PM
  4. Query Help Needed
    By dtheo in forum Alpha Five Version 5
    Replies: 9
    Last Post: 06-02-2003, 04:02 AM
  5. Query filter help needed
    By tlyon in forum Alpha Five Version 4
    Replies: 16
    Last Post: 05-20-2002, 03:06 AM

Bookmarks

Posting Permissions

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