Versions Compared

Key

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

The purpose of the Company Currencies List View is to assign both the Realized and Unrealized Gain and Realized and Unrealized Loss GL Accounts to all the foreign currencies that are open to the current company. From here, users can click the 'Edit' icon and assign/edit the GL Accounts. The list of currencies in this list view include all the currencies assigned to the company in the System→Configuration→Currencies Master File. Most transactions within NorthScope require the Currency ID to be specified. For those that do not, it is assumed they are in the Home Currency.

Software Version: 20192023.0912.03 19 and newer

Table of Contents
typeflat

Page Header Header

...

Toolbar IconsDescriptionCancel Insert excerptCancel - List View EditCancel - List View EditnopaneltrueDelete Insert excerptDelete - GlobalDelete - GlobalnopaneltrueEdit Insert excerptEdit - List View Single LineEdit - List View Single LinenopaneltrueExcel Insert excerptExcel - GlobalExcel - GlobalnopaneltrueFavorites Insert excerptFavorites Add/Remove - GlobalFavorites Add/Remove - GlobalnopaneltrueGrid Layout Insert excerptGrid LayoutGrid LayoutnopaneltrueHelpInquiry Criteria Insert excerptInquiry Criteria - GlobalInquiry Criteria - GlobalnopaneltrueMass Update Insert excerptMass Update - GlobalMass Update - GlobalnopaneltrueMore Actions Insert excerptMore Actions - GlobalMore Actions - GlobalnopaneltrueNew Insert excerptNew - GlobalNew - GlobalnopaneltrueNotes Insert excerptNotes - GlobalNotes - GlobalnopaneltruePrint Insert excerptPrint - GlobalPrint - GlobalnopaneltrueProcessRefresh Insert excerptRefresh - GlobalRefresh - GlobalnopaneltrueRequery Insert excerptRefresh - GlobalRefresh - GlobalnopaneltrueSave Insert excerptSave - GlobalSave - GlobalnopaneltrueValidateFieldsDescriptionField 1Field 2Field 3(Field Name) IDThe unique identifier of the (what type of record is this)CancelCancel - List View Edit
Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Cancel - List View Edit
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Edit
Insert excerpt
Edit - List View (ML)Edit - List View (ML)
nopaneltrue
Excel
Insert excerpt
Excel - GlobalLV 3.0
Excel - GlobalLV 3.0
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid LayoutGroup By Show/Hide
Insert excerpt
Grid LayoutGrid Layout
nopaneltrue
Help
Insert excerpt
Help - Global IconHelp - Global IconGroup By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
SaveHelpField 1Field 2Field
Insert excerpt
Save Help - Global 3.0Save
Help - Global
nopaneltrue
FieldsDescription
3
(Field Name) ID

The unique identifier of the (what type of record is this). This is required for all records and must be unique (what must it be unique by) (and defaults from or is calculated by). 

Linked Database Field: ERPx_#####.#####.

(Field Name) Description

The name associated with the (ID Field Name) ID. This is required for all records but does not need to be unique (what must it be unique by) (and defaults from or is calculated by). 

Linked Database Field: ERPx_#####.#####.

InactiveA Yes/No field used to identify if the record is Inactive. If set to 'Yes' then the record is "Inactive" and will not be included in look-ups for transactions or other master files. If set to 'No' then the record is "Active" and can be freely used ('No' values display as blank in the grid). This value is always editable. Linked Database Field: ERPx_#####.#####.
CheckboxUsed to select one or more records.
Date FieldThe date of the (what is the date for) that was created by the transaction. Linked Database Field: ERPx_#####.#####.
HyperlinkA hyperlink show the (Field Name) of the transaction. Clicking on the link opens the record view of the transaction. This field is not editable. Linked Database Field: ERPx_#####.#####.
Lookup (from an Enumeration)

A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabledLinked Database Field: ERPx_#####.#####.

This lookup contains all the values in the (What enumeration Class - link this) Enumeration Class. 

Lookup (non Enumeration)

A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabledLinked Database Field: ERPx_#####.#####

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' (what does it include).

Text Field

The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####.

(Tab1 Name) Tab

.0
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Save
Insert excerpt
Save - LV (Multi Line) 3.0
Save - LV (Multi Line) 3.0
nopaneltrue
Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
FieldsDescription
Currency

The unique identifier of the Currency record. This is required for all records and must be unique

(what must it be unique by) (and defaults from or is calculated by)

within the NorthScope system

Linked

Database Field:

ERPx

 ERPx_

#####

MFCurrency.

#####Lookup (non Enumeration)A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabledLinked Database Field: ERPx_#####.#####

CurrencyID.

(Field Name) Description

The name associated with the (ID Field Name) ID. This is required for all records but does not need to be unique (what must it be unique by) (and defaults from or is calculated by). 

Linked Database Field: ERPx_#####.#####.

