nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

profit by product report

anthonyha1

Hi , does anyone know how you can create a profit by product report to dump into excel?

Ie. cost price of each item and sell price printed in one document.

Find more posts tagged with

Accepted answers

Mike_James

Hi @anthonyha1 , after adding the fields, go back to the first tab, and click the green curly arrow to refresh the report. If you don't do that the export will omit the new files.

I'll respond to your question about costs when I have a moment.

All comments

anthonyha1

Hi MIke ,
Thank you for your great answer. I tried to rerun the report but didn't seem to save the new settings. I didn't notice a rerun button on the same screen as modify. I print screened it and that worked.

There seems to be 4 different definitions for costs. If you know what these are i would much apprecate your feedback.

Last cost incl

Last cost

last purchase price

Anthonyha1

buying price

Mike_James

Hi @anthonyha1 , welcome to the forum. Run the Sales Item Detail report to the screen, then select the Modify tab, and click Show/Hide. Then add gross margin $ and gross margin % fields. You may also wish to remove any fields you don't need. Then go back and re-run the report. Then once the new fields are on screen, select the down arrow (top left) and send to excel.