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

InvoiceDetailsGroupByDate

CData Excel Add-In for FreshBooks 2019 - Build 19.0.7354

Returns information about all, or a filtered set of invoices, as grouped by each month.

Columns

Name Type Description
Billed Decimal Billed amount, two decimal places.
Collected Decimal Collected amount so far, two decimal places.
Outstanding Decimal Outstanding amount (remaining), two decimal places.
CurrencyCode String Three-letter currency code.
Year String Year which the invoice was sent.
Month String Month which the invoice was sent.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ClientId String Identifier for the client.
Status String Status of invoice.
DateFrom Datetime Starting date filter.
DateTo Datetime Ending date filter.

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