InactiveA Yes/No field used to identify if the record is Inactive. If set to 'Yes' then the record is "Inactive" and will not be included in look-ups for transactions or other master files. If set to 'No' then the record is "Active" and can be freely used ('No' values display as blank in the grid). This value is always editable. Linked Database Field: ERPx_#####.#####.CheckboxUsed to select one or more records.Date FieldThe date of the (what is the date for) that was created by the transaction. Linked Database Field: ERPx_#####.#####.HyperlinkA hyperlink show the (Field Name) of the transaction. Clicking on the link opens the record view of the transaction. This field is not editable. Linked Database Field: ERPx_#####.#####.Lookup (from an Enumeration)

A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabledLinked Database Field: ERPx_#####.#####.

This lookup contains all the values in the (What enumeration Class - link this) Enumeration Class. 

Realized Gain Account

A single select lookup to assign the GL Account that will be used on Currency Gain journal entries. This defaults to blank and is not required to Save but it is required to create a Realized Gain journal entry. This should be assigned to every foreign currency used by the company. This field is always enabled

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' GL Accounts.

Database Field: ERPx_MFDataEntityCompanyCurrency.RealizedGainActSK

Realized Loss Account

A single select lookup to assign the GL Account that will be used on Currency Loss journal entries. This defaults to blank and is not required to Save but it is required to create a Realized Loss journal entry. This should be assigned to every foreign currency used by the company. This field is always enabled

This lookup contains a blank value, the current assigned value, and a list of all the 'Active'

(what does it include).Text FieldThe [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####.

(Tab2 Name) Tab

Toolbar IconsDescriptionCancel Insert excerptCancel - List View EditCancel - List View EditnopaneltrueDelete Insert excerptDelete - GlobalDelete - GlobalnopaneltrueEdit Insert excerptEdit - List View Single LineEdit - List View Single LinenopaneltrueExcel Insert excerptExcel - GlobalExcel - GlobalnopaneltrueFavorites Insert excerptFavorites Add/Remove - GlobalFavorites Add/Remove - GlobalnopaneltrueGrid Layout Insert excerptGrid LayoutGrid LayoutnopaneltrueHelpMass Update Insert excerptMass Update - GlobalMass Update - GlobalnopaneltrueMore Actions Insert excerptMore Actions - GlobalMore Actions - GlobalnopaneltrueNew Insert excerptNew - GlobalNew - GlobalnopaneltrueNotes Insert excerptNotes - GlobalNotes - GlobalnopaneltruePrint Insert excerptPrint - GlobalPrint - GlobalnopaneltrueProcessRefresh Insert excerptRefresh - GlobalRefresh - GlobalnopaneltrueRequery Insert excerptRefresh - GlobalRefresh - GlobalnopaneltrueSave Insert excerptSave - GlobalSave - GlobalnopaneltrueValidateFieldsDescriptionField 1Field 2Field 3(Field Name) ID

The unique identifier of the (what type of record is this). This is required for all records and must be unique (what must it be unique by) (and defaults from or is calculated by). 

Linked Database Field: ERPx_#####.#####.

(Field Name) Description

The name associated with the (ID Field Name) ID. This is required for all records but does not need to be unique (what must it be unique by) (and defaults from or is calculated by). 

Linked Database Field: ERPx_#####.#####.

InactiveA Yes/No field used to identify if the record is Inactive. If set to 'Yes' then the record is "Inactive" and will not be included in look-ups for transactions or other master files. If set to 'No' then the record is "Active" and can be freely used ('No' values display as blank in the grid). This value is always editable. Linked Database Field: ERPx_#####.#####.CheckboxUsed to select one or more records.Date FieldThe date of the (what is the date for) that was created by the transaction. Linked Database Field: ERPx_#####.#####.HyperlinkA hyperlink show the (Field Name) of the transaction. Clicking on the link opens the record view of the transaction. This field is not editable. Linked Database Field: ERPx_#####.#####.Lookup (from an Enumeration)

A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabledLinked Database Field: ERPx_#####.#####.

This lookup contains all the values in the (What enumeration Class - link this) Enumeration Class. 

Lookup (non Enumeration)A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabledLinked Database Field: ERPx_#####.#####

GL Accounts.

Database Field: ERPx_MFDataEntityCompanyCurrency.RealizedLossActSK

Unrealized Gain Account

A single select lookup to assign the GL Account that will be used on Currency Unrealized Gain journal entries. This defaults to blank and is not required to Save but it is required to create an Unrealized Gain journal entry. This should be assigned to every foreign currency used by the company. This field is always enabled

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' GL Accounts.

Database Field: ERPx_MFDataEntityCompanyCurrency.UnrealizedGainActSK

Unrealized Loss Account

A single select lookup to assign the GL Account that will be used on Currency Unrealized Loss journal entries. This defaults to blank and is not required to Save but it is required to create an Unrealized Loss journal entry. This should be assigned to every foreign currency used by the company. This field is always enabled

This lookup contains a blank value, the current assigned value, and a list of all the 'Active'

(what does it include).Text FieldThe [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####.

GL Accounts.

Database Field: ERPx_MFDataEntityCompanyCurrency.UnrealizedLossActSK


Related Topics



Expand
titlePage Definitions

Page Definitions


...