AR

Материал из JD Edwards E1
Перейти к навигации Перейти к поиску

База

  • Модуль РД может работать изолировано без взаимодействия с другими модулями (кроме АК).
  • Перед работой необходимо выполнить базовые настройки системы и создать карточки клиентов РД в дополнение к карточкам АК.
  • Для учета дебиторской задолженности по клиенту необходимо вводить документы реализации. В данной системе учета все документы реализации условно называются Инвойсами ().
  • Для учета кредиторской задолженности по клиенту можно ввести т.н. Отрицательный инвойс (он же Кредит мемо, он же кредитный авизо).
  • Для учета закрытия дебиторской задолженности клиента используется механизм соотнесения. Соотносить Инвойсы можно с Денежными поступлениями от клиентов (в т.ч. с драфтами), с отрицательными инвойсами или устроить взаимозачет с модулем РК.
  • Если Денежные поступления от клиентов нет возможности сразу соотнести с Инвойсами (предоплата, особенности БП и пр.), то можно ввести Несоотнесенные поступления. Потом выполнить соотнесение.
  • Если для Денежных поступлений нет возможности сразу соотнести клиентом, то можно ввести Зарегистрированные поступления. Потом, после создания карточки клиента, определить контрагента.
  • Если Денежных поступлений не связаны с реализацией, то можно ввести Поступления ГК, распределив их на соответствующие счета учета.

Документ реализации (Invoice)

Виды инвойсов:

Тип документа Описание
RI (Regular Invoice) Unless you modify the processing option in the Invoice Entry MBF Processing Options program (P03B0011), the system assigns RI to all invoice documents that are created by the JD Edwards EnterpriseOne Sales Order Management system and those invoices entered manually using Standard Invoice Entry or Speed Invoice Entry.
RM (Credit Memo) Unless you modify the processing option in the Invoice Entry MBF Processing Options program (P03B0011), the system assigns RM to credit memos entered manually using Standard Invoice Entry or Speed Invoice Entry.
RR (Recurring Invoice) The system assigns RR to all recurring invoices entered with frequency and number of payments.
RN (Manual Billing) The system assigns RN to all invoices generated from manual billings in the JD Edwards EnterpriseOne Real Estate Management system.
RD (Recurring Billing) The system assigns RD to all invoices generated from the recurring billings in the JD Edwards EnterpriseOne Real Estate Management system.
RH (Expense Participation) The system assigns RH to all invoices generated from the expense participation billings in the JD Edwards EnterpriseOne Real Estate Management system.
RJ (Sales Overage) The system assigns RJ to all invoices generated from the sales overage billings in the JD Edwards EnterpriseOne Real Estate Management system.
RL (Escalation) The system assigns RL to all invoices generated from the escalation billings in the JD Edwards EnterpriseOne Real Estate Management system.
RT (A/R Fee & Interest) The system assigns RT to all invoices generated from the fee and interest billings in the JD Edwards EnterpriseOne Real Estate Management system.
RB (Chargeback Invoice) The system assigns RB to invoice chargeback records generated when the receipt is entered. The chargeback indicates that you want to pursue payment for an unearned discount or disputed invoice amount.
R5 (Deduction) The system assigns R5 to invoice deduction records generated when the receipt is entered. The deduction indicates an unpaid amount that must be resolved.
R1 (Draft) The system assigns R1 to draft invoice records. Drafts are a promise to pay a debt. This document can be a paper record or an electronic record. A draft includes the amount to be paid, the due date, banking information and, possibly, information about underlying liabilities.
RF (Delinquency Fee) The system assigns RF to fee invoices. The fee invoice represents the total amount of all fees generated for all eligible invoices for the customer for the time period specified.
NP (Partial NSF) The system assigns NP to stand-alone invoice records that are generated for the NSF amount when you enter a partial NSF draft.


