Rate Plan Search Maps for Ad Hoc scenarios are similar to other Usage Type configurations, but with some additional field requirements.
To create the Rate Plan Search Map:
- Go to Setup > Zone Advanced Billing Maps/Definitions > Rate Plan Search Map > New
- Name the Rate Plan Search Map.
- Select the Search that will be providing Ad Hoc Data.
- When building the Search, the Search Type should be ‘ZAB Ad Hoc Data’ or any other record representing Ad Hoc Data.
- The Search cannot have summarized results (or summary criteria). Leverage Count/Ad Hoc Grouping and Count/Ad Hoc Aggregation for those needs.
- Select Quantity Search as the Available For Search Type
- Under Field Mapping, select the Search Map Type ‘Ad Hoc’.
- To the far right, populate the following the Ad Hoc Data field mappings:
- Ad Hoc Date Filter Field = Date
- Ad Hoc Record Subscription Item = Subscription Item
- Ad Hoc Record Charge Field = Charges
- This field must be present on the record used as the Saved Search Type. It cannot be a join.
- Under Search Mapping ‘Quantity Column In Search Results’, specify which column in Search results represents Quantity (e.g. column 8 in search results provides these values).
- Add Bill Date to Column Mapping (optional)
- Add Filter Mapping
- Save
Example: Rate Plan Search Map configured for Ad Hoc Usage
An Out-of-the-box ZAB Ad Hoc Data Record referencing Charges tied to this data record (automatically generated by the system after rating)