- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Problem:
Error while querying AmountHomeCurrency and HomeCurrency from JournalEntryItem using AQuA:
Request example:
{ "format" : "csv", "version" : "1.1", "name" : "JournalEntryItem", "encrypted" : "none", "useQueryLabels" : "true", "dateTimeUtc" : "true", "queries" : [ { "name":"JournalEntryItem", "query":"select AmountHomeCurrency and HomeCurrency from JournalEntryItem", "type":"zoqlexport" } ] }
Response:
{ "errorCode": "90005", "message": "There is a syntax error in one of the queries in the AQuA input", "useLastCompletedJobQueries": false, "batches": [ { "localizedStatus": "pending", "recordCount": 0, "full": true, "apiVersion": "97.0", "batchType": "zoqlexport", "status": "pending", "name": "JournalEntryItem", "query": "select AmountHomeCurrency and HomeCurrency from JournalEntryItem" } ], "encrypted": "none", "status": "error", "name": "JournalEntryItem", "offset": 0, "version": "1.0", "format": "CSV" }
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Cause:
"Currency Conversion" feature is not enabled in the tenant, therefore HomeCurrency and AmountHomeCurrency fields are not available in journal Entry Item object.
https://knowledgecenter.zuora.com/CC_Finance/D_Finance_Settings/F_Foreign_Currency_Conversion
As checking from data source export against Journal Entry Item object.
- Feature disabled:
- Feature enabled:
Solution:
- Remove HomeCurrency and AmountHomeCurrency fields from the query
- Or, if you wish to have access to this Currency Conversion feature, submit a request at Zuora Global Support.
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √