Team, on a transaction search via SuiteTalk SOAP, ...
# suitetalkapia
Antonio Garcia
11/19/2024, 9:36 AMTeam, on a transaction search via SuiteTalk SOAP, I am getting columns from the main transaction header but I would like to add columns from the lines. Do you know how to define columns form the line?
Antonio Garcia
11/19/2024, 9:36 AMHere is my XML
Antonio Garcia
11/19/2024, 9:36 AM<s:Body>
<search xsitype=‘platformMsgsSearchRequest’>
<searchRecord xsitype=‘tranSalesTransactionSearchAdvanced’ xmlnsplatformSearch=“urnsales_2023_1.transactions.webservices.netsuite.com” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”>
<platformSearch:criteria>
<platformSearch:basic>
<platformCommon:type platformCommon:operator=“anyOf”>
<platformCoresearchValue> invoice</platformCoresearchValue>
</platformCommon:type>
</platformSearch:basic>
</platformSearch:criteria>
<platformSearch:columns>
<platformSearch:basic>
<amount xmlns=“urn:common_2023_1.platform.webservices.netsuite.com”/>
<currency xmlns=“urn:common_2023_1.platform.webservices.netsuite.com”/>
<fxAmount xmlns=“urn:common_2023_1.platform.webservices.netsuite.com”/>
<internalId xmlns=“urn:common_2023_1.platform.webservices.netsuite.com”/>
<lastModifiedDate xmlns=“urn:common_2023_1.platform.webservices.netsuite.com”/>
<line xmlns=“urn:common_2023_1.platform.webservices.netsuite.com”/>
<lineSequenceNumber xmlns=“urn:common_2023_1.platform.webservices.netsuite.com”/>
<memo xmlns=“urn:common_2023_1.platform.webservices.netsuite.com”/>
<message xmlns=“urn:common_2023_1.platform.webservices.netsuite.com”/>
<refNumber xmlns=“urn:common_2023_1.platform.webservices.netsuite.com”/>
<serialNumber xmlns=“urn:common_2023_1.platform.webservices.netsuite.com”/>
<source xmlns=“urn:common_2023_1.platform.webservices.netsuite.com”/>
<subsidiary xmlns=“urn:common_2023_1.platform.webservices.netsuite.com”/>
<title xmlns=“urn:common_2023_1.platform.webservices.netsuite.com”/>
<tranDate xmlns=“urn:common_2023_1.platform.webservices.netsuite.com”/>
<transactionNumber xmlns=“urn:common_2023_1.platform.webservices.netsuite.com”/>
<type xmlns=“urn:common_2023_1.platform.webservices.netsuite.com”/>
<customFieldList xmlns=“urn:common_2023_1.platform.webservices.netsuite.com”>
<customField scriptId=“custbody_ewg_entvatid” xsi:type=“SearchColumnStringCustomField” xmlns=“urn:core_2023_1.platform.webservices.netsuite.com”/>
</customFieldList>
</platformSearch:basic>
<platformSearch:subsidiaryJoin>
<nameNoHierarchy xmlns=“urn:common_2023_1.platform.webservices.netsuite.com”/>
</platformSearch:subsidiaryJoin>
</platformSearch:columns>
</searchRecord>
</search>
</s:Body>
6 Views