Виды ввода инвойса:

  • Стандартный ввод инвойса / Standard Invoice Entry (P03B11)
  • Ускоренный ввод инвойса / Speed Invoice Entry (P03B11SI)
  • Пакетный ввод инвойсов / Batch Invoice Revisions (P03B11Z1, R03B11Z1A, R03B11Z1P)
Стандартный ввод инвойса Ускоренный ввод инвойса

При использовании Standard Invoice Entry (P03B11) возможно:

  • Создавать Оплаты в рассрочку, используя расширенные условия оплаты (installment payment term).
  • Использовать множество элементов оплат.
  • Настраивать recurring invoices.
  • Изменять, удалять и сторнировать/аннулировать инвойсы.
  • Использовать и создавать модельные журнальные записи.
  • Перезаписывать счет Распределении ГК.

При использовании Speed Invoice Entry (P03B11SI) возможно:

  • Использовать одну форму для ввода информации как счетов-фактур, так и о распределении по ГК.
  • Быстро вводить ограниченную информацию для инвойса.


Ввод документов реализации (Invoce)

Стандартный ввод инвойса (P03B11/P03B2002) - RI

На форме Работа с запросом к регистру заказчиков / Work with Customer Ledger Inquiry (W03B2002A) нажать Добавить / Add для доступа к приложению Стандартный ввод инвойса / Standard Invoice Entry (P03B11):

  1. (OPTIONAL). To assign the document number, document type, and document company, complete the Document No/Type/Co optional fields in the header area. Usually you should let the system assign the document number from Next Numbers (P0002), the document type from the Invoice Entry MBF (P03B0011) processing options, and the document company from the company number that you assign to the invoice. The system assigns this information when you click 'OK' at the end of this task.
  2. Complete the Customer, Company, Invoice Date, and G/L Date fields in the header area.
NOTE: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000 for transaction entries, such as invoice entry.
  1. (OPTIONAL) Override the value in the Payment Terms field, if necessary. These are defaulted from the Customer Master (F03012)
  2. (OPTIONAL) Select 'Additional Info' from the Form menu to access the Additional Information form.
  3. (OPTIONAL) Override the value for any of the fields on the Additional Information form, if necessary, and then click 'OK' to return to the Standard Invoice Entry form.
  4. In the detail area of the Standard Invoice Entry form, complete the Gross Amount field for each pay item. Other field values such as Pymt Terms (Payment Terms) and Discount Available will default once you tab out of the detail line.
  5. (OPTIONAL) In the detail area, complete the Remark, Pymt Terms, Business Unit, Due Date, and G/L Offset fields for each pay item.
    • Payment Terms: The system completes the Pymt Terms field with the value that is assigned in the header portion of the form, but you can override it for any or all invoice pay items.
      • NOTE: If you change the payment terms code after you have entered the pay item, you must clear the values in the Discount Available, Due Date, and Discount Due Date fields so that the system can calculate new values.
    • Due Date: The system calculates the due date based on the payment term that is entered, or you can enter it manually. If you enter a negative invoice (credit memo), the system will use the G/L date as the due date prior to 8.9. From 8.9, a processing option in the master business function (P03B0011) controls how the system calculates the due date for credit memos.
    • G/L Offset: is defaulted from the Customer Master (F03012) record but can be overridden manually. The G/L Offset is the code that determines the trade account that the system uses as the offset when you post invoices. The system concatenates the value entered to the Automatic Accounting Instruction (AAI) item RC (for Accounts Receivable) to locate the trade account. For example, if you enter TRAD, the system searches for the AAI item RCTRAD (for receivables).
  6. Click 'OK' to access the G/L Distribution form.
  7. On the G/L Distribution form, complete the Account Number and Amount fields in the detail area for each G/L distribution line.
  8. (OPTIONAL) Complete the Explanation -Remark field, and click 'OK'.

