Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
Sales Order Total in Rest Query ( SuiteQL )
Hi Guru ,
Happy to connect with you again.
I'm developing a query to get list of sales orders for a customer using REST query services. I'm able to get all required details from the sales order but not Amount.
I tried with different names/ids but not able to get the total of sales order.
Could you please help me over this ? Below is the body used in the request.
{
"q": "SELECT BUILTIN.DF( Transaction.TranID ) AS OrderNumber, Transaction.Entity, BUILTIN.DF( Transaction.Entity ) AS CustomerName,Transaction.BillingAddress, BUILTIN.DF( Transaction.BillingAddress ) AS BillingAddress,Transaction.ShippingAddress, BUILTIN.DF( Transaction.ShippingAddress ) AS ShippingAddress,Transaction.ShippingAddress, BUILTIN.DF( Transaction.ShippingAddress ) AS ShippingAddress, BUILTIN.DF(Transaction.custbody_total_quantity) AS ItemsCount,Transaction.Total,Transaction.TranDate,BUILTIN.DF( Transaction.StartDate ) AS StartDate,BUILTIN.DF( Transaction.custbody_xwarehouse ) AS CancelDate, BUILTIN.DF( Transaction.Status ) AS OrderStatus, Customer.LastName, Customer.FirstName, Customer.Email, Customer.ID, FROM Customer INNER JOIN Transaction ON ( Customer.ID = Transaction.Entity ) WHERE ( Customer.ID = '123678' ) AND ( Transaction .Type = 'SalesOrd' )"