Loading Data for JD Edwards EnterpriseOne Plant Manager's Dashboard

This chapter provides an overview of JD Edwards EnterpriseOne Plant Manager's Dashboard (PMD) data loading and the general ledger data loads, and discusses how to:

• Set processing options for the G/L Data Load – Cardex COGS program (R80D221A).

• Run the G/L Data Load – Cardex COGS program

• Set processing options for the G/L Data Load – Direct Ship Orders COGS program (R80D221B).

• Run the G/L Data Load – Direct Ship Orders COGS program.

Understanding PMD Data Loading

The JD Edwards EnterpriseOne PMD system uses multiple batch programs to load and create the metric data information. You must run the batch programs in a sequential manner for the metric data to be complete and accurate. This diagram illustrates the JD Edwards EnterpriseOne PMD business process flow for data:

JD Edwards EnterpriseOne PMD business process

The system must populate tables with data within the JD Edwards EnterpriseOne PMD before you can run subsequent batch programs. The programs have been grouped into different levels based on the data contingencies:

This flowchart illustrates the sequential order in which all the PMD data load batch programs should be run:

JD Edwards EnterpriseOne PMD data process flow

These detail flowcharts show the sequence and frequency that is recommended for each data load batch program to keep the data accurate and timely:

Level one and two batch programs

Level three and four batch programs

Note. The Inventory Data Load program calculates the metric data for the Inventory Turns and the Days Sales in Inventory metrics.

Level five batch program

Understanding the General Ledger Data Loads

The system loads data to the General Ledger Aggregate table (F80D221) to calculate performance for the Days Sales in Inventory, Inventory Turns, and Days Payable Outstanding metrics. You add records to the General Ledger Aggregate table using the G/L Data Load – Cardex COGS program (R80D221A) and the G/L Data Load – Direct Ship Orders COGS program (R80D221B), if using direct ship orders.

The R80D221A program selects records in the Item Ledger File table (F4111) based on the general ledger date and the as of posted code. The JD Edwards EnterpriseOne PMD system does not access data directly from the Item Ledger File table. The system must evaluate data in the appropriate context to process metric calculations. The R80D221A program converts the currency to the default currency code that is specified in the Dashboard Constants program (P80D300).

The R80D221B program is an optional data load program for customers who need to include direct ship order lines in the COGS calculation. The R80D221B program selects records in the Sales Order Detail File table (F4211) and Sales Order History table (F42119) based on the general ledger date.

The system maintains the total amounts for COGS in the F80D221 table by branch/plant and short item number.

This flowchart shows the sequence for the data load batch programs for the general ledger to keep the data accurate and timely:

General Ledger Data Load program flow

The system stores last run date for the R80D221A and R80D221B programs in the PMD - UBE Timestamp table (F80D101) for informational purposes. The first time you run the R80D221A program, the system creates a new record in the F80D101 table with the date and time. When you run the R80D221A program again, the system updates the existing record in the F80D101 table with a new run date and time. The same is true for the R80D221B program.

Setting Processing Options for the G/L Data Load – Cardex COGS Program (R80D221A)

Processing options enable you to specify the default processing for the G/L Data Load – Cardex COGS program.

Display

This processing option controls the print output.

Running the G/L Data Load – Cardex COGS Program

Enter BV in the Fast Path field, and then enter R80D221A in the Batch Application field.

The R80D221A program selects records in the Item Ledger File table (F4111) based on the general ledger date and the as of posted code. The system totals the values in the Amount – Extended Cost/Price field for the selected records for each branch/plant and short item number and creates records in the F80D221 table using the current system date as the processing date.

The R80D221A program creates records in the General Ledger Aggregate table only for transactions that have:

• A general ledger date between today and today minus 365.

• An as of posted code not equal to X.

You must run the R80D221A program before these programs within JD Edwards EnterpriseOne PMD:

• Inventory Data Load (R80D220)

• Days Payable Outstanding (R80D201)

• G/L Data Load – Direct Ship Orders COGS (R80D221B) (optional)

The listed programs use information from the F80D221 table to aggregate data for the corresponding metric calculations.

Setting Processing Options for the G/L Data Load – Direct Ship Orders COGS Program (R80D221B)

Processing options enable you to specify the default processing for the G/L Data Load – Direct Ship Orders COGS program.

Display

This processing option controls the print output.

Running the G/L Data Load – Direct Ship Orders COGS Program

Enter BV in the Fast Path field, and then enter R80D221B in the Batch Application field.

The R80D221B program is an optional data load for customers who need to include direct ship order lines in the COGS calculation. The R80D221B program selects records in the Sales Order Detail File (F4211) and Sales Order History (F42119) tables based on the general ledger date. You must use data selection to identify sales order line types that you use for direct ship orders.

Using both the F4211 and F42119 tables enables you to select sales orders for the entire year regardless of how many months or years have been purged from the F4211 table. For example, you maintain only the last three months of sales orders in the F4211 table and purge the other nine months of the year to the F42119 table. Using both tables enables the R80D221B program to pull the first three months from the F4211 table and the other nine months from the F42119 table.

The F4211 table is the primary table for the batch program. The R80D221B program contains data selection options for the fields in the F4211 table. These fields are identical in the F42119 table; therefore, the data selection that you set for the F4211 table applies to the F42119 table as well.

The system totals the values in the Amount – Extended Cost field for the selected records for each branch/plant and short item number and either creates or updates records in the existing F80D221 table. The system converts the values on direct ship order lines to negative values to total the COGS value correctly. The system calculates COGS based on the additions and subtractions to inventory. Because direct ship orders do not adjust inventory quantities, the system pulls information directly from the F4211 and F42119 tables. Standard sales orders result in negative entries to the Item Ledger table (F4111). Therefore, to correctly calculate the impact of direct ship orders to the COGS, the system must multiply the value by –1. The report output displays the values as negative numbers for the processed direct ship orders.

The R80D221B program creates records in the F80D221 table only for transactions that have a general ledger date between today and today minus 365.

You must run the R80D221B program before these programs within JD Edwards EnterpriseOne PMD:

• Inventory Data Load (R80D220)

• Days Payable Outstanding (R80D201)

The listed programs use information from the F80D221 table to aggregate data for the corresponding metric calculations.

Note. You must run the R80D221A program prior to running the R80D221B program. The system verifies that a record exists in the F80D101 table for the R80D221A program with the current date. If the system does not find a record for R80D221A with the current date, the system displays an error message and does not process any direct ship orders.