- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-20-2017
06:26 AM
07-20-2017
06:26 AM
Home Currency on zoqlexport
hello team,
Since I work with invoices in multiple currencies, I have been trying to run a query that would convert all my invoices into home currency (EUR, in my case).
However, my query never seems to work.
{ "format" : "csv", "version" : "1.1", "name" : "Reporting", "encrypted" : "none", "useQueryLabels" : "true", "project" : "InvoiceWithCurrency", "dateTimeUtc" : "false", "queries" : [ { "name" : "Example",
"convertToCurrencies": "EUR", "query" : "select Subscription.CreatedDate, SoldToContact.Country, Invoice.InvoiceNumber, Invoice.AmountWithoutTax, Account.Currency, Invoice.AmountWithoutTaxEUR from InvoiceItem", "type" : "zoqlexport" }] }
Can anybody help me understand what is my mistake in this specific example?
Labels: