You are here
Home > Accounts Receivable > Processing Recurring Invoices > Recycling Recurring Invoices

Recycling Recurring Invoices

Recycling Recurring Invoices

Concept

After you enter, review, and revise recurring invoices, you recycle them to create a new batch of transactions for the next month, quarter, or year. The Recycle Recurring Invoices program (R03B8101) generates a new transaction based on the number of payments and the recurring frequency that you specified when you created the original recurring transaction. When you recycle an invoice, the system makes a copy of the previous transaction and updates the appropriate fields. It repeats this process every time you run the recycle program until the number of payments equals one. When one payment remains, the transaction no longer recycles. For example, to set up a recurring invoice for one year, you set the number of payments to 12. Because the original transaction is the first payment, the recycle program does not consider transactions that have one payment remaining.

 

You do not have to pay an existing invoice or voucher to generate the next cycle of recurring transactions.

 

The system updates information in the Batch Control Records (F0011), Customer Ledger (F03B11), and Account Ledger (F0911) tables during the recycle process.

 

When you recycle recurring invoices, the system:

• Removes the recurring frequency and number of payments from either the original transaction or the most recent copy of the transaction.

• Creates a new invoice and updates the following: document number with a new number, batch number with a new number, number of payments (decreases by one), G/L date and net due date (using the recurring frequency to calculate the next date), invoice date according to the processing options, and invoice number (vouchers only) according to the processing options.

• Creates an exception report that lists the number of invoices that were successfully recycled, and the number of transactions that could not be recycled due to errors (exceptions). You can view error messages in the Work Center. These errors include:

– No accounting distribution records created. This occurs when no records are found in the F0911 table for the recurring invoice or voucher.

– G/L date is for a prior fiscal year (PYEB).

– G/L date is for a prior period (PBCO) and the Allow PBCO Postings check box is not selected in the General Accounting Constants program (P0000).

– G/L date does not occur in a fiscal date pattern for the company.

 

After recycling recurring invoices, you must post them to the general ledger.

Procedure

In this task, you will recycle a recurring invoice to update payment information.

Step Action
Navigate to the Recycle Recurring Invoices program (R03B8101) on the Other Invoice Entry Methods menu (G03B111).

Click the Other Invoice Entry Methods menu.

Click the Recycle Recurring Invoices menu.

Use the Available Versions form to select a version of the batch program. In your work environment, the system might display additional versions.
Click the ZJDE0002 option.

Click the Select button.

Use the Version Prompting form to access data selection and data sequencing for the batch program. If the Data Selection or Data Sequencing option is disabled, you cannot review or change the data selection or sequencing for the version.
Click the Data Selection option.
Click the Submit button.

Use the Data Selection form to specify which records the system should retrieve from the database and include in the report.
Click the OK button.

Use the Processing Options form to set parameters for how a batch program processes data. Processing options are unique to a version. You should review processing options to ensure that the settings are correct.
Click the OK button.

Use the Printer Selection form to identify printer information for the report. In your work environment, the printer settings will be different.
The Recycle Recurring Invoice report lists the number of records that the system recycled.
You have successfully recycled a recurring invoice to update payment information.

End of Procedure.

Ayman Refat
Over 20 years of experience in IT area, working as Oracle JD Edwards Developer with expertise in Windows Server, SQL Server and Microsoft Exchange Server, experience in Linux operating systems (Debian and Redhat), VMWare ESX / ESXi, Novell Netware, relational databases like Oracle 10/11g and backup solutions from Computer Associates. Large experience in high-end servers from Dell and HP, having the following certifications: Microsoft: MCP, MCSE, MCDBA, MCSA and MCT (2008 ~ 2013), Computer Associates: Technical Specialist – Storage and Backup Solutions,
http://www.AymanRefat.com

Leave a Reply

Top