NOTE: If you are using Advanced Cost Accounting, you might also need to complete the Cost Object and Object Type fields. See JD Edwards EnterpriseOne Advanced Cost Accounting Implementation Guide. The Implementation Guides are available on the Oracle Technology Network.

Быстрый ввод инвойса (P03B11SI) - RI

Access the Speed Invoice Entry form (P03B11SI)

  1. On Speed Invoice Entry, to identify the invoice, complete the following fields:
    • Customer
    • Company
    • Gross Amount
    • Invoice Date
    • G/L Date
  2. Complete the following optional fields:
    • Remark
    • Pay Status
  3. To override default and system-calculated information, complete the following fields:
    • BU
    • Tax Rate/Area
    • Pay Terms
    • Tax Expl Code
    • Pay Instr
    • Due Date
    • Tax Amount
    • Disc Due Date
    • Taxable Amount
    • Currency
  4. To enter G/L distribution information, complete the following fields in the detail area:
    • Account Number
    • Amount - Depending on how you set the processing options, you enter this amount as a positive or negative number.
  5. Complete the following optional field in the detail area:
    • Remark
  6. Click 'OK'.

Стандартный ввод Отрицательного инвойса Credit Memo (P03B11/P03B2002) - RM

текст

Стандартный ввод Повторяющегося инвойса Credit Memo (P03B11/P03B2002) - RR

Recurring Invoice Entry Recurring invoices are set up in the Standard Invoice Entry (P03B11) program. You do this by using either the Recurring Invoice form, which you access from the Form menu, or by completing the Recur Frequency (recurring frequency) and Number of Payments fields in the detail area of the invoice.

Recur Frequency (recurring frequency) codes are set up in User Defined Code (UDC) table H00/RF. The codes are used to specify the time interval between which the system creates transactions. Valid recurring frequency values are:

MO: Monthly AN: Annually WK: Weekly QT: Quarterly SA: Semi-annually BW: Biweekly

Option 1: On Standard Invoice Entry (P03B11) complete the header information and take the Form exit 'Recurring Invoice'. On Recurring Invoice, complete the Recur Frequency (recurring frequency) and Number of Payments fields, and click 'OK'. On Standard Invoice Entry complete the grid detail with 'Gross Amount' and any other information you need. If you add an invoice with multiple pay items, the system adds the recurring information to each pay item. You can override the recurring information as necessary. Click 'OK'. Complete the necessary G/L distribution information. Click 'OK'

Option 2: On Standard Invoice Entry (P03B11) complete the header information. In the grid detail area complete the 'Gross Amount' field and any other information you need. Scroll to the right of the grid to find the 'Recur Frequency' and 'Number of Payments' fields. Complete these two fields to make the invoice a recurring invoice. Click 'OK' Complete the necessary G/L distribution information. Click 'OK' When you enter a recurring invoice, the system assigns a document type of 'RR' and the system stores recurring invoice information in the Customer Ledger (F03B11).

Recurring Invoice Review (P03B120)

Copyright (c) 2024, Oracle. All rights reserved. Oracle Confidential.


Click to add to Favorites E1: 03B: Processing Recurring Invoices in EnterpriseOne Accounts Receivable (P03B11, P03B120, R03B305, R03B8101) (Doc ID 1466797.1) To BottomTo Bottom

In this Document Purpose Scope Details 

	Overview of Recurring Invoices
	Setting Up a Recurring Invoice
	Recurring Invoice Entry
	Revising a Recurring Invoice
	Recurring Invoice Review (P03B120)
	Printing the Recurring Invoice Report (R03B305)
	Setting Data Selection and Data Sequencing for Recurring Invoice Report (R03B305)
	Setting Processing Options for Recurring Invoice Report (R03B305)
	Recurring Invoice Revisions
	Cancelling a Recurring Invoice
	Adding Recurring Information to an Existing Transaction 
	Understanding the Recycle Process (R03B8101)
	Setting Processing Options for Recycle Recurring Invoices (R03B8101)

