This section provides an overview of the store-and-forward process and discusses how to:
Download master tables for store-and-forward processing.
Create journal entries for store-and-forward processing.
Upload store-and-forward journal entries.
Process store-and-forward journal entries.
Update transaction control records.
Purge processed store-and-forward journal entries.
Store-and-forward journal entry processing provides an efficient way to enter and manage a high volume of journal entries before processing them in the JD Edwards EnterpriseOne General Accounting system. For example, if you are at a remote site and are not using a dedicated line to access the server, you could create journal entries in a local environment on your PC during normal business hours and then upload them to the server for processing during off-peak hours.
To process store-and-forward journal entries, you must first download master tables from the server. Then you can use store-and-forward processing to create JD Edwards EnterpriseOne journal entries on the client and later upload them to the server for processing. After you process the entries in proof mode, you can revise or delete them, as necessary. After you process them in final mode, update the transaction control status for each journal entry on the PC so it matches the status on the server. Then you can post the journal entries in the F0911 table to the F0902 table.
This section provides an overview of the download of master tables for processing and discusses how to download store-and-forward master tables.
Before processing store-and-forward journal entries on the client, you must download tables from the server. These tables are necessary to create and validate transactions. For example, you must download the F0101 and F0901 tables to provide the account information that you need to create journal entries.
You must download each table separately. You can use data selection or category codes to limit the information that the system downloads from each table. Each version of the Master Table Download program (P00140) represents a table and its associated tables or a group of tables.
Each table is associated with one version. Not all versions must be present for all tables. You can create new versions for these tables in the Store & Forward Journal Entry - Revision program (P0911Z1).
The business data tables must reside on the local machine that you use for store-and-forward processing of journal entries:
F0004 - User-Defined Code Types
F0005 - User-Defined Codes
F0006 - Business Unit Master
F0008 - Date Fiscal Patterns
F0009 - General Constants
F0010 - Company Constants
F0013 - Currency Codes
F0014 - Payment Terms
F0022 - Tax Rules
F0041Z1 - Transaction Control File
F0101 - Address Book Master
F0111 - Address Book - Who's Who
F0116 - Address by Date
F0901 - Account Master
F0907 - Chart of Accounts Format
F0911Z1 - Journal Entry Transactions - Batch File
F4008 - Tax Areas
F4801 - Work Order Master File
In addition to the business data tables, you must also download the technical data tables, such as Next Numbers - Automatic (F0002) and Next Numbers by Company/Fiscal Year - Automatic (F00021).
The system creates a download report for each table that you download. Use this report to verify the number of records that the system downloads to your PC. After you download the master tables, you can enter your transactions using the store-and-forward process.
Before you complete the tasks in this section:
Download the necessary master tables.
Verify that you are connected to the server and signed on to your normal production environment.
Select Store and Forward Journal Entries (G09318), Master Table Download.
This section provides an overview of journal entry creation and discusses how to add store-and-forward journal entries.
After you download the master tables, you can use store-and-forward processing to create journal entries. Using the Store and Forward Journal Entry - Revisions program, you create and store the journal entries until you are ready to upload (or transfer) them to the server for processing.
When you create journal entries that you store and forward, the system:
Edits and validates each journal entry, based on the information that you downloaded from the tables.
Creates a transaction control record for each journal entry, assigns it a status of 1 (ready to process), and stores it in the Transaction Control File table (F0041Z1).
When you create journal entries that you store and forward, the system assigns a transaction number to each journal entry. It does not assign document numbers until you upload and process the journal entries.
You can store and forward these types of journal entries:
Basic journal entries
Models for percent journal entries
Percent journal entries
Model journal entries
Form Name |
FormID |
Navigation |
Usage |
Work With Store & Forward Journal Entries |
W0911Z1B |
Store and Forward Journal Entries (G09318), Store & Forward Journal Entry - Revision |
Review a list of batches of store-and-forward journal entries. |
Store & Forward Journal Entry Revisions |
W0911Z1A |
On the Work With Store & Forward Journal Entries form, click Add. |
Add a batch of store-and-forward journal entries. You can also use this form to revise or delete store-and-forward journal entries prior to processing them in final mode. Alternatively, you can correct the data in the batch table at its external source and upload the batch again to the JD Edwards EnterpriseOne General Accounting system. |
Access the Store & Forward Journal Entry Revisions form.
This section provides an overview of the store-and-forward upload process and discusses how to upload store-and-forward journal entries to the server.
After creating journal entries on your personal computer, you must upload them to the server for processing. To do this task, you must be connected to the server and signed on to your normal production environment.
When you upload journal entries, the system:
Creates records in the Journal Entry Transactions - Batch File table (F0911Z1).
Updates the transaction control status of each journal entry to 5 (uploaded) on the PC.
After a journal entry is updated to status 5, you cannot change it on the PC. You can change it only on the server.
When a journal entry on the PC has a status of 1 (ready to process) or 2 (errors), you can change it on the PC.
Creates a transaction control record for each journal entry on the server and assigns it a status of 1 (ready to process).
Prints a transmission upload report for all of the journal entries that you upload.
Use this report to verify that the journal entries have been uploaded correctly.
To maximize system performance, upload the journal entries during off-peak hours.
Select Store and Forward Journal Entries (G09318), Store & Forward Journal Entry Upload.
This section provides an overview of the store-and-forward processor and discusses how to:
Run the Store & Forward JE Batch Processor.
Set processing options for Store & Forward JE Batch Processor.
After you upload journal entries, you must process them to create transactions in the F0911 table. The system sends error messages to the employee work center.
The program that you use to process store-and-forward journal entries is different from the program that you use to process batch journal entries, although the results are similar. Verify that you are using the batch processor for store-and-forward journal entries.
After you process the journal entries, you must update the transaction control status of the journal entries on the PC to match the status of those on the server.
Select Store and Forward Journal Entries (G09318), Store & Forward JE Batch Processor.
Processing options enable you to specify the default processing for programs and reports.
Version Tab
1. Journal Entry Version |
Specify a version of Journal Entry MBF Processing Options (P0900049). If you leave this processing option blank, the standard version is run. |
2. Post Version |
Specify a version of the General Ledger Post program (R09801) to use to automatically post journal entries to the F0902 table. If you specify a version of the General Ledger Post program, the version must exist on the server. If you leave this processing option blank, the post is not submitted. |
Process Tab
1. Process Mode |
Specify whether to process the batch in proof or final mode. Values are: Blank: Proof mode. Tables are not updated. 1: Final mode. Tables are updated. |
2. Out of Balance |
Specify whether to allow general ledger transactions that are out of balance (amounts do not net to zero) to process. Values are: Blank: Do not allow out-of-balance transactions to process. 1: Allow out-of-balance transactions to process. |
3. Purge |
Specify whether to automatically purge processed transactions from the batch file. Values are: Blank: Do not purge processed transactions. 1: Purge processed transactions. |
Messages Tab
1. Warning Message |
Specify whether to suppress the creation of warning messages in the work center. Values are: Blank: Do not suppress warning messages 1: Suppress warning messages. |
2. Electronic Message |
Specify a user to receive electronic messages in the work center. Values are: Blank: The user who entered the transactions receives the messages. User ID: The user specified receives the messages. |
Edits Tab
1. Batch Approval |
Specify whether to have the status on all batches set to approved. Values are: Blank: The system sets all batch statuses according to the General Accounting constants. 1: The system sets all batch status to approved. |
This section provides an overview of the Update Transaction Control Record program and discusses how to update control records.
After you process store-and-forward journal entries, the transaction control status for each journal entry on the PC is different from the status of the journal entry on the server. You need to update the status on the PC so that it matches the status on the server. To perform this task, run the Update Transaction Control Record program (R0041Z1).
You can also run this update program to identify any PC journal entries that were in error when they were uploaded to the server. The system updates the journal entry on the PC with the error status of the journal entry on the server. You can then identify the journal entries that are in error on the PC, correct them, and upload them again to the server. Alternatively, you can correct them on the server.
You can also use the Update Transaction Control Record program to purge processed transactions from the F0911Z1 table in your local environment.
Select Store and Forward Journal Entries (G09318), Update Transaction Control Record.
When you run the Purge Store and Forward Transactions program (R0041Z1P), the system purges processed journal entries and deletes the records in the F0911Z1 and F0041Z1 table, but only from the environment in which you are running the program.
This section discusses how to purge processed store-and-forward journal entries.
Select Store and Forward Journal Entries (G09318), Purge Store and Forward Transactions.