АИ: различия между версиями

Материал из JD Edwards E1
Перейти к навигации Перейти к поиску
(не показано 28 промежуточных версий 4 участников)
Строка 47: Строка 47:
 
! colspan = "4" | Default AAIs
 
! colspan = "4" | Default AAIs
 
|-  
 
|-  
| RC || Default Trade Account || O || PCxxx, PCyyyy, PC
+
| RC || Default Trade Account || O || RCxxx, RCyyyy, RC
 
|-  
 
|-  
| RB || Default Bank Account || R || PBxxx, ?PByyyy, PB
+
| RB || Default Bank Account || R || RBxxx, ?RByyyy, RB
 
|-  
 
|-  
 
| RKD || Discount Taken || O ||
 
| RKD || Discount Taken || O ||
Строка 85: Строка 85:
 
| ICCC/ICH || Intercompany Settlements || ||  
 
| ICCC/ICH || Intercompany Settlements || ||  
 
|-  
 
|-  
! colspan = "4" | Multi-currency (including Alternate Currency Receipts) AAIs (Only required in Multi-currency environments)  
+
! colspan = "4" | Multi-currency* AAIs (Only required in Multi-currency environments)  
 
|-  
 
|-  
| RG/RL || Multi-currency Gain/Loss  || ||  
+
| RG/RL || Multi-currency Gain/Loss  || O ||  
 
|-  
 
|-  
| RV/RW || Multi currency Unrealized Gain/Loss || ||  
+
| RV/RW || Multi currency Unrealized Gain/Loss || R ||  
 
|-  
 
|-  
| RRyyy || Unrealized Gain/Loss Offset Account || ||  
+
| RRyyy || Unrealized Gain/Loss Offset Account || R ||  
 
|-  
 
|-  
| RY/RZ || Alternate Currency Receipt Gain/Loss || ||  
+
| RY/RZ || Alternate Currency Receipt Gain/Loss || R ||  
 
|-  
 
|-  
| R8 || A/R Rounding Account || ||  
+
| R8 || A/R Rounding Account || R ||  
 
|-  
 
|-  
| R7 || Alternate Currency Receipt Clearing Acct || ||  
+
| R7 || Alternate Currency Receipt Clearing Acct || R ||  
 
|}
 
|}
 +
 +
<nowiki>*</nowiki> включая Alternate Currency Receipts
 +
 +
=== AAI для Accounts Payable/Расчеты с кредиторами ===
 +
 +
{| class="wikitable"
 +
! AAI || Описание || БЕ || Иерархия
 +
|-
 +
! colspan = "4" | Default AAIs
 +
|-
 +
| PC || Offset или Trade Account || O || PCxxx, PCyyyy, PC
 +
|-
 +
| PB || Default Bank Account || R || PBxxx, PByyyy*, PB
 +
|-
 +
| PKD || Discount Taken || O || PKD
 +
|-
 +
| PKL || Discount Lost || O || PKL
 +
|-
 +
| PKJ/PKJL || Job Cost ||  ||
 +
|-
 +
! colspan = "4" | Miscellaneous AAIs
 +
|-
 +
| PT || Tax Account || R || [EXR1 = U, V]: PT </br> [EXR1 = B]: PTyyyy, PT
 +
|-
 +
| PP/PQ || Voucher Logging ||  || PPxxx, PPyyyy, PP; PQyyyy, PQ
 +
|-
 +
| PD || Draft Payable Account  ||  ||
 +
|-
 +
| NC || Netting document  ||  ||
 +
|-
 +
! colspan = "4" | Multi Currency AAIs
 +
|-
 +
| PG/PL || Multi Currency Realized Gain/Loss || R || PGxxx, PGyyyy**, PG (PL также)
 +
|-
 +
| PV/PW || Multi Currency Unrealized Gain/Loss || R || PVxxx, PVyyyy, PV (PW также)
 +
|-
 +
| PR || Multi Currency Unrealized Gain/Loss Offset account || R || PRxxx, PRyyyy, PR
 +
|-
 +
| PY/PZ || Alternate Currency  || R || PYxxx, PYyyyy, PY (PZ также)
 +
|-
 +
| P7 || Alternate Clearing account || R || P7
 +
|}
 +
 +
<nowiki>*</nowiki> где yyyy указывает на счет банка при вводе ваучера.
 +
 +
