18 Processing EDI Transactions for Accounts Receivable

This chapter contains the following topics:

18.1 Understanding EDI for Accounts Receivable

As an alternative to using a magnetic tape to receive payment information from the bank, you can set up the system to receive information electronically using EDI. When you process EDI transactions, you might use a trading partner and translator software to prepare the records for JD Edwards EnterpriseOne tables. After the information is received in the JD Edwards EnterpriseOne EDI tables, you can review and revise it before the system transfers it to the Electronic Receipts Input table (F03B13Z1).

The JD Edwards EnterpriseOne Accounts Receivable system can process inbound electronic receipts for these two types of payment transaction sets:

  • 823 - Lockbox

  • 820 - Payment Order

The process to receive, revise, add, and remove payment information is the same, regardless of the transaction set that you use. After you successfully process EDI inbound receipts, the transactions are ready for automatic receipt processing.

18.2 Understanding EDI Receipt Transmissions

You can use EDI to receive Accounts Receivable receipt transmissions. To receive these transmissions, you run a program that converts and transfers the EDI information from the format that was sent by the bank in the EDI tables into the format that is used by the F03B13Z1 table.

See Processing EDI Documents, Receiving EDI Standard Business Documents.

To process transmissions that are received through EDI, you must understand the mapping requirements for each of its components when they are received.

18.2.1 Mapping Requirements for Processing Inbound EDI Transmissions

These tables are used to receive EDI transmissions:

  • EDI Lockbox/Payment Header - Transaction (F47111): The system stores transaction information in this table.

  • EDI Lockbox Header - Transaction (F47112): The system stores deposit information in this table.

  • EDI Lockbox/Payment Detail - Batch (F47113): The system stores payment (receipt) information in this table.

  • EDI Lockbox/Payment Detail - Payment (F47114): The system stores remittance (invoice) information in this table.

You can receive multiple transactions in a single EDI transmission; each transaction can have one deposit, each deposit can have multiple payments, and each payment can have multiple remittances (that is, it can pay multiple invoices). Total amounts are maintained by deposit and check for audit purposes, but are not transferred to the F03B13Z1 table.

The system uses key fields in EDI tables F47111, F47112, F47113, and F47114 to differentiate transactions and their related components. You should assign the same value to the key fields in all of the EDI tables. This table describes these key fields:

Field Name Alias Type Length Definition and Values to Enter
EDI Document Key Company EKCO Number 5 A number that is used in conjunction with the values in the EDI Document Number (EDOC), EDI Document Type (EDCT), and EDI Line Number (EDLN) fields to uniquely identify a transaction.

The number that you enter must exist in the Company Constants table (F0010).

EDI Document Number EDOC Number 9 A number that is used in conjunction with the values in the EDI Document Key Company (EKCO), EDI Document Type (EDCT), and EDI Line Number (EDLN) fields to uniquely identify a transaction.
EDI Document Type EDCT Alpha 2 A two-character code that is used in conjunction with the values in the EDI Document Key Company (EKCO), EDI Document Number (EDOC), and EDI Line Number (EDLN) fields to uniquely identify a transaction.
EDI Line Number EDLN Number 7 A number that is used in conjunction with the values in the EDI Document Key Company (EKCO), EDI Document Number (EDOC), and EDI Document Type (EDCT) fields to uniquely identify a transaction.

Enter 1 for both 823 and 820 transaction sets.


To successfully process EDI transactions, complete the additional required fields in the EDI Lockbox/Payment Header - Transaction table (F47111):

Field Name Alias Type Length Definition and Values to Enter
EDI Transaction Set Number Z1EDST Number 6 A number that specifies the format of the transfer program.

Enter 823 to specify EDI lockbox transactions and 820 to specify EDI inbound payment-order transactions.

EDI Send/Receive Indicator Z1EDER Alpha 1 A code that indicates whether the transaction is inbound or outbound.

Enter R to indicate inbound transactions.

Alpha Name Z1ALPH Alpha 40 The name of the payor.

If you process lockbox transactions (823), this is the name of the bank.

EDI Transmission Date Z1EDDT Date 6 The date on which the EDI data is transmitted.

