Scenario
The Purchase by Vendor and Purchase by Item Reports are designed to display vendor bill amounts that are posted to Expense and Other Expense accounts. Bills that are posted to Other Current Liability account would not show on the reports. For example: Tax Item record on Bills would not show on the report. Currently Enhancement 80447 is logged to requested for ability to display all bills on Purchase by Vendor and Purchase by Item Reports. The alternate solution is to create a custom report.
Note: To search and vote for the Enhancement see 10054 Voting for Enhancements.
Solution
- Navigate to Reports > New Report
- Click Transaction
- Report Title: Enter Title
Example: Purchase by Vendor - Select the field you want to report on:
- Metric: Select Amount
- Select the format of the report:
- Select Summary
- Select how you want to subtotal the report:
- Component: Select Account
- Field: Select Name
- Click More Customization Button
- Click Edit Columns
- Click Name column
- Click Remove Column
- Top left panel: Add Fields section:
- Click Transaction
- Click Entity(Line)
- Click Name (Group)
Note: If you see to two Name(Group) fields, select the first one. - Click Column: Entity(Line): Name (Group)
- Column Label: Enter Vendors/Payees
- Click Filters
- Top left panel: Add Fields section
- Click Transaction
- Click Transaction Type
- Filter: Select Equal to
- Select Multiple: Select Bill
- Click Done
- Click Account
- Click Account Type
- Filter: Select Equal to
- Select Multiple: Select AcctPay
- Click Done
- Click Sorting
- Top left panel: Add Fields section:
- Click Transaction
- Click Entity(Line)
- Click Name (Group)
Note: If you see to two Name(Group) fields, select the first one. - Click Add
- Report Components: Entity (Line)
- Click Move Up
- Click Save