References APPLIES TO: JD Edwards EnterpriseOne Accounts Receivable - Version XE and later Information in this document applies to any platform. PURPOSE This document discusses how to set up and process recurring invoices within Oracle JD Edwards EnterpriseOne Accounts Receivable.

SCOPE This document is intended for users who are setting up or using recurring invoices in the EnterpriseOne Accounts Receivable module

DETAILS Overview of Recurring Invoices If you bill customers on a regular basis for the same amount, you can enter a recurring invoice. When entering a recurring invoice you indicate the total number of invoices you need to create, eg. 12, and the invoicing interval, eg monthly. Then you can run a recycle program to generate a new transaction at regular periods, rather than entering a new invoice each time. The system assigns a new document number and batch number to the new transaction and reduces the number of transactions by one. You continue to recycle and create new transactions until one invoice remains.

Setting Up a Recurring Invoice Recurring Invoice Entry Recurring invoices are set up in the Standard Invoice Entry (P03B11) program. You do this by using either the Recurring Invoice form, which you access from the Form menu, or by completing the Recur Frequency (recurring frequency) and Number of Payments fields in the detail area of the invoice.

Recur Frequency (recurring frequency) codes are set up in User Defined Code (UDC) table H00/RF. The codes are used to specify the time interval between which the system creates transactions. Valid recurring frequency values are:

MO: Monthly AN: Annually WK: Weekly QT: Quarterly SA: Semi-annually BW: Biweekly

Number of Payment. Enter the number of recurring invoices that the system processes. This number includes the original transaction that you enter. For example, if you enter '12', the system will process the transaction eleven additional times, reducing the value of the number of payments by one each time it creates a new transaction. When this field contains a value of '1', the system does not create a new transaction. Instead, the system clears the field.

Option 1:

Recurring Invoice Entry with form exit

On Standard Invoice Entry (P03B11) complete the header information and take the Form exit 'Recurring Invoice'. On Recurring Invoice, complete the Recur Frequency (recurring frequency) and Number of Payments fields, and click 'OK'. On Standard Invoice Entry complete the grid detail with 'Gross Amount' and any other information you need. If you add an invoice with multiple pay items, the system adds the recurring information to each pay item. You can override the recurring information as necessary. Click 'OK'. Complete the necessary G/L distribution information. Click 'OK' Recurring Invoice Form exit

Option 2:

Standard Invoice Entry screen

On Standard Invoice Entry (P03B11) complete the header information. In the grid detail area complete the 'Gross Amount' field and any other information you need. Scroll to the right of the grid to find the 'Recur Frequency' and 'Number of Payments' fields. Complete these two fields to make the invoice a recurring invoice. Click 'OK' Complete the necessary G/L distribution information. Click 'OK' 

Standard Invoice Entry Grid Details


When you enter a recurring invoice, the system assigns a document type of 'RR' and the system stores recurring invoice information in the Customer Ledger (F03B11).


Revising a Recurring Invoice Before sending the invoice to the customer or recycling it next month, you might want to check it. Recurring invoices can be reviewed online using Recurring Invoice Review (P03B120) or you can print them on a report using Recurring Invoice Report (Invoice Journal) (R03B305).

Recurring Invoice Review (P03B120) Usually, invoices are viewed online.

Access the Work With Recurring Invoices History form (P03B120)

To review recurring invoices online: 1. Display and review invoices in the detail area. 2. To review the invoice information on one form instead of in the detail area, select an invoice, and then select Detail from the Row menu.

Recurring Invoice Inquiry

You can also access recurring invoices on the Work with Customer Ledger Inquiry (P03B2002). To do so, select the 'Recurring Invoices' option, and then click 'Find'.

Customer Ledger Recurring Invoice filter

Printing the Recurring Invoice Report (R03B305)

Печать инвойса Invoice Print (R03B505)

текст

Локализация инвойсов РФ