The system does not require a value in this field to process records; however, the EDI Inbound Receipt Inquiry program (P47110) uses this field to limit the number of records that appear.


To successfully process EDI transactions, complete the additional required fields in the EDI Lockbox Header - Transaction table (F47112):

Field Name Alias Type Length Definition and Values to Enter
EDI Transaction Set Number Z2EDST Number 6 A number that specifies the format of the transfer program.

Enter 823 to specify EDI lockbox transactions and 820 to specify EDI inbound payment order transactions.

EDI Send/Receive Indicator Z2EDER Alpha 1 A code that specifies whether the transaction is inbound or outbound.

Enter R to specify inbound transactions.

Deposit Number Z2DEPN Alpha 30 A number that identifies a group of payments.
Total Amount Transmitted Z2TTOT Number 15 A number that represents the total amount of the deposit.

To successfully process EDI transactions, complete the additional required fields in the EDI Lockbox/Payment Detail - Batch table (F47113):

Field Name Alias Type Length Definition and Values to Enter
Deposit Number Z3DEPN Alpha 30 A number that identifies a group of payments.

Enter the same information in this field that you enter in the corresponding field in the EDI Lockbox Header - Transaction table (F47112).

Line Number Z3LNID Number 6 A number that identifies a receipt within a deposit.

You must enter a unique value for each record.

Receipt Number Z3DOCM Alpha 8 A number that identifies a receipt.

When you process the record, the system updates the check number field (CKNU) in the F03B13Z1 table with the value in this field.

Bank Transit Number Z3TNST Alpha 20 A number that identifies the bank from which the customer's payment is made.
Customer Bank Account Number Z3CBNK Alpha 20 A number that identifies the customer's account at a bank.
Address Number Z3AN8 Number 8 The customer's address book number.

As an alternative to providing values for the Bank Transit Number and Customer Bank Account Number fields, you can enter the customer's address book number. The system locates the customer bank-account information, based on the customer's address book number, as long as it has been set up in the system.

Total Amount Transmitted Z3TTOT Number 15 A number that represents the amount of the receipt.

If multiple receipts exist for one deposit, the sum of this field should equal the value in the Total Amount Transmitted field (Z2TTOT) in the F47112 table.

Currency Code Z3CRCD Alpha 3 The currency of the receipt amount.

Complete this field only if you use multicurrency processing and you enter a value in the Currency Amount field (CRCA) in the F47114 table.


To successfully process EDI transactions, complete the additional required fields in the EDI Lockbox/Payment Detail - Payment table (F47114):

Field Name Alias Type Length Definition and Values to Enter
Deposit Number Z4DEPN Alpha 30 The value that you enter must be the same as the deposit number that is entered in the corresponding field in the F47112 table.
Line Number Z4LNID Number 6 The number that you enter must be the same as the line number that is entered in the corresponding field in the F47113 table.
Sequence Number Z4SEQN Number 7 A number that identifies a receipt pay item when one receipt pays multiple invoices.
Receipt Number Z4DOCM Number 8 The number that you enter must correspond to a check number (data item DOCM) in the F47113 table.
Document Number Z4DOC Number 8 See the note after the table.
Document Type Z4DCT Alpha 2 See the note after the table.
Document Pay Item Z4SFX Number 3 See the note after the table.
Gross Amount Z4AG Number 15 A number that represents the amount of the receipt to apply to the invoice.

Do not enter a value into this field if the receipt amount is foreign. Instead, use the Currency Amount field (Z4ACR).

Currency Amount Z4ACR Number 15 The foreign amount of the receipt to apply to the invoice.

If you use multicurrency, but the receipt is in the domestic currency, do not enter the domestic amount in this field. Instead, use the Gross Amount field (Z4AG).

If you complete this field, you must complete the Currency Code field (Z3CRCD) in the F47113 table.

Receipt Matching Reference 1 RMR1     A string variable that is used to match AR Invoices with AR Receipts.

Note:

The Document Number (Z4DOC), Document Type (Z4DCT), and Document Pay Item (Z4SFX) fields identify the invoice that the receipt pays. You must have a separate record for each invoice and invoice pay item that the receipt pays.

