Skip to main content
Question

Mulch Used Report

  • April 14, 2026
  • 2 replies
  • 56 views

Forum|alt.badge.img+1

I am looking for a report that will show me how many total yards of mulch used on completed tickets this month. I was using the Work Tickets Pivot Table, but that only shows total material cost, not quantities. 

2 replies

Forum|alt.badge.img+12
  • Employee
  • April 15, 2026

a purchase pivot might be the better option.  Filter your dates to this month, set "Item Name" (or Allocation Name) as a Row field, and select "Allocation Quantity" as your Data field.  Might not able to get ONLY completed tickets this way though.  


BADV-Brady
Forum|alt.badge.img+9
  • Participating Frequently
  • April 17, 2026

To piggy-back off rc3’s great advice - some other tips when using the Purchases Pivot:

  • Blank Work Ticket Number = Inventory Adjustment
  • Blank Vendor = Pulled from Inventory (can use various others, this is just the one I use)

Also - if you want to make sure you’re only at COMPLETED tickets in a specific period - you could grab a completed work ticket list with your date filters on it, and use your preferred LOOKUP function in Excel (I recommend XLOOKUP) to add “WT Completed Date” column to the purchases pivot export (add WT # as a display field prior to export - use that as the lookup value).

 

Another workaround I’ve used (if Mulch WTs ONLY material cost is Mulch) - take your catalog allocation unit cost x actual material costs on the WTs to reverse engineer the quantities allocated.

 

The final workaround: IF your company doesn’t regularly use Purchasing Assistant (AND doesn’t clean out completed work tickets) - you can actually see “Allocated Quantity” there, as well as filter for completed date, and even filter by Service.

 

I REALLY wish Aspire allowed access to the data displayed in Purchasing Assistant as a Standard Report (even after a company uses/clears the lines) - it’s literally the best source when looking at item-specific allocations.