/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Is there a KACE report that totals dollar amounts?

01/13/2017 748 views
Want to create or find a report that will list out invoices by Vendor and then total the Invoice Amount field at the end.  
5 Comments   [ + ] Show comments

Comments

  • How are you storing invoices? I've never heard of using KACE to do so, but if the price information is available in a field then it almost certainly can be reported on.
  • We have these built into Asset Management as a defined asset type. So I am trying to extract from that specific report topic. The price or invoice amount is a defined field.
  • Are you trying to select each Vendor and give the total for all associated Invoice Amounts?
  • We could have a use for both types of reports. Either with a filter to capture just a single vendor, say by month, for a monthly total. Then with every vendor, breaking on each one with an individual total.
  • Since the Asset module is built dynamically, it would help if you could post the SQL for selecting the Asset Name, the Vendor, and the cost field. From that, we should be able to get you pointed in the right direction.

Be the first to answer this question

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