Reclassify Transactions

Form ID:(GL506000)

On this form, you can initiate the process of reclassifying or splitting the transactions that you select. You can load the needed transactions to the table on this form by specifying the required selection criteria in the Load Transactions dialog box (which you invoke by clicking Load on the form toolbar). Alternatively, if you have navigated to this form from the Account Details (GL404000) or Journal Transactions (GL301000) form, the transactions you have selected already appear on the list. For details, see Reclassifying Transactions.

Form Toolbar

The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.

Button Description
Load

Opens the Load Transactions Dialog Box. In this dialog box, you can specify the selection criteria to load the required list of transactions to the form.

This button is unavailable if you open the form by clicking Edit on the toolbar of the Journal Transactions (GL301000) form to edit an unreleased batch of the Reclassification type.

Process Initiates the reclassification process, which generates a reclassification batch.
Replace Opens the Find and Replace Dialog Box. In this dialog box, you can specify the original and reclassification settings for the transactions. This replacement will be simultaneously applied to all transactions that match the previous settings.
Split

Inserts a row after the one you have selected (by clicking it), in which you can specify the settings to be used when the system splits the transaction.

Load Transactions Dialog Box

This dialog box opens when you click Load on the form toolbar. In this dialog box, you can specify the selection criteria to load the required transactions for reclassification.

Element Description
Branch

The branch to which the transaction was posted.

This box appears on the form only if the Multibranch Support feature is enabled on the Enable/Disable Features (CS100000) form.

From Account The first account in the range of accounts. For a transaction to be uploaded to the form, its account must be within the specified range of accounts.
To Account The last account in the range of accounts. For a transaction to be uploaded to the form, its account must be within the specified range of accounts.
From Subaccount

The first subaccount in the range of subaccounts. For a transaction to be uploaded to the form, its subaccount must be within the specified range of subaccounts.

This box appears on the form only if the Subaccounts feature is enabled on the Enable/Disable Features form.

To Subaccount

The last subaccount in the range of subaccounts. For a transaction to be uploaded to the form, its subaccount must be within the specified range of subaccounts.

This box appears on the form only if the Subaccounts feature is enabled on the Enable/Disable Features form.

From Period The first financial period in the range of periods. For a transaction to be uploaded to the form, its period must be within the specified range of periods.
To Period The last financial period in the range of periods. For a transaction to be uploaded to the form, its period must be within the specified range of periods.
From Date The first date in the range of dates. For a transaction to be uploaded to the form, its date must be within the specified date range.
To Date The last date in the range of dates. For a transaction to be uploaded to the form, its date must be within the specified date range.
Module The identifier of the module (that is, the part of the system) where the transaction originated. If you select a module, a transaction will be uploaded to the form only if it originated in this module.
Batch Number The number of the batch that contains the transactions to be uploaded to the form.
Ref. Number The reference number of the external or internal document associated with the journal transaction to be uploaded.
Customer/Vendor

The customer or vendor specified in the transaction. If you select a customer or vendor, a transaction will be uploaded to the form only if the customer or vendor is specified in the transaction.

If a branch is selected in the Branch box of this dialog box, the list of values is based on the selected branch. If a branch is not selected, the list of values is restricted based on the current user's access role.

Project

The project with which the transaction is associated.

This box appears on the form only if the Project Accounting feature is enabled on the Enable/Disable Features form.

From Project Task

The first project task in the range of project tasks of the selected project. For a transaction to be uploaded to the form, its project task must be within the specified range of project tasks.

This box appears on the form only if the Project Accounting feature is enabled on the Enable/Disable Features form.

To Project Task

The last project task in the range of project tasks of the selected project. For a transaction to be uploaded to the form, its project task must be within the specified range of project tasks.

This box appears on the form only if the Project Accounting feature is enabled on the Enable/Disable Features form.

From Cost Code

The first cost code in the range of cost codes of the selected project. For a transaction to be uploaded to the form, its cost code must be within the specified range of cost codes.

This box appears on the form only if the Cost Codes feature is enabled on the Enable/Disable Features form.

To Cost Code

The last cost code in the range of cost codes of the selected project. For a transaction to be uploaded to the form, its cost code must be within the specified range of cost codes.

This box appears on the form only if the Cost Codes feature is enabled on the Enable/Disable Features form.

