Versions Compared

Old Version 9

changes.mady.by.user Tom Williams

Saved on

compared with

New Version 10

changes.mady.by.user Emma Greenwood

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The purpose of the Currency Exchanges List View is to show all the Currency Exchange Tables that are available within the system and see which company they are associated with. From here, users can add, edit, or delete exchange tables but the most common function is to update exchange rates. Exchange Tables are only needed for companies that deal with foreign currencies and they are used on transactions and transaction journal entries that a foreign currency.

Software Version: 20192023.0906.0330 and newer

Table of Contents
typeflat

Page Header

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Delete
Insert excerpt
Delete - LV 3.0
Delete - LV 3.0
nopaneltrue
Edit
Insert excerpt
Edit - LV 3.0
Edit - LV 3.0
nopaneltrue
Excel
Insert excerpt
Excel - Global (old)LV 3.0
Excel - Global (old)LV 3.0
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid LayoutGroup By Show/Hide
Insert excerpt
Grid Layout Group By Show/Hide - GlobalGrid Layout
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
New
Insert excerpt
New - Global 3.0
New - Global 3.0
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
FieldsDescription
CheckboxUsed to select one or more records for delete.
Company

A label to show Displays the names of all the Companies that are assigned to use this exchange rate table. This table can only be used by the companies that it is assigned to. This field is always editable from the Currency Exchanges Record View. 

Linked Database Field: ERPx_MFDataEntityCompanyCurrencyExchange.DataEntityCompanySK .

Exchange Table

The Displays the name associated with the Exchange Table ID. This is required for all records but does not need to be unique. This field is always editable from the Currency Exchanges Record View. 

Linked Database Field: ERPx_MFCurrencyExchange.Description 

Exchange Table ID

The Displays the unique identifier of the  the Exchange Table record. This  This field is always only editable from the the Currency Exchanges Record View . Linked for a new record before the initial Save, after Save it is disabled.

Database Field: ERPx_MFCurrencyExchange.ExchangeID 

From Currency

The Displays the Currency ID that the Currency Exchange Table is converting from.Linked   This field is only editable from the Currency Exchanges Record View for a new record before the initial Save, after Save it is disabled. 

Database Field: ERPx_MFCurrencyExchange.SourceCurrencySK

To Currency

The Displays the Currency ID that the Currency Exchange Table is converting to.  This field is only editable from the Currency Exchanges Record View for a new record before the initial Save, after Save it is disabled. 

Linked Database Field: ERPx_MFCurrencyExchange.DestCurrencySK

Sequence

Identifies the sequence you want the Exchange tables selected in are displayed when there is more than one applicable Exchange Table that can be assigned. For example, if there is more than one Exchange Table that converts from CAD to USD, the system will auto assign the one with the lowest sequence number. This can be edited from this list view by using Drag+Drop.

Linked Database Field: ERPx_MFCurrencyExchange.Sequence

...