Purchase Report Applet

Purpose and Overview

The Purchase Report Applet is the consolidated reporting workspace for your organization’s procurement spend. It answers the most critical procurement question: “What did we buy, from whom, and at what cost?”

Mastering the Purchase Report Applet: A User's Guide to Procurement Insights — Mastering the Purchase Report Applet: A comprehensive guide to procurement insights, covering report selection, role-based workflows, and real-world reconciliation scenarios.

Instead of manually reconciling purchase orders, invoices, and GRNs across multiple screens, this applet brings together purchase document data into structured report views — giving AP teams, finance managers, and purchasing administrators a single place to review purchase activity, analyze supplier spend, and export data for audit or planning purposes.

Core Concept: Choose the report by your procurement question

Use Purchase Report (by document) when the question is: “What specific transactions make up this spend?”
Use Purchase Report By Item Code when the question is: “How much did we spend on each item across all suppliers?”

Which Report Should I Use First?

If the user needs to know…	Start here	Why this is the right report
Line-item details behind a purchase figure	Purchase Report (by document)	It shows the individual transactions that make up the total.
Total spend or quantity by item code	Purchase Report By Item Code	It aggregates purchase data at the item level across all suppliers.
Who approved the spend	Any report filtered by Company or Branch	Filter the relevant report to focus on the approval context.

Who Benefits from This Applet?

Role	How they use it
AP Officers	Review purchase invoices and supplier spend, verify amounts before payment processing.
Purchasing Managers	Monitor purchase activity, review item-level spend, and compare quantities across branches.
Finance Managers	Run period-end purchase summaries for cost-of-goods calculations and budget reviews.
Finance Admins	Set default branch and location values and configure printable formats for exported reports.
Auditors and Reviewers	Open purchase document details, drill into line items, and trace document links for traceability.

What Problems Does This Solve?

Without This Applet:

Procurement teams pull data from purchase documents separately and reconcile manually in spreadsheets.
Finance cannot quickly answer “How much did we spend with Supplier X this quarter?” without running multiple reports.
AP teams struggle to see item-level totals without manually aggregating across documents.
Period-end purchase reviews require effort from multiple teams to compile reliable numbers.

With the Purchase Report Applet:

You get a shared purchase reporting workspace with filters for Supplier, Company, Branch, and Date Range.
You can move from document-level detail to item-level summaries without leaving the applet.
The report views support Export actions for Excel-compatible outputs at every level.
The document and drill-down views support PRINT actions where the workflow needs a shareable output.

Best used for operational review and period reporting This applet is designed for review, export, and analysis of completed or finalized purchase transactions. It does not expose edit or posting actions on source purchase documents.

The Reporting Framework: Understanding the Screens

Before jumping into each report, it helps to understand what filters and behaviors are shared across the applet.

Common Filters Across the Listings

All main report listings use a shared advanced-search model.

Filter / Search	What it does
Keyword Search	Searches the listing. Keyword must be at least 3 characters to be effective.
Supplier	Limits results to selected supplier entities.
Company	Limits results to selected companies.
Branch	Narrows results to one or more branches.
Date Range	Sets the start and end date for the report period.
Document Type	Switches the view between purchase order, purchase invoice, GRN, and related document types where applicable.

Important: Always set the Date Range before running any purchase report. The listing defaults may show a narrow current-period slice. Use a full month or quarter range for period reviews.

What Users Can and Cannot Do Here

This applet is good for…	This applet is not for…
Reviewing supplier spend by document type, date, or amount	Editing source purchase transactions
Drilling into line items and document detail for specific purchases	Posting payments, creating GRNs, or approving purchase orders
Exporting purchase data for audit, reconciliation, or planning	Replacing the source purchase order or invoice applets
Generating printable purchase summaries	Changing purchase document status or finalizing documents

Role-Based Quick Start Guides

For AP Officers: Review Purchase Transactions by Period

Your goal is to review finalized purchase invoices and supplier amounts for a given period.

Open Purchase Detail Report from the sidebar.
Set Supplier, Company, and Date Range to narrow the results.
If you use keyword search, enter at least 3 characters.
Run the search and review the listing columns: Document, Txn Date, Supplier, Amount, and Status.
Click a document row to open the detail view.
Review the tabs: Details, Line Items, Account, Settlement, and Doc Link.
Use the listing-level Export button to export the current result set if needed.

