Showing COGS Account of an item record in item search.

Requirement: User wants to fetch the COGS account of all the item records in the item search.

Solution:

Formula (Text) > Summary Type = Maximum >

Formula = case when {‌transaction.accounttype} = ‘Cost of Goods Sold’ then {‌transaction.account} else null end Custom Label = COGS

Summary Type = COGS

This will however only works with items with transactions since the fields that it will be using will be coming from transactions history.