The Part Inventory Accounts report shows you the total value of your part inventory as recorded in Blackpurl. Run this report regularly to reconcile your Blackpurl part inventory totals against the relevant Part Inventory General Ledger accounts in your accounting package.
What This Report Is For
The Part Inventory Accounts report shows what Blackpurl indicates as the total of your part inventory. Use it to verify that your inventory valuation in Blackpurl matches the corresponding General Ledger accounts in your accounting package.
How to Run This Report
Navigate to the report by going to Reporting in the Blackpurl header, then selecting Reports > Reconciliation > Part inventory accounts.
The report is pre-configured with the filters, columns, and totals you need. To view the inventory valuation total, click Totals and review the Inventory Valuation total.
Totals may initially appear blank while they are being calculated. If you have a large inventory, allow a short time for the calculation to complete before the totals appear.
Breaking Down Valuation by Part Inventory Category
To report on the valuation for each Part Inventory Category, add a Category column to the report:
1. Click Columns and select Category from the list.
2. Click Save As to save your customised report layout.
3. Click Select Column to Group and choose Category to group records by category.
4. Confirm that Group Records By: Category is set correctly.
5. Set Output Results To: Excel (.CSV).
6. Click Apply to generate the export.
The exported CSV file provides totals for each category, allowing you to balance each category against the relevant General Ledger accounts in your accounting package.
When to Use This Report
Run this report regularly — at minimum at the end of each month — so you can balance your accounting package's Part Inventory General Ledger accounts against your Blackpurl part inventory totals.
What to Do With This Report
If your dealership has accounting integration enabled, use this report to compare your Blackpurl part inventory totals against the relevant Part Inventory General Ledger accounts in your accounting package.
For step-by-step guidance on performing this comparison, see Reconcile Part Inventory to Your Accounting Package.
More Information on Reporting
The following articles provide additional detail on working with reports in Blackpurl:
Reporting Tips - Totals / Changing Columns / Changing Parameters / Exporting Search Results / Save Custom Reports / Scheduling Reports / Favourite Reports (no longer available) — how to get totals, change columns and filters, print or export, and save custom reports
Scheduled Reporting — how to schedule a report to generate automatically and be emailed to a Blackpurl user
Reporting - Where are the Reports? (no longer available) — where to find all reports in Blackpurl
Share a Custom Report in Blackpurl — how to share custom reports with other users