Report ID: 34

Location: Reports > List > Finance  

Description: The Ledger Cardlines report enables users to view and export all cardline transaction data along with their associated ledger codes. Any custom ledger codes that have been mapped to Emersion's ledger codes are exported with the data.

The Ledger Cardline report produces a record for every cardline created within the chosen date range.

Licensing

This feature is available to subscribers of the following:

  • Emersion Core
  • Optional Modules 
  • Optional Features 
  • Upon Request (please contact your Account Manager)



Access Controls

Some reports require tuning on a specific module permission or power. These are provided below.

Module Permissions

  • Reports

Powers

No powers are needed to access this report.

Related Service Type

This report is not specifically related to any service types, but will contain data for transactions related to plans created for service types you have sold.



Report Fields

Field nameDescription
Account IDThe Emersion account ID
Export ReferenceThe export reference against the account under Customer > Details.
Cardline IDThe unique system generated cardline identifier.
Transaction DateThe date the cardline was generated.
DescriptionThe cardline description that was generated by the system or entered by the user at the time the cardline was created.
Ledger CodeThe ledger code associated with this cardline. The ledger code will contain the Emersion system default code unless it has been mapped to a custom or simple code.
Cardline ApprovedThe date the cardline was approved.
Actual Value RoundedThe transaction amount, including tax.
Tax AmountThe tax amount of the transaction.
Service IDThe service ID associated with the cardline. This field will be blank for transactions that are not subscription-related such as product purchases.
Billing TypeThe billing type as either ‘Advance’ or ‘Arrears’.
Invoice IDThe invoice ID that the cardline was included on. If the cardline is still pending and not allocated to an invoice at the time the report was generated, this will be blank.
Vanity Covers FromThe start date the cardline covers from (e.g. for service access fees that cover a month etc).
Vanity Covers ToThe end date the cardline covers to.
Invoice Start DateThe invoice period start date. This will be blank if the cardline has not been invoiced to the customer at the time the report is generated.
Invoice End DateThe invoice period end date. This will be blank if the cardline has not been invoiced to the customer at the time the report is generated.
Invoice Approval Status

The invoice status as either ‘Approved’ or ‘Pending’.

Package Plan NameThe package plan ID associated with the cardline. This field will be blank for transactions that are not subscription-related.