For Purchasing Managers: Review Item-Level Spend

Your goal is to identify high-volume or high-spend items across all suppliers.

Open Purchase Report By Item Code from the sidebar.
Filter by Company, Branch, and Date Range.
Review the grouped totals by item code, including Qty and Purchase Amount.
Expand any item group row to see the individual transactions that make up the total.
Export the result set to Excel for further analysis if needed.

For Finance Managers: Period-End Purchase Review

Your goal is to produce a purchase document review for cost-of-goods or budget review.

Open Purchase Report from the sidebar.
Set Company, Branch, and Date Range to cover the full review period.
Review the listing columns: Document, Supplier, Amount, and Doc Type.
Click a document row to open the detail view and review the tabs.
Use Export to download the result set as an Excel file.
If the applet shows Please setup the default printable format, go to Settings > Printable Format Settings and configure the required format first before generating printable output.

Deep-Dive: The Report Workspaces

1. Purchase Detail Report (The Transaction-Level Workspace)

Purchase Report By Document view showing a grid of purchase transactions with supplier and item details. — Purchase Report By Document: Drill into transaction-level procurement data across all companies and branches.

This is the default landing view for document-level purchase investigation.

Use this report when:

AP needs to verify one specific invoice or credit note
Finance needs to see the exact line items and amounts behind a purchase total
An auditor requests the supporting documents for a purchase transaction
A reviewer wants a printable document-level view

Report Columns:

Column	What it shows
Document	The purchase document identifier (invoice number, PO number, etc.).
Txn Date	The transaction date for the document.
Supplier Code	The entity code of the supplier.
Supplier Name	The supplier or vendor name.
Company Name	Company code and company name combined in one column.
Branch	The branch associated with the document.
Currency	Transaction currency.
Amount	Document total amount.
Status	Current document status (e.g., Finalized, Draft, Cancelled).

Document Detail Tabs:

Purchase Document Details view showing header information and multiple tabs including Lines, Settlement, and Doc Link. — Document Details: Review comprehensive document data including line items, GL accounts, and linked documents.

Tab	Purpose
Details	Main document-level header information.
Account	GL account breakdown and accounting entries for the document.
Line Items	Individual line items on the purchase document. Users can drill into View Item for item-level detail.
Delivery Details	Delivery-related information when present.
Settlement	Settlement records linked to the document.
Department	Department and cost-center allocation.
Contra	Contra entries or offsetting records.
Doc Link	Linked documents and document relationships, tracing the PO → GRN → Invoice chain.

Best use case: Start in Purchase Detail Report when the question is “What exactly is behind this purchase amount?” rather than “How much did we spend in total?”

2. Purchase Report By Item Code (The Item-Level Summary)

This screen provides an aggregated view of purchase activity grouped by item code, allowing for quick analysis of item-level spend and volume.

Purchase Report By Item Code view showing aggregated purchase totals grouped by individual item codes. — Purchase Report By Item Code: Analyze procurement spend and quantities at the individual item level.

Use this report when:

Purchasing needs to review the total quantity of a specific item purchased across all suppliers
Management wants to identify high-volume or high-spend items for contract negotiations
Inventory managers want to compare purchase totals against stock availability or demand

Report Columns:

Item Code: The primary grouping for the report.
Item Name: The descriptive name of the item.
Type: Item classification (e.g., BASIC_ITEM).
UOM: Unit of Measure.
Branch: The branch where the item was purchased.
Qty: Total quantity purchased for the period and filters.
Purchase Amount: Total spend for the item.

Applet Configuration (For Admins)

Navigate to Settings in the sidebar to configure the applet.

Application Settings

The Application Settings screen allows administrators to control the visibility of specific menu items within the applet.

Setting	Purpose
Sidebar Menu Toggles	Use these toggles to hide or show the Purchase Report and Purchase Report By Item Code menu items for all users.

Default Selection

This screen provides applet-wide default values.

Setting	Purpose
Default Branch	Preselects a branch for the applet.
Default Location	Preselects a location for the applet.

Field Settings

