TABLE OF CONTENTS
Import Revenue Transactions
In order to import revenue transactions, please access the Revenue Import form by clicking the Generate Txns button on the Transaction Batch Entry form under Main Menu/Transaction Entry. This will launch the Generate Transaction menu and the user can select the Revenue Import button to begin the revenue import process.
The system will prompt the user that if the import contains data for an existing Revenue batch, then the system will override that batch with the new data. Click OK to continue or click cancel and enter a new unique Batch ID in the import template if you do not want to override the current batch.
Click the Import File button and select the revenue template to import.
Click Open to import the selected template and the system will fill in the path for this template in the Select Import File screen. Click OK to continue.
The system will launch a progress bar to inform the user that the data is being imported.
The Generate Transactions form will launch with details for the newly created batch.
If there are errors in the template, then the system will not create the batch and will display the errors list in the Import Errors tab. Click the Close button to exit out of the form and correct the errors in the template and re-import the template.
Import A Revenue Transactions with Agreement Detail TIDs
On the Revenue Import template, the user can populate the TxnAgreementDtlTID. This will allow you to populate only certain columns on the revenue agreement template. If populated, the system will use the revenue agreement setup to book the revenue.
The Agreement DtlTIDs can be located a couple different ways. The user will need to navigate to the Revenue Master Files/Revenue Agreements. The user can find the DtlTID on the bottom of Agreement Details tab. Please see below.
The user can also find the Agreement DtlTIDs on the Purchaser Agreement Details Tab on the revenue agreements form. The user has two ways to pull the data out of the system. The user can highlight all the column headers and single left click to reveal the Agreement DtlTIDs. The user can search for a specific revenue agreement detail that can be populated on the revenue import template.
If the user is looking to pull all the Agreement DtlTIDs, the user can export the Purchaser Agreement Listing tab out of the system into Excel. Once the data is exported into Excel, all the columns can be unhidden. This will allow access to all the Agreement DtlTIDs.
We’ll follow the same steps above to import the revenue transactions, please access the Revenue Import form by clicking the Generate Txns button on the Transaction Batch Entry form under Main Menu/Transaction Entry. This will launch the Generate Transaction menu and the user can select the Revenue Import button to begin the revenue import process.
Import a Revenue Transactions with a Key Sheet
The revenue import templates also have the functionality to add additional tabs that can be linked to the actual template spreadsheet. The users can link data from one sheet to another. For instance, if the user gets an electronic copy from the purchaser/operator, they can setup the spreadsheet to link this data to the correct column in the template. The users can also build out the key sheets to verify tax calcs, override the receipt interest, and to check for cross foot warnings prior to loading the data into the system.
We’ll follow the same steps above to import the revenue transactions, please access the Revenue Import form by clicking the Generate Txns button on the Transaction Batch Entry form under Main Menu/Transaction Entry. This will launch the Generate Transaction menu and the user can select the Revenue Import button to begin the revenue import process.
Import a Revenue Suspense Adjustment (RSADJ)
The Revenue Suspense Adjustment (RSADJ) import can be used to import acquired suspense or any direct owner transactions that need to be uploaded into Enertia. This import utilizes the revenue import template and is imported using the Revenue Import function on the Txn Batch Entry form. This form is found under Main Menu/Txn Batch Entry and users must click the Generate Txns button to open the Revenue Import.
Before importing, users must ensure the RSADJ transaction is available for Revenue batches in the Txn Types form found under Main Menu/Master Files/Common Files. If the RSADJ transaction type exists, then the user should be able to select this in Txn Batch Entry when setting up a new Revenue batch. This code will be used in the Revenue import template under the “Txn Type” column.
Example of import template using the RSADJ transaction type code.
Additionally, the user will need to have the Revenue Agreement and Business Associates set up before running the import. The Revenue Agreement does not need to be any specific type of agreement nor does the Business Associate require any specific categorization to be used in the RSADJ upload. However, the import will error if the revenue agreement and business associate (direct owner) is not set up beforehand. Owner interest, suspense codes, and even a special account can be defined on the revenue entry, if applicable.
Common Errors/Troubleshooting:
Below are a couple common errors that users receive when loading the import templates. Please see the examples below.
The file was not saved on the Import tab.
Error: Cannot convert a char value to money. This is caused from bad data in the template.
You can locate the bad data by selecting Control + F > Find what: E- This will identify the char value in the money columns.
More than one agreement detail exists without an agreement detail TID being provided. To fix this the user must update the Prop Xref on the revenue agreement to make the agreement unique.
Incorrect Detail TID. The wrong agreement detail TID was entered for the purchaser listed in the import template.
