Does anyone know which table I need and which display value to show sales (in $$$) by part on a report?
Invoice Detail, you will need to summarize.
2 Likes
right now I have the customer : part number : total invoice amount : Total Quantity. The last column I need is to pull together total quantity and price per part to make a column showing the sales for each part in a given time frame.