Reckon Accounts Hosted API Payroll Summary Report Payroll Item Filter XML
I'm running a Payroll Summary report and need to add the "Payroll Item" filter set to "All Gross Pay". Does anyone know the XML for this?
Here is the XML that I am using:
<?xml version="1.0"?><?qbxml version="6.1"?>
<QBXML>
<QBXMLMsgsRq onError="continueOnError">
<PayrollSummaryReportQueryRq requestID="123">
<PayrollSummaryReportType >PayrollSummary</PayrollSummaryReportType>
<ReportPeriod>
<FromReportDate>2018-06-01</FromReportDate>
<ToReportDate>2018-06-30</ToReportDate>
</ReportPeriod>
<ReportClassFilter>
<FullNameWithChildren>Corporate</FullNameWithChildren>
</ReportClassFilter>
<SummarizeColumnsBy>Employee</SummarizeColumnsBy>
<IncludeSubcolumns>false</IncludeSubcolumns>
<ReportCalendar>FiscalYear</ReportCalendar>
<ReturnRows>ActiveOnly</ReturnRows>
<ReturnColumns>ActiveOnly</ReturnColumns>
</PayrollSummaryReportQueryRq>
</QBXMLMsgsRq>
</QBXML>Comments
-
Hi Darryl,
Thanks for your email. Unfortunately their is no option for this in the SDK.
The only filters available in the SDK are:
<ReportAccountFilter> (filter by account)
<ReportEntityFilter> (filter by entity type, or by entity name - as in customers, employees, etc.)
<ReportItemFilter> (filter by items - as in inventory items, service items, etc)
<ReportClassFilter> (filter by class)
<ReportModifiedDateRangeFilter> (filter by a date range)
<ReportDetailLevelFilter> (filter by detail level - as in the level of detail to show)
<ReportPostingStatusFilter> (filter by posting status - irrelevant to this report)
These are the only "Filters" available in the SDK for this report, and I couldn't find any report that will give you this filter via the SDK.
The only thing I can suggest, is that if all your payroll items for Gross Wages are linked to the same account and only those items are linked to that account, then you try filter it by that account. I can't say for sure if that will give you the result you want, but its the only suggestion I can make that may possibly help as far as the SDK goes.
In Reckon Accounts there is an option to export reports to CSV or Excel, so if one of those formats will meet your requirments you could run the report in Reckon Accounts, and customise to your specifications, and export to CSV or Excel.
Sorry I couldn't be more helpful on this query, but we are just limited by what the SDK can do.
Regards,
Shane
Reckon API Team.
0
Categories
- All Categories
- 6.4K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 5.9K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.3K Reckon Payroll 🚀
- 21 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 3K Reckon One
- 7 📢 Reckon One - Announcements
- 10 Reckon Invoices App
- 14 Reckon Insights
- 107 Reckon API
- 822 Payroll Premier
- 307 Point of Sale
- 1.9K Personal Plus and Home & Business
- 62 About Reckon Community