The field-settings screen controls which optional columns or fields appear in the report listings.

Group	Available toggles
Report Settings	Column visibility toggles specific to each report listing.
Department Settings	`Segment`, `G/L Dimension`, `Profit Center`, `Project`

Printable Format Settings

This setup is important if users need to generate printable report outputs.

Area	What users see
Listing	`Format Code`, `Format Name`, `File Name`, `File Size`, `Uploaded Date`, and `Uploaded By`
Add Printable Format	`Format Code`, `Format Name`, `Type`, `Default`, and file upload / drag-and-drop
Edit Printable Format	The same fields plus download and delete actions

The uploaded file must be a .jrxml file. Mark the format as Default if you want report print actions to use it automatically.

Personalization

Users also have a personalization area.

Section	Purpose
Default Selection	User-level default Branch and Location that override the applet defaults for that user.

Depending on deployment and permissions, administrators may also have access to additional routes such as Webhook, permission pages, and Release Notes. These are part of the applet routing but may not appear for every user in the standard menu.

Common Real-World Scenarios

Scenario 1: Month-End Purchase Spend by Item

The Situation: Finance needs total procurement spend per item for the month to support cost-of-goods calculations. The Workflow:

Open Purchase Report By Item Code.
Set Company and Date Range to cover the full month.
Review the aggregated spend totals by item code.
Export to Excel for further analysis or upload to the finance reporting tool.

Why this report fits the scenario: Item-level aggregation is faster than totaling individual documents, and the export supports downstream reconciliation.

Scenario 2: Investigate a Specific Purchase Document

The Situation: AP discovers a discrepancy in a specific purchase invoice and the team needs to review the full document details. The Workflow:

Open Purchase Report (by document).
Filter by the specific Supplier and the relevant Date Range.
Click the document row to open the detail view.
Review the tabs: Details, Lines, Settlement, and Doc Link.
Escalate to the relevant team to resolve any discrepancies.

Why this report fits the scenario: This is the document investigation workspace. It provides the complete view of a single purchase transaction.

Scenario 3: Audit Trail for a Specific Purchase Document

The Situation: An external auditor requests the full supporting documentation for a large purchase invoice — including the original PO, the GRN receipt, and the invoice. The Workflow:

Open Purchase Detail Report.
Search for the invoice document number or filter by supplier and date.
Open the document row in the detail view.
Use Doc Link to show the full PO → GRN → Invoice trail.
Use PRINT to generate a shareable output of the document detail.

Why this report fits the scenario: This is the document investigation workspace. It provides the complete audit trail without leaving the applet.

FAQs

Q: Which report should I open first?

Start with the question you need to answer. Use Purchase Report (by document) for investigating specific transactions, and Purchase Report By Item Code for aggregated item-level spend totals.

Q: What filters are available on the listing pages?

The shared listing filters are Supplier, Company, Branch, Date Range, and Document Type, plus keyword search. Keyword searches must be at least 3 characters long.

Q: Why does my purchase total not match the GL balance?

Check three things:

Ensure you are using the exact same date range in both the purchase report and the GL.
Ensure you are filtering by the same Company and Currency.
Verify that all relevant invoices have been Finalized/Posted. Draft or unposted documents may not appear in purchase reports but may exist in the GL.

Q: Can I generate a printable purchase statement from this applet?

Yes, if printable formats are configured. Go to Settings > Printable Format Settings, upload a .jrxml file for the required report type, and mark it as Default. Then use the PRINT action in the report or document detail view.

Q: Can I edit or post documents from this applet?

No. This applet is for review, drill-down, export, and print. It does not expose posting or edit actions on source purchase documents. Use the relevant purchase order, GRN, or invoice applet for those actions.

Q: What is the difference between Purchase Report and Purchase Report By Item Code?

Purchase Report (by document) is document-level and used for transaction investigation and audit. Purchase Report By Item Code is aggregated by item and used for spend analysis and volume reviews.

Q: Can I export the report results?

Yes. Each main listing screen includes an Export button for the current grid results.

Q: Why are some purchase documents not showing in the report?

Check the Date Range, Company, and Document Type filters. Draft or unposted documents may be excluded from finalized report views. If records are still missing, ask your administrator to review the applet’s data scope configuration.