COGS Amount Saved Search have the Transaction.{cogsamount} field. How can I get COGAmount from SuiteAnalyitcs Connect (the field is not on the table)

just a guess but join with transactionline where iscogs = true

accountingline table is your friend