Funds Transfers

Form ID: (CA301000)

You use this form to transfer funds from one cash account to another, with related service charges applied, and to view the details of the recorded funds transfers. You can also reverse an incorrect funds transfer on this form.

Form Toolbar

The form toolbar includes standard buttons and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands can be shown as buttons on the form toolbar, as commands on the More menu, or in both places. These commands are listed in the following table in alphabetical order.

Command Description
Hold

Changes the status of the funds transfer to On Hold. You click this button or command when you want to make changes to the funds transfer or to pause its processing.

Release

Releases the selected funds transfer.

Remove Hold

Changes the status of the funds transfer from On Hold to Balanced, making it possible to release the funds transfer.

This button and command are available if the funds transfer has the On Hold status.

Reverse

Creates a funds transfer with the details of the original funds transfer reversed. That is, the details from the Destination Account section (Summary area) of this form for the original transfer are copied to the Source Account section of this form for the created transfer; the details from the Source Account section of this form for the original transfer are copied to the Destination Account section of this form for the created transfer.

This button and command are available only if a funds transfer with the Released status is selected on the form.

Summary Area

In this area, you can specify all the settings of the funds transfer, including source and destination accounts, currencies, and dates.

Element Description
Transfer Number The transfer number, as assigned by the numbering sequence for transfers defined on the Cash Management Preferences (CA101000) form.
Status

The status of the transfer, which is assigned by the system.

The status can be one of the following:

  • On Hold: The transfer is a draft only; the actual transfer of goods has not been initiated. You can take the transfer off hold by clicking the Remove Hold button on the form toolbar (or the equivalent command).
  • Balanced: The transfer is balanced and can be released.
  • Released: The transfer has been released.
Description A detailed description for the transfer transaction. An alphanumeric string of up to 60 characters may be used.
RGOL A read-only box that displays realized gain or loss (RGOL) amount: the difference between the amount in the base currency specified for the source account and the amount in the base currency resulting for the destination account, for cases when the source and destination currencies are different.
Table 1. Source Account Section
Element Description
Account The account from which the funds are transferred.
Transfer Date

The date of the transaction.

You can enter only a date that corresponds to a financial period that has been generated on the Master Financial Calendar (GL201000) form. If the date that you enter belongs to a financial period that has not yet been generated in the system—for example, for a date in the distant future or past—the system will display an error message, and you will not be able to save the document.

Cleared A check box that indicates (if selected) that this transaction is cleared.
Document Ref. The reference number of the transfer in the bank.

This box is required, if the Require Document Ref. Nbr. on Entry check box is selected on the Cash Management Preferences (CA101000) form.

Currency

The currency of denomination for the source cash account.

This set of boxes appears on the form only if the Multicurrency Accounting feature is enabled on the Enable/Disable Features (CS100000) form.

Amount The amount of the transaction in the specified currency.
Batch Number The identification number of the batch that updates the source and cash-in-transit accounts. You can click the link in this box to view the batch on the Journal Transactions (GL301000) form.
Clear Date The date when the transaction was cleared during the reconciliation process.
GL Balance

A read-only box displaying the balance of the source account recorded in the General Ledger for the financial period that includes the transfer date.

This box is displayed on the form only if the selected transfer has the On Hold or Balanced status.

Available Balance

A read-only box displaying the balance of the cash account calculated in accordance with the options selected in the Receipts to Add to Available Balances and Disbursements to Deduct from Available Balances sections on the Cash Management Preferences form.

This box is displayed on the form only if the selected transfer has the On Hold or Balanced status.

Base Currency Amount The amount of the transfer in the base currency. If the source account is denominated to a foreign currency, the default exchange rate associated with the account is used. You can specify another rate by using the Currency controls.
Table 2. Destination Account Section
Element Description
Account The account to which the funds are transferred.
Receipt Date

The date of the transfer receipt.

You can enter only a date that corresponds to a financial period that has been generated on the Master Financial Calendar (GL201000) form. If the date that you enter belongs to a financial period that has not yet been generated in the system—for example, for a date in the distant future or past—the system will display an error message, and you will not be able to save the document.

Cleared A check box that indicates (if selected) that this transaction is cleared.
Document Ref. The reference number of the transfer in the bank or other financial entity.
Currency

The currency of denomination for the destination account.

This set of boxes appears on the form only if the Multicurrency Accounting feature is enabled on the Enable/Disable Features form.

Amount The amount of the transaction in the currency of the destination account.
Batch Number The identification number of the batch that creates related journal entries to update the cash-in-transit and destination accounts. You can click the link in this box to view the batch on the Journal Transactions (GL301000) form.
Clear Date The date when the transaction was cleared during the reconciliation process.
GL Balance

The balance of the target account, as recorded in the general ledger.

This box is displayed on the form only if the transfer has the On Hold or Balanced status.

Available Balance

The actual balance of the target account.

This box is displayed on the form only if the transfer has the On Hold or Balanced status.

Base Currency Amount The amount of the transaction in the base currency. You can specify another exchange rate by using the Currency controls.

Table

