Knowledgebase: Sp_commands & Reports
[QXL-Desktop] How to run Profit and Loss detail report - with different parameters
Posted by Jack - QODBC Support on 24 April 2017 10:42 AM

How to run Profit and Loss detail report - with different parameters

Problem Description:

I am using QXL & I want to run Profit and Loss detail report through QXL. I can see the report on the list. But I want to change report parameter.

How can I change report parameter & run the updated report?


You can change report parameter from QXL Report Settings tab.

The first step in changing report parameter is to click on settings icon for QXL options details.

You can choose ProfitAndLossDetail report from the drop-down list & add the report for export.


You can see default report query in Report Query/Command box.

You can modify report query by from Report Query/Command box.

You can refer QODBC Data Layouts site for details about different report parameters.

Navigate to the above link & Click on the region of the QuickBooks edition you are using.

You will be redirected to QuickBooks region link. Click on the "ALPHABETICAL LISTING OF ALL REPORTS" under "REPORT OVERVIEW" label.

You will be presented all list of reports. Search for "ProfitAndLossDetail" report & click on "Parameters" to get details about all supported parameters for ProfitAndLossDetail report.

If you are QuickBooks USA user, then you can refer direct link for PARAMETERS AND VALUES FOR: ProfitAndLossDetail

You can use any of supported parameter in report query.

I am changing report query by adding TxnFilterTypes ='Invoice' parameter & ReportBasis='Accrual' and changing DateMacro parameter value to 'ThisMonthToDate'.

For Example: sp_report ProfitAndLossDetail show TxnType_Title, Date_Title, RefNumber_Title, Name_Title, Memo_Title, ClearedStatus_Title, SplitAccount_Title, Debit_Title, Credit_Title, RunningBalance_Title, Text, Blank, TxnType, Date, RefNumber, Name, Memo, ClearedStatus, SplitAccount, Debit, Credit, RunningBalance parameters DateMacro = 'ThisMonthToDate', TxnFilterTypes='Invoice', ReportBasis='Accrual'

You need to modify report query & click "Add or Update" button to update report query.

The modified report query & added to the export list.

By repeating above process, You can add different report with different supported parameters as per your requirement.

The report will be exported by clicking on the Export icon from QXL Main Window.

Report exported.

(1 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).