Understanding Accounts Receivable Tables

The volume of records stored in the JD Edwards EnterpriseOne Accounts Receivable tables can affect processing time when you run the conversion workbench. To reduce the processing time, you can create and run multiple versions of the accounts receivable conversion programs from different workstations.

Before you create and run multiple versions, analyze the data in the accounts receivable tables and look for a logical way in which to group the records into equal parts (or versions). You might decide to group the records by company only, by batch type, batch, or general ledger date; or by an internal tracking number called the unique key ID. You can group the records into different versions using any of the fields that are available in the data selection for a particular conversion program.

The unique key IDs for the JD Edwards EnterpriseOne Accounts Receivable tables are:

Key IDs	Table(s)
DOC, DCT, CO, and SFX	F03B11
DOC, DCT, CO, SFX, and SFXE	Invoice Revisions (F03B112)
PYID	F03B13 and F03B14
UKID	F03B22 and F03B23
DCID	F03B40 and F03B41

To view the unique key IDs for these tables, use the Universal Table Browser (UTB).

After you carefully analyze the data, review the following information to understand how the accounts receivable conversion programs work and to help ensure that you set up the versions correctly:

• The Euro Conversion Workbench form in the Control Table Workbench program (P98413) contains 10 accounts receivable conversion programs.

  Each conversion program converts one of these tables:

  • F03B11

    The conversion program that converts the F03B11 table also converts corresponding records in the F0018 table.

  • F03B112

  • F03B13

  • F03B14

  • F03B22

  • F03B23

  • F03B40

  • F03B41

• You can create multiple versions for each accounts receivable conversion program, or create multiple versions for some programs and not for others.

  You should base the decision on the volume of records in each JD Edwards EnterpriseOne Accounts Receivable table. If the volume in a table is not significant, do not create multiple versions. Instead, run the accounts receivable conversion program for that table along with the other conversion programs that appear on the Euro Conversion Workbench form.

• You should convert a record only one time.

  When you create the versions, ensure that each accounts receivable record is selected by only one version of an accounts receivable conversion program and that no overlapping of records occurs among the versions.

  For example, if you create versions by batch type, do not convert the same batch type in two different versions. Conversely, do not omit any batch types.

• You must set up unique conversion plans to run multiple versions of an accounts receivable conversion program.

  Remember that conversion plans can contain one or more companies. You can run one or more accounts receivable conversion programs in a plan; however, you cannot run a version for a specific conversion program multiple times.

  You are essentially running multiple plans for that conversion program when you run multiple versions of an accounts receivable conversion program.

• You cannot inadvertently convert records that have already been converted by the accounts receivable conversion programs.

  For each accounts receivable conversion program, the system either ignores a transaction or issues an error message if the currency in the F0087 table or a processing option is the same as the domestic currency of the transaction in the table being converted.