My Oracle Support Banner

E1: 03B: How To Set Up, Process and Troubleshoot Batch Invoice Processing In EnterpriseOne Accounts Receivable (P03B11Z1, R03B11Z1A, R03B11Z1P) [Video] (Doc ID 1473954.1)

Last updated on APRIL 26, 2019

Applies to:

JD Edwards EnterpriseOne Accounts Receivable - Version XE and later
Information in this document applies to any platform.

Purpose

Batch Invoice Processing Overview

The Batch Invoice Processor (R03B11Z1A) is designed to process open invoices into the Customer Ledger (F03B11) and Account Ledger (F0911) tables from an external or legacy system, such as PC data entry, third-party or customer systems, or electronic data interchanges (EDI). Before you perform batch invoice processing, you need to write a custom program to copy the data from the external system to these tables:

After you upload the batch invoice data from the external system to the batch file tables, you run the Batch Invoice Processor (R03B11Z1A) to create invoices in the JD Edwards EnterpriseOne Accounts Receivable system. When you run the Batch Invoice Processor (R03B11Z1A), the system:

Based on how you set the Batch Invoice Processor (R03B11Z1A) processing options, the system can automatically post the invoice batches that the system creates and purge the successfully processed records from the batch tables (F03B11Z1 and F0911Z1). Or the post and purge options can be done manually as separate stages. There is also an option using the Batch Invoice Revisions program (P03B11Z1) to review, revise and add batch invoice transactions.

Originally the Batch Invoice Processor program in release Xe/ERP8.0 was R03B11Z1I. However a new program R03B11Z1A was developed in Enhancement <Bug 10777354>: BATCH INVOICING PERFORMANCE to improve performance. See Xe/ERP8 Enhancement below for more information. From release 8.9, only R03B11Z1A is available.

NOTE: The invoice batch processor is designed to process only open invoices. You cannot process paid or partially paid invoices, deductions, receipts, or chargebacks. If you use this program to process information other than open invoices, the program is considered a custom program and is not supported by Oracle. Contact the field representative for assistance with custom programming.

Scope

 This document is intended for users who are setting up or using the batch invoice process in the EnterpriseOne Accounts Receivable module

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
 Batch Invoice Processing Overview
Scope
Details
 AR Invoice Batch Processing Video Presentation (Video)
 Understanding the Mapping of Batch Invoice Transactions
 Revising Batch Invoices (P03B11Z1)
 Setting Processing Options for Batch Invoice Revisions (P03B11Z1)
 Revising Batch Invoices
 Adding Batch Invoices
 Deleting Batch Invoices
 Processing Batch Invoices (R03B11Z1A)
 Data Selection for Batch Invoice Processor (R03B11Z1A)
 Setting Processing Options for Batch Invoice Processor (R03B11Z1A)
 Troubleshooting Tips
 Posting Batch Invoices
 Batch Invoice Purge (R03B11Z1P)
 XE/ERP8.0 Enhancement
 Detail Mapping Information
 Required Fields For Batch Invoices (F03B11Z1) Table - No Currency
 Required Field for the Journal Entry Transactions - Batch File (F0911Z1) Table - No Currency
 Additional Fields Required for Discounts - Batch Invoices (F03B11Z1)
 Additional Fields Required for Taxes - Batch Invoices (F03B11Z1)
 Tax Considerations for Updating the Journal Entry Transactions - Batch File (F0911Z1) Table
 Additional Fields Required for Currency - Batch Invoices (F03B11Z1)
 Currency Fields that should be Blank - Batch Invoices (F03B11Z1)
 Currency Consideration for Updating the Journal Entry Transactions - Batch File (F0911Z1) Table
 Other Fields
 Optional Fields – Batch Invoices (F03B11Z1)
 Ignored Fields – Batch Invoices (F03B11Z1)
 Ignored Fields – Batch Invoices (F03B11Z1) Fields Reserved for Users - Batch Invoices (F03B11Z1)
 Enterprise-wide Profitability Solution - Journal Entry Transactions - Batch Tag File (F0911Z1T) (System 16)
 Required Fields for F0911Z1T  
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.