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' )"