Hi everyone, I’m working on a SuiteQL query in NetSuite and I need to pull the '*cogsamount'* field. I tried checking the Transaction, TransactionLine and TransactionAccountingLine records, but I’m not seeing a clear way to get it in SuiteQL.
Has anyone successfully retrieved cogsamount in a SuiteQL query? If yes, could you please guide me on which table/field to join or query from? Thanks In Advance!🙏