This article will allow you to see how much your part valuation is worth at the time of running the report 


The default of this report will include all parts with either an in-stock quantity OR an oversold qty - in the parameters /  filters, it is referred to as the inventory quantity 


The report will report on actual cost (not average cost)


For example:

  • you have a part that has stock on hand quantity of 2
  • quantity of 1 was purchased at a cost of $10
  • quantity of 1 was purchased at a cost of $11
  • the actual cost this report will show for this part will be $10 + $11 = $21 



Tip:

This report is only as good as the day it is run 

Blackpurl does not give you the option of back dating the report and have it generate for a past date

BUT you can setup Scheduled Reporting to have this report automatically run at a certain frequency and be emailed to Blackpurl Licenced Users

For further information on Scheduled Reporting, please review our article - Reporting - Scheduled Reporting



How to run the Report:



  1. From the Blackpurl Header > Reporting > Reports


User-added image


  1. Run the Part Valuation Report  - Common Search > Reporting > Part Inventory Valuation




The Default parameters means that the report result will list all Inventory Qty - not equal to 0 

It will list not only parts with stock on hand but also parts that have a negative value ie oversold in Blackpurl at this point in time


Just a few tips for you:


  • You can change the parameters as required by clicking on  
For example if you are running this report as part of your Data Emergency Plan (see this article - Operating during Power or IT Infrastructure Failure) you will need to change the parameter to: Qty Available: Greater than zero

  • This is a good time to add / removing any columns by clicking on User-added image 
For example: 
  • if you are  balancing out your Blackpurl Parts Inventory Valuation totals to your Accounting Package, we would recommend you add the column - CATEGORY


  • if you want to Available Cost or Committed Cost then the user can add the relevant columns 

  1. If you need to see Summary Totals > click on


If you want to see more totals, simply click on  and select which other totals you want to see ie Available Cost or Committed Cost etc 




If you want to print / export the data > click on  and Select Output Result requirement


TIP:

If you are balancing Blackpurl to your Accounting Package, we would recommend that you Group Records By: Category as this will allow you to compare the Part Inventory General Ledger (which is attached to the Category) to the relevant General Ledger in your Accounting Package



  1. Once you are happy with the layout of the report etc, we would recommend that you save it as a CUSTOM search by clicking on User-added image

For further information on Blackpurl Reports or Reporting Tips - please review our articles:


 Reporting - Where are the Reports? or Reporting Tips - Totals / Changing Columns / Changing Parameters / Exporting Search Results