You use this program to define the interface ledger accounts by branch and optionally by currency/bank, for the revaluation of outstanding foreign currency supplier invoices using the AP Exchange Rate Revaluation program.
| Field | Description | ||||||
|---|---|---|---|---|---|---|---|
| Functions | |||||||
| Maintain | Add or change the interface entries. | ||||||
| Integration Level | Set the integration level required. Interface entries can be defined by currency within AP branch, or by bank within AP branch. The AP branch is mandatory. |
||||||
| Validate | Check the validity of the interface entries to ensure the integrity of your interface records based on the Integration Level selected. You can view missing entries, and delete invalid entries. | ||||||
| View | Indicate the type of entries to display in the
listview.
|
AP currency variance integration can be defined by:
| Field | Description |
|---|---|
| OK | Select this to accept your selections. |
| Cancel | Select this to ignore any changes and set focus back to the AP Variance Interface Details listview. |
| Autoload Values | These options enable you to indicate how you want to save the
selections made in this pane. You can choose to set all selections as they were when you last ran the program (i.e. Load Previous Form Values) or save your selections in the pane as your default preferences for all companies, or for the current company only (i.e. Save Form Values as Default or Save Form Values for this Company). If you have saved form values for the company or as the default, then you can remove these settings and restore them to the form's default preference selections. |
| Currency | Enable this to define interface entries by currency within AP branch code. |
| Bank | Enable this to define interface entries by bank
within AP branch code. This enables you define a different currency variance account from the currency variance account defined against the bank to which to post variances when using the AP Exchange Rate Revaluation program. |
This screen is displayed when you select the Validate option from the Functions menu.
| Field | Description |
|---|---|
| OK | Select this to accept your selections and proceed with the validation. |
| Cancel | Select this to set focus back to the AP Variance Interface Details listview. |
| View entries | |
| Delete entries no longer valid | Select this to delete interface entries that are no longer valid. |
| Check for missing entries | Select this to display all missing interface entries, based on the level of integration defined. |
Details of the interface entries currently defined are displayed in this listview.
Existing entries are displayed by default. Missing entries can be displayed using the View menu.
| Column | Description |
|---|---|
| Delete | Select this icon to delete the ledger interface entry currently highlighted in the listview. |
| Maintain | Select this icon to maintain the ledger interface entry currently highlighted in the listview. |
| Print SRS report | Select this to use the AP Currency Variance Interface Listing program to generate a report of the interface entries currently defined. |
| Select this to generate a report of the contents currently displayed in the listview. | |
| Supplier branch | Displays the Accounts Payable branch for the interface entry. |
| Currency | Displays the currency within the branch for the interface entry. This applies when interface entries are defined by currency within branch level. |
| Bank | Displays the bank within the currency for the interface entry. This applies when interface entries are defined by bank within currency level. |
| Realized variance | Displays the General Ledger interface account for the branch and currency/bank combination for all realized losses/gains due to currency variances. |
| Unrealized variance | Displays the General Ledger interface account for the
branch and currency/bank combination for all unrealized
losses/gains due to currency variances. This column is only available in a SQL environment as the data in this column is from a field that was only added to the SQL table. In C-ISAM this column is disabled. |
You use this pane to define the integration entries based on the Integration Level selected.
| Field | Description |
|---|---|
| Apply Changes | Create the ledger interface entries according to your selections and the information entered. Changes are only applied when all fields are valid. |
| Cancel | Ignores any changes made. |
| Branch | |
| Branch selection | Indicate the AP branches for which to maintain interface entries. |
| Currency | |
| Currency selection | Indicate the currency(ies) for which to maintain
interface entries. This only applies integration is defined by currency within branch. |
| Bank | |
| Bank selection |
Indicate the bank(s) for which to maintain interface entries. This only applies when integration is defined by bank within branch or by bank within branch and currency. |
| General ledger accounts | |
| Realized variance | Indicate the ledger code to which actual calculated
exchange rate variances must be posted for the selected
branches, currencies and banks. These variances are the actual
expense in the case of an exchange rate loss, or the actual
income/revenue in the case of an exchange rate gain. This should be an expense/revenue type account. When defined, this account is used:
When the Realized variance account is not defined, the variances are posted to the Exchange variance account defined against the relevant bank (Banks). |
| Realized description | This is the description for the account. |
| Unrealized variance |
Indicate the ledger code to which unrealized currency exchange rate variances must be posted. This should be an expense/revenue type account. This account is used for currency exchange variances arising from:
When the Execute AP Payment Run program is run and the invoices were revalued using the AP Exchange Rate Revaluation program, then the provisional variances raised by the exchange rate revaluation are reversed, and the realized variance is calculated based on the original invoice rate. The actual calculated exchange rate variance (per the payment) is posted to the Realized variance account. |
| Unrealized description | This is the description for the account. |
This program can be accessed from the Variance interfaces field of the General Ledger Integration program.