Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Querying Purchase Orders through smbXML
The transaction custom form has the field, trandate with description Date and laberl Date. It is one of the mandatory fields on the form. I want to query on the date and only get Purchase Orders that are greater than a certain date.
Not having much luck at the moment, I have tried both trandate and Date in the name field and it isnt going through. This is the error for both trandate and Date;
<error>Used invalid smbXML element name [trandate] in query.</error>
This is the query XML I am using;
<query>
0