/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide 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.
Please log in to comment

There are no answers at this time
Answer this question or Comment on this question for clarity

Answers