Max. Number of Transactions The maximum number of records to be selected from the database. The default value is 999. That is, the system selects at most 999 records from the database that meet the specified criteria, applies additional filters (if needed), and displays the resulting list of records.
The dialog box has the following buttons.
Load Closes the dialog box and loads the transactions that match the specified criteria. New transactions are added to any existing transactions that are listed on the form.
Reload Closes the dialog box and loads the transactions that match the specified criteria. Any existing transactions listed on the form are removed, and any new transactions that match the specified criteria appear.
Note: This button is not available during the editing process—that is, if you have entered the current form by clicking the Edit button for a selected transaction on the Journal Transactions (GL301000) form.
Cancel Closes the dialog box and ignores any specified criteria.

Find and Replace Dialog Box

In this dialog box, which opens when you click Replace on the form toolbar, you can specify the settings for mass updating of the rows listed on the form.

Element Description
Find section
Branch

The branch of the original transaction.

This box appears on the form only if the Multibranch Support feature is enabled on the Enable/Disable Features (CS100000) form.

Account The account specified in the original transaction.
Subaccount

The subaccount specified in the original transaction.

This box appears on the form only if the Subaccounts feature is enabled on the Enable/Disable Features form.

Project

The project with which the original transaction is associated.

This box appears on the form only if the Project Accounting feature is enabled on the Enable/Disable Features form.

Project Task

The project task specified in the original transaction.

This box appears on the form only if the Project Accounting feature is enabled on the Enable/Disable Features form.

Cost Code

The cost code specified in the original transaction.

This box appears on the form only if the Cost Codes feature is enabled on the Enable/Disable Features form.

Date The date of the original transaction.
Post Period The financial period to which the original transaction was posted.
Transaction Description The description of the original transaction. The system searches for the exact string that you enter in this box. To find transactions with no descriptions, enter two consecutive quotation marks with no spaces between them. You can use wildcard characters (* or ?) to perform a flexible search.
Replace With section
Branch

The branch that should be specified in the reclassification transaction.

This box appears on the form only if the Multibranch Support feature is enabled on the Enable/Disable Features form.

Account The account that should be specified in the reclassification transaction.
Subaccount

The subaccount that should be specified in the reclassification transaction.

This box appears on the form only if the Subaccounts feature is enabled on the Enable/Disable Features form.

Project

The project that should be specified in the reclassification transaction.

This box appears on the form only if the Project Accounting feature is enabled on the Enable/Disable Features form.

Project Task

The project task that should be specified in the reclassification transaction.

This box appears on the form only if the Project Accounting feature is enabled on the Enable/Disable Features form.

Cost Code

The cost code that should be specified in the reclassification transaction.

This box appears on the form only if the Cost Codes feature is enabled on the Enable/Disable Features form.

Date The date to which the reclassification transaction should be posted.
Transaction Description The description of the reclassification transaction. To replace the description of the original transaction with an empty description in the reclassification transaction, enter two consecutive quotation marks with no spaces between them in this box.
The dialog box has the following buttons.
Replace Initiates the process of replacing the original settings with the specified reclassification settings in the rows of the current form.
Cancel Closes the dialog box and ignores any specified settings in the dialog box.

Table

The table contains the list of journal transactions that you can reclassify or split. To reclassify a transaction, you can either change the required settings in each selected transaction manually or change the same settings in a group of transactions by using the find and replace functionality (the Replace button on the form toolbar). To split a transaction, you click the transaction, click the Split button on the form toolbar, and change the required settings in the new line manually.

Table 1. Table Columns
Column Description
Included

An unlabeled check box that indicates (if selected) that the line will be reclassified or split when you initiate a process of reclassification or splitting by clicking the Process button on the form toolbar.

For a journal entry to be reclassified, the system selects this check box if you change the value in at least one of the following columns: To Account, To Subaccount, To Branch, To Project, To Project Task, and To Cost Code.

For a journal entry to be split, the system selects this check box if this check box is selected for all the new lines related to this line. For the new lines, the system selects this check box if you specify an amount in the New Amount column and change the value in at least one of the following columns: To Account, To Subaccount, To Branch, To Project, To Project Task, and To Cost Code.

Icon

The icon that identifies whether the journal entry in the row is an original journal entry to be split or a new journal entry that has been added in the process of splitting a transaction. The following icons can be displayed in this column:

  • : The original journal entry to be split
  • : The new journal entry that has been added in the process of splitting the original journal entry

This column appears if you specify the splitting settings for any listed transaction or at least one of the listed transactions has been split. The column is filled in only if the transaction in the row has been split or created as a result of a split.

