TAG LINE
TAG LINE
SMALL TITLE
BUTTON
Product Overview
Becoming familiar with the foundational concepts of LogiSense billing
Introduction
Product Vision
Usage Billing Challenges
LogiSense Billing UI Walkthrough
Terminology
Quick Start Guide
Release Notes
- LogiSense Billing 10.4.x Release Notes
- LogiSense Billing 10.5.x Release Notes
- LogiSense Billing 10.6.x Release Notes
- LogiSense Billing 10.7.x Release Notes
Accounts
Adding all of your customers and their products to the system
Account Overview Screen
Account Packages Screen
- Account Package Example
- Billing an Account Example
Account Settings Screen
Account Credits Screen
- Adding and Disbursing a Credit Example
Account Transactions Screen
- Adding a Transaction Example
Account Notes Screen
Account Contacts Screen
- Adding Account Contacts Example
Creating a New Account Screen
- New Account Creation Example
- Child Account Creation Example
Admin - Configuration
Configure all your system settings and user permissions
Owner Configuration Screen
- Financial Settings Example
- Password Policy Example
- Branding Example
- Automatic Naming Example
- Locales Example
- Payment Types Example
SMTP Settings Screen
- SMTP Example
Account Types Screen
- Account Types Example
Account Status Types Screen
- Account Status Types Example
Contact Types Screen
- Contact Types Example
Users and Roles
Users Screen
- User Example
Roles Screen
- Role Example
Role Groups Screen
- Role Group Example
Billing - Configuration
Group your customers into groups that bill in a similar fashion
Bill Runs Screen
- Bill Run Example
- Bill Run Auto-Pay Example
Bill Run History Screen
Bill Groups Screen
- Bill Group Example
General Ledger Codes Screen
- General Ledger (GL) Code Example
Contracts & Commitments
Ensure you are enforcing the contract commitments from your customers
Account Contracts Screen
- Commitments and Ramp Up Periods
- Early Termination
- Account Contract Example
Account Contract Status Types Screen
- Account Contract Status Types Example
Package Contracts Screen
- Package Contract Example
Customer Experience
Provide the best posssible experience from your billing touchpoints
Customer Portal
Email Templates
- Dunning/Payment Overdue Email Template Example
Dunning & Collections
Automate your collections and notification processes
Accounts Receivable Terms Screen
- Accounts Receivable Terms Example
Payment Terms Screen
- Payment Terms Example
Dunning Rules Screen
- Dunning Rules Example
Extensibility
Configure extra custom fields to cover unique scenarios
Custom Fields Screen
Custom Fields Layouts Screen
Importing & Exporting Data
Perform transforms on data that you wish to import into the system
Archiving Data
Data Imports
- Data Profiles
- Mapping
- Transforms
- Validations
- Debugging
Data Profiles Screen
Data Imports Screen
Invoicing & Credit Notes
Design your invoice templates and manage account invoices and credit notes
Account Invoices Screen
- Invoice Management Example
Account Credit Notes Screen
Invoice Delivery Screen
- Invoice Delivery Example
Invoice & Credit Notes Templates Screen
- Word Invoice Template Mail Merge Tips
- Embedding Reports in Invoice Templates
- Invoice Template Example
Rounding Behavior
Notifications & Events
Subscribe to different system events to trigger integration workflows
Available Events
Available Event Tokens
Notifications Screen
Payments
Record automatic payments or manually disburse amounts
Account Payment Methods Screen
Account Payments Screen
- Payments Example
Payment Gateway Screen
- Payment Gateway Example
Pricing
Explore different pricing options and customer specific catalogs
Account Price Plans Screen
Tiered Monthly Recurring Charge
Tiered Usage
Counting Rules for Tiered Pricing
Price Book Regions Screen
Price Books Screen
Product Catalog
Add all of our products and services to the product catalog
Services Screen
- Service Example
Service Status Screen
- Service Status Example
Service Transitions Screen
- Service Transitions Example
Service Types Screen
- Service Type Example
Packages Screen
- Recurring and One Time Charges Package Example
- Global Add-on Package Example
- Toll Free & Trunk Groups Products Use Case
Package Frequencies Screen
Package Status Screen
- Package Status Example
Counting Rules Screen
Promo Codes Screen
Regional & Currency Settings
Setup all of your regonal settings including multiple currencies
Configuring Countries
- Regional Settings Example
Configuring State/Province
Multi-Currency
Currency Exchange Screen
- Currency Exchange Example
Exchange History Screen
Reporting & Analytics
Dig into your billing data for the analytics you need
Charts & Dashboards
Generating, Viewing and Downloading Reports
Filtering, Generating and Downloading Reports Example
Revenue Recognition
Recognizing the monetary value of a transaction or contract over time
Revenue Recognition Configuration
IFRS 15 and ASC 606
Salesforce Integration
Connect LogiSense Billing to Salesforce to automate your quote-to-cash
Salesforce Admin Guide
- LogiSense Billing Configuration
- Salesforce (Pre App Installation Process)
- Salesforce (app installation)
- Connecting Salesforce to LogiSense Billing
- Account Field Mapping
- Package Field Mapping
- Contact Field Mapping
- Order Product Field Mapping
- Order Product Service Field Mapping
- Account Invoice List
- Importing and Syncing Data
- LogiSense Requests (API Logs)
Salesforce User Guide
Sales Orders
Combine multiple products into a single order for an account
Account Orders Screen
Share Plans
Configure share plans to share usage across multiple services
Account Share Plans Screen
Share Plans Screen
Share Plan Buckets Screen
Single Sign On
Single Sign On Configuration
Taxes
Manage your tax setup and integration with 3rd parties
Tax Codes Screen
Tax Vendor Screen
- LogiSense Tax Example
Tax Rates Screen
Service Tax Categories Screen
Account Tax Categories Screen
Usage & Rating
Create flexible usage pricing and transform event data
Usage Rate Groups Screen
Usage Rates Screen
Usage Rate Plans Screen
Usage Classes Screen
Usage Class Types Screen
GeoTree Screen
Rounding Rules
Time Periods Screen
Location Groups Screen
Mediation
Usage Data Feeds
Import Usage by API
Billing Activation Rules
Dynamic Usage Classes Screen
Usage Exceptions
- Exceptions Screen
- No UDR Usage Identifier match
- UDR time does not match time period of UDR Usage Identifier
- Usage Rate matching UDR not found
- Usage Rate Group matching UDR not found
- Usage Rate Plan not defined
- Final Usage Bill issued
- Software System Error
Use For Cost Configuration
Usage Buckets
Create definitions of usage inclusions that can be used in plans
Base Buckets Screen
Usage Buckets Screen
Developer
Information for those looking to integrate with the billing system
API Platform
Developers - Getting Started
- Tokens & Authentication
- PATCH, POST, PUT & DELETE
- Search Requests
- Deep Search - Related Objects
- v2/v3 GET Filters
- Update Requests
- Response Data
- LogiSense Tools
- API Logging
Developer - Data Views
- Creating a Database View
- Configuring your DataSource
Eventing System
- Events
- Notifications
Architecture
Explore the logical, delployment and functional architecture of LogiSense Billing
Logical Architecture
- Web Client
- Rating & Mediation Scaling
- Usage Aggregation and Scaling
- Billing Scaling
- Database
Deployment Architecture
- Overview
- Single Node
- Upgrade Strategy
Functional Architecture
- Module Descriptions
- Adjunct Rating & Charging
Security
Controlled Flexibility
Search

Creating a Database View

Last Updated: Fri Oct 02 2020

LogiSense Billing has number of out-of-the-box views which can be leveraged for creating data sources. Our philosophy is to provide you with a lot of columns at the view level which can then be pared down at the data source and ultimately sorted and filtered by the report according to your business needs. LogiSense will work with you to create custom views.

Please find a list of commonly used views below:

View

Description

Statement of Account

Transactional and invoice summary

Usage

Individual rated usage event details

Invoice Summary

Details grouped by invoice

Sales

A list of all transactional line items

Product Catalog

Details of all offerings

Account

List all accounts with subscriptions and contacts

Data Allowance

Usage allowance by account and bucket/share plan

Account Contract

Contract details grouped by account

Tax

Lists all taxed amounts with account and tax category details

Accounting Export

Transaction level detail to be imported by financial system

Payments and Credits

Lists payment and disbursement details grouped by account

Aged Balance

Lists balance due by account and days late