If the invoice has only one pay item, you can leave the Pay Item field blank. The system numbers the pay items beginning with 001.

As an alternative to specifying the invoice document number (DOC, DCT, and SFX fields) in the F47114 table, you can complete one of these fields:

Purchase Order (Z4PO)

Control/Statement Number (Z4CTL)

This number is either the statement number on which the invoice appears or the user-defined reference number.

Shipment Number (Z4SHPN)

When the system processes transactions that use any of these fields, it copies the value from the field into the Generic Matching Field (GMFD) in the F03B13Z1 table.

Do not use multiple methods to identify the invoice. Use the DOC, DCT, and SFX fields, or the PO field, or the CTL field, or the SHPN field.

18.3 Transferring Inbound EDI Transmissions

This section provides an overview of the transfer of inbound transmissions and discusses how to:

  • Run the Update to Electronic Receipts program.

  • Set processing options for Update to Electronic Receipts (R47111).

18.3.1 Understanding the Transfer of Inbound Transmissions

To transfer inbound transmissions from the EDI tables to the F03B13Z1 table, run the Update to Electronic Receipts program (R47111) from the appropriate menu. When you run the program from the Lock Box menu, the system processes 823 transactions. When you run the program from the Inbound Payment Order menu, the system processes 820 transactions.

You can run this program in proof or final mode.

In proof mode, the system prints the EDI - Update Electronic Receipts report that you use to review the transactions and correct errors before you run the program in final mode. The report prints:

  • The amount to be applied to the invoice (data items Z4AG or Z4ACR) from the F47114 table.

  • The amount of the receipt (data item Z3TTOT) from the F47113 table.

  • The total amount of the deposit (data item Z2TTOT) from the F47112 table.

Proof mode enables you to verify that total remittance amounts equal total deposit amounts. If the amounts do not total properly, the system prints an error message on the report.

In final mode, the system:

  • Transfers EDI inbound transmissions to the F03B13Z1 table for further processing by the automatic receipt application programs.

  • Updates the EDI - Successfully Processed field (EDSP) to Y.

  • Prints the EDI - Update Electronic Receipts report.

    Note:

    The system writes records to the F03B13Z1 table regardless of errors. Although errors are detected during the automatic receipt application process, you should run this program in proof mode first and correct any errors before you run the program in final mode.

18.3.2 Running the Update to Electronic Receipts Program

Use one of these navigations:

From the Lock Box menu (G47264), select Update to Electronic Receipts.

From the Inbound Payment Order menu (G47265), select Update to Electronic Receipts.

18.3.3 Setting Processing Options for Update to Electronic Receipts (R47111)

Processing options enable you to specify the default processing for programs and reports.

18.3.3.1 Defaults

These processing options specify default values to use when processing transactions.

1. Short Bank Account ID (Required)

Specify the eight-digit account ID of the general ledger bank account to assign to records in the F03B13Z1 table if a value does not exist in the F47112 table. For example, the account ID for 1.1110.BEAR is 00000108.

If the system cannot locate a bank account, it does not process any records.

2. G/L Date

Specify the GL date to assign to records in the F03B13Z1 table if a value does not exist in the F47112 table. If the system cannot locate a GL date, it uses the system date as the GL date.

3. Payment Instrument

Specify the user-defined code (00/PY) for the payment instrument to assign to records in the F03B13Z1 table, such as X for EDI remote draft, if a value does not exist in the Payment Instrument field (PYIN) in the F47113 table.

Note:

The system does not require a value for the payment instrument. If a value exists in the F47113 table, the system does not overwrite that value.

18.3.3.2 Process

These processing options specify the method to use for processing transactions.

1. Process Mode

Specify whether to process EDI payments in proof or final mode. Values are:

Blank: Process EDI payments in proof mode. The system prints a report, but does not create records in the F03B13Z1 table.

1: Process EDI payments in final mode. The system prints a report and creates records in the F03B13Z1 table.

18.4 Locating and Revising Components of an Inbound EDI Transmission

