Hi everyone, I’m working on a SuiteQL query in Net...
# general
v
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!🙏
c
COGS amount isn't directly visible in SuiteQL. It's calculated behind the scenes. Try joining the TransactionLine to the InventoryAssignment table. Alternatively, use TransactionAccountingLine filtered by account type "Cost of Goods Sold" to get the GL impact instead of the inventory calculation.
j
Hi @Vaibhav Patil did you get this working? I'm encountering the same issue when trying to get {cogsamount} in a Transaction Analytics Dataset.