Difference between revisions of "ManPageW Currency"
(→Notes about Accounting Tab: edit) |
|||
(One intermediate revision by the same user not shown) | |||
Line 14: | Line 14: | ||
== Notes about Accounting Tab == | == Notes about Accounting Tab == | ||
− | + | :In accounting tab is not possible to save data. | |
− | + | :When you enter to a company, it's not possible to capture because currencies are defined in System company. | |
− | When you enter to a company, it's not possible to capture because currencies are defined in System company. | + | :When you enter to System company, it's not possible to capture because from System you can't see the other companies. |
− | + | :: Accounts entered here are not used - Adempiere uses the defined on accounting scheme - check [[Default Accounts Usage]] - [[User:CarlosRuiz|CarlosRuiz_globalqss]] 04:17, 22 January 2010 (PST) | |
− | When you enter to System company, it's not possible to capture because from System you can't see the other companies. | + | |
− | + | ||
− | + | ||
[[Category:Manual|W C]] | [[Category:Manual|W C]] |
Latest revision as of 05:20, 22 January 2010
Enjoy it, and help to fill it! But please, always respecting copyright.
Please write your contributions under the Contributions Section
Contents
Window: Currency
Description : Maintain Currencies
Help : The Currency Window defines any currency which will be used in documents or reporting. You would define used currencies on System level and add currencies on Client level only for statistical currencies (e.g. for instable currencies)
Tab: Currency
Description : Define Currency
Help : The Currency Tab defines any currency you will transact with or report in.
Table Name : C_Currency
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
ISO Currency Code | Three letter ISO 4217 Code of the Currency | For details - http://www.unece.org/trade/rec/rec09en.htm | ISO_Code
CHAR(3) String |
Symbol | Symbol of the currency (opt used for printing only) | The Currency Symbol defines the symbol that will print when this currency is used. | CurSymbol
NVARCHAR2(10) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Standard Precision | Rule for rounding calculated amounts | The Standard Precision defines the number of decimal places that amounts will be rounded to for accounting transactions and documents. | StdPrecision
NUMBER(10) Integer |
Costing Precision | Rounding used costing calculations | The Costing Precision defines the number of decimal places that amounts will be rounded to when performing costing calculations. | CostingPrecision
NUMBER(10) Integer |
Tab: Translation
Description :
Help :
Table Name : C_Currency_Trl
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Currency | The Currency for this record | Indicates the Currency to be used when processing or reporting on this record | C_Currency_ID
NUMBER(10) TableDir |
Language | Language for this entity | The Language identifies the language to use for display and formatting | AD_Language
VARCHAR2 Table |
Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Translated | This column is translated | The Translated checkbox indicates if this column is translated. | IsTranslated
CHAR(1) YesNo |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Symbol | Symbol of the currency (opt used for printing only) | The Currency Symbol defines the symbol that will print when this currency is used. | CurSymbol
NVARCHAR2(10) String |
Tab: Accounting
Description : Currency Accounting
Help : The Accounting Tab defines the accounting parameters used for transactions including a currency. Please nore that if not defined, the default accounts of the Accounting Schema are used!
Table Name : C_Currency_Acct
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Currency | The Currency for this record | Indicates the Currency to be used when processing or reporting on this record | C_Currency_ID
NUMBER(10) TableDir |
Accounting Schema | Rules for accounting | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar | C_AcctSchema_ID
NUMBER(10) TableDir |
Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Realized Gain Acct | Realized Gain Account | The Realized Gain Account indicates the account to be used when recording gains achieved from currency revaluation that have been realized. | RealizedGain_Acct
NUMBER(10) Account |
Realized Loss Acct | Realized Loss Account | The Realized Loss Account indicates the account to be used when recording losses incurred from currency revaluation that have yet to be realized. | RealizedLoss_Acct
NUMBER(10) Account |
Unrealized Gain Acct | Unrealized Gain Account for currency revaluation | The Unrealized Gain Account indicates the account to be used when recording gains achieved from currency revaluation that have yet to be realized. | UnrealizedGain_Acct
NUMBER(10) Account |
Unrealized Loss Acct | Unrealized Loss Account for currency revaluation | The Unrealized Loss Account indicates the account to be used when recording losses incurred from currency revaluation that have yet to be realized. | UnrealizedLoss_Acct
NUMBER(10) Account |
Tab: Conversion Rates
Description : Define currency conversion rates
Help : The Conversion Rate Tab defines the rates to use when converting a source currency to an accounting or reporting currency. Note that only the multiply rate is used; The divide rate is for visualization only.
Table Name : C_Conversion_Rate
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Currency | The Currency for this record | Indicates the Currency to be used when processing or reporting on this record | C_Currency_ID
NUMBER(10) Table |
Currency To | Target currency | The Currency To defines the target currency for this conversion rate. | C_Currency_ID_To
NUMBER(10) Table |
Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Currency Type | Currency Conversion Rate Type | The Currency Conversion Rate Type lets you define different type of rates, e.g. Spot, Corporate and/or Sell/Buy rates. | C_ConversionType_ID
NUMBER(10) TableDir |
Valid from | Valid from including this date (first day) | The Valid From date indicates the first day of a date range | ValidFrom
DATE Date |
Valid to | Valid to including this date (last day) | The Valid To date indicates the last day of a date range | ValidTo
DATE Date |
Multiply Rate | Rate to multiple the source by to calculate the target. | To convert Source number to Target number, the Source is multiplied by the multiply rate. If the Multiply Rate is entered, then the Divide Rate will be automatically calculated. | MultiplyRate
NUMBER Number |
Divide Rate | To convert Source number to Target number, the Source is divided | To convert Source number to Target number, the Source is divided by the divide rate. If you enter a Divide Rate, the Multiply Rate will be automatically calculated. | DivideRate
NUMBER Number |
Contributions
Notes about Accounting Tab
- In accounting tab is not possible to save data.
- When you enter to a company, it's not possible to capture because currencies are defined in System company.
- When you enter to System company, it's not possible to capture because from System you can't see the other companies.
- Accounts entered here are not used - Adempiere uses the defined on accounting scheme - check Default Accounts Usage - CarlosRuiz_globalqss 04:17, 22 January 2010 (PST)