Some fields in APBILL and APBILLITEM cannot be queried - Githubissues

intacct / intacct-sdk-js

Official repository of the Sage Intacct SDK for JavaScript in Node.js

https://developer.intacct.com/tools/sdk-node-js/

Apache License 2.0

23 stars 33 forks source link

Some fields in APBILL and APBILLITEM cannot be queried #83

Closed justin-ch closed 2 years ago

justin-ch commented 2 years ago

Hello,

I'm seeing an error when querying some fields in these two objects using IA.Functions.Common.NewQuery.Query.

ResultException [Error]: Result status: failure for Control ID: 65d824c7-68c1-4a9c-9cea-cc4007c76ac6 - XL03000006 The following fields cannot be queried: [ apbill: [PAYTOCONTACTNAME, RETURNTOCONTACTNAME] ] [Support ID: LYF3ZEB034%7EYeogyP0F2YJ-hwZWD-iCgQAAABU]

These are the fields that I've run into issues with:

APBILL

PAYTOCONTACTNAME
RETURNTOCONTACTNAME

APBILLITEM

GLACCOUNTNO

I'm using the version 2.1.1 of the @intacct/intacct-sdk

ryan-holderfield-sage commented 2 years ago

Hi @justin-ch, please be sure to build/validate your fields for the new query function by using the lookup function:

Developers Site for query

Lookup function

dylan-holt-sage commented 2 years ago

@justin-ch, did the above comment resolve your issue?

dylan-holt-sage commented 2 years ago

Closing this issue.... if it is persisting, please reopen and we will revisit.