0

Actually I am getting invoice details through the sales order but not getting details of linelevel data of invoice then my question is how to fetch this details using suiteql.

SELECT DISTINCT NTo.tranid AS 'invoice tranid' ,
FROM NextTransactionLineLink AS NTLLo 
INNER JOIN Transaction AS NTo ON NTo.ID = NTLLo.NextDoc
 WHERE NTLLo.PreviousDoc = t.id
 AND NTo.Type = 'CustInvc' `This is my query and I want item information using above details`

Pratiksha
  • 1
  • 1

0 Answers0