The table displays the list of cash adjustments that contain the charges and expenses related to the selected funds transfer. To add an additional charge or expense, you add a row to the table and fill in the applicable columns. You can also edit the details of cash adjustments for unreleased funds transfers in this table.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Table 3. Table Columns
Column Description
Cash Account The cash account to be updated by this transaction.
Entry Type The entry type of this charge or expense. In this column, you can select an entry type from only the entry types that have been associated with the selected cash account on the Entry Types tab of the Cash Accounts (CA202000) form.
Tip: If an entry type has been defined as the default one for the cash account on the Entry Types tab of the Cash Accounts (CA202000) form, the system automatically fill in this entry type, but you can override this value.
Description

A description of the entry.

By default, the system fills in this column with the description of the selected entry type. You can override the description if necessary.

Amount The amount of the charge or expense.
Tax Amount

The total amount of all tax lines added to the current expense.

The displayed amount is a link you can click to open the Expense Taxes dialog box.

Total Amount

The total amount of the expense.

This amount is calculated based on the following formulas, which differ based on whether the taxes are inclusive:

  • For non-inclusive taxes: Total Amount = Amount + Tax Amount where Taxable Amount = Amount
  • For inclusive taxes: Total Amount = Taxable Amount + Tax Amount where Total Amount = Amount

In these formulas, Amount is the amount of the expense manually defined by a user. For non-inclusive taxes, this amount is also known as the taxable amount. Tax Amount is the total amount of the taxes applied to this expense manually or automatically.

Currency

The currency of the charge or expense. The system fills in this column with the currency associated with the cash account on the Cash Accounts (CA202000) form.

Currency Rate

The currency rate that will be used for the transaction.

By default, this is the effective currency rate of the rate type specified for the cash account in the Curr. Rate Type box on the Cash Accounts (CA202000) form. If the default currency rate type is not specified for the cash account, then the effective currency rate of the rate type specified in the CA Rate Type box on the Currency Management Preferences (CM101000) form is used.

You can edit the value in this column if a foreign currency is selected in the Currency column for a row.

Document Ref. A reference number of an external document related to the transfer, the charges, or both.
Offset Account

The GL expense account that will be updated by this charge or expense.

By default, the system fills in this column with the offset account of the entry type selected for this row, which is specified for the entry type on the Entry Types (CA203000) form. You can override this value if necessary.

Offset Subaccount

The subaccount that will be updated, along with the account, by this charge or expense.

By default, the system fills in this column with the offset subaccount of the entry type selected for this row, which is specified on the Entry Types (CA203000) form. You can override this value if necessary.

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

Doc. Date

The transaction date. By default, the current business date is selected, but you can override this value.

You can enter only a date that corresponds to a financial period that has been generated on the Master Financial Calendar (GL201000) form. If the date that you enter belongs to a financial period that has not yet been generated in the system—for example, for a date in the distant future or past—the system will display an error message, and you will not be able to save the document.

Fin. Period

The financial period of the transaction.

By default, the period of the current business date is selected.

Tax Zone The tax zone applied to the expense. By default, the tax zone is copied from the tax zone of the selected cash account specified for the selected entry type in the Tax Zone column on the Entry Types tab of the Cash Accounts (CA202000) form.
Tax Category The default tax category of the tax zone. You can override this value.
Tax Calculation Mode

The tax calculation mode, which defines which amount (tax-inclusive or tax-exclusive) is entered in the current row.

Select one of the following options:

  • Tax Settings: The tax amount for the funds transfer is calculated according to the settings of the applicable tax or taxes.
  • Gross: The amount in the funds transfer line includes a tax or taxes.
  • Net: The amount in the funds transfer line does not include taxes.
Note: The default value is copied from the combination of the cash account and entry type selected in this row.

This column is available only if the Net/Gross Entry Mode feature is enabled on the Enable/Disable Features (CS100000) form.

Cleared A check box that indicates (if selected) that this transaction is cleared.
Batch Nbr. The identification number of the batch that creates journal entries related to the expense. You can click a link in this column to view the batch on the Journal Transactions (GL301000) form.
Table 4. Expense Taxes Dialog Box

This dialog box opens when you click a link in the Tax Amount column. You can use this dialog box to review the settings of the tax applied to the expense line and to create, delete, and modify taxes for a particular expense line.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Element Description
Tax ID The identifier of the tax defined automatically by the system based on the tax zone and tax category or manually selected by a user.
Tax Rate The tax rate (%) that is used to calculate the tax amount. By default, this value is unavailable for editing and is copied from the Tax Rate column on the Tax Schedule tab of the Taxes (TX205000) form for the selected tax.
Taxable Amount

The taxable amount of the tax line.

For exclusive taxes, this amount is defined as equal to the value in the Expense Amount column. For inclusive taxes, this amount is equal to the difference between the values in the Expense Amount and Tax Amount columns.

Tax Amount The amount of the tax calculated automatically by the system based on the tax ID or specified manually by a user.
Deductible Tax Rate

The revision of the deductible tax rate, which is actual as of the expense date.

For taxes that have the Partially Deductible VAT check box cleared on the Taxes (TX205000) form, the value is 100. For taxes that have the Partially Deductible VAT check box selected, the value is copied from the Deductible Tax Rate column on the Tax Schedule tab on the Taxes (TX205000) form.

Expense Amount The non-deductible tax amount that is recorded as an expense.

The dialog box has the following button.

OK Saves the changes made in the dialog box, such as an added or deleted tax, and closes the dialog box. The system recalculates the amount in the Tax Amount and Total Amount columns automatically.