ManPageW ImportAccount

From ADempiere ERP Wiki

Jump to: navigation, search

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section



Window: Import Account

Description : Import Natural Account Values

Help : The Import Natural Account Window is an interim table which is used when importing external data into the system. Selecting the 'Process' button will either add or modify the appropriate records.



Tab: Import Account

Description :

Help :

Table Name  : I_ElementValue

Fields

Name Description Help Technical Data
Import Account Import Account Value I_ElementValue_ID

NUMBER(10)

ID

Imported Has this import been processed The Imported check box indicates if this import has been processed. I_IsImported

CHAR(1)

YesNo

Account Element Account Element Account Elements can be natural accounts or user defined values. C_ElementValue_ID

NUMBER(10)

TableDir

Import Error Message Messages generated from import process The Import Error Message displays any error messages generated during the import process. I_ErrorMsg

NVARCHAR2(2000)

String

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

Element Name Name of the Element ElementName

NVARCHAR2(60)

String

Element Accounting Element The Account Element uniquely identifies an Account Type. These are commonly known as a Chart of Accounts. C_Element_ID

NUMBER(10)

TableDir

Search Key Search key for the record in the format required - must be unique A search key allows you a fast method of finding a particular record.

If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).

Value

NVARCHAR2(40)

String

Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name

NVARCHAR2(60)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Account Type Indicates the type of account Valid account types are A - Asset, E - Expense, L - Liability, O- Owner's Equity, R -Revenue and M- Memo. The account type is used to determine what taxes, if any are applicable, validating payables and receivables for business partners. Note: Memo account amounts are ignored when checking for balancing AccountType

CHAR(1)

List

Account Sign Indicates the Natural Sign of the Account as a Debit or Credit Indicates if the expected balance for this account should be a Debit or a Credit. If set to Natural, the account sign for an asset or expense account is Debit Sign (i.e. negative if a credit balance). AccountSign

CHAR(1)

List

Summary Level This is a summary entity A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values. IsSummary

CHAR(1)

YesNo

Parent Key Key if the Parent ParentValue

NVARCHAR2(40)

String

Parent Account The parent (summary) account ParentElementValue_ID

NUMBER(10)

Table

Post Actual Actual Values can be posted The Post Actual indicates if actual values can be posted to this element value. PostActual

CHAR(1)

YesNo

Post Budget Budget values can be posted The Post Budget indicates if budget values can be posted to this element value. PostBudget

CHAR(1)

YesNo

Post Statistical Post statistical quantities to this account? PostStatistical

CHAR(1)

YesNo

Post Encumbrance Post commitments to this account PostEncumbrance

CHAR(1)

YesNo

Document Controlled Control account - If an account is controlled by a document, you cannot post manually to it IsDocControlled

CHAR(1)

YesNo

Default Account Name of the Default Account Column Default_Account

NVARCHAR2(30)

String

Column Column in the table Link to the database column of the table AD_Column_ID

NUMBER(10)

Table

Import Accounts Import Natural Accounts Import accounts and their hierarchies and optional update the default accounts.

Updating the Default Accounts changes the natural account segment of the used account, e.g. account 01-240 becomes 01-300). If you create a new combination, the old account (e.g. 01-240) will remain, otherwise replaced. If you select this, make sure that you not multiple default accounts using one natural account and HAVE A BACKUP !!

The Parameters are default values for null import record values, they do not overwrite any data.

Processing

CHAR(1)

Button

Processed The document has been processed The Processed checkbox indicates that a document has been processed. Processed

CHAR(1)

YesNo

Contributions

  • When you use the Import Loader (below) to import the accounts into the above screen, you can press the Import Accounts button at the bottom to begin the process.
  • There may be a few errors due to starting blank records which won’t affect the results as all the right records are in.


Personal tools