This section provides overviews of the EDI Inbound Receipt Inquiry program and control information and discusses how to:

  • Set processing options for EDI Inbound Receipt Inquiry (P47110).

  • Revise a transaction for an inbound EDI transmission.

  • Revise a deposit for an inbound EDI transaction.

  • Revise a payment for an inbound EDI deposit.

  • Revise a remittance for an inbound EDI payment.

  • Revise control information on inbound EDI transmissions.

  • Revise EDI control information for a deposit.

  • Revise EDI control information for a payment.

  • Revise EDI control information for a remittance.

18.4.1 Understanding the EDI Inbound Receipt Inquiry Program

After you run the Update to Electronic Receipts program (R47111) in proof mode, you must make corrections or additions to an EDI transmission before you run the program in final mode.

You use the EDI Inbound Receipt Inquiry program (P47110) to locate and revise components of an inbound EDI transmission. A version of this program resides on both the Lockbox (823) and Inbound Payment Order (820) menus. The only difference between the two versions is a processing option setting for the default transaction set. The system stores information for each component in a different table. These components constitute an EDI transmission:

Component Description
Transaction A transaction contains header information that links together the deposit, payment, and remittance components. Transaction information is stored in the F47111 table.
Deposit A deposit contains all of the payments that are received by the bank for a specific time frame, such as one day. Deposit information is stored in the F47112 table.
Payment A payment is a receipt that can be applied to one or more invoices or invoice pay items. Payment information is stored in the F47113 table.
Remittance A remittance contains information about the invoice that is to be paid. Remittance information is stored in the F47114 table.

To change any of the components of the EDI transmission, you must first locate them. The relationship between the components is hierarchical. Therefore, to locate a deposit, you must first locate the transaction that contains the deposit; to locate a payment, you must first locate the transaction and the deposit that contains the payment; to locate a remittance, you must first locate the transaction, the deposit, and the payment.

After you locate the EDI transaction and component, you can revise any of the available fields.

18.4.2 Understanding Control Information

The system stores EDI control information for inbound EDI transmissions in each of the four EDI tables. These four tables have a hierarchical relationship:

  1. F47111 - Transaction

  2. F47112 - Deposit

  3. F47113 - Payment

  4. F47114 - Remittance

Therefore, if you change EDI control information for the transaction (F47111), the system copies the change to each component in the subordinate tables (F47112, F47113, and F47114). If you change EDI control information for the payment (F47113), the system copies the change to each remittance (F47114) for the payment. The system copies changes to subordinate tables only, never to a superordinate table. For example, if you change EDI control information for the payment (F47113), the system does not copy the change to the deposit (F47112) or the transaction (F47111) tables.

18.4.3 Forms Used to Locate and Revise Components of an Inbound EDI Transmission

Form Name Form ID Navigation Usage
Work with Transaction Status W47110A Lock Box (823) (G47264), EDI Inbound Receipt Inquiry

Inbound Payment Order (820) (G47265), EDI Inbound Inquiry

Display EDI transactions.
Transaction Header Revisions W47110B On the Work with Transaction Status form, select the transaction and click Select. Revise a transaction for an inbound EDI transmission.
EDI Control Revisions W47CTLB On the Work with Transaction Status form, select a record, and then select Control from the Row menu. Revise control information on inbound EDI transmissions.
Work with Deposit W47110C On the Work with Transaction Status form, select a transaction, and then select Deposit from the Row menu. Review deposits in a transaction.
Deposit Revisions W47110D On the Work with Deposit form, select the deposit that you want to revise, and click Select. Revise a deposit for an inbound EDI transaction.
Work with Payment W47110E On the Work with Deposit form, select a deposit, and then select Payment from the Row menu. Review payments for a deposit.
Payment Revisions W47110F On the Work with Payment form, select the payment that you want to revise, and click Select. Revise a payment for an inbound EDI deposit.
Work with Remittance W47110G On the Work with Payment form, select a payment, and then select Remittance from the Row menu. Review remittances for a payment.
Remittance Revisions W47110H On the Work with Remittance form, select the remittance that you want to revise, and click Select. Revise a remittance for an inbound EDI payment.