Локализация инвойсов (G74R03B):

  • Standard Invoice Entry (P03B11). Связать Документ реализации (Invoice) из РД с локал. документом из 42 системы.
    • Additional Information for Invoices - Invoice Related Information program (P74P3B02) - Regional Info
      • The system launches the Invoice Related to CN/DN (P7430015)
      • Invoice Entry - PO program (P74P33B1)
  • Add Invoice - PO program (P7433B11)

Настройки инвойсов

Документы должны существовать в:

  • Определяем все типы заказов и документов (как будто это справочник): UDC 00/DT (Document Type - All Documents)
  • Разрешаем использовать эти типы документов как Документ реализации: UDC 00/DI (Document Type - Invoices Only)

Механизм соотнесения (Apply Invoice)

Денежные поступления (Receipt)

Виды поступлений:

Соотнесенное поступление (Аpplied receipt)
поступление от клиента или плательщика, которое соотнесено с конкретным документом реализации (Invoice).
Несоотнесенное поступление (Unapplied receipt)
поступление от клиента или плательщика, которое не соотнесено с конкретным документом реализации (Invoice).
Balance Forward receipt
поступление от клиента или плательщика, для которого можно указать дату, начиная с которой система будет искать документом реализации (Invoice) для соотнесению. Либо указать конкретный номер документа реализации (Invoice)
Зарегистрированное поступление (Logged receipt)
поступление от клиента или плательщика, которого не удалось связать с клиентом или плательщиком из АК/РД.
Поступление ГК (General Ledger receipt)
поступление не от клиента или плательщика. Например, возмещение по страховому случаю.

Тип документов поступлений:

Тип Название Описание
RC Поступление (Receipt) Система присваивает этот тип документа при вводе поступления.
RO Void Receipt Система присваивает этот тип документа при аннулировании поступления.
RS Spread Receipt Система присваивает этот тип документа, когда кредитное авизо (Credit Memo) соотноситься с документом реализации (Invoice), создавая поступление с нулевой суммой. Этот тип документа не присваивается при соотнесении несоотнесенного поступления (Unapplied Receipt) с документом реализации (Invoice).
RV Insufficient Funds Receipt Данный тип документа система присваивает в случае, если у клиента недостаточно средств на счете в банке для оплаты платежа. (The system assigns this document type when a customer has insufficient funds in the bank to pay the payment.)
RU Unapplied Receipt Система присваивает этот тип документа поступлению, которое не соотнесено с конкретным документом реализации (Invoice).
RL Logged Receipt Система присваивает этот тип документа поступлению, которое не связано с клиентом или плательщиком.
RR Rounding Record Система назначает этот тип документа, когда поступление в иностранной валюте либо полностью соотнесена в иностранной части, но не полностью соотнесена в домашней валюте, либо полностью не соотнесена на иностранной стороне, но не полностью соотнесена в домашней валюте из-за проблем округления. Эта запись округления находится на уровне поступления и не связана с какой-либо конкретной позицией оплаты документа

Виды ввода поступлений:

  • Standard Receipts Entry (P03B102)
  • Speed Receipts Entry (P03B0001)
  • Automatic Receipt Processing (P03B121, P03B124, R03B50)

When you apply receipts or drafts to invoices, you use type input (TI) codes to automatically calculate amounts to apply for payments, discounts, write-offs, chargebacks, and deductions.

Type Input Code Calculations
10 (Simple Invoice Match)
  • Payment amount = current open amount - discount available
  • Discount taken = discount available
  • Write-off = optional
  • Chargeback = optional
  • Deduction = optional
11 (Invoice Match with Automatic Chargeback for Discount Amount)
  • Payment amount = current open amount - discount available
  • Discount taken = optional
  • Write-off = optional
  • Chargeback = discount available
  • Deduction = optional
15 (Invoice Match with Write-Off)

