User Tools

Site Tools


finance:utilities:importjvtransactions

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
finance:utilities:importjvtransactions [2017/11/03 16:31] emorenofinance:utilities:importjvtransactions [2025/09/09 13:16] (current) emoreno
Line 7: Line 7:
 <WRAP round intro>This utility is used to import general journal transactions. <WRAP round intro>This utility is used to import general journal transactions.
  
-[[http://txeis.net/page/Partners|File layout]]+[[https://help.ascendertx.com/interfaces/doku.php/business/import_jv_transactions|Import JV Transactions File Layout]] 
 + 
 +{{ :finance:utilities:import_jv_template.xlsx |Import JV Transactions Template}}
  
 </WRAP> </WRAP>
Line 14: Line 16:
 ====Import journal voucher transactions:==== ====Import journal voucher transactions:====
  
-Under **Import Options**:+VCV Under **Import Options**:
  
 ^Field ^Description ^ ^Field ^Description ^
-^Accounting Period|By default, the  field is set to the current accounting period, or you can select the next accounting period.|+^Accounting Period|By default, this field is set to the current accounting period, or you can select the next accounting period.|
 ^Journal Type|Select **Actual** if the file contains journal actual entries, or select **Budget** if the file contains journal budget entries.| ^Journal Type|Select **Actual** if the file contains journal actual entries, or select **Budget** if the file contains journal budget entries.|
 ^Transaction Date|{{page>general:trans_date}}| ^Transaction Date|{{page>general:trans_date}}|
Line 24: Line 26:
 ^Use Description from Finance Object Code|Select to use the descriptions from the Finance Object Code table. If the general ledger account description is blank in the input file, the general ledger description will use the descriptions from the Finance Object Code table. If the general ledger account description is blank in the file and the Finance Object Code description is also blank, the system will issue a warning message.| ^Use Description from Finance Object Code|Select to use the descriptions from the Finance Object Code table. If the general ledger account description is blank in the input file, the general ledger description will use the descriptions from the Finance Object Code table. If the general ledger account description is blank in the file and the Finance Object Code description is also blank, the system will issue a warning message.|
 ^ Allow to Post Any Overdrawn Account|Select to allow transactions to post to overdrawn accounts. A preview report will display the overdrawn accounts prior to posting. If Allow to Post Any Overdrawn Account is not selected, the overdrawn accounts will display on the Error Report, and posting will not occur. If the remainder of the JV is not balanced, posting will not occur.| ^ Allow to Post Any Overdrawn Account|Select to allow transactions to post to overdrawn accounts. A preview report will display the overdrawn accounts prior to posting. If Allow to Post Any Overdrawn Account is not selected, the overdrawn accounts will display on the Error Report, and posting will not occur. If the remainder of the JV is not balanced, posting will not occur.|
-^ Import File Name|{{page>general:import_jv}}| 
- 
-If any errors are encountered during the import process, the system displays the Import JV Transactions Error Report. 
- ++++Review the report.|{{page>general:printreport&inline}}++++ 
- 
-Click **Continue** to view the Import JV Transactions Preview report. This report displays a list of the import journal voucher transactions. If there are no errors, the Import JV Transactions Error Report is not displayed. 
  
-If no errors are encountered during the import process, or you clicked Continue from the Import JV Transactions Error Report, the Import JV Transactions Preview report is displayed.+{{page>general:import_jv}}
  
- ++++Review the report.|{{page>general:printreport&inline}}+++++  * If any errors are encountered during the import process, the Import JV Transactions Error Report is displayed[[general:printreport|Review the report.]]
  
-If you click **Process**message is displayed indicating a system backup should be performedA backup is highly recommended.+  Click **Continue** to view the Import JV Transactions Preview report. This report displays list of the import journal voucher transactions 
 +  * Click **Process** to proceed.  
 +  * Click **Cancel** to cancel the process.
  
-Click **Yes** to create the backup. Click **No** to not create the backup and continue.+<div indent>A message is displayed indicating that the process was completed successfully. 
 +</div>
  
-Click **Cancel** to terminate the process without saving the changes and to close the dialog box. 
  
  
finance/utilities/importjvtransactions.1509726695.txt.gz · Last modified: 2017/11/03 11:31 (external edit)