@hussainiii, let me try to explain what @Patch is telling you a different way. You are confused by what shows in your custom report. But you have no idea where the information is coming from. @Patch is suggesting that you add the general ledger account name to your Select criteria. That will tell you what general ledger transaction you are seeing on each line. Once you know that, you can use Where filters to exclude the accounts whose transactions you do not want to see.
For example, a simple sales invoice involving an inventory item will post transactions to:
- Inventory - sales
- Inventory - cost
- inventory on hand
- Accounts receivable
A purchase invoice will post transactions to:
- Inventory on hand
- Accounts payable
Your current custom report design will show all of those. Depending on the purpose for your report, it is doubtful you want to see all of those postings. So you must exclude the ones you don’t want. After you have determined the necessary filters (the Where entries), you can remove the unwanted columns from the report.
Average cost is not a field in general ledger transaction records. It is something calculated and displayed in the inventory item ledgers. So you will not get it in a custom report.
Also, the sales price and purchase price fields you have selected are unrelated to any actual sales or purchases. Those are just the default values you defined for the inventory items.
@Joe91 also offers good advice. You are trying to do everything at once, before you understand what the program is returning in your custom report. Grouping is the last thing you should add.