How to run a Material Acceptance Usage Report

Running the Report

From the Report Log, open the Material Acceptance Usage report and click Configure to set up your criteria:

Pay Items (required) — Choose which pay items to include. Only items that have Requires Material Acceptance enabled on the Pay Item list will appear here. Defaults to all eligible items.

When a field allows multiple selections, chosen values display as chips; if there isn't room to show them all, the field will show a chip indicating how many additional values are selected.

Click Run to generate the report, or Cancel to close the configuration without changes. You can reopen Configure at any time from the Report View page to adjust your selection and re-run.

NOTE: This report always runs for all dates — there is no date range filter. Because Quantity Recorded and Material Acceptance status are cumulative "to date" values, filtering by date range would produce misleading results, so the report intentionally reflects the full project history (the same approach used by the Item Variance Report).

TIP: Double clicking the report will open and run the report using the most recently used report configuration criteria.

Viewing the Report

The report shows one row for every Material Acceptance record entered against a selected item — so if an item has five separate acceptance entries recorded, that item will show five rows.

Results are organized as follows:

Items are listed ascending by Item Number
Within each item, Material Acceptance records are sorted descending by Date (most recent first)

Each row includes:

Column	Source
Section Number / Description	From the Pay Item list
Item Number / Description	From the Pay Item list
Authorized Quantity	From the Pay Item list
Accepted Quantity	From the Material Acceptance entry
Date	From the Material Acceptance entry
Remarks	From the Material Acceptance entry
Creator	From the Material Acceptance entry

Quantity Recorded and Material Acceptance Quantity Needed are shown as summary values only (see below) — they aren't shown at the individual row level, since both are cumulative, project-to-date figures rather than values tied to a single acceptance record.

Report Summary

At the bottom of each item group, the report displays summary totals:

Accepted Quantity — sum of all Accepted Quantity values recorded for the item
Quantity Recorded — total quantity recorded for the item across all Published and Archived Daily Report entries (excludes deleted entries)
Material Acceptance Quantity Needed — Quantity Recorded minus Accepted Quantity; this shows how much material still needs to be accepted to catch up with what's been recorded as completed
- If more Acceptance quantity has been entered then installed quantity has been recorded this value may be negative.

Exporting the Report

Click Export to choose between a PDF or Excel version of the report:

A notification appears letting you know your export is processing.
Once ready, you'll receive an email with a Download link. This link expires 3 days after the email is sent.
The downloaded file is named Material Acceptance Usage Report Export [yyyy-mm-dd], using the date the export was generated.

PDF Export: Generated in landscape orientation using the standard report header and footer, with longer text columns (Item Description, Remarks, etc.) wrapping as needed. Accepted Quantity is subtotaled by item, and the Quantity Recorded and Material Acceptance Quantity Needed summary values are also shown, matching the Report View.

Excel Export: The header row matches the report's current column order, and each row matches what's shown in the report, including the same summary values shown in the on-screen report. Field formats (like dates) are preserved — the export contains field values only, without any additional calculation logic.

If you have any questions, or need additional assistance, please reach out to our support team at support@facsware.com and we will be happy to assist you.