Обучение: различия между версиями
Yarkin.m (обсуждение | вклад) |
Yarkin.m (обсуждение | вклад) м (→Компания) |
||
(не показаны 122 промежуточные версии этого же участника) | |||
Строка 1: | Строка 1: | ||
== Базовые знания (пользователей) == | == Базовые знания (пользователей) == | ||
− | + | {| class="wikitable" | |
+ | | colspan="2" | '''Общие понятия''' | ||
+ | |- | ||
+ | |00:00 - 00:30 || | ||
+ | * Введение. | ||
+ | * Доступ в систему (вход/выход). | ||
+ | * Изменение пароля доступа в систему JDE. | ||
+ | * Ознакомление с меню JDE, "Карусель", меню Избранное. | ||
+ | |- | ||
+ | | colspan="2" | '''Открытие и работа с интерактивными приложениями''' | ||
+ | |- | ||
+ | |00:30 - 02:00 || | ||
+ | Форма. Заголовок формы и сетка. | ||
+ | * Панель инструментов. | ||
+ | * Панель переходов. | ||
+ | * Поля заголовка и Визуальный помощник (лупа). | ||
+ | Поиск в сетке. | ||
+ | * Записи, прокрутка, максимизировать сетку. | ||
+ | * Поиск с помощью фильтров в форме. | ||
+ | * Поиск с помощью строки QBE (запрос по образцу). | ||
+ | * Использование специальных символов - *, <, >, !=. | ||
+ | * Персонализация сетки (Диспетчер форматов сетки). | ||
+ | * Экспорт данных. | ||
+ | Работа с прикреплениями (медиа-объектами). | ||
+ | * Поиск, Менеджер прикреплений, удаление медиа-объектов | ||
+ | |- | ||
+ | | colspan="2" | '''Работа с пакетными приложениями''' | ||
+ | |- | ||
+ | |02:00 - 02:30 || | ||
+ | * Запуск отчета (Выбор данных) | ||
+ | |} | ||
== Базовые знания (ФС) == | == Базовые знания (ФС) == | ||
− | + | {| class="wikitable" | |
− | + | | colspan="2" | '''Введение''' | |
− | + | |- | |
− | + | |00:00 - 00:30 || | |
− | + | * Знакомство | |
− | + | * Что такое ERP? Что такое ERP Oracle JDE E1? | |
− | + | * История..., использование, конкуренты…, назначение. | |
+ | * Сайты с документацией docs.oracle.com, jde.erpref.com. | ||
+ | * Пользователи / роли. | ||
+ | |- | ||
+ | | colspan="2" | '''Общие понятия и структура''' | ||
+ | |- | ||
+ | |00:30 - 04:00 || | ||
+ | * Oracle JDE Е1 - набор бизнес-приложений (Application) и ядро (Tools). Релизы. | ||
+ | * Доступ в JDE. Клиентs (толстый и тонкий). Среды (PS, DV, PY, PD) | ||
+ | * Интерфейс (Домашняя страница, Меню, Карусель) | ||
+ | * Виды приложений (интерактивные, пакетные, отчеты) | ||
+ | * "Модули" и "Контуры". Основы и АК, финансы, производство, логистика, польз., локализация, система и пр. | ||
+ | * Объекты: Приложения (формы, представления, функции), таблицы и элементы данных. | ||
+ | * Таблицы. Данные: транзакционные, справочные и системные. | ||
+ | * Приложения. Формы (заголовок, грид, работа с записями, справка приложения) | ||
+ | * Приложения. Версии (IV, BV; Procesing Options, Data Selection, Data Sequencing) | ||
+ | * Приложения. Сообщения и очереди. Печатные формы. | ||
+ | * ENVIRONMENT = PATH CODE + OCM MAPPINGS | ||
+ | |- | ||
+ | | colspan="2" | '''Базовые настройки системы''' | ||
+ | |- | ||
+ | |04:00 - 06:00 || | ||
+ | * P0000 - Настройка системы (System Setup) | ||
+ | * P0001 - Компания/структура БЕ / (Company/Business Unit Tree Structure) | ||
+ | * P0002 / P00022 / P00023A - Автонумерация (Next Number Revisions / Next Unique Key Number / Distributed Next Number Revisions) | ||
+ | * P0004A - User Defined Codes | ||
+ | * P0006 - Business Units | ||
+ | * P00071 - Производственный календарь (Workday Calendar) | ||
+ | * P0008 - Финансовый календарь (Fiscal Date Patterns) | ||
+ | * P0010 - Компании (Companies) | ||
+ | * P0011 - Пакеты фин. документов (Batches) | ||
+ | * P0012 - Финансовые АИ (Automatic Accounting Instructions) | ||
+ | * P0013 - Коды валют (Currency Codes) | ||
+ | * P0014 - Условия оплаты (Payment Terms) | ||
+ | * P0015A - Курсы валют (Currency Exchange Rates) | ||
+ | * P00166 - Прикрепления и медиа-объекты (Media Object) | ||
+ | * P0018 - Tax File Revisions | ||
+ | * P0022 - Правила налогообложения (Tax Rules) | ||
+ | * P0025 - Ledger Type Master Setup | ||
+ | * P0030A/B/G - Bank Accounts by Address / Business Unit Payment Information / G/L Bank Accounts | ||
+ | --- | ||
+ | * P0040 - Data Protection Configuration !!! | ||
+ | * P0050 - Organizational Structures Revisions !!! | ||
+ | * P00620 - Supplemental Data Profile by Business Unit | ||
+ | * P0070 - Country Constants | ||
+ | * P0092 - User Profile Revisions | ||
+ | * P0094 - Work With Environments | ||
+ | * P00950 - Security Workbench | ||
+ | --- | ||
+ | * P4008 Tax Rate/ Areas | ||
+ | |} | ||
+ | |||
+ | === Финансовый контур === | ||
+ | {| class="wikitable" | ||
+ | | colspan="2" | '''Главная книга и счета''' | ||
+ | |- | ||
+ | |00:00 - 02:00 || | ||
+ | Главная книга (ГК) | ||
+ | * Модуль ГК. Введение. | ||
+ | * БЕ. Справочник счетов. План счетов. | ||
+ | * Книги и их типы. | ||
+ | * Сальдо/балансы. | ||
+ | * Журнальные записи. | ||
+ | |- | ||
+ | | colspan="2" | '''РД и РК''' | ||
+ | |- | ||
+ | |02:00 - 06:00 || | ||
+ | Расчеты с дебиторами (РД) | ||
+ | * Модуль РД. Введение. | ||
+ | *: [[File:ar_business_proc90.gif|options|caption]] | ||
+ | * Настройка: Константы | UDC | NN | AAI | Налоги | Валюта | ||
+ | * Карточка покупателя (справочник) | Книга (журнал) покупателя | ||
+ | * Ввод инвойса: Стандартный | Быстрый | Разнесение в ГК | ||
+ | * Инвойса: Стандартный | Повторяющийся | ||
+ | * Ввод поступлений: Стандартный | Быстрый | ||
+ | * Поступления 1: Автоматические | Ручные | Драфты РД | ||
+ | * Поступления 2: Unapllied | Logged | GL | ||
+ | * Поступления 3: Скидки | Вычеты | Chargebacks | Списания. | ||
+ | * Взаимозачет РД/РК | Возмещение переплат через ваучер РК | ||
+ | * Возмещения | Уведомление и штрафы просроченных поступлений | ||
+ | * Отчетность: Отчеты РД | As Of | Целостность данных | ||
+ | |- | ||
+ | |02:00 - 06:00 || | ||
+ | Расчеты с кредиторами (РК) | ||
+ | * Модуль РК. Введение. | ||
+ | *: [[File:ap_business_proc90.gif|options|caption]] | ||
+ | * Настройка: Константы | UDC | NN | AAI | Налоги | Валюта | ||
+ | * Карточка поставщика (справочник) | Книга (журнал) поставщиков | ||
+ | * Ввод ваучера: Стандартный | Быстрый | Разнесение в ГК | ||
+ | * Ваучер 1: Стандартный; Повторяющийся; Logged; Предоплатный | ||
+ | * Ваучер 2: Ваучер для оплаты | Pay When Paid | ||
+ | * Оплаты: Автоматические | Ручные | Драфты РК | ||
+ | * Взаимозачет РД/РК | ||
+ | * EDI: Inbound EDI Vouchers | Outbound EDI Payments | ||
+ | * Positive pay | ||
+ | * Отчетность: Отчеты РК | As Of | Целостность данных | ||
+ | * | ||
+ | |} | ||
− | + | === Логистический контур === | |
− | + | {| class="wikitable" | |
− | / | + | | colspan="2" | '''Inventory/OP Base (40) и Inventory Management (41)''' |
+ | |- | ||
+ | |00:00 - 02:00 || | ||
+ | Базовые настройки логистика/дистрибуция | ||
+ | * P400391 Document Type Exclusion Rules | ||
+ | * P4004Z Recurring Orders | ||
+ | * P40040 Document Type Maintenance | ||
+ | * P4005[] Return Material Authorization | ||
+ | * P4007[] Preference Master / Customer Group Preferences / Item Group Preferences / Preference Hierarchy | ||
+ | ;* P4008 Tax Rate/ Areas | ||
+ | ;* P400951 Default Location & Printers | ||
+ | ;* P40096 Default Print Queues | ||
+ | * P40100 Unit of Measure Lookup | ||
+ | * P40116 Message List | ||
+ | * P40131 Order Processing Cross Reference | ||
+ | * P4015 Order Template Revisions | ||
+ | * P40162 Print Message | ||
+ | * P40163 Item Notes | ||
+ | * P4017 Select Price Based On Date | ||
+ | * P40201 Freight/Additional Cost Update | ||
+ | ;* P40204 Order Activity Rules | ||
+ | ;* P40205 Line Type Constants | ||
+ | * P4021 Supply and Demand Inquiry | ||
+ | * P40210 Freight/Additional Charges Summary/Revision | ||
+ | * P40215 Order Template Inquiry | ||
+ | * P40230A Commitment Inquiry | ||
+ | * P40241 UNSPSC Commodity Code Definition | ||
+ | * P40241D UNSPSC Code Alternate Description | ||
+ | * P40242 Secondary Commodity Code Definition | ||
+ | * P40243 Commodity Relationships | ||
+ | ;* P40296 Flexible Sales Accounting | ||
+ | * P403[] Preference Profiles Inquiry by Customer/Item | ||
+ | * P40500 Set up Commodity Code | ||
+ | * P40510 Setup UNSPSC Code and Commodity Code Relationship | ||
+ | * P40520 Supplier branch commodity code setup | ||
+ | * P40521 Search Supplier Branch Plant | ||
+ | * P40551 G/L Account and Commodity Code Setup | ||
+ | * P407[] Price Adjustment Schedule / Price Adjustment Type / Price Adjustment Detail Revisions / Rebate & etc. | ||
+ | * P4080 Price Adjustments Inquiry | ||
+ | * P4081 Price Adjustment Audit Trial Inquiry | ||
+ | * P4091 Summary Constants | ||
+ | * P4092 Group Code Definition | ||
+ | ;* P40950 Distribution AAIs | ||
+ | |- | ||
+ | |00:00 - 02:00 || | ||
+ | Системные константы, склады и справочник номенклатур | ||
+ | * Константы складов | Константы складов | МХ | ||
+ | * Мастер-справочник н/н | Cправочник н/н по складам | Коды категорий н/н | ||
+ | * Item Features + Item Notes | ||
+ | * Преобразование ЕИ н/н | Стандартные ЕИ | ||
+ | * Кросс-ссылки н/н | ||
+ | * Себестоимость н/н | Базовая цена продаж и закупок | ||
+ | * Location Cross Reference | ||
+ | Мгновенные операции: | ||
+ | * Cardex: Issues | Тransfers | Adjustments | Reclassifications | ||
+ | * Physical inventories: Tag | Cycle | ||
+ | Партия | ||
+ | * Lot Master (P4108) + RU | Lot Status Codes | Lot Dates | ||
+ | * Lot Master Availability (P41280) | Trace/Track Inquiry (P41203) | ||
+ | Managing Containers | ||
+ | |- | ||
+ | | colspan="2" | '''РД и РК''' | ||
+ | |} | ||
== Базовые знания (Программисты и Администраторы) == | == Базовые знания (Программисты и Администраторы) == | ||
Строка 24: | Строка 213: | ||
текст | текст | ||
+ | |||
+ | |||
+ | == Реализация в у.е. == | ||
+ | |||
+ | : Компания | ||
+ | : Клиент | ||
+ | : Прайс/Заказ | ||
+ | : Инвойс | ||
+ | : Поступление | ||
+ | |||
+ | === Constants (P0000) - GA === | ||
+ | ;Multicurrency Conversion Constant (Y, N, Z) | ||
+ | A code that specifies whether to use multi-currency accounting. Valid values are: | ||
+ | |||
+ | *'N' Do not use multi-currency accounting. | ||
+ | **Use if you enter transactions in only one currency for all companies. | ||
+ | **The multi-currency fields will not appear on forms. | ||
+ | **The system supplies a default value of 'N' if you do not enter a value. | ||
+ | *To activate EnterpriseOne Multicurrency Processing, you must set the constant in the Multicurrency Conversion field as follows depending on the default conversion method that you want to use: | ||
+ | *'Y' Multiplier method | ||
+ | **Use the multiplier rate to convert amounts from one currency to another. | ||
+ | **The system multiplies the foreign amount by the exchange rate to calculate the domestic amount. | ||
+ | *'Z' Divisor method | ||
+ | **Use the divisor rate to convert amounts from one currency to another. | ||
+ | **The system divides the foreign amount by the exchange rate to calculate the domestic amount. | ||
+ | When the multicurrency conversion constant is activated, the system displays currency fields on various entry and inquiry forms.You can override the default conversion method when you set up specific currency relationships. | ||
+ | |||
+ | NOTE: After you begin using EnterpriseOne Multicurrency Processing, do not change the multicurrency conversion constant or you will get unpredictable results | ||
+ | |||
+ | === Компания=== | ||
+ | ; Setting Up Companies | ||
+ | You use the Work with Companies program P0010 to set up your companies for multicurrency for following: | ||
+ | * Assign the base currency for each company. | ||
+ | * Decide whether to use currency restatement and, if so, which method. | ||
+ | * Decide whether to maintain account balances by currency. | ||
+ | The system stores company currency information in the Company Constants table (F0010). | ||
+ | |||
+ | You must set up the following multicurrency information for each company in your organization under the Currency tab: | ||
+ | |||
+ | ; Domestic Currency | ||
+ | * Assign a domestic currency code to specify the base currency of a company. | ||
+ | * The system maintains amounts in the AA ledger in the domestic currency, using the correct decimal positions as specified for the currency code. | ||
+ | * After you assign a currency code to a company and enter transactions, do not change the currency code. Changing the currency code affects the integrity of the data. | ||
+ | |||
+ | ; Restatement Computation (?Balance Currency Restatement Computation - Приведение балансов валютных счетов на конец периода) | ||
+ | * Identify the computation method to use for balance currency restatement. | ||
+ | * You can assign the same ID to multiple companies. | ||
+ | * To override the computation ID assigned to a company, you can specify a different ID in processing option for the Balance Restatement program (R11414A). | ||
+ | * For more information on how to process Balance Restatement (R11414A), refer to Document 664911.1. | ||
+ | |||
+ | ; Detailed Currency Restatement (Ведение учета счетов еще в нескольких более стабильных альтернативных валютах) | ||
+ | : Enter a value that identifies whether a company allows detailed currency restatement processing: | ||
+ | ::; Blank | ||
+ | :::* Do not allow detailed currency restatement processing. | ||
+ | ::; 1 | ||
+ | :::* Allow detailed currency restatement processing. | ||
+ | :::* The system automatically determines whether to use the Y (multiplier) or Z (divisor) method. | ||
+ | :::* The method is the opposite of the multicurrency conversion method set up in General Accounting Constants. | ||
+ | ::; Y | ||
+ | :::* Allow detailed currency restatement processing. | ||
+ | :::* Enter 'Y' (multiplier) if the multicurrency conversion method in General Accounting Constants is 'Z' (divisor). | ||
+ | ::; Z | ||
+ | :::* Allow detailed currency restatement processing. | ||
+ | :::* Enter 'Z' (divisor) if the multicurrency conversion method in General Accounting Constants is 'Y' (multiplier). | ||
+ | |||
+ | Note: Values '1', 'Y', and 'Z' all allow detailed currency restatement processing. The primary difference is that by choosing 1, you let the system determine the conversion method value and by choosing Y or Z, you specify the method explicitly. For more information on how to process Detailed Currency Restatement (R11411), refer to Document 664750.1. | ||
+ | |||
+ | ; Post Account Balances by Currency | ||
+ | * Check this option to post records to Foreign Currency ledger (CA) by currency in the Account Balances table (F0902). | ||
+ | * The system uses the account ranges specified in AAI item PBCxx to post account balances by currency. | ||
+ | ** The Confirmation - AAI Setup form appears if you have not set up the required account ranges for AAI item PBCxx for the company or for default company 00000. If this form appears, click Yes to display the Set Up Multiple AAI Items form and add the ranges for PBCxx. Then click OK to return to the Company Setup form. | ||
+ | ** If you click No and do not set up the required AAI item ranges, be aware that the general ledger post program posts journal entries for the company as summarized balances with mixed currencies instead of detailed balances by currency. * The post program sends a warning to the work center that the balances were not posted by currency because AAI item PBC was not found. | ||
+ | * If you do not select this option, the system summarizes all currency amounts in one total amount. | ||
+ | * For more information, see Document 664783.1 Overview of Post Balance by Currency. | ||
+ | |||
+ | === Клиент (P03013) === | ||
+ | Currency Code - This field only displays if you have selected to use multicurrency in the G/L Constants (P0000) - See Document 1434211.1 E1: 09: Overview of General Accounting Constants (P0000) for more information. Enter the code that identifies the default currency that the system assigns to invoices that you enter for the customer. '''You can override this value when you enter the invoice, or you can leave this field blank and assign the currency code for each transaction.''' | ||
+ | : E1: 03B: How To Set Up A Customer Master In EnterpriseOne Accounts Receivable (P03013) (Doc ID 1478003.1) | ||
+ | |||
+ | === Multi-Currency and Sales === | ||
+ | The Sales module provides multi-currency functionality. It allows for the requirements of international orders, enabling users to create international sales orders, print sales documents in different currencies, and create Account Ledger (F0911) records with the foreign and domestic journal entries. Once a sales order is entered into the system, there are a few currency-related fields in the Sales Order Header (F4201) and Sales Order Detail (F4211) that will enable the multi-currency functionality throughout the sales cycle. The information will be recorded in the currency of the company and in the currency of the transaction. All programs that are based on these files, in conjunction with the Item Cost (F4105), will use these fields to pull domestic information, foreign information, or both. | ||
+ | |||
+ | ;Sales Order Entry | ||
+ | Once multi-currency is activated, Sales Order Entry (P4210) will show new fields in both the Header and Detail screens. | ||
+ | |||
+ | * Mode: (CRRM) is the transaction entry mode. It can be domestic or foreign. Based on the value of this field, the amounts shown in the detail screen will be in the currency of the company (domestic) or in the currency of the customer (if it is foreign). The system will determine the mode of entry, checking in the Customer Master to see the currency of the "Sold to". Then it will compare it to the base currency of the company. If the customer has a different currency than the one of the company, the system will assume it is a foreign transaction. If the customer has no currency associated, the system will assume that it is a domestic transaction. | ||
+ | |||
+ | *Base Co: (CRCD) will show the base currency of the company that the branch belongs to. This value is defined in the Company Numbers and Names (P0010) program. This field gets protected and cannot be changed. | ||
+ | |||
+ | *Currency Code: (CRDC) The currency code of the customer defaulted from the Customer Master. If inquiring on the foreign side of the transaction, this is the currency of the amounts on the Sales Order. | ||
+ | |||
+ | *Exchange Rate: (CRR) The current exchange rate defaults from the Set Daily Transaction Rates (P0015/P0015A) program. The user can manually override the exchange rate. | ||
+ | |||
+ | ;Example | ||
+ | The customer has in the Customer Master the COP (Columbian Peso) currency, and our branch belongs to a USD company, therefore the transaction is foreign and the current exchange rate is applied. | ||
+ | |||
+ | The prices are shown in the currency of the transaction. If there is no price for that particular currency, the system will convert the one on the base currency using the exchange rate. If we have a price set in a third currency, not related to the ones involved in the transaction (base company or transaction), no price information will show. | ||
+ | |||
+ | From the sales order, we can see the Online Invoice with domestic or foreign amounts. Also, the Customer Service Inquiry has a currency field to display information. | ||
+ | |||
+ | When multiple orders are displayed in the grid, the summation line will be suppressed if multiple currencies are being displayed. | ||
+ | |||
+ | Once the transaction is created, the fields Currency Code (CRDC) and Exchange Rate (CRR) are protected and cannot be changed. | ||
+ | |||
+ | * Processing Options 1 through 3 on the Currency Tab of Sales Order Entry (P4210) may be used with multi-currency transactions. | ||
+ | ** Tolerance Limit - Use this processing option to enter a tolerance limit for multi-currency orders. If you enter an option in Set Daily Transaction Rates (P00151) to allow spot rates, you can manually enter or override an exchange rate during order entry. If the currency rate that you enter is outside this tolerance limit, the system issues a warning. | ||
+ | ** Currency Code for as-if Currency Display - Use this processing option to indicate the currency code in which the system displays transactions. | ||
+ | ** As Of Date - Use this processing option to indicate the date with which the system retrieves the exchange rate for the As-If currency. If you leave this option blank, the system uses the system date. | ||
+ | |||
+ | ;Sales Order Process | ||
+ | Most programs in the sales cycle can process multi-currency. | ||
+ | * The Print Pick Slip program (R42520) can print amounts in domestic, foreign or both. | ||
+ | * Confirm Shipment program (P4205) has a Currency Mode field on the screen and the additional lines entered will be considered in the transaction currency. | ||
+ | * Print Invoices program (R42565) will also allow printing in domestic or foreign amounts, based on a processing option. | ||
+ | * Update Exchange Rates (R42950). In the event the exchange rates fluctuate considerably or they just need to be updated for the orders that are active in the sales cycle, the Update Sales Price/Cost (R42950) can be run to update domestic values based on the most current exchange rate defined in the system. There are two processing options that are used for Currency Exchange Rate Update (R42950). | ||
+ | ** Process Tab Option #2 (Exchange Rate) is used with regular Sales Orders if you set the value to 1 the system will update the exchange rate and recalculate the Domestic Price and Foreign Cost values in the sale order line. | ||
+ | ** Process Tab Option #3 (Update Intercompany Exchange Rate) is used with SK/OK intercompany Sales Orders. The Currency Exchange Rate Update (R42950) does not have the ability to update a related purchase order (OK). When this processing option is set to 1, the exchange rate on the order will be updated, but not order values will be recalculated based upon the exchange rate. This is to ensure the SK price and OK unit cost are equal and the general ledger inventory account gets netted out. For more information, please refer to Doc ID 625619.1 Update Sales Price/Cost (R42950). | ||
+ | * Sales Update (R42800) - There is no AAIs or processing options for multi-currency in sales update. The important thing to keep in mind is that we cannot summarize the COGS accounts with multi-currency. Once Sales Update is run, the system records for the domestic and the foreign side of the transactions in the files F0911 and F0B311. The foreign side of the transactions will be recorded in the CA ledger and the domestic side in the AA ledger. The Sales Journal (R42810) program, can print in domestic, foreign or both, based on a processing option. Once Sales Update (R42800) is run, the system records the field currency mode CRRM in the file F03B11 with the value '3' to indicate to the Financials system that the transaction is foreign and originated in the distribution side. |
Текущая версия на 18:02, 5 февраля 2025
Содержание
Базовые знания (пользователей)
Общие понятия | |
00:00 - 00:30 |
|
Открытие и работа с интерактивными приложениями | |
00:30 - 02:00 |
Форма. Заголовок формы и сетка.
Поиск в сетке.
Работа с прикреплениями (медиа-объектами).
|
Работа с пакетными приложениями | |
02:00 - 02:30 |
|
Базовые знания (ФС)
Введение | |
00:00 - 00:30 |
|
Общие понятия и структура | |
00:30 - 04:00 |
|
Базовые настройки системы | |
04:00 - 06:00 |
---
---
|
Финансовый контур
Главная книга и счета | |
00:00 - 02:00 |
Главная книга (ГК)
|
РД и РК | |
02:00 - 06:00 |
Расчеты с дебиторами (РД)
|
02:00 - 06:00 |
Расчеты с кредиторами (РК)
|
Логистический контур
Inventory/OP Base (40) и Inventory Management (41) | |
00:00 - 02:00 |
Базовые настройки логистика/дистрибуция
|
00:00 - 02:00 |
Системные константы, склады и справочник номенклатур
Мгновенные операции:
Партия
Managing Containers |
РД и РК |
Базовые знания (Программисты и Администраторы)
текст
Расширенные знания (ФС)
текст
Реализация в у.е.
- Компания
- Клиент
- Прайс/Заказ
- Инвойс
- Поступление
Constants (P0000) - GA
- Multicurrency Conversion Constant (Y, N, Z)
A code that specifies whether to use multi-currency accounting. Valid values are:
- 'N' Do not use multi-currency accounting.
- Use if you enter transactions in only one currency for all companies.
- The multi-currency fields will not appear on forms.
- The system supplies a default value of 'N' if you do not enter a value.
- To activate EnterpriseOne Multicurrency Processing, you must set the constant in the Multicurrency Conversion field as follows depending on the default conversion method that you want to use:
- 'Y' Multiplier method
- Use the multiplier rate to convert amounts from one currency to another.
- The system multiplies the foreign amount by the exchange rate to calculate the domestic amount.
- 'Z' Divisor method
- Use the divisor rate to convert amounts from one currency to another.
- The system divides the foreign amount by the exchange rate to calculate the domestic amount.
When the multicurrency conversion constant is activated, the system displays currency fields on various entry and inquiry forms.You can override the default conversion method when you set up specific currency relationships.
NOTE: After you begin using EnterpriseOne Multicurrency Processing, do not change the multicurrency conversion constant or you will get unpredictable results
Компания
- Setting Up Companies
You use the Work with Companies program P0010 to set up your companies for multicurrency for following:
- Assign the base currency for each company.
- Decide whether to use currency restatement and, if so, which method.
- Decide whether to maintain account balances by currency.
The system stores company currency information in the Company Constants table (F0010).
You must set up the following multicurrency information for each company in your organization under the Currency tab:
- Domestic Currency
- Assign a domestic currency code to specify the base currency of a company.
- The system maintains amounts in the AA ledger in the domestic currency, using the correct decimal positions as specified for the currency code.
- After you assign a currency code to a company and enter transactions, do not change the currency code. Changing the currency code affects the integrity of the data.
- Restatement Computation (?Balance Currency Restatement Computation - Приведение балансов валютных счетов на конец периода)
- Identify the computation method to use for balance currency restatement.
- You can assign the same ID to multiple companies.
- To override the computation ID assigned to a company, you can specify a different ID in processing option for the Balance Restatement program (R11414A).
- For more information on how to process Balance Restatement (R11414A), refer to Document 664911.1.
- Detailed Currency Restatement (Ведение учета счетов еще в нескольких более стабильных альтернативных валютах)
- Enter a value that identifies whether a company allows detailed currency restatement processing:
- Blank
-
- Do not allow detailed currency restatement processing.
- 1
-
- Allow detailed currency restatement processing.
- The system automatically determines whether to use the Y (multiplier) or Z (divisor) method.
- The method is the opposite of the multicurrency conversion method set up in General Accounting Constants.
- Y
-
- Allow detailed currency restatement processing.
- Enter 'Y' (multiplier) if the multicurrency conversion method in General Accounting Constants is 'Z' (divisor).
- Z
-
- Allow detailed currency restatement processing.
- Enter 'Z' (divisor) if the multicurrency conversion method in General Accounting Constants is 'Y' (multiplier).
Note: Values '1', 'Y', and 'Z' all allow detailed currency restatement processing. The primary difference is that by choosing 1, you let the system determine the conversion method value and by choosing Y or Z, you specify the method explicitly. For more information on how to process Detailed Currency Restatement (R11411), refer to Document 664750.1.
- Post Account Balances by Currency
- Check this option to post records to Foreign Currency ledger (CA) by currency in the Account Balances table (F0902).
- The system uses the account ranges specified in AAI item PBCxx to post account balances by currency.
- The Confirmation - AAI Setup form appears if you have not set up the required account ranges for AAI item PBCxx for the company or for default company 00000. If this form appears, click Yes to display the Set Up Multiple AAI Items form and add the ranges for PBCxx. Then click OK to return to the Company Setup form.
- If you click No and do not set up the required AAI item ranges, be aware that the general ledger post program posts journal entries for the company as summarized balances with mixed currencies instead of detailed balances by currency. * The post program sends a warning to the work center that the balances were not posted by currency because AAI item PBC was not found.
- If you do not select this option, the system summarizes all currency amounts in one total amount.
- For more information, see Document 664783.1 Overview of Post Balance by Currency.
Клиент (P03013)
Currency Code - This field only displays if you have selected to use multicurrency in the G/L Constants (P0000) - See Document 1434211.1 E1: 09: Overview of General Accounting Constants (P0000) for more information. Enter the code that identifies the default currency that the system assigns to invoices that you enter for the customer. You can override this value when you enter the invoice, or you can leave this field blank and assign the currency code for each transaction.
- E1: 03B: How To Set Up A Customer Master In EnterpriseOne Accounts Receivable (P03013) (Doc ID 1478003.1)
Multi-Currency and Sales
The Sales module provides multi-currency functionality. It allows for the requirements of international orders, enabling users to create international sales orders, print sales documents in different currencies, and create Account Ledger (F0911) records with the foreign and domestic journal entries. Once a sales order is entered into the system, there are a few currency-related fields in the Sales Order Header (F4201) and Sales Order Detail (F4211) that will enable the multi-currency functionality throughout the sales cycle. The information will be recorded in the currency of the company and in the currency of the transaction. All programs that are based on these files, in conjunction with the Item Cost (F4105), will use these fields to pull domestic information, foreign information, or both.
- Sales Order Entry
Once multi-currency is activated, Sales Order Entry (P4210) will show new fields in both the Header and Detail screens.
- Mode: (CRRM) is the transaction entry mode. It can be domestic or foreign. Based on the value of this field, the amounts shown in the detail screen will be in the currency of the company (domestic) or in the currency of the customer (if it is foreign). The system will determine the mode of entry, checking in the Customer Master to see the currency of the "Sold to". Then it will compare it to the base currency of the company. If the customer has a different currency than the one of the company, the system will assume it is a foreign transaction. If the customer has no currency associated, the system will assume that it is a domestic transaction.
- Base Co: (CRCD) will show the base currency of the company that the branch belongs to. This value is defined in the Company Numbers and Names (P0010) program. This field gets protected and cannot be changed.
- Currency Code: (CRDC) The currency code of the customer defaulted from the Customer Master. If inquiring on the foreign side of the transaction, this is the currency of the amounts on the Sales Order.
- Exchange Rate: (CRR) The current exchange rate defaults from the Set Daily Transaction Rates (P0015/P0015A) program. The user can manually override the exchange rate.
- Example
The customer has in the Customer Master the COP (Columbian Peso) currency, and our branch belongs to a USD company, therefore the transaction is foreign and the current exchange rate is applied.
The prices are shown in the currency of the transaction. If there is no price for that particular currency, the system will convert the one on the base currency using the exchange rate. If we have a price set in a third currency, not related to the ones involved in the transaction (base company or transaction), no price information will show.
From the sales order, we can see the Online Invoice with domestic or foreign amounts. Also, the Customer Service Inquiry has a currency field to display information.
When multiple orders are displayed in the grid, the summation line will be suppressed if multiple currencies are being displayed.
Once the transaction is created, the fields Currency Code (CRDC) and Exchange Rate (CRR) are protected and cannot be changed.
- Processing Options 1 through 3 on the Currency Tab of Sales Order Entry (P4210) may be used with multi-currency transactions.
- Tolerance Limit - Use this processing option to enter a tolerance limit for multi-currency orders. If you enter an option in Set Daily Transaction Rates (P00151) to allow spot rates, you can manually enter or override an exchange rate during order entry. If the currency rate that you enter is outside this tolerance limit, the system issues a warning.
- Currency Code for as-if Currency Display - Use this processing option to indicate the currency code in which the system displays transactions.
- As Of Date - Use this processing option to indicate the date with which the system retrieves the exchange rate for the As-If currency. If you leave this option blank, the system uses the system date.
- Sales Order Process
Most programs in the sales cycle can process multi-currency.
- The Print Pick Slip program (R42520) can print amounts in domestic, foreign or both.
- Confirm Shipment program (P4205) has a Currency Mode field on the screen and the additional lines entered will be considered in the transaction currency.
- Print Invoices program (R42565) will also allow printing in domestic or foreign amounts, based on a processing option.
- Update Exchange Rates (R42950). In the event the exchange rates fluctuate considerably or they just need to be updated for the orders that are active in the sales cycle, the Update Sales Price/Cost (R42950) can be run to update domestic values based on the most current exchange rate defined in the system. There are two processing options that are used for Currency Exchange Rate Update (R42950).
- Process Tab Option #2 (Exchange Rate) is used with regular Sales Orders if you set the value to 1 the system will update the exchange rate and recalculate the Domestic Price and Foreign Cost values in the sale order line.
- Process Tab Option #3 (Update Intercompany Exchange Rate) is used with SK/OK intercompany Sales Orders. The Currency Exchange Rate Update (R42950) does not have the ability to update a related purchase order (OK). When this processing option is set to 1, the exchange rate on the order will be updated, but not order values will be recalculated based upon the exchange rate. This is to ensure the SK price and OK unit cost are equal and the general ledger inventory account gets netted out. For more information, please refer to Doc ID 625619.1 Update Sales Price/Cost (R42950).
- Sales Update (R42800) - There is no AAIs or processing options for multi-currency in sales update. The important thing to keep in mind is that we cannot summarize the COGS accounts with multi-currency. Once Sales Update is run, the system records for the domestic and the foreign side of the transactions in the files F0911 and F0B311. The foreign side of the transactions will be recorded in the CA ledger and the domestic side in the AA ledger. The Sales Journal (R42810) program, can print in domestic, foreign or both, based on a processing option. Once Sales Update (R42800) is run, the system records the field currency mode CRRM in the file F03B11 with the value '3' to indicate to the Financials system that the transaction is foreign and originated in the distribution side.