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 (CS100000) 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 (CS100000) 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 (CS100000) 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. Note: The project tasks with the Completed, Canceled, or In Planning status can be selected on data entry forms only if a user has the Project Accountant role assigned to user's account on the User Roles (SM201005) form. This box appears on the form only if the Project Accounting feature is enabled on the Enable/Disable Features (CS100000) 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. Note: The project tasks with the Completed, Canceled, or In Planning status can be selected on data entry forms only if a user has the Project Accountant role assigned to user's account on the User Roles (SM201005) form. This box appears on the form only if the Project Accounting feature is enabled on the Enable/Disable Features (CS100000) 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 (CS100000) 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 (CS100000) 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 (CS100000) 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 (CS100000) 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 (CS100000) 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 (CS100000) 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 (CS100000) 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 (CS100000) 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 (CS100000) 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 (CS100000) 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 (CS100000) 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 (CS100000) 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 (CS100000) 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 (CS100000) 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 (CS100000) form. If the Contract Management feature is enabled on the Enable/Disable Features (CS100000) 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 (CS100000) 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 (CS100000) 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 (CS100000) 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 (CS100000) 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 (CS100000) 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 (CS100000) 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 (CS100000) 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.