Ledger Cardline Report

The Ledger Cardlines report enables you to view and export all cardline transaction data along with their associated ledger codes. All existing mapped custom ledger codes are exported with the data. The Ledger Cardline report produces a record for every cardline created within the date range selected.

Report Fields

The Ledger Cardlines report fields are as follows:

Report Field	Description
Account ID	The customer’s account ID.
Export Reference	The custom reference field set up against the account. This will be blank of no custom reference field has been set up.
Cardline ID	The unique system generated cardline identifier.
Transaction Date	The date the cardline was generated.
Description	The cardline description, either generated by the system or user entered at the time the cardline was created.
Ledger Code	The 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 Approved	The date the cardline was approved
Actual Value Rounded	The transaction amount, including tax.
Tax Amount	The tax amount of the transaction.
Service ID	The service ID associated with the cardline. This may be blank for product purchases and other non-service specific transactions.
Billing Type	The billing type as either ‘Advance’ or ‘Arrears’.
Invoice ID	The invoice ID that the cardline was included on. This will be blank if the cardline has not been invoiced to the customer at the time the report is generated.
Vanity Covers From	The start date the cardline covers from (e.g. for service access fees that cover a month etc).
Vanity Covers To	The end date the cardline covers to.
Invoice Start Date	The 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 Date	The 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 Name	The package plan ID associated with the cardline. This may be blank for some non-package specific transactions.

To Generate the Ledger Cardline Report

Before you can export the ledger cardline data, you must first generate the data by running the Ledger Cardline report.

Select Report > List > Finance from the Menu. The Finance Reports page will display showing a list of existing finance reports.
Click the Generate Report link beside the Ledger Cardlines report in the list. The Ledger Cardlines Report page will display.
The Parent Account ID should show your Emersion account name. If you have multiple accounts set up in Emersion, select the required account to report from the drop list.
Select the date to report cardline from in the Transaction Date Start field. A calendar tool will appear to allow you to select the required date.
Select the date to report cardline to in the Transaction Date End field. A calendar tool will appear to allow you to select the required date.
Select the invoice types you wish to report from the Invoice Approval Status drop list. Options available are ‘All’, ‘Approved’, ‘Pending’ and ‘Rejected’.
Click the Search button to run the report. The cardlines will be displayed on the Ledger Cardlines report page.
Click the Export to CSV button. A message box will appear at the top of the screen showing ‘Your report is being generated, please see Generated report section’.

To Download the Ledger Cardline Report

Before you can download the report, you must first run the report to create the output report file (see the To Generate the Ledger Cardline Report section on 12). The output .CSV file is created compressed in .ZIP format. Once you download it, you will need to extract the .CSV from the .ZIP file before you can open it.

Select Report > Generated Report from the Menu. The Downloadable Reports page will display showing a list of reports that have been generated in the default date range.
Locate the Ledger Cardline Report previously generated and click the Download link beside the Ledger Cardlines report in the list. The Opening Ledger Cardlines file window will appear. If you don’t see the required report in the list, adjust the date range in the Requested From and Requested To fields to include the date the report was generated.
Click the Download link beside the Ledger Cardlines report in the list. The Opening Ledger Cardlines Report file window will display.
Note that the file window on your system may different to the sample window shown above, depending on the version of Firefox and operating system you have installed.
Ensure the option to Save the file to your computer is selected, and then click the OK button.
Save the Ledger_Cardlines_<ID>_<date>.zip file to your computer, making sure you note the location where you saved the file.
Extract the .CSV file from the .ZIP file, using your system’s unzipping tool.
Open the CSV file with your preferred application or spread sheet program e.g. MS Excel. Fields are separated by commas and by default MS Excel will separate the data into columns & rows based on a comma field separator. The file may be password protected with the password ‘emersion’.
You can manipulate the CSV file as required, and import it into your accounting application as required.

Ledger Cardline Report

Contents