You are here
Home > Accounts Receivable > Processing Automatic Receipts > Working with Electronic Receipts

Working with Electronic Receipts

Working with Electronic Receipts

Concept

Use the Review Electronic Receipts program (P03B121) to review, revise, and add a new receipt to the Electronic Receipts Input table (F03B13Z1).

 

You might need to add electronic receipts for the following reasons:

• The information on the bank tape was insufficient for the system to create a Receipts Header record (F03B13) when the Update Receipts Header program (R03B551) was run.

• A receipt record is missing due to a problem such as power failure while uploading receipt information from the bank tape.

 

You might need to revise electronic receipts for the following reasons:

• The invoice information, which the system retrieves for the Known Invoice Match algorithms (R03B50D and R03B50E), is not correct.

• You want to update the status on records so that the purge program selects them. For example, a duplicate record exists in the Electronic Receipts Input table, or the record is damaged.

• You want to update the status on a batch of records that processed in error.

 

After you add or revise electronic receipts, you must process them so that the system can create the appropriate records in the appropriate table. Use the Form menu to run the appropriate report directly from the P03B121 program.

 

Procedure

In this task, you will review an uploaded electronic receipt and add an electronic receipt.

Step Action
Navigate to the Review Electronic Receipts program (P03B121) on the Automated Receipts Processing menu (G03B13).

Click the Automated Receipts Processing menu.

Click the Review Electronic Receipts menu.

Use the Work With Electronic Receipts Input form to locate and delete electronic receipt records in the F03B13Z1 table.

Step Action
First, review an electronic receipt.

Click in the Batch Number field.

Enter the desired information into the Batch Number field. Enter “29946“.

Click the Find button.

Click the 4343 option.

Click the Select button.

Use the Revise Electronic Receipt Input form to review and revise electronic receipt records in the F03B13Z1 table.
When you revise an electronic receipt, you cannot change the batch number, batch date, or receipt number.
The value in the Upload Status field indicates the status of the transaction during the automatic receipt process. Values are:

• Blank: The transaction has not been not processed.

• B: The transaction is eligible for reprocessing. The system assigns this code when you use the Revise Electronic Receipts Input Status program (P03B124) and turn on the option Set to Upload Status after you correct receipts that previously processed with errors.

• E: The transaction was processed with errors.

• H: The transaction was processed by the Update Receipts Header program (R03B551) but was not matched to invoices using the Apply Receipts to Invoices program (R03B50). The system assigns this value to receipts that will be processed using the Known Invoice Match With Amount algorithm (R03B50D) or the Known Invoice Match Without Amount algorithm (R03B50E).

• Y: The transaction is successfully processed and is ready to be purged.

Step Action
Click the OK button.

Step Action
Next, add an electronic receipt.

Click the Add button.

Use the Electronic Receipt Entry form to add electronic receipts to the F03B13Z1 table.

Step Action
Use the Company field to enter a code that identifies a specific organization, fund, or other reporting entity.

Click in the Company field.

Enter the desired information into the Company field. Enter “1“.

Click in the G/L Date field.

Use the G/L Date field to enter the date that identifies the financial period to which the system posts the transaction.

Enter the desired information into the G/L Date field. Enter “091516“.

Click in the Amount Expected field.

Use the Amount Expected field to enter the amount of the receipt or payment.

Enter the desired information into the Amount Expected field. Enter “4590“.

Click in the Transaction Number field.

Use the Transaction Number field to enter the number that an Electronic Date Interchange transmitter assigns to a transaction. In a non-EDI environment, you can assign any number that is meaningful to you to identify a transaction within a batch. It can be the same as an EnterpriseOne document number.

Enter the desired information into the Transaction Number field. Enter “06“.

Click in the Receipt Number field.

Use the Receipt Number field to enter an alphanumeric code that identifies a check or receipt.

Enter the desired information into the Receipt Number field. Enter “600“.

Click in the Customer Number field.

Use the Customer Number field to enter a user-defined name or number that identifies an address book record.

Enter the desired information into the Customer Number field. Enter “3001“.

Click in the Receipt Gross Amount field.

Use the Receipt Gross Amount field to enter the actual amount of the receipt or payment. Do not enter a credit (negative amount). The system cannot apply negative receipts to invoices.

Enter the desired information into the Receipt Gross Amount field. Enter “4590“.

Click in the Receipt Date field.

Use the Receipt Date field to enter the date on the check or the date that you enter the receipt into the system. The receipt date is used for information and reporting purposes only.

Enter the desired information into the Receipt Date field. Enter “091516“.

If this receipt paid multiple invoices, you can insert additional rows by clicking anywhere in the second row.
With multiple invoices, complete the Receipt Gross Amount field for the first line only. The result is that when processed, the system creates one F03B13 record for the single amount.
Click the OK button.

Click the Cancel button.

Step Action
Click the Close button.

You have successfully reviewed an uploaded electronic receipt and added an electronic receipt.

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