ManPageW ImportGLJournal es

From ADempiere ERP Wiki
Jump to navigationJump to search

Volver al Indice

¡Disfrútalo y ayuda a completarlo! Pero por favor, siempre respetando los derechos de autor.

Por favor, escriba sus contribuciones bajo la Sección Contribuciones


Window: Import GL Journal[edit]

Description : Import General Ledger Journals

Help : You way want to check the balance of the import with "Validate Only" before importing. Unbalanced Journals are imported; the handling is based on your settings for the posting process. The optional balance check checks the entire import, not individual batches and journals.



Tab: General Ledger[edit]

Description : Import General Ledger

Help : A new Journal Batch is created, if the Batch Document No or accounting schema are different. A new Journal is created, if the Document No, Currency, Document Type, GL Category, Posting Type or Accounting type is different. You can also force the creation of a new Batch or Jornal by selecting the creat new flag.

Please note that there are three Organization Fields: The Document Organization is the owner of the document and set directly or per parameter default. The Organization is part of the accounting key and only required id no Valid Account Comination is specified; If not defined it is derived from the Document Organization. The Transaction Organization is part of the account combination.
The optional balance check applies to the entire import, not for individual batches or journals.
The document numbers will be overwritten if the document type is not set to manual sequences. Table Name  : I_GLJournal

ManPageW ImportGLJournal GeneralLedger.png

Fields

Name Description Help Technical Data
Import GL Journal Import General Ledger Journal I_GLJournal_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

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

Journal Batch General Ledger Journal Batch The General Ledger Journal Batch identifies a group of journals to be processed as a group. GL_JournalBatch_ID

NUMBER(10)

Search

Client Key Key of the Client ClientValue

NVARCHAR2(40)

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

Document Org Document Organization (independent from account organization) AD_OrgDoc_ID

NUMBER(10)

Table

Batch Document No Document Number of the Batch BatchDocumentNo

NVARCHAR2(30)

String

Create New Batch If selected a new batch is created Note that the balance check does not check that individual batches are balanced. IsCreateNewBatch

CHAR(1)

YesNo

Batch Description Description of the Batch BatchDescription

NVARCHAR2(255)

String

Journal General Ledger Journal The General Ledger Journal identifies a group of journal lines which represent a logical business transaction GL_Journal_ID

NUMBER(10)

Search

Journal Document No Document number of the Journal JournalDocumentNo

NVARCHAR2(30)

String

Create New Journal If selected a new journal within the batch is created Note that the balance check does not check that individual journals are balanced. IsCreateNewJournal

CHAR(1)

YesNo

Account Schema Name Name of the Accounting Schema AcctSchemaName

NVARCHAR2(60)

String

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

PostingType The type of posted amount for the transaction The Posting Type indicates the type of amount (Actual, Budget, Reservation, Commitment, Statistical) the transaction. PostingType

CHAR(1)

List

Budget General Ledger Budget The General Ledger Budget identifies a user defined budget. These can be used in reporting as a comparison against your actual amounts. GL_Budget_ID

NUMBER(10)

TableDir

Document Type Name Name of the Document Type DocTypeName

NVARCHAR2(60)

String

Document Type Document type or rules The Document Type determines document sequence and processing rules C_DocType_ID

NUMBER(10)

TableDir

Category Name Name of the Category CategoryName

NVARCHAR2(60)

String

GL Category General Ledger Category The General Ledger Category is an optional, user defined method of grouping journal lines. GL_Category_ID

NUMBER(10)

TableDir

Account Date Accounting Date The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document. It is also used for any currency conversion. DateAcct

DATE

Date

Period Period of the Calendar The Period indicates an exclusive range of dates for a calendar. C_Period_ID

NUMBER(10)

TableDir

Journal Line General Ledger Journal Line The General Ledger Journal Line identifies a single transaction in a journal. GL_JournalLine_ID

NUMBER(10)

Search

Line No Unique line for this document Indicates the unique line for a document. It will also control the display order of the lines within a document. Line

NUMBER(10)

Integer

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

NVARCHAR2(255)

String

