How to show price per transaction in custom report?

[wohata5562]

Hi,

I’m trying to show price per transaction in custom report, but no luck with me.

Result:

[Joe91]

The field you have selected Inventory Item/Sales price is the sales price from the Inventory record not the sales price on the invoice

I don’t think that the unit price on the invoice is exposed and so it is not available for a custom report

[wohata5562]

What i must do? i tried all inventory and non-inventory item, but nothing work

[Joe91]

All you can do is create a custom report with quantity and sales value, export it to Excel and calculate the price in Excel by dividing one by the other

[wohata5562]

Thanks