Reporting Tags
Reporting Tags act like labels you attach to a notebook or file. In Zoho Procurement, you can create reporting tags and associate them with items, vendors, and purchase transactions to make them easy to identify and organize.
As businesses grow, they expand across multiple departments and locations. When you generate analytic reports, it becomes hard to find details pertaining to a particular department or location. By setting up reporting tags, you can link them to specific items, vendors, and transactions, then filter your analytic reports based on the associated tags to get a clear breakdown of your procurement spend.
You can also organize tag options in a parent-child hierarchy, control when each option appears using visibility conditions, make a tag mandatory, and restrict access to tagged records.
Scenario: Zylker Corporation works with a wide range of vendors to source office supplies, IT equipment, and professional services. To track vendor spending, Patricia, the procurement admin at Zylker, creates a reporting tag called Vendor Category with options such as IT Services, Office Supplies, and Logistics, adding sub-options under IT Services, such as Hardware and Software. Now, Patricia can filter analytic reports by this tag and its options to analyze spending patterns for each vendor category.
Create Reporting Tags
Note: You can create a maximum of 10 reporting tags, and each reporting tag can have a maximum of 500 options.
To create a reporting tag:
- Go to Settings in the top right corner of the page.
- Click Reporting Tags under Customization.
- Click + New Reporting Tag in the top right corner.
You’ll be directed to the reporting tag creation page, where you can configure the tag across four steps: Create Reporting Tag, Configure Options, Configure Visibility Conditions, and Access Control.
In the Create Reporting Tag step, name the tag and choose the modules you want to associate it with. Here’s how:
- Enter a name for the reporting tag in the Reporting Tag Name field.
- Enter a Description, if required.
- Under Associate This Reporting Tag To, select the modules you want to associate the reporting tag with: Purchases, Vendors, or Items.
- If you select Purchases, choose whether the tag applies At Transaction Level, where the tag is applied to the entire transaction, or At Line Item Level, where the tag is applied to individual line items within a transaction.
Note: You can associate a reporting tag with the Items module only if Purchases is associated At Line Item Level. Since the Items module tracks tags for individual items, a tag applied at the transaction level can’t be assigned to specific items.
- Enable Make This Reporting Tag Mandatory option to ensure the tag is applied to all relevant transactions. A mandatory reporting tag should have at least one active option.
- Click Save and Continue to move to the Configure Options step.
Note: A reporting tag is saved as Not Ready until it has at least one option. To mark it as ready, hover over the tag on the Reporting Tags list page, click the More icon, and select Mark as Ready.
Configure Options
In the Configure Options step, you can create the options users will select while recording transactions. You can also arrange options in a parent-child hierarchy by adding sub-options under a main option, up to five levels deep.
To configure options for a reporting tag:
- Enter an option name in the Configure Options step.
- Click + Add Option to add a new option, or hover over an existing option and click the + icon to:
- Select Add Option Above to add an option above the selected option.
- Select Add Option Below to add an option below the selected option.
- Select Add a Child to add the option as a sub-option of the selected option.
- Click the Delete icon next to an option to remove it.
- Click Save and Continue to move to the Configure Visibility Conditions step, or click Save and Exit if you don’t want to set visibility conditions.
Configure Visibility Conditions
Visibility conditions let you control when each option of a reporting tag appears on a transaction by mapping it to the options of other reporting tags. This is disabled by default.
Scenario: Patricia creates a reporting tag called Department with options Procurement, Finance, and Operations, and selects Location as a filter for this tag. She maps the Finance option to appear only when the selected location is New York. When a user records a bill, the Finance option under Department appears only if the transaction’s location is New York.
To configure visibility conditions for a reporting tag:
- Slide the Configure When Tag Options Should Be Visible toggle.
- Under Choose Filters, select the reporting tags you want to use as filters for the current tag. You can only use tags that appear before the current tag on the Reporting Tags list page as filters.
- Map each option in the current tag to specific options of the filter tags you selected. An option is visible only when one of the mapped filter options is selected. You can add up to five filters per tag and map up to 200 options.
- While mapping, select specific options as filters, choose All to map an option to every option of another reporting tag, or choose Untagged to display the option even when no option is selected in the mapped tag.
- Click Save and Continue to move to the Access Control step.
Configure Access Control
Access control lets you restrict which records each user can view based on the reporting tag options assigned to them. When enabled, users can only view records tagged with the options assigned to them, while other records remain hidden.
Note: You can enable access control for only one reporting tag in your organization.
To enable access control for a reporting tag:
- Slide the Access Control toggle.
- Click Save.
Associate Reporting Tags
Once you’ve created a reporting tag, you can associate it with items, vendors, and purchase transactions, depending on the modules you selected while creating the tag.
Associate Reporting Tags with Items
To associate reporting tags with items:
- Click Items on the left sidebar.
- Create a new item by clicking + New in the top right corner, or select an existing item.
- Enter all your details and click the dropdown next to the reporting tag you want to associate with the item.
- Select the required option and click Save.
The associated reporting tag is applied by default whenever you add this item as a line item in a transaction.
Associate Reporting Tags with Vendors
To associated reporting tags with vendors:
- Click Vendors on the left sidebar.
- Create a new vendor by clicking + New in the top right corner, or select an existing vendor.
- Go to the Reporting Tags tab.
- Click the dropdown next to the reporting tag you want to associate with the vendor, select the required option, and click Save.
The associated reporting tag is applied by default whenever you select this vendor in a transaction.
Associate Reporting Tags with Transactions
To associate a reporting tag with a transaction:
- Open the transaction for which you want to associate a reporting tag, or create a new one.
- If the reporting tag is applied At Transaction Level, click the dropdown next to the reporting tag and select the required option.
- If the reporting tag is applied At Line Item Level:
- Scroll down to the Item Table section and click the More icon next to the line item.
- Click Show Additional Information and select the required option from the Reporting Tags dropdown.
- Click Save.
Insight: Reporting tags associated with purchase requests and purchase orders can also be used as a criteria field while setting up custom approval for these modules.
Edit Reporting Tags
Here’s how you can edit a reporting tag:
- Go to Settings in the top right corner of the page.
- Click Reporting Tags under Customization.
- Hover over the reporting tag and click Edit from the More dropdown.
- Make the necessary changes and click Save.
Reorder Reporting Tags
Reporting tags listed higher on the Reporting Tags page can be used as filters for the tags listed below them. Reorder your reporting tags to control which tags can be used as filters for others. Here’s how:
- Go to Settings in the top right corner of the page.
- Click Reporting Tags under Customization.
- Click Change Order.
- Drag the reporting tags to rearrange their order.
- Click Save.
Note: A tag used as a filter for another reporting tag can’t be moved above the tag it filters.
Mark an Option as Default
Marking an option as default ensures it’s automatically applied whenever the reporting tag is used in a new transaction. Here’s how:
- Go to Settings in the top right corner of the page.
- Click Reporting Tags under Customization.
- Select the reporting tag for which you want to mark an option as default.
- Hover over the option you want to set as default and click the More icon.
- Select Mark as Default from the dropdown.
Generate Analytic Reports
After creating and associating reporting tags with your items, vendors, and transactions, you can filter your analytic reports using the reporting tags. Here’s how:
- Click Analytics on the left sidebar.
- Click the required Analytic Category.
- Click the required analytic report.
- Click + More Filters in the Filters section.
- Select the reporting tag you want to filter by, choose a comparator, and select the option you want to filter with.
- Click Run Report to generate the analytic report based on the criteria you’ve set.