Skip to main content

    Power BI

    New

    QuickBooks Online Shortcomings

    Vote (32) Share
    Dave Rowley's profile image

    Dave Rowley on 05 Nov 2015 13:35:16

    Please figure out a way to bring in the department and class columns into the General Ledger tables. Without those, I can't view data by location or by class...which is a really big deal for tracking product line profitability.

    Comments (11)
    Dave Rowley's profile image Profile Picture

    2e2533be ece1-4cc7-8bd7-d9e5f1b3ec39 on 05 Jul 2020 22:19:31

    RE: QuickBooks Online Shortcomings

    The following line in the query can pull this data if your edition of QuickBooks allows it:

    QuickBooks.Report("/reports/GeneralLedger?start_date=2016-04-01&end_date=2016-04-30&columns=tx_date,txn_type,doc_num,name,item_name,account_name,subt_nat_amount,debt_amt,credit_amt,inv_date,quantity,rate,cust_name,vend_name,emp_name,split_acc,is_ar_paid,is_ap_paid,dept_name,klass_name&accounting_method=Cash")