Item wise Report for Finished Goods in Metric ton

Jira Code: DRF-204

• Created a search which displays the sales per item with criteria
  • Transaction type: invoice, cash sale
  • Item-type : Inventory Items
  • COGS Line : false
  • Shipping Line : false
  • Main-Line : false
    
• In results add :
  • Item name: Group,
  • Quantity : SUM
  • ASSOCIATED IN KG in item record(custom field) : Group,
  • Formula(currency) : SUM :(NVL(TO_NUMBER({item.custitem_jj_drf_75_qty_assoc}),0)*NVL({quantity},0))/1000
• Also calculated the items in metric done which is: (QUANTITY ASSOCIATED IN KG in item record * Quantity)/1000. Also set date filters.