Amount applied = current amount - discount available

  • Discount taken = discount available
  • Write-off = current open amount - amount applied, discount taken, chargeback amount, and deduction amount
  • Chargeback = optional
  • Deduction = optional
16 (Invoice Match with Chargeback)
  • Amount applied = current open amount - discount available
  • Discount taken = discount available
  • Write-off = optional
  • Chargeback = current open amount - amount applied, discount taken, write-off, and deduction amount
  • Deduction = optional
17 (Invoice Match with Deduction)
  • Amount applied = current open amount - discount available
  • Discount taken = discount available
  • Write-off = optional
  • Chargeback = optional
  • Deduction = current open amount - amount applied, discount taken, write-off, and chargeback


Note - Document types (RU. R5, RS, etc) generated by the AR receipt entry P03B102 are hard coded in the program and it cannot be changed.

To look at upcoming or archived Advisor Webcasts, please see Advisor Webcast Details Document 1450327.1. If your topic is not currently scheduled, please suggest it.

Ввод стандартного поступления (P03B102)

текст

Проводки поступлений

Аpplied receipt w/o Discount (TI 10)
Дт [AAI RB] > W03B102E.ANI > F03B13.GLBA
Kт F03B11.AID (Invoce) > F03B14.AID
Unapplied receipt
Дт [AAI RB] > W03B102E.ANI > F03B13.GLBA
Kт PO(1) = Blank: F0301.ARC > W03B102I.GLC (2) > [AAI RCxxxx] [AAI RCUC] > F03B13.AID
or
PO(1) = 1: [AAI RCUC] > F03B13.AID
(1) PO P03B102: Default; 8. Default G/L Offset for Unapplied Receipts
(2) W03B102I (Additional Information): Form > Additional Info
G/L receipt
Дт [AAI RB] > W03B102E.ANI > F03B13.GLBA
Kт W03B0001C.ANI (1) > F03B14.AID2
(1) W03B0001C (G/L Receipts Entry): Form > General Ledger
Logged receipt
Дт W03B0001A.ANI > F03B13.GLBA
Kт W03B0001A.GLC(1) > [AAI RCLC] > F03B13.AID
(1) для ESAC = 3 (Logged Receipt), W03B0001A.GLC = LC (Hard Coded), можно изменить вручную.
Аpplied receipt with Discount Taken (TI 10)
Дт [AAI RB] > W03B102E.ANI > F03B13.GLBA
Kт F03B11.AID (Invoce) > F03B14.AID
[AAI RKDzz] > F03B14.AIDD

Локализация РФ

  • Для предоплатных поступлений (Unapplied Receipt) существует P74R3100 (Prepayment VAT Setup - RUS - 03B)
  • The system uses the Unapplied Case Tax Code (74R/UT) user-defined code (UDC) table to determine the GL offset account to use for journal entries. If the appropriate values are not set up in this UDC table, the system updates the batch status to E (error). The system writes records to the Prepayment Header Tax File (F74R310) and Prepayment Detail Tax File (F74R311) tables. The system also uses the processing option values that you set up in the Prepayment VAT Setup program (P74R3100). The system reads the values in the Prepayment VAT Setup program when you run the General Ledger Post program.

Настройки

Т.к документы поступления жестко кодированы и не применяются в F03B11 кроме несоотнесенных поступлений, то их нет необходимости разрешать к исползованию. Документы несоотнесенных поступлений должны существовать в:

  • Определяем все типы заказов и документов (как будто это справочник): UDC 00/DT (Document Type - All Documents)
  • Разрешаем использовать эти типы документов как Документ реализации: UDC 00/DI (Document Type - Invoices Only)
  • Разрешаем использовать эти типы документов как Несоотнесенные поступления: UDC 00/DI: UDC 00/DIUDC 00/UT (Document Type Unapplied Rcpts)

Вычеты (Deductions)

Источник — http://wiki.sgsproject.nichost.ru/index.php?title=AR&oldid=108097