Custom report for inventory sales and purchase price

During development show more data about each item in the general ledger (which is what custom reports show).

In particular at least show the general ledger account name. For more details see the start of this post Custom Report Not Returning Transaction Type Properly - #12 by Patch

The most likely reason to show double the expected amount is Manager is a double entry accounting system so everything is entered twice.