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

Материал из JD Edwards E1
Перейти к навигации Перейти к поиску
(не показано 37 промежуточных версий 4 участников)
Строка 41: Строка 41:
  
 
=== AAI для Accounts Receivable/Расчеты с дебиторами ===
 
=== AAI для Accounts Receivable/Расчеты с дебиторами ===
 +
 +
{| class="wikitable"
 +
! AAI || Описание || БЕ || Иерархия
 +
|-
 +
! colspan = "4" | 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 || ? ||
 +
|-
 +
! colspan = "4" | Receipts Specific AAIs
 +
|-
 +
| RCUC || Unapplied Cash Receipt || O || Hard Coded
 +
|-
 +
| RCLC || Logged Receipts || R || Hard Coded 
 +
|-
 +
| RAzz || Write-off Reason Code || O ||
 +
|-
 +
! colspan = "4" | 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 || 
 +
|-
 +
! colspan = "4" | Intercompany Settlements AAIs
 +
|-
 +
| ICCC/ICH || Intercompany Settlements || ||
 +
|-
 +
! colspan = "4" | 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 ||
 +
|}
 +
 +
<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.
  
 
== Ссылки ==
 
== Ссылки ==
Строка 49: Строка 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.

Ссылки