hi! how can i get a sales report to include COG on...
# suiteanalytics
s
hi! how can i get a sales report to include COG on kits? We have kits that include individual items, and kits that include kits. When I run a sales by item report, I don't know that the COGS is included for kits (that have individual components or set components). Is there a way to include this information on a sales by item report?
s
Heya Shannan, while it's not the same exact thing, I had to write a script that ran on our Assembly Items (different than Kit Items) and upon saving it, the script went out and found the average cost/purchase price for each component and stored that cost in some custom fields I created too... We basically had a custom field for Total Cost and some other fields, depending on their Expense/COGS account if that makes any sense.
s
Thank you Sirus! 🙂