Import GL Journal (прозорец ID-278)
От iDempiere bg
прозорец: Import GL Journal
описание: Import General Ledger Journals
помощ: 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: Главна сметкова книга
описание: Импорт на главна сметкова книга
помощ 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.
Файл:Import GL Journal - Главна сметкова книга - прозорец (iDempiere 1.0.0).png
| име | име | описание | помощ | спецификации |
|---|---|---|---|---|
| Import GL Journal | Import GL Journal | Import General Ledger Journal | null | I_GLJournal_ID numeric(10) NOT NULL ID |
| Imported | Импортирано | Импортирано | The Imported check box indicates if this import has been processed. | I_IsImported character(1) NOT NULL Yes-No |
| Import Error Message | Съобщение за грешка при импорта | Съобщения генерирани от процеса на импорт | The Import Error Message displays any error messages generated during the import process. | I_ErrorMsg character varying(2000) String |
| Journal Batch | Главна счетоводна книга | Партида от дневник от главна сметкова книга | The General Ledger Journal Batch identifies a group of journals to be processed as a group. | GL_JournalBatch_ID numeric(10) Search |
| Client Key | Client Key | Key of the Client | null | ClientValue character varying(40) String |
| Client | Фирма | Фирма | Фирма | AD_Client_ID numeric(10) Table Direct |
| Document Org | Document Org | Document Organization (independent from account organization) | null | AD_OrgDoc_ID numeric(10) Table |
| Batch Document No | Batch Document No | Document Number of the Batch | null | BatchDocumentNo character varying(30) String |
| Create New Batch | Create New Batch | If selected a new batch is created | Note that the balance check does not check that individual batches are balanced. | IsCreateNewBatch character(1) Yes-No |
| Batch Description | Batch Description | Description of the Batch | null | BatchDescription character varying(255) String |
| Journal | Дневник | Дневник главна сметкова книга | The General Ledger Journal identifies a group of journal lines which represent a logical business transaction | GL_Journal_ID numeric(10) Search |
| Journal Document No | Journal Document No | Document number of the Journal | null | JournalDocumentNo character varying(30) String |
| Create New Journal | 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 character(1) Yes-No |
| Account Schema Name | име счетоводна схема | Името на счетоводната схема | null | AcctSchemaName character varying(60) String |
| Accounting Schema | Счетоводна схема | Правила по които се води счетоводството | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar | C_AcctSchema_ID numeric(10) Table Direct |
| 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 character(1) List |
| 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 numeric(10) Table Direct |
| Document Type Name | Document Type Name | Name of the Document Type | null | DocTypeName character varying(60) String |
| Document Type | Тип документ | Тип на документа | The Document Type determines document sequence and processing rules | C_DocType_ID numeric(10) Table Direct |
| Category Name | Category Name | Name of the Category | null | CategoryName character varying(60) String |
| GL Category | Категория на главна сметкова книга | Категория | The General Ledger Category is an optional, user defined method of grouping journal lines. | GL_Category_ID numeric(10) Table Direct |
| Account 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 timestamp without time zone Date |
| Period | Период | Период от календара | The Period indicates an exclusive range of dates for a calendar. | C_Period_ID numeric(10) Table Direct |
| Journal Line | Запис в книгата | Ред от дневник на главна сметкова книга | The General Ledger Journal Line identifies a single transaction in a journal. | GL_JournalLine_ID numeric(10) Search |
| Line No | Ред No | Номер на реда на документа | Indicates the unique line for a document. It will also control the display order of the lines within a document. | Line numeric(10) Integer |
| Description | Описание | Описание (не повече 255 символа) | A description is limited to 255 characters. | Description character varying(255) String |
| Source Debit | Дебит | Дебит (в текущата валута) | The Source Debit Amount indicates the credit amount for this line in the source currency. | AmtSourceDr numeric Amount |
| Source Credit | Кредит | Кредит (в текущата валута) | The Source Credit Amount indicates the credit amount for this line in the source currency. | AmtSourceCr numeric Amount |
| ISO Currency Code | Код ISO | Код на валутата по ISO 4217 (http://www.unece.org/trade/rec/rec09en.htm) | For details - http://www.unece.org/trade/rec/rec09en.htm | ISO_Code character(3) String |
| Currency | Валута | Валута | Indicates the Currency to be used when processing or reporting on this record | C_Currency_ID numeric(10) Table Direct |
| Currency Type Key | Currency Type Key | Key value for the Currency Conversion Rate Type | The date type key for the conversion of foreign currency transactions | ConversionTypeValue character varying(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 numeric(10) Table Direct |
| Rate | Курс | Currency Conversion Rate | The Currency Conversion Rate indicates the rate to use when converting the source currency to the accounting currency | CurrencyRate numeric Number |
| Accounted Debit | Дебит | Дебит | The Account Debit Amount indicates the transaction amount converted to this organization's accounting currency | AmtAcctDr numeric Amount |
| Accounted Credit | Кредит | Кредит | The Account Credit Amount indicates the transaction amount converted to this organization's accounting currency | AmtAcctCr numeric Amount |
| UOM | Мярка | Мерна единица | The UOM defines a unique non monetary Unit of Measure | C_UOM_ID numeric(10) Table Direct |
| Quantity | Количество | Количество | The Quantity indicates the number of a specific product or item for this document. | Qty numeric Quantity |
| Combination | Комбинация | Комбинация | The Combination identifies a valid combination of element which represent a GL account. | C_ValidCombination_ID numeric(10) Search |
| Org Key | Org Key | Key of the Organization | null | OrgValue character varying(40) String |
| Organization | Организация | Подразделение на клиента | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID numeric(10) Table Direct |
| Account Key | Ключ на сметка | Ключ за счетоводния елемент | null | AccountValue character varying(40) String |
| Account | Сметка | Исползвана Сметка | The (natural) account used | Account_ID numeric(10) Table |
| Business Partner Key | Business Partner Key | Key of the Business Partner | null | BPartnerValue character varying(40) String |
| Business Partner | Партньор | Партньор | Партньорът е всеки, с когото работите. Това може да означава Доставчик, Клиент, Служител или Търговски представител. | C_BPartner_ID numeric(10) Search |
| Product Key | Само за тази стойност | Генериране на листа само за този продукт (може да се исползва %) | null | ProductValue character varying(40) String |
| UPC/EAN | Баркод | Баркод (Универсален Продуктов Код или по-общото Европейски Артикулен Номер) | 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 character varying(30) String |
| SKU | Вътрешен код | Код за вътрешна употреба | Това поле показва дефиниран от потребителя код за съхранение и проследяване на материалите. Може да се използва за допълнителен бар код или собствено дефинирана система от кодове. | SKU character varying(30) String |
| Product | Продукт | Продукт | Identifies an item which is either purchased or sold in this organization. | M_Product_ID numeric(10) Search |
| Project Key | Ключ проект | Ключа на даден проект | null | ProjectValue character varying(40) String |
| Project | Проект | Финансов проект | A Project allows you to track and control internal or external activities. | C_Project_ID numeric(10) Search |
| 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 numeric(10) Table Direct |
| Activity | Дейност | Бизнес дейност | Activities indicate tasks that are performed and used to utilize Activity based Costing | C_Activity_ID numeric(10) Table Direct |
| Sales Region | Регион за продажби | Регион покриван при продажби | The Sales Region indicates a specific area of sales coverage. | C_SalesRegion_ID numeric(10) Table Direct |
| Trx Org Key | Trx Org Key | Key of the Transaction Organization | null | OrgTrxValue character varying(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 numeric(10) Table |
| Location From | От | Място от което е преместван инвентара | The Location From indicates the location that a product was moved from. | C_LocFrom_ID numeric(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 numeric(10) Table |
| User List 1 | Потребител1 | User defined list element #1 | The user defined element displays the optional elements that have been defined for this account combination. | User1_ID numeric(10) Table |
| User List 2 | Потребител2 | User defined list element #2 | The user defined element displays the optional elements that have been defined for this account combination. | User2_ID numeric(10) Table |
| Import Journal | 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 character(1) Button |
| Processed | Обработено | Документа е обработен | The Processed checkbox indicates that a document has been processed. | Processed character(1) Yes-No |
.png){kind=link}