18.4.4 Setting Processing Options for EDI Inbound Receipt Inquiry (P47110)

Processing options enable you to specify the default processing for programs and reports.

18.4.4.1 Defaults

This processing option specifies the transaction set number that appears on the Work with Transaction Status form.

1. EDI Transaction Set Number

Specify the default transaction set number. If you leave this processing option blank, the system uses 823. Values are:

823: Lockbox

820: Payment Order

18.4.4.2 Process

This processing option specifies whether to process EDI transactions in update or add mode.

1. Process Mode

Specify whether the system processes EDI transactions in update or add mode. Values are:

Blank: Process transactions in update mode to enable revisions to existing records.

1: Process transactions in add mode to add new records.

18.4.5 Revising a Transaction for an Inbound EDI Transmission

Access the Transaction Header Revisions form.

Change the value in the Alpha Name field.

18.4.6 Revising a Deposit for an Inbound EDI Transaction

Access the Deposit Revisions form.

Cleared/Value Date

Enter the date on which the payment amount was debited or credited to the bank account. The value date is not the date on which the bank reconciled the payment. The system populates this field with automatic payments automatically. If you are making manual payments and have set a processing option to display the value date field, you can manually enter the value date here.

G/L Date

Enter the date to which the transaction is posted.

Reference

Enter an alphanumeric value to specify a cross-reference or secondary reference number. Typically, this is the customer number, supplier number, or job number.

DFI ID Qualifier (depository financial institution identification number type)

Enter the depository financial institution identification number type. Values are:

01: ABA Transit Routing Number

02: Swift Identification

03: CHIPS

04: Canadian Bank Branch

ZZ: Mutually Defined

DFI ID Number

Enter the depository financial institution identification number.

Reference 2

Enter a reference number, such as the supplier's bid document number, quote document, sales order, work order, or job number.

G/L Bank Account

Enter the bank account to which the transaction is posted.

Amount Deposited

Enter the total currency amount as transmitted on an EDI transaction.

A/R Batch Number

Displays the number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either assign a batch number or let the system assign it using the Next Numbers program.

A/R Batch Date

Displays the date of the batch.

A/R Batch Type

Displays the batch type. Do not change the value of this field; RB is the only value.

18.4.7 Revising a Payment for an Inbound EDI Deposit

Access the Payment Revisions form.

Check Number

Displays the number of the matching document, such as a receipt, payment, adjustment, or credit. You apply a matching document (DOCM) against an original document (DOC), such as an invoice or voucher.

Check/Item Date

Enter the date on which a receipt was entered.

Bank Transit

Enter the number that is assigned to the bank by the Federal Reserve to facilitate the clearing of funds.

Customer Bank Account

Enter the number that is assigned by a bank to identify the account for the customer.

Note:

Nordic users: Enter the bank, Bankgiro, or Postgiro account number.
Transaction Type Code

Enter the EDI code designating the action to be taken by all parties. Refer to ANSI X.12 Data Item 305.

Payment Instrument

Enter the user-defined code (00/PY) that determines the means by which a payment is issued to a supplier or received from the customer. Examples of payment instruments include check, electronic funds transfer, lockbox, and EDI.

Check Document Type

Displays the user-defined code (00/DT) that specifies the kind of document that is used to match the original document.

Check Cleared Date

Enter the date that the check was debited to the bank account. The system updates this during the tape bank reconciliation.

Pay Method Code

Enter the Payment Method Code - ANSI S.12 data item 591.

Account Mode

Enter the code that indicates which of the three general ledger account numbers is being used for data entry. Values are:

1: The short account ID number.

2: The standard long account number.

3: The long (unstructured, 24-byte) account number.

7: The first character of the account number indicates the format of the account number You can also define special characters in the Accounting Constants table (F0009) to facilitate data entry. For example:

  • Blank: business unit.object.subsidiary number.

  • /: Unstructured account number

  • *: Short account ID number

For example, if the account mode is 7 and the first character of the account number is *, the account number was entered as the short account ID number.

A/R Batch Number

Displays the number that identifies a group of transactions that the system processes and balances as a unit.

A/R Batch Date

Displays the date of the batch. If you leave this field blank, the system date is used.