Source Debit Source Debit Amount The Source Debit Amount indicates the credit amount for this line in the source currency. AmtSourceDr

NUMBER

Amount

Source Credit Source Credit Amount The Source Credit Amount indicates the credit amount for this line in the source currency. AmtSourceCr

NUMBER

Amount

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

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

Currency Type Key Key value for the Currency Conversion Rate Type The date type key for the conversion of foreign currency transactions ConversionTypeValue

NVARCHAR2(40)

String

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

Rate Currency Conversion Rate The Currency Conversion Rate indicates the rate to use when converting the source currency to the accounting currency CurrencyRate

NUMBER

Number

Accounted Debit Accounted Debit Amount The Account Debit Amount indicates the transaction amount converted to this organization's accounting currency AmtAcctDr

NUMBER

Amount

Accounted Credit Accounted Credit Amount The Account Credit Amount indicates the transaction amount converted to this organization's accounting currency AmtAcctCr

NUMBER

Amount

UOM Unit of Measure The UOM defines a unique non monetary Unit of Measure C_UOM_ID

NUMBER(10)

TableDir

Quantity Quantity The Quantity indicates the number of a specific product or item for this document. Qty

NUMBER

Quantity

Combination Valid Account Combination The Combination identifies a valid combination of element which represent a GL account. C_ValidCombination_ID

NUMBER(10)

Search

Org Key Key of the Organization OrgValue

NVARCHAR2(40)

String

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

Account Key Key of Account Element AccountValue

NVARCHAR2(40)

String

Account Account used The (natural) account used Account_ID

NUMBER(10)

Table

Business Partner Key Key of the Business Partner BPartnerValue

NVARCHAR2(40)

String

Business Partner Identifies a Business Partner A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson C_BPartner_ID

NUMBER(10)

Search

Product Key Key of the Product ProductValue

NVARCHAR2(40)

String

UPC/EAN Bar Code (Universal Product Code or its superset European Article Number) Use this field to enter the bar code for the product in any of the bar code symbologies (Codabar, Code 25, Code 39, Code 93, Code 128, UPC (A), UPC (E), EAN-13, EAN-8, ITF, ITF-14, ISBN, ISSN, JAN-13, JAN-8, POSTNET and FIM, MSI/Plessey, and Pharmacode) UPC

VARCHAR2

String

SKU Stock Keeping Unit The SKU indicates a user defined stock keeping unit. It may be used for an additional bar code symbols or your own schema. SKU

VARCHAR2

String

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

Search

Project Key Key of the Project ProjectValue

NVARCHAR2(40)

String

Project Financial Project A Project allows you to track and control internal or external activities. C_Project_ID

NUMBER(10)

Search

Campaign Marketing Campaign The Campaign defines a unique marketing program. Projects can be associated with a pre defined Marketing Campaign. You can then report based on a specific Campaign. C_Campaign_ID

NUMBER(10)

TableDir

Activity Business Activity Activities indicate tasks that are performed and used to utilize Activity based Costing C_Activity_ID

NUMBER(10)

TableDir

Sales Region Sales coverage region The Sales Region indicates a specific area of sales coverage. C_SalesRegion_ID

NUMBER(10)

TableDir

Trx Org Key Key of the Transaction Organization OrgTrxValue

NVARCHAR2(40)

String

Trx Organization Performing or initiating organization The organization which performs or initiates this transaction (for another organization). The owning Organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions. AD_OrgTrx_ID

NUMBER(10)

Table

Location From Location that inventory was moved from The Location From indicates the location that a product was moved from. C_LocFrom_ID

NUMBER(10)

Table

Location To Location that inventory was moved to The Location To indicates the location that a product was moved to. C_LocTo_ID

NUMBER(10)

Table

User List 1 User defined list element #1 The user defined element displays the optional elements that have been defined for this account combination. User1_ID

NUMBER(10)

Table

User List 2 User defined list element #2 The user defined element displays the optional elements that have been defined for this account combination. User2_ID

NUMBER(10)

Table

Import Journal Import General Ledger Batch/Journal/Line 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

Contribuciones[edit]