General Ledger Integration > Receivables > AR Currency Variance GL Interface

AR Currency Variance GL Interface

You use this program to define the interface ledger accounts by branch/currency for the revaluation of outstanding foreign currency customer invoices using the AR Exchange Rate Revaluation and AR Payment Run programs.

Toolbar and menu

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 AR branch, or by currency code within AR branch.

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.
OptionDescription
Existing Entries

The entries displayed in the listview are the existing entries defined against the Branch and/or currency.

This option is enabled by default.

Missing EntriesSelect this to view the missing integration entries. This option is only enabled after you select to Validate the interface entries and the system has detected missing entries.

Integration Level

AR currency variance integration can be defined by:

  • AR Branch code
  • Currency code within AR branch code
Column Description
OK Select this to accept your selections.
Cancel Select this to ignore any changes and set focus back to the AR 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.

Integration level Enable this to define interface entries by currency within AR branch code.
Currency Enable this to define interface entries by currency within AR branch code.

Validate Interface Entries

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 AR 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.

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.

AR Variance Interface Details

Field Description
Save Select this icon to save the changes made in the listview grid.
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 AR Currency Variance Interface Listing program to generate a report of the interface entries currently defined.
Print Select this to generate a report of the contents currently displayed in the listview.
Customer branch Displays the Accounts Receivable branch for the interface entry.
Currency Displays the currency within the branch for the interface entry. This is only displayed if you selected to define interface entries by currency within branch level.
Realized variance Displays the General Ledger interface account for the branch/currency combination for all realized losses/gains due to currency variances.
Unrealized variance Displays the General Ledger interface account for the branch/currency 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.

AR Variance Interface Maintenance

This pane is enabled when you select the Maintain icon in the AR Variance Interface Details listview.

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 Indicate the AR branches for which to maintain interface entries.
Currency Indicate the currency(ies) for which to maintain interface entries.

This option is only enabled when defining integration by Currency within Branch.

Options  
Apply default general ledger codes Enable this to automatically enter the Exchange rate variance account (General Ledger Integration) into the Realized variance field below.

You typically use this option if you only wanted to define a few ledger accounts differently at branch level to the ledger account codes defined at default level in the General Ledger Integration program. You can then change only the few entries that are different.

General ledger account  
Realized variance Indicate the ledger code to which actual calculated exchange rate variances must be posted for the selected branches and currency(ies). 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:

  • for currency variances arising from payments processed using the AR Payments Import, AR Payments and Adjustments, AR Payment Run and AR Post Dated Check Status programs.

  • by the Customer-Supplier Contra program for exchange variances arising from offsetting foreign currency customer and supplier invoices.

  • for all currency variances (realized and unrealized) when running SYSPRO in a C-ISAM environment.

When the Realized variance account is not defined, the variances are posted to the account specified in the Exchange rate variance field of the General Ledger Integration program.

Realized description This is the description for the realized variance 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:

  • Revaluations processed (for the selected branches and currencies) using the AR Exchange Rate Revaluation program.

  • Debit and Credit notes posted against revalued invoices using the AR Invoice Posting program.

When invoices that were revalued using the AR Exchange Rate Revaluation program are paid, the provisional variances raised by the exchange rate revaluation are reversed to this account, and the actual calculated exchange rate variance (per the payment) is posted to the Realized variance account.

Unrealized description This is the description for the unrealized variance account.

Notes and warnings

Program access

  • This program can be accessed from the Variance interfaces field of the General Ledger Integration program.

Integration considerations

  • If you do not define the interface ledger accounts using this program, then all currency exchange variances are posted to the Exchange rate variance account defined in the General Ledger Integration program.

Restrictions and limits

  • You can only generate a report of currency variances interfaces if you have access to the AR Currency Variance Interface Listing program.