CData Excel Add-In for Reckon 2019 - Online Help
Questions / Feedback?

ReportTime

CData Excel Add-In for Reckon 2019 - Build 19.0.7354

Generates summary and detail reports related by time.

Input

Name Type Description
Reporttype String The type of the report.

The allowed values are TIMEBYITEM, TIMEBYJOBDETAIL, TIMEBYJOBSUMMARY, TIMEBYNAME.

The default value is TIMEBYITEM.

Reportperiod String Report date range in the format fromdate:todate where either value may be omitted for an open-ended range (e.g., 2009-12-25:). Supported date format: yyyy-MM-dd.
Reportdaterangemacro String Use a predefined date range.

The allowed values are ALL, TODAY, THISWEEK, THISWEEKTODATE, THISMONTH, THISMONTHTODATE, THISQUARTER, THISQUARTERTODATE, THISYEAR, THISYEARTODATE, YESTERDAY, LASTWEEK, LASTWEEKTODATE, LASTMONTH, LASTMONTHTODATE, LASTQUARTER, LASTQUARTERTODATE, LASTYEAR, LASTYEARTODATE, NEXTWEEK, NEXTFOURWEEKS, NEXTMONTH, NEXTQUARTER, NEXTYEAR.

The default value is ALL.

Entitytype String Allows the user to query for a specified name type.

The allowed values are NONE, CUSTOMER, EMPLOYEE, OTHERNAME, VENDOR.

The default value is NONE.

Entitylisttype String Allows the user to query for specific list elements.

The allowed values are LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN.

The default value is FULLNAME.

Entitylists String The list elements to report on. For LISTIDLIST and FULLNAMELIST, use a comma-separated list.
Itemtype String Allows the user to query for a specified item type.

The allowed values are NONE, ALLEXCEPTFIXEDASSET, ASSEMBLY, DISCOUNT, FIXEDASSET, INVENTORY, INVENTORYANDASSEMBLY, NONINVENTORY, OTHERCHARGE, PAYMENT, SALES, SALESTAX, SERVICE.

The default value is NONE.

Itemlisttype String Allows the user to query for specific list elements.

The allowed values are LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN.

The default value is FULLNAME.

Itemlists String The list elements to report on. For LISTIDLIST and FULLNAMELIST, use a comma-separated list.
Classlisttype String Allows the user to query for a specified class.

The allowed values are LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN.

The default value is FULLNAME.

Classlists String The list elements to report on. For LISTIDLIST and FULLNAMELIST, use a comma-separated list.
Summarizecolumnsby String Determines which data the report calculates and how the columns will be labeled across the top of the report.

The allowed values are NONE, ACCOUNT, BALANCESHEET, CLASS, CUSTOMER, CUSTOMERTYPE, DAY, EMPLOYEE, FOURWEEK, HALFMONTH, INCOMESTATEMENT, ITEMDETAIL, ITEMTYPE, MONTH, PAYEE, PAYMENTMETHOD, PAYROLLITEMDETAIL, QUARTER, SALESREP, SALESTAXCODE, SHIPMETHOD, TERMS, TOTALONLY, TWOWEEK, VENDOR, VENDORTYPE, WEEK, YEAR.

The default value is NONE.

Includesubcolumns String Determines whether to include any subcolumn information.

The allowed values are TRUE, FALSE.

The default value is FALSE.

Reportcalendar String Specifies the type of year that will be used for this report.

The allowed values are NONE, CALENDARYEAR, FISCALYEAR, TAXYEAR.

The default value is NONE.

Returnrows String Specifies whether you want the report to include only rows with active information, only rows with nonzero values, or all rows regardless of their content or active status.

The allowed values are NONE, ACTIVEONLY, NONZERO, All.

The default value is NONE.

Returncolumns String Specifies whether you want the report to include only columns with active information, only columns with nonzero values, or all columns regardless of their content or active status.

The allowed values are NONE, ACTIVEONLY, NONZERO, All.

The default value is NONE.

Delimiter String Set the delimiter character for the fields

The default value is ;.

Result Set Columns

Name Type Description
Rowtype String The type of row being output. For example, TitleRow, TextRow, DataRow, SubtotalRow, or TotalRow.
Column_value String The data in this row in a semicolon separated list of the report.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0