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 Screen
- 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
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

Archiving Data

Last Updated: Tue Dec 13 2022

Overview

The LogiSense Billing application has a built in data archival tool which removes old data from the system to prevent its database from growing too large and prevent certain tables from becoming bloated.

Data that is archived is sent to an S3 bucket and organized by day and target (targets are explained below).

Archived Data and Targets

The table below details data archive targets and recommended settings for them. These settings can be modified per target if required. The general default is to store data in a production system for 3 months.

Note: There are certain targets that cannot have their archive type changed (for example, API Logs currently can’t be archived, they must be purged).

Release

Target

Description

Archive Type and Duration

Reason

10.4.0

Usage

Data relating to Usage Records (Rated, Mediated, Extensions, Aggregates).

Archive & Purge - 3 Months

Usage Records that were processed could be audited at a later date, by auditors or customer disputes.

10.4.0

Unprocessed Usage Exceptions

The usage exceptions that have not been resolved.

Purge - 3 Months

If the exceptions haven’t been dealt with after 3 months, they probably aren’t going to be resolved or charged.

10.4.0

Processed Usage Exceptions

Usage Exception records that have been sent for Rerating.

Purge - 1 Day

These would normally get deleted once sent for reprocessing.

10.4.0

Rerated Usage Records

Original Usage Records that have been sent in for Rerating, making the original record obsolete.

Purge - 1 Day

These would normally get deleted once sent for reprocessing.

10.4.0

API Logs

The request/response API logs from every API call made to the system.

Purge - 5 days

There are many API calls made every day in the system and this table fills up quickly. This data also is rarely referenced again.

10.4.0

Tax Logs

The Tax Logs from every tax calculation made in the system.

Archive & Purge - 3 Months

Tax calculations are audited annually and could be challenged on any invoice.

10.4.0

Webhook Logs

The response data from every webhook sent from the system.

Purge - 3 Months

These generally are not required once the change has been made or the action has completed.

10.5.0

Data Import Tracking and Batch details

Usage API and Data Import Tracking details

Purge - 3 Months

Once imported, this data is used by the system from the UDRMediated and UsageRated tables. The import details are no longer used by the system.

Monitoring Data Archival Activity

Within the LogiSense Billing AdminPortal data archiving activity can be tracked by loading the Operations / Monitor / Data Archive screen.

All data archive operations are by default configured to run for a maximum of six hours. If an operation takes more than six hours it will be cancelled and listed as Cancelled on this screen.

Downloading Archived Data from S3

When data is successfully archived to an S3 bucket it will be listed as Completed on the Data Archive screen and the archived files will be listed under the Files tab. From this tab you can download the archived files if you are required to keep them longer than they will be stored in the S3 bucket.