Is there a KACE report that totals dollar amounts?
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
-
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. - JasonEgg 7 years ago
-
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. - pams 7 years ago
-
Are you trying to select each Vendor and give the total for all associated Invoice Amounts? - grayematter 7 years ago
-
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. - pams 7 years ago
-
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. - grayematter 7 years ago
Answers (0)
Please log in to answer
Be the first to answer this question