<nowiki>**</nowiki> где yyyy код корр.счета ГК из ваучера, который оплачен.
 +
 +
; PB
 +
*Based on the company number entered during Standard Voucher Entry (P0411).
 +
*Can be configured for a specific company or for the Default Company (00000).
 +
*Business Unit is required.
 +
*Designed to automatically fill in the G/L Bank Account (ANI) field during Standard Voucher Entry (P0411).
 +
*If the PB AAI does not exist, the system produces an error
 +
*If a G/L Offset is used for the Trade Account AAI (PCyyyy), a matching PB AAI must exist or the system produces an error.
 +
*The system uses the following hierarchy to validate the PB Automatic Accounting Instructions (AAIs). If the first item does not exist, the system looks for the next AAI:
 +
*#    PBxxx - where xxx is the currency code.
 +
*#    PByyyy - where yyyy is the GL Offset.
 +
*#    PB for the company assigned to the transaction.
 +
*#    PB for Company 00000.
 +
 +
If multiple bank accounts for a company exist, define an offset PByyyyy.  Note that if PByyyy is set up, PCyyyy must also exist.
  
 
== Ссылки ==
 
== Ссылки ==
Строка 107: Строка 168:
 
* [https://support.oracle.com/epmos/faces/DocumentDisplay?id=664682.1 E1: 09: Overview of Automatic Accounting Instructions (AAI) in General Accounting (P0012) (Doc ID 664682.1)]  
 
* [https://support.oracle.com/epmos/faces/DocumentDisplay?id=664682.1 E1: 09: Overview of Automatic Accounting Instructions (AAI) in General Accounting (P0012) (Doc ID 664682.1)]  
 
* [https://support.oracle.com/epmos/faces/DocumentDisplay?id=1409284.1 E1: 04: Overview and Set Up of Accounts Payable (P0004A, P0000, P0002, X00500, P0012, P00022) (Doc ID 1409284.1)]
 
* [https://support.oracle.com/epmos/faces/DocumentDisplay?id=1409284.1 E1: 04: Overview and Set Up of Accounts Payable (P0004A, P0000, P0002, X00500, P0012, P00022) (Doc ID 1409284.1)]
* E1: 04: How To Set Up Automatic Accounting Instructions (AAIs) Within EnterpriseOne Accounts Payable (P0012) (Doc ID 1991354.1)
+
* [https://support.oracle.com/epmos/faces/DocumentDisplay?id=1991354.1 E1: 04: How To Set Up Automatic Accounting Instructions (AAIs) Within EnterpriseOne Accounts Payable (P0012)]
 
* [https://support.oracle.com/epmos/faces/DocumentDisplay?id=1476249.1 E1: 03B: Overview and Set Up of Accounts Receivable (P0000, P0011, P0002, P0004A, P0012) (Doc ID 1476249.1)]
 
* [https://support.oracle.com/epmos/faces/DocumentDisplay?id=1476249.1 E1: 03B: Overview and Set Up of Accounts Receivable (P0000, P0011, P0002, P0004A, P0012) (Doc ID 1476249.1)]

Версия 15:43, 25 ноября 2021

Меню:

  • Финансовые АИ - AAI - P0012/F0012
    • АИ ГК
    • АИ РД
    • АИ РК
    • АИ Локализации - RUS
  • Логистические АИ - DMAAI - P40950/F4095
    • АИ Склад
    • АИ Продажи
    • АИ Закупки
    • АИ Локализации - RUS


DMAAI

Создать АИ можно для любой уникальной комбинации:

  • Компания (Company Number);
  • Тип документа (Document Type);
  • Код класса ГК (G/L Class code).

Если указанная комбинация не найдена, система использует по умолчанию компанию 00000 и код класса ГК ****. Тип документа должен соответствовать.

Например, Компания 00001, код класса ГК IN20:

  1. Поиск для комбинации Компания 00001, код класса ГК IN20.
  2. Если не найдено, тогда поиск для Компания 00001, код класса ГК ****.
  3. Если не найдено, тогда поиск для Компания 00000, код класса ГК IN20.
  4. Eсли не найдено, тогда поиск для Компания 00000, код класса ГК ****.
  5. Eсли не найдено, система выдает ошибку.

FAAI

Многие финансовые АИ используют следующую (стандартную) иерархию отбора счета.

Например, при вводе инвойса (Ко: 00005, кор.счет ГК: CUST, валюта: RUB) систем для префикса RC выполнит следующую последовательность:

  1. Поиск для RCRUB (RCxxx) по 00005.
  2. Если не найдено, то поиск для RCRUB (RCxxx) по 00000.
  3. Если не найдено, то поиск для RCCUST (RCyyyy) по 00005.
  4. Если не найдено, то поиск для RCCUST (RCyyyy) по 00000.
  5. Если не найдено, то поиск для RC (RC) по 00005.
  6. Если не найдено, то поиск для RC (RC) по 00000.
  7. Eсли не найдено, система выдает ошибку.

AAI для Accounts Receivable/Расчеты с дебиторами

AAI Описание БЕ Иерархия
Default AAIs
RC Default Trade Account O RCxxx, RCyyyy, RC
RB Default Bank Account R RBxxx, ?RByyyy, RB
RKD Discount Taken O
RT A/R Taxes ?
Receipts Specific AAIs
RCUC Unapplied Cash Receipt O Hard Coded
RCLC Logged Receipts R Hard Coded
RAzz Write-off Reason Code O
Delinquency Fee, Deductions, Drafts, and Netting Specific AAIs
RFC/RFD Delinquency Fees O
RN Deductions O
RD1 Draft Receivables R
RD2 Drafts remitted R
RD3 Drafts remitted for discount R
RD4 Contingent Liability R
RD5 Draft void/NSF (non-sufficient funds) R
NC Netting R
Intercompany Settlements AAIs
ICCC/ICH Intercompany Settlements
Multi-currency* AAIs (Only required in Multi-currency environments)
RG/RL Multi-currency Gain/Loss O
RV/RW Multi currency Unrealized Gain/Loss R
RRyyy Unrealized Gain/Loss Offset Account R
RY/RZ Alternate Currency Receipt Gain/Loss R
R8 A/R Rounding Account R
R7 Alternate Currency Receipt Clearing Acct R

* включая Alternate Currency Receipts

AAI для Accounts Payable/Расчеты с кредиторами

AAI Описание БЕ Иерархия
Default AAIs
PC Offset или Trade Account O PCxxx, PCyyyy, PC
PB Default Bank Account R PBxxx, PByyyy*, PB
PKD Discount Taken O PKD
PKL Discount Lost O PKL
PKJ/PKJL Job Cost
Miscellaneous AAIs
PT Tax Account R [EXR1 = U, V]: PT
[EXR1 = B]: PTyyyy, PT
PP/PQ Voucher Logging PPxxx, PPyyyy, PP; PQyyyy, PQ
PD Draft Payable Account
NC Netting document
Multi Currency AAIs
PG/PL Multi Currency Realized Gain/Loss R PGxxx, PGyyyy**, PG (PL также)
PV/PW Multi Currency Unrealized Gain/Loss R PVxxx, PVyyyy, PV (PW также)
PR Multi Currency Unrealized Gain/Loss Offset account R PRxxx, PRyyyy, PR
PY/PZ Alternate Currency R PYxxx, PYyyyy, PY (PZ также)
P7 Alternate Clearing account R P7

* где yyyy указывает на счет банка при вводе ваучера.

** где yyyy код корр.счета ГК из ваучера, который оплачен.

PB
  • Based on the company number entered during Standard Voucher Entry (P0411).
  • Can be configured for a specific company or for the Default Company (00000).
  • Business Unit is required.
  • Designed to automatically fill in the G/L Bank Account (ANI) field during Standard Voucher Entry (P0411).
  • If the PB AAI does not exist, the system produces an error
  • If a G/L Offset is used for the Trade Account AAI (PCyyyy), a matching PB AAI must exist or the system produces an error.
  • The system uses the following hierarchy to validate the PB Automatic Accounting Instructions (AAIs). If the first item does not exist, the system looks for the next AAI:
    1. PBxxx - where xxx is the currency code.
    2. PByyyy - where yyyy is the GL Offset.
    3. PB for the company assigned to the transaction.
    4. PB for Company 00000.

If multiple bank accounts for a company exist, define an offset PByyyyy. Note that if PByyyy is set up, PCyyyy must also exist.

Ссылки