Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook

Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

QuickBooks Report Relationships

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    QuickBooks Report Relationships

    Here is a list of built-in QuickBooks reports in QReportBuilder that have relationships to the base tables for additional information. The links are built into QReportBuilder for your convenience.

    brad


    APAgingDetail AccountFullName Account.FullName
    APAgingDetail AccountListID Account.ListID
    ARAgingDetail AccountFullName Account.FullName
    ARAgingDetail AccountListID Account.ListID
    CollectionsReport AccountFullName Account.FullName
    CollectionsReport AccountListID Account.ListID
    ProfitAndLossBudgetOverview AccountFullName Account.FullName
    ProfitAndLossBudgetOverview AccountListID Account.ListID
    ProfitAndLossBudgetPerformance AccountFullName Account.FullName
    ProfitAndLossBudgetPerformance AccountListID Account.ListID
    ProfitAndLossBudgetVsActual AccountFullName Account.FullName
    ProfitAndLossBudgetVsActual AccountListID Account.ListID
    CustomTxnDetail TextAccountName Account.FullName
    CustomTxnDetail TextClassName Class.Name
    CustomTxnDetail TextCustomerName Customer.Name
    CustomTxnDetail TextCustomerTypeName CustomerType.Name
    CustomTxnDetail TextEmployeeName Employee.Name
    CustomTxnDetail TextItemName Item.Name
    CustomTxnDetail TextPaymentMethodName PaymentMethod.Name
    CustomTxnDetail TextSalesRepInitial SalesRep.Initial
    CustomTxnDetail TextSalesTaxCodeDesc SalesTaxCode.Desc
    CustomTxnDetail TextShipMethodName ShipMethod.Name
    CustomTxnDetail TextTermsName Terms.Name
    CustomTxnDetail TextVendorName Vendor.Name
    CustomTxnDetail TextVendorTypeName VendorType.Name
    CustomTxnDetail AccountFullName Account.FullName
    CustomTxnDetail AccountListID Account.ListID
    CustomSummary LabelAccountName Account.Name
    CustomSummary LabelClassName Class.Name
    CustomSummary LabelCustomerName Customer.Name
    CustomSummary LabelCustomerTypeName CustomerType.Name
    CustomSummary LabelEmployeeName Employee.Name
    CustomSummary LabelItemName Item.Name
    CustomSummary LabelPaymentMethodName PaymentMethod.Name
    CustomSummary LabelSalesRepInitial SalesRep.Initial
    CustomSummary LabelSalesTaxCodeDesc SalesTaxCode.Desc
    CustomSummary LabelShipMethodName ShipMethod.Name
    CustomSummary LabelTaxCodeDesc TaxCode.Desc
    CustomSummary LabelTermsName Terms.Name
    CustomSummary LabelVendorName Vendor.Name
    CustomSummary LabelVendorTypeName VendorType.Name
    CustomSummary TextAccountName Account.Name
    CustomSummary TextCustomerFullName Customer.FullName
    CustomSummary TextItemFullName Item.FullName
    Detail1099 AccountFullName Account.FullName
    Detail1099 AccountListID Account.ListID
    AuditTrail AccountFullName Account.FullName
    AuditTrail AccountListID Account.ListID
    BalanceSheetDetail AccountFullName Account.FullName
    BalanceSheetDetail AccountListID Account.ListID
    CheckDetail AccountFullName Account.FullName
    CheckDetail AccountListID Account.ListID
    CustomerBalanceDetail TextAccountName Account.FullName
    CustomerBalanceDetail TextClassName Class.Name
    CustomerBalanceDetail TextCustomerName Customer.Name
    CustomerBalanceDetail TextCustomerTypeName CustomerType.Name
    CustomerBalanceDetail TextEmployeeName Employee.Name
    CustomerBalanceDetail TextItemName Item.Name
    CustomerBalanceDetail TextPaymentMethodName PaymentMethod.Name
    CustomerBalanceDetail TextSalesRepInitial SalesRep.Initial
    CustomerBalanceDetail TextSalesTaxCodeDesc SalesTaxCode.Desc
    CustomerBalanceDetail TextShipMethodName ShipMethod.Name
    CustomerBalanceDetail TextTermsName Terms.Name
    CustomerBalanceDetail TextVendorName Vendor.Name
    CustomerBalanceDetail TextVendorTypeName VendorType.Name
    CustomerBalanceDetail AccountFullName Account.FullName
    CustomerBalanceDetail AccountListID Account.ListID
    DepositDetail AccountFullName Account.FullName
    DepositDetail AccountListID Account.ListID
    EstimatesByJob AccountFullName Account.FullName
    EstimatesByJob AccountListID Account.ListID
    ExpenseByVendorDetail AccountFullName Account.FullName
    ExpenseByVendorDetail AccountListID Account.ListID
    GeneralLedger AccountFullName Account.FullName
    GeneralLedger AccountListID Account.ListID
    IncomeByCustomerDetail AccountFullName Account.FullName
    IncomeByCustomerDetail AccountListID Account.ListID
    IncomeTaxDetail AccountFullName Account.FullName
    IncomeTaxDetail AccountListID Account.ListID
    JobProgressInvoicesVsEstimates AccountFullName Account.FullName
    JobProgressInvoicesVsEstimates AccountListID Account.ListID
    MissingChecks AccountFullName Account.FullName
    MissingChecks AccountListID Account.ListID
    OpenInvoices AccountFullName Account.FullName
    OpenInvoices AccountListID Account.ListID
    OpenPOs AccountFullName Account.FullName
    OpenPOs AccountListID Account.ListID
    OpenPOsByJob AccountFullName Account.FullName
    OpenPOsByJob AccountListID Account.ListID
    PendingSales TextAccountName Account.FullName
    PendingSales TextClassName Class.Name
    PendingSales TextCustomerName Customer.Name
    PendingSales TextCustomerTypeName CustomerType.Name
    PendingSales TextEmployeeName Employee.Name
    PendingSales TextItemName Item.Name
    PendingSales TextPaymentMethodName PaymentMethod.Name
    PendingSales TextSalesRepInitial SalesRep.Initial
    PendingSales TextSalesTaxCodeDesc SalesTaxCode.Desc
    PendingSales TextShipMethodName ShipMethod.Name
    PendingSales TextTermsName Terms.Name
    PendingSales TextVendorName Vendor.Name
    PendingSales TextVendorTypeName VendorType.Name
    PendingSales AccountFullName Account.FullName
    PendingSales AccountListID Account.ListID
    ProfitAndLossDetail AccountFullName Account.FullName
    ProfitAndLossDetail AccountListID Account.ListID
    PurchaseByItemDetail AccountFullName Account.FullName
    PurchaseByItemDetail AccountListID Account.ListID
    PurchaseByVendorDetail TextAccountName Account.FullName
    PurchaseByVendorDetail TextClassName Class.Name
    PurchaseByVendorDetail TextCustomerName Customer.Name
    PurchaseByVendorDetail TextCustomerTypeName CustomerType.Name
    PurchaseByVendorDetail TextEmployeeName Employee.Name
    PurchaseByVendorDetail TextItemName Item.Name
    PurchaseByVendorDetail TextPaymentMethodName PaymentMethod.Name
    PurchaseByVendorDetail TextSalesRepInitial SalesRep.Initial
    PurchaseByVendorDetail TextSalesTaxCodeDesc SalesTaxCode.Desc
    PurchaseByVendorDetail TextShipMethodName ShipMethod.Name
    PurchaseByVendorDetail TextTermsName Terms.Name
    PurchaseByVendorDetail TextVendorName Vendor.Name
    PurchaseByVendorDetail TextVendorTypeName VendorType.Name
    PurchaseByVendorDetail AccountFullName Account.FullName
    PurchaseByVendorDetail AccountListID Account.ListID
    SalesByCustomerDetail TextAccountName Account.FullName
    SalesByCustomerDetail TextClassName Class.Name
    SalesByCustomerDetail TextCustomerName Customer.Name
    SalesByCustomerDetail TextCustomerTypeName CustomerType.Name
    SalesByCustomerDetail TextEmployeeName Employee.Name
    SalesByCustomerDetail TextItemName Item.Name
    SalesByCustomerDetail TextPaymentMethodName PaymentMethod.Name
    SalesByCustomerDetail TextSalesRepInitial SalesRep.Initial
    SalesByCustomerDetail TextSalesTaxCodeDesc SalesTaxCode.Desc
    SalesByCustomerDetail TextShipMethodName ShipMethod.Name
    SalesByCustomerDetail TextTermsName Terms.Name
    SalesByCustomerDetail TextVendorName Vendor.Name
    SalesByCustomerDetail TextVendorTypeName VendorType.Name
    SalesByCustomerDetail AccountFullName Account.FullName
    SalesByCustomerDetail AccountListID Account.ListID
    SalesByItemDetail AccountFullName Account.FullName
    SalesByItemDetail AccountListID Account.ListID
    SalesByRepDetail TextAccountName Account.FullName
    SalesByRepDetail TextClassName Class.Name
    SalesByRepDetail TextCustomerName Customer.Name
    SalesByRepDetail TextCustomerTypeName CustomerType.Name
    SalesByRepDetail TextEmployeeName Employee.Name
    SalesByRepDetail TextItemName Item.Name
    SalesByRepDetail TextPaymentMethodName PaymentMethod.Name
    SalesByRepDetail TextSalesRepInitial SalesRep.Initial
    SalesByRepDetail TextSalesTaxCodeDesc SalesTaxCode.Desc
    SalesByRepDetail TextShipMethodName ShipMethod.Name
    SalesByRepDetail TextTermsName Terms.Name
    SalesByRepDetail TextVendorName Vendor.Name
    SalesByRepDetail TextVendorTypeName VendorType.Name
    SalesByRepDetail AccountFullName Account.FullName
    SalesByRepDetail AccountListID Account.ListID
    TxnDetailByAccount TextAccountName Account.FullName
    TxnDetailByAccount TextClassName Class.Name
    TxnDetailByAccount TextCustomerName Customer.Name
    TxnDetailByAccount TextCustomerTypeName CustomerType.Name
    TxnDetailByAccount TextEmployeeName Employee.Name
    TxnDetailByAccount TextItemName Item.Name
    TxnDetailByAccount TextPaymentMethodName PaymentMethod.Name
    TxnDetailByAccount TextSalesRepInitial SalesRep.Initial
    TxnDetailByAccount TextSalesTaxCodeDesc SalesTaxCode.Desc
    TxnDetailByAccount TextShipMethodName ShipMethod.Name
    TxnDetailByAccount TextTermsName Terms.Name
    TxnDetailByAccount TextVendorName Vendor.Name
    TxnDetailByAccount TextVendorTypeName VendorType.Name
    TxnDetailByAccount AccountFullName Account.FullName
    TxnDetailByAccount AccountListID Account.ListID
    TxnListByCustomer AccountFullName Account.FullName
    TxnListByCustomer AccountListID Account.ListID
    TxnListByDate AccountFullName Account.FullName
    TxnListByDate AccountListID Account.ListID
    TxnListByVendor AccountFullName Account.FullName
    TxnListByVendor AccountListID Account.ListID
    UnpaidBillsDetail AccountFullName Account.FullName
    UnpaidBillsDetail AccountListID Account.ListID
    UnbilledCostsByJob TextAccountName Account.FullName
    UnbilledCostsByJob TextClassName Class.Name
    UnbilledCostsByJob TextCustomerName Customer.Name
    UnbilledCostsByJob TextCustomerTypeName CustomerType.Name
    UnbilledCostsByJob TextEmployeeName Employee.Name
    UnbilledCostsByJob TextItemName Item.Name
    UnbilledCostsByJob TextPaymentMethodName PaymentMethod.Name
    UnbilledCostsByJob TextSalesRepInitial SalesRep.Initial
    UnbilledCostsByJob TextSalesTaxCodeDesc SalesTaxCode.Desc
    UnbilledCostsByJob TextShipMethodName ShipMethod.Name
    UnbilledCostsByJob TextTermsName Terms.Name
    UnbilledCostsByJob TextVendorName Vendor.Name
    UnbilledCostsByJob TextVendorTypeName VendorType.Name
    UnbilledCostsByJob AccountFullName Account.FullName
    UnbilledCostsByJob AccountListID Account.ListID
    VendorBalanceDetail TextAccountName Account.FullName
    VendorBalanceDetail TextClassName Class.Name
    VendorBalanceDetail TextCustomerName Customer.Name
    VendorBalanceDetail TextCustomerTypeName CustomerType.Name
    VendorBalanceDetail TextEmployeeName Employee.Name
    VendorBalanceDetail TextItemName Item.Name
    VendorBalanceDetail TextPaymentMethodName PaymentMethod.Name
    VendorBalanceDetail TextSalesRepInitial SalesRep.Initial
    VendorBalanceDetail TextSalesTaxCodeDesc SalesTaxCode.Desc
    VendorBalanceDetail TextShipMethodName ShipMethod.Name
    VendorBalanceDetail TextTermsName Terms.Name
    VendorBalanceDetail TextVendorName Vendor.Name
    VendorBalanceDetail TextVendorTypeName VendorType.Name
    VendorBalanceDetail AccountFullName Account.FullName
    VendorBalanceDetail AccountListID Account.ListID
    BalanceSheetPrevYearComp AccountFullName Account.FullName
    BalanceSheetPrevYearComp AccountListID Account.ListID
    BalanceSheetStandard AccountFullName Account.FullName
    BalanceSheetStandard AccountListID Account.ListID
    BalanceSheetSummary AccountFullName Account.FullName
    BalanceSheetSummary AccountListID Account.ListID
    ProfitAndLossByClass AccountFullName Account.FullName
    ProfitAndLossByClass AccountListID Account.ListID
    ProfitAndLossByJob AccountFullName Account.FullName
    ProfitAndLossByJob AccountListID Account.ListID
    ProfitAndLossPrevYearComp AccountFullName Account.FullName
    ProfitAndLossPrevYearComp AccountListID Account.ListID
    ProfitAndLossStandard AccountFullName Account.FullName
    ProfitAndLossStandard AccountListID Account.ListID
    ProfitAndLossYTDComp AccountFullName Account.FullName
    ProfitAndLossYTDComp AccountListID Account.ListID
    TrialBalance AccountFullName Account.FullName
    TrialBalance AccountListID Account.ListID
    EmployeeStateTaxesDetail TextAccountName Account.FullName
    EmployeeStateTaxesDetail TextClassName Class.Name
    EmployeeStateTaxesDetail TextCustomerName Customer.Name
    EmployeeStateTaxesDetail TextCustomerTypeName CustomerType.Name
    EmployeeStateTaxesDetail TextEmployeeName Employee.Name
    EmployeeStateTaxesDetail TextItemName Item.Name
    EmployeeStateTaxesDetail TextPaymentMethodName PaymentMethod.Name
    EmployeeStateTaxesDetail TextSalesRepInitial SalesRep.Initial
    EmployeeStateTaxesDetail TextSalesTaxCodeDesc SalesTaxCode.Desc
    EmployeeStateTaxesDetail TextShipMethodName ShipMethod.Name
    EmployeeStateTaxesDetail TextTermsName Terms.Name
    EmployeeStateTaxesDetail TextVendorName Vendor.Name
    EmployeeStateTaxesDetail TextVendorTypeName VendorType.Name
    EmployeeStateTaxesDetail AccountFullName Account.FullName
    EmployeeStateTaxesDetail AccountListID Account.ListID
    PayrollItemDetail TextAccountName Account.FullName
    PayrollItemDetail TextClassName Class.Name
    PayrollItemDetail TextCustomerName Customer.Name
    PayrollItemDetail TextCustomerTypeName CustomerType.Name
    PayrollItemDetail TextEmployeeName Employee.Name
    PayrollItemDetail TextItemName Item.Name
    PayrollItemDetail TextPaymentMethodName PaymentMethod.Name
    PayrollItemDetail TextSalesRepInitial SalesRep.Initial
    PayrollItemDetail TextSalesTaxCodeDesc SalesTaxCode.Desc
    PayrollItemDetail TextShipMethodName ShipMethod.Name
    PayrollItemDetail TextTermsName Terms.Name
    PayrollItemDetail TextVendorName Vendor.Name
    PayrollItemDetail TextVendorTypeName VendorType.Name
    PayrollItemDetail AccountFullName Account.FullName
    PayrollItemDetail AccountListID Account.ListID
    PayrollReviewDetail AccountFullName Account.FullName
    PayrollReviewDetail AccountListID Account.ListID
    PayrollTransactionDetail AccountFullName Account.FullName
    PayrollTransactionDetail AccountListID Account.ListID
    PayrollTransactionsByPayee AccountFullName Account.FullName
    PayrollTransactionsByPayee AccountListID Account.ListID
Working...
X