I have inventory items and non-inventory items, I would like to create a report for each item along with the custom fields for the item (ICF) itself not for the sales invoice custom fields.
Example:
Inv#501 Customer: Joe Date: 06/06/24 PRN# JXD235 D.P Date 07/24/24
Line Item Type Description Com Policy Qty Price Total
1 1004 ADT AMM-JFK $70 Xn Cy 2 $470 $940
2 1004 CHD AMM-JFK $65 Xn Cy 4 $400 $1,600
from this example I am looking to create detailed report will show only:
Date Item Type (ICF) Description Com (ICF) Policy (ICF) Amount
06/06/24 1004 ADT AMM-JFK $70 Xn Cy $470
06/06/24 1004 ADT AMM-JFK $70 Xn Cy $470
06/06/24 1004 CHD AMM-JFK $65 Xn Cy $400
06/06/24 1004 CHD AMM-JFK $65 Xn Cy $400
06/06/24 1004 CHD AMM-JFK $65 Xn Cy $400
06/06/24 1004 CHD AMM-JFK $65 Xn Cy $400
What Should I do to get it detailed like this including the item custom fields. I created a report but it only shows it as totals by the invoice for the item.
as you see it shows there is no custom fields but I have them