Check Amount

Enter the total currency amount as transmitted on an EDI transaction.

A/R Batch Type

Displays the batch type. Do not change the value of this field; RB is the only value.

18.4.8 Revising a Remittance for an Inbound EDI Payment

Access the Remittance Revisions form.

Pay Item

Displays the number that identifies the pay item for a voucher or an invoice. The system assigns the pay item number. If the voucher or invoice has multiple pay items, the numbers are sequential.

Statement Number

Displays the number that identifies the statement on which the invoice appears.

Gross Amount

Enter the value that specifies the total amount of the invoice pay item. The gross amount might include the tax amount, depending on the tax explanation code. The system does not decrease the gross amount when payments are applied. When you void a transaction, the system clears the gross amount field.

Discount Taken

Enter the amount by which an invoice is reduced if paid by a specific date. The discount taken does not have to be the same as the discount available.

Currency Amount

Displays the foreign currency amount that is entered on the transaction. If the Multi-Currency Conversion option on the General Accounting constants is set to Y, the foreign amount is multiplied by the exchange rate to arrive at the domestic amount. If the Multi-Currency Conversion option is set to Z, the foreign amount is divided by the exchange rate.

Foreign Discount Taken

Displays the amount of the discount, expressed in the foreign currency of the transaction, that was taken or granted during the application of a payment to an open invoice.

Type Input

Enter the code for specific transaction processing in cash receipts. A blank type input code causes the transaction to be bypassed. For more detailed information, see the system help text for Cash Receipts w/Action Code program (P03103). Values are:

1: Invoice Match Net with Discount.

2: Inv Match Open without Discount (invoice match open without discount).

A: Adjustment.

B: Balance Forward.

C: Chargeback (Unapplied Debit).

D: Inv Match w/ Chgbck for Discount (invoice match with chargeback for discount).

F: Automatic Gain/Loss Record (foreign currency only - machine generated).

G: General Ledger.

I: Invoice Match.

R: Begin or End Range of Invoices.

S: Spread.

U: Unapplied Cash (Credit).

W: Automatic Write-off.

X: Skip Invoice within Range.

Z: Automatic Gain/Loss on Spreads (foreign currency only-machine generated).

Miscellaneous Code 2

Displays a flag that internal processing uses for the A/P and A/R detail files. If this field is blank, the general ledger post program create the offsetting entries for tax in the Account Ledger table (F0911) and write to the Tax file (F0018) table.

The Order Processing and Distribution systems update this field with a 1 as offsetting entries for tax are written to the Taxes table (F0018).

If 1 is in this field, the invoice entry programs require manual changes to the tax amount information. It does not automatically calculate the information. Any changes to tax amounts in this program are not carried to the F0018 table when this code is 1.

Cash Rcpts/Inv Reg Code (cash receipts/invoice regulation code)

Displays a code to designate whether cash records from cash receipts are written in detail or summary. All records within a batch have the same value. Values are:

Blank: Cash records are written in summary.

1: Cash records are written in detail.

18.4.9 Revising Control Information on Inbound EDI Transmissions

Access the Work with Transaction Status form.

Select an EDI transaction, and then select Control from the Row menu.

Note:

The system copies the changes that you make to each deposit, payment, and remittance for the transaction.

18.4.10 Revising EDI Control Information for a Deposit

Access the Work with Transaction Status form.

Select a deposit, and then select Control from the Row menu.

Note:

The system copies the changes that you make to each payment and remittance for the deposit.

18.4.11 Revising EDI Control Information for a Payment

Access the Work with Transaction Status form.

Select a payment, and then select Control from the Row menu.

Note:

The system copies the changes that you make to each remittance for the payment.

18.4.12 Revising EDI Control Information for a Remittance

Access the Work with Transaction Status form.

Select a remittance, and then select Control from the Row menu.

Number of Detail Lines

Displays the number of detail lines that were transmitted in an EDI transaction. This is the total number of lines on a per order basis, number of lines included on an invoice, and so on.

EDI - Transmission Date

Displays the specific date that an EDI transaction was either transmitted or received.

Trading Partner ID

