Understanding the Upload/Conversion Program

After you review and, if necessary, revise your budget data on the Revise Batch Account Balances form, run the Upload/Conversion program (R14110) to copy the data from the Account Balance - Batch File (F0902Z1) to the F0902 table.

In proof mode, the system identifies any errors that might occur. You must correct the errors before you run the program in final mode. If the system finds any problems with the records, it sends a workflow message to the work center notifying you of the problem and does not process any of the records in the F0902Z1 table. This ensures the integrity of the data.

Examples of possible errors include:

• Account numbers not set up in the F0901 table.

• Invalid subledgers or subledger types.

• Fiscal date patterns not set up for the fiscal year.

• Invalid ledger types.

Note: If you are using the R14110 program to upload budgets to the JD Edwards EnterpriseOne Job Cost system, the system allows you to post units budgets to accounts in job cost ledgers with a posting edit code of N.

Use the Upload/Conversion Revisions program (P0902Z1) to correct any errors in the F0902Z1 table. Then rerun the Upload/Conversion program in proof mode. When the resulting report is free of errors, run the program in final mode.

In final mode, the program prints a report and uploads the budget data to the F0902 table. For each record that the program successfully uploads, it updates the Batch Status field to D (posted) in the F0902Z1 table. The program bypasses any records that contain errors.

For detailed budgets by period, final mode sets the budget pattern code to DNS (Do Not Spread) for the corresponding accounts in the F0901 table.

You set processing options to control the upload process. For example, you can:

• Specify an annual budget upload instead of uploading periodic amounts.

  If you do this, specify the type of budget (requested, approved, or final) to which the system adds all periodic amounts.

• Add uploaded amounts to the existing amounts in the F0902 table.

  The processing option default replaces the amounts in the F0902 table with the uploaded amounts for all matching account numbers.

• Reverse the sign of the amounts for all revenue accounts.

After the budget data is loaded successfully into the F0902 table, you can purge records from the F0902Z1 table using the Processed Upload Purge program (R0902ZP).