Reclass. Batch Number

The number of the generated reclassification batch.

This column appears if any listed transaction has been split. The column is filled in only if the transaction in the row has been split or created as a result of a split.

To Branch

The branch to be used in the reclassification transaction. If you change the branch for the transaction, the system selects the check box in the Included column of the row to indicate that this transaction will be reclassified if you click Process.

This column appears on the form only if the Multibranch Support feature is enabled on the Enable/Disable Features form.

To Account

The account to be used in the reclassification transaction. If you change the account for the transaction, the system selects the check box in the Included column of the row to indicate that this transaction will be reclassified if you click Process.

If the Contract Management feature is enabled on the Enable/Disable Features form and the selected transaction is associated with a contract, you can select an account that is not included in any account group (an account that has the Account Group column empty on the Chart of Accounts (GL202500) form.)

Description The description of the account specified in the To Account column.
To Subaccount

The subaccount to be used in the reclassification transaction. If you change the subaccount for the transaction, the system selects the Included check box of the row to indicate that this transaction will be reclassified if you click Process.

This column appears on the form only if the Subaccounts feature is enabled on the Enable/Disable Features form.

To Project

The project to be used in the reclassification transaction. If you change the project for the transaction, the system selects the Included check box of the row to indicate that this transaction will be reclassified if you click Process.

This column appears on the form only if the Project Accounting feature is enabled on the Enable/Disable Features form.

If the Contract Management feature is enabled on the Enable/Disable Features form and the selected transaction is associated with a contract, this column is read-only and shows the value specified in the Project column.

To Project Task

The project task to be used in the reclassification transaction. If you change the project task for the transaction, the system selects the Included check box of the row to indicate that this transaction will be reclassified if you click Process.

This column appears on the form only if the Project Accounting feature is enabled on the Enable/Disable Features form.

To Cost Code

The last cost code in the range of cost codes of the selected project. For a transaction to be uploaded to the form, its cost code must be within the specified range of cost code.

This column appears on the form only if the Cost Codes feature is enabled on the Enable/Disable Features form.

New Tran. Date

The date of the reclassified or split transaction; this column is available for editing.

For the rows of a split transaction, this column is available for editing if you have changed a value in any of the following columns: To Branch, To Account, To Subaccount, To Project, To Project Task, and To Cost Code.

New Transaction Description

A description of the reclassified or split transaction. You can enter an appropriate description.

For the original journal entries of a split transaction, this column is available for editing if you have changed a value in any of the following columns: To Branch, To Account, To Subaccount, To Project, To Project Task, and To Cost Code.

New Amount

The remaining amount that can be split of the original journal entry or the amount to be transferred from the original journal entry to a new journal entry (for a new line). For a new journal entry, a positive or negative value can be specified in this column. A positive amount will decrease the amount of the original journal entry. A negative amount, which is highlighted in red, will increase the amount of the original journal entry.

This column appears when you click Split for any journal entry in the table and is available for editing for only new journal entries that have been added to split an original journal entry.

Debit Amount The debit amount of the original transaction. This column is not available for editing.
Credit Amount The credit amount of the original transaction. This column is not available for editing.
Currency The currency of the original transaction. This column is not available for editing.
Branch

The branch of the original transaction. This column is not available for editing.

This column appears on the form only if the Multibranch Support feature is enabled on the Enable/Disable Features form.

Account The account of the original transaction. This column is not available for editing.
Description The description of the account specified in the original transaction. This column is not available for editing.
Subaccount

The subaccount of the original transaction. This column is not available for editing.

This column is displayed on the form only if the Subaccounts feature is enabled on the Enable/Disable Features form.

Project

The project with which the transaction is associated.

This column appears on the form only if the Project Accounting feature is enabled on the Enable/Disable Features form.

Project Task

The last project task in the range of project tasks of the selected project. For a transaction to be uploaded to the form, its project task must be within the specified range of project task.

This column appears on the form only if the Project Accounting feature is enabled on the Enable/Disable Features form.

Cost Code

The last cost code in the range of cost codes of the selected project. For a transaction to be uploaded to the form, its cost code must be within the specified range of cost code.

This column appears on the form only if the Cost Codes feature is enabled on the Enable/Disable Features form.

Transaction Date The date of the original transaction. This column is not available for editing.
Post Period The financial period of the original transaction. This column is not available for editing.
Transaction Description The description of the original transaction. This column is not available for editing.