CUSTOMER.CUSTTYPE in readbyquery

[Ming Han Chung]

Im having a problem where I can use CUSTOMER.CUSTTYPE in my readbyquery . In the new Query it works but readby it doesn't. Is there anyway to access this field in the query?

 

?xml version="1.0" encoding="UTF-8"?>

<request> <control> <senderid>REDACTED</senderid> <password>REDACTED</password> <controlid>1715270549</controlid> <uniqueid>false</uniqueid> <dtdversion>3.0</dtdversion> <includewhitespace>false</includewhitespace> </control> <operation transaction="false"> <authentication> <login> <userid>REDACTED</userid> <companyid>REDACTED</companyid> <password>REDACTED</password> </login> </authentication> <content> <function controlid="a0736698-dff3-495d-915a-c5fbb18d2de5"> <readByQuery> <object>ARINVOICE</object> <query>WHENCREATED <= '01/30/2024' and TOTALDUE != '0.00' and CUSTTYPE = CLAIMS </query> <fields>RECORDID,CUSTOMERID,CUSTOMERNAME,CUSTOMER.CUSTOMERID,CUSTOMER.STATUS,TOTALPAID,TOTALDUE,TRX_TOTALDUE,WHENCREATED,CUSTOMER.CUSTTYPE,WHENDUE,DOCNUMBER</fields> <pagesize>500</pagesize> <returnFormat>xml</returnFormat> </readByQuery> </function> </content> </operation> </request>

 

This is the xml. when doing customer.custonerid it works fine.

[Lee Savidge]

Not sure if it will work but change this:

<query>WHENCREATED <= '01/30/2024' and TOTALDUE != '0.00' and CUSTTYPE = CLAIMS </query>

to

<query>WHENCREATED <= '01/30/2024' and TOTALDUE != '0.00' and CUSTOMER.CUSTTYPE = 'CLAIMS'</query>