User Tools

Site Tools


Sidebar

Table of Contents

finance:utilities:importjvtransactions

Import JV Transactions - FIN8900

Finance > Utilities > Import JV Transactions

This utility is used to import general journal transactions.

Import JV Transactions File Layout

Import JV Transactions Template

Import journal voucher transactions:

❏ Under Import Options:

Field Description
Accounting PeriodBy default, this field is set to the current accounting period, or you can select the next accounting period.
Journal TypeSelect Actual if the file contains journal actual entries, or select Budget if the file contains journal budget entries.
Transaction Date

The current system date is displayed by default, but it can be modified. If it is modified, all new transactions default to the last transaction date that was entered.

JV Number

Type a user-defined, six-character journal voucher number. If numeric values only are used, the system zero-fills the number to six digits when the user enters a partial JV number and tabs out of the field (e.g., the user entered 123, the system zero-fills the field to 000123). If alphanumeric values are used, the system does not zero-fill the JV number to six characters (e.g., the user entered ABC2, the amendment number remains ABC2).

The Use Automatic JV Number Assignment field does not apply to this utility.

This is an optional field. However, if the field data is not in the file or on the Import JV Transactions page, the system will issue an error message.

The same JV number can be used multiple times as long as it is within the same accounting period.

JV Number DescriptionType a user-defined description of the journal voucher transaction. If the JV reason description is left blank, the JV reason description entered on the page will be used. This is a required field in the file or on the Import JV Transactions page.
Use Description from Finance Object CodeSelect 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 AccountSelect 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.

❏ Click Browse. A pop-up window is displayed.

  • Locate and select the file on your computer or network.
  • Click Open to select the file, or click Cancel to close the dialog box without processing.
  • If any errors are encountered during the import process, the Import JV Transactions Error Report is displayed. Review the report.
  • Click Continue to view the Import JV Transactions Preview report. This report displays a list of the import journal voucher transactions.
  • Click Process to proceed.
  • Click Cancel to cancel the process.

A message is displayed indicating that the process was completed successfully.

finance/utilities/importjvtransactions.txt · Last modified: 2023/01/06 15:33 by emoreno