Sales Invoice by Date Range with Details Items

You can’t get the report you want, because the unit price field is not exposed in the general ledger transactions table. (I assume from your screen shot that is what you mean by “Amount,” although the Amount field is actually something else in Manager. The closest you can get is to use the sales price for the inventory item. Note, however, that number will come from the inventory item definition, not the sales invoice. If you edit it or discount it, the change will not show up on your custom report. See below: