This article explains how to download transaction details of a summary journal entry.
Invoice Adjustment transaction is deprecated on Production.
You can download transaction details from the journal entry page or the journal run page. The download link appears when the journal entry status is "Created".
If more are than 1,000 transactions in a journal entry, the download processes the transactions asynchronously and downloads on completion. For journal entry with less the 1,000 transactions, the download occurs in real-time.
Navigation: Finance > Accounting Periods and select the Journal Run tab. Click the journal run number to access the journal run page. Click [download] from a journal entry.
JEExport_[Accounting Period Name]_[Transaction Type Included]_YYYYMMDDHHMMSS.csv
JEExport_Apr14_Revenue-Event-Item_20140731141750.csv represents a journal entry export for the April 2014 accounting period that includes transactions for revenue event items. The CSV file was created on July 31, 2014 at 14:17:50 (military time).
The following is an excerpt from an exported transaction details CSV file of invoice items for the August 2013 accounting period.
Transactions are downloaded in the order listed.
|All Transactions, except for Revenue|| |
|Revenue Event Item Transactions|| |
Transaction subtypes further qualify transactions. Transaction types for billing, cash, and credit balance transactions have a set of transaction subtypes. For example, an invoice transaction can be a charge, discount, prepayment, or tax.
|Transaction Type||Transaction Subtype|
Invoice Item Adjustment
Invoice Item Adjustment Tax
Credit Balance Refund (electronic or external)
Credit Balance Payment (electronic or external)
Credit Balance (applied to invoice)
Credit Balance (transferred from invoice)
See the table the end of this article for more information.
Certain transaction types, such as invoice item adjustments or refunds, have a one-to-one relationship with another transaction type. The following table show how certain transaction types map to an associated transaction type.
Each associated transaction type has a corresponding associated transaction subtype. These subtypes are the same as those documented in the previous Transaction Subtypes table. For example, the associated transaction subtypes for Invoice Item Adjustment are Credit and Charge.
|Transaction Type||Associated Transaction Type|
|Invoice||Invoice Item||Invoice Payment||Payment||Refund||Taxation Item|
|Credit Balance (applied to invoice)|
|Credit Balance (transferred From invoice)|
|Credit Balance (electronic payment)|
|Credit Balance (external payment)|
|Credit Balance (electronic refund)|
|Credit Balance (external refund)|
|Invoice Item Adjustment|
|Invoice Item Adjustment (tax)|
The set of data exported for a revenue event item differs from all other transaction exports. Key differences include:
|Column||Revenue Event Item|
|Transaction Type||The transaction that created the revenue event item.|
|Transaction Subtype||The transaction subtype of the transaction that create the revenue event item.|
The Revenue event item download includes data related to revenue schedules and additional revenue event details.