Enter the qualifier to identify the trading partner with whom you are exchanging EDI standard business documents.

18.5 Adding Components of an Inbound EDI Transmission

This section lists a prerequisite and discusses how to:

  • Add an inbound EDI transaction.

  • Add a deposit to an inbound EDI transaction.

  • Add a payment to an inbound EDI deposit.

  • Add a remittance to an inbound EDI payment.

18.5.1 Prerequisite

Set the processing options for the EDI Inbound Receipt Inquiry program (P47110) and verify that the Process Mode processing option contains a value of 1 to enable additions.

18.5.2 Forms Used to Add Components of an Inbound EDI Transmission

Form Name Form ID Navigation Usage
Work with Transaction Status W47110A Lock Box (823) (G47264), EDI Inbound Receipt Inquiry

Inbound Payment Order (820) (G47265), EDI Inbound Inquiry

Display EDI transactions.
Transaction Header Revisions W47110B Click Add on the Work with Transaction Status form. Add one or more components to an existing transmission. This might be useful if you want to test the process before implementing it.
Work with Deposit W47110C Select the EDI transaction to which the deposit should be added, and then select Deposit from the Row menu on the Work with Transaction Status form. Review deposits in a transaction.
Deposit Revisions W47110D On the Work with Deposit form, click Add. Add a deposit to an inbound EDI transaction.
Work with Payment W47110E On the Work with Lockbox Deposit form, select a deposit, and then select Payments from the Row menu. Review payments a deposit.
Payment Revisions W47110F On the Work with Payment form, click Add. Add a payment to an inbound EDI deposit.
Work with Remittance W47110G On the Work with Payment form, select a payment, and then select Remittance from the Row menu. Review remittances for a payment.
Remittance Revisions W47110H On the Work with Remittance form, click Add. Add a remittance to an inbound EDI payment.

18.5.3 Adding an Inbound EDI Transaction

Access the Transaction Header Revisions form.

Complete the EDI Document Number, EDI Document Type, EDI Document Company, EDI Line Number, and Alpha Name fields to identify the transaction. All other available fields are optional.

Note:

When you add an inbound EDI transaction, the system automatically adds the corresponding EDI control information.

18.5.4 Adding a Deposit to an Inbound EDI Transaction

Access the Deposit Revisions form.

Complete the Deposit Number and Amount Deposited fields to enter the deposit. All other available fields are optional.

Note:

When you add a deposit to an inbound EDI transaction, the system automatically adds the corresponding EDI control information.

18.5.5 Adding a Payment to an Inbound EDI Deposit

Access the Payment Revisions form.

Complete the Deposit ID, Check Document Type, Check Amount, and Check Number fields to enter the payment. All other available fields are optional.

Note:

When you add a payment to an inbound EDI deposit, the system automatically adds the corresponding EDI control information.

18.5.6 Adding a Remittance to an Inbound EDI Payment

Access the Remittance Revisions form.

Complete the Sequence Number, Check Number, and Check Document Type fields and complete either the Gross Amount field or the Currency Amount field. All other available fields are optional.

Note:

When you add a remittance to an inbound EDI payment, the system automatically adds the corresponding EDI control information.

18.6 Purging Inbound EDI Transmissions

This section provides an overview of the purge process for EDI inbound transmissions and discusses how to run the Purge EDI Inbound Receipts program.

18.6.1 Understanding the Purge Process for EDI Inbound Transmissions

After you successfully process EDI inbound transmissions, you can remove them from the inbound EDI tables by running the purge program. The system retains processed EDI transactions in the system 47 tables until you purge them.

When you purge EDI inbound transmissions, the system removes records that have a Y in the Processed (Y/N) field (EDSP) from these tables:

  • F47111

  • F47112

  • F47113

  • F47114

    Important:

    When you purge information, the system does not copy transactions to a purge table. Instead, the system deletes transactions from the system.

18.6.2 Running the Purge EDI Inbound Receipts Program

Use one of these navigations:

From the Inbound Payment Order menu (G47265), select Purge EDI Inbound Receipts.

From the Lock Box menu (G47266), select Purge EDI Inbound Receipts.