Using Store and Forward in Cost Object Tracking

This chapter provides overviews of store and forward, General Accounting, and Accounts Payable and discusses how to:

• Enter cost object information in store and forward journal entries.

• Upload cost object information using the store and forward journal entry upload.

• Upload cost object information using the store and forward journal entry batch processor.

• Enter cost object information in store and forward voucher entry.

• Upload cost object information using the store and forward voucher entry upload.

• Upload cost object information using the store and forward batch voucher process.

Understanding Store and Forward

Store and forward (batch) processing provides an efficient way to enter and manage a high volume of transactions from a remote site when you do not have a dedicated line for access to the server. However, entering transactions on your PC during normal business hours might be more productive and cost-effective; they could then be uploaded to the server for processing during off-peak hours.

When you enter store and forward transactions that include profitability management information, the system verifies cost object information on the server and creates records accordingly.

See Also

Processing Store-and-Forward Journal Entries

Understanding General Accounting

This section provides an overview of General Accounting and lists prerequisites.

General Accounting

Entering cost object information using store-and-forward processing in the JD Edwards EnterpriseOne General Accounting system involves the following tasks:

• Entering cost object information in journal entries using the Store & Forward Journal Entry - Revision program (P0911Z1).

• Uploading the journal entries from your PC to the Journal Entry Transactions - Batch File table (F0911Z1) on the server using the Store & Forward Journal Entry Upload program (R0911Z1).

• Processing the uploaded journal entries to move them from the F0911Z1 to the Account Ledger table (F0911).

Understanding Accounts Payable

Entering cost object information using store and forward processing in the JD Edwards EnterpriseOne Accounts Payable system involves the following:

1. Entering cost object information in vouchers using the Store and Forward Batch Voucher Revisions program (P0411Z1)

2. Uploading the vouchers from your PC to the Voucher Transactions - Batch File (F0411Z1) and the Journal Entry Batch File (F0911Z1) tables on the server using the Voucher Upload program (R0411Z1)

3. Processing the uploaded vouchers to move them from F0411Z1 and the F0911Z1 to the Accounts Payable Ledger (F0411) and the Account Ledger (F0911) tables by using the Store and Forward Batch Voucher Process program (R04110Z2)

Entering Cost Object Information in Store and Forward Journal Entries

This section provides an overview of cost object information entry in store and forward journal entries, list prerequisites, and discusses how to enter cost object information in store and forward journal entries.

Understanding Cost Object Information Entry in Store and Forward Journal Entries

After you download the master tables to your PC, you can create JD Edwards EnterpriseOne journal entries using the store and forward environment. You store the journal entries on your PC until you are ready to upload (or forward) 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 Journal Entry Transactions - Batch File table (F0911Z1).

You can enter cost object information when you create a journal entry. When you upload the journal entries to the server, the system verifies the cost object type and the cost object edit code that you defined in the Account Master table (F0901). If you enter an item, the system edits cost object information against the Item Master table (F4101) only if you have installed the JD Edwards EnterpriseOne Inventory Management system.

Prerequisite

Before you complete the tasks in this section, set the processing options.

Form Used to Enter Cost Object Information in Store and Forward Journal Entries

Entering Cost Object Information in Store and Forward Journal Entries

Access the Store & Forward Journal Entry Revisions form.

To enter cost object information in store and forward journal entries:

1. Follow the steps to enter a basic journal entry on the Store & Forward Journal Entry Revisions form.

   When you create journal entries that you store and forward, the system does not assign document numbers until you upload and process them. Instead, it assigns a transaction number to each journal entry.

2. Complete the following fields to enter cost object information on the Store & Forward Journal Entry Revisions form:

   • Object Type 1

   • Cost Object 1

   • Object Type 2

   • Cost Object 2

   • Object Type 3

   • Cost Object 3

   • Object Type 4

   • Cost Object 4

   • Item Number

3. Click OK.

See Also

Creating Journal Entries for Store-and-Forward Processing

Uploading Cost Object Information Using the Store and Forward Journal Entry Upload

This section provides an overview of cost object information uploads using the store and forward journal entry upload, lists prerequisites, and discusses how to upload cost object information using the store and forward journal entry upload.

Understanding Cost Object Information Uploads Using the Store and Forward Journal Entry Upload

After creating journal entries with cost object information on your PC, 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 this status, you cannot modify it on the PC. You can change it only on the server.

  If 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).

The system creates 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.

After you upload your journal entries and process them, you must update the transaction control status of the journal entries on the PC to match the status of those on the server.

See Also

Updating Transaction Control Records

Uploading Store-and-Forward Journal Entries to the Server

Prerequisites

Before you complete the tasks in this section recognize that to maximize system performance, you should upload the journal entries during off-peak hours.

Uploading Cost Object Information Using the Store and Forward Journal Entry Upload

Select Store and Forward Journal Entries (G09318), Store & Forward Journal Entry Upload.

Uploading Cost Object Information Using the Store and Forward Journal Entry Batch Processor

This section provides an overview of cost object information uploads using the store and forward journal entry batch processor and discusses how to upload cost object information using the store and forward journal entry batch processor.

Understanding Cost Object Information Uploads Using the Store and Forward Journal Entry Batch Processor

After you upload journal entries to the server, you must process them to create transactions in the Account Ledger table. When you process vouchers in the store and forward environment when JD Edwards EnterpriseOne Advanced Cost Accounting is active, the system creates voucher information in the Account Ledger table (F0911)

When processing the journal entries that you uploaded, 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.

See Also

Processing Batch Journal Entries

Uploading Cost Object Information Using the Store and Forward Journal Entry Batch Processor

Select Store and Forward Journal Entries (G09318), Store & Forward JE Batch Processor.

Entering Cost Object Information in Store and Forward Voucher Entry

This section provides an overview of cost object information entry in store and forward voucher entry and discusses how to enter cost object information in store and forward voucher entry.

Understanding Cost Object Information Entry in Store and Forward Voucher Entry

After you download the master tables to your PC, you can create standard JD Edwards EnterpriseOne vouchers using the store and forward environment. You store the vouchers on your PC until you are ready to upload (forward) them to the server for processing.

When you create vouchers that you store and forward, the system:

• Edits and validates each voucher based on the information that you downloaded from the tables.

• Creates a transaction control record for each voucher, assigns it a status of 1 (ready to process), and stores it in the Transaction Control File table (F0041Z1).

You can enter cost object information when you enter a voucher. When you upload the vouchers to the server, the system verifies the cost object type and the cost object edit code that you defined in the Account Master table (F0901). If you enter an item, the system edits cost object information against the Item Master table (F4101) only if you have installed the JD Edwards EnterpriseOne Inventory Management system.

Form Used to Enter Cost Object Information in Store and Forward Voucher Entry

Entering Cost Object Information in Store and Forward Voucher Entry

Access the Enter Voucher - Payment Information form.

To enter cost object information in store and forward voucher entry:

1. Follow the steps to enter a standard voucher on the Enter Voucher - Payment Information form.

2. Complete the following fields on GL Distribution:

   • Object Type 1

   • Cost Object 1

   • Object Type 2

   • Cost Object 2

   • Object Type 3

   • Cost Object 3

   • Object Type 4

   • Cost Object 4

   • Item Number

3. Click OK.

See Also

Entering Standard Vouchers

Uploading Cost Object Information Using Store and Forward Voucher Entry Upload

This section provides an overview of cost object information uploads using store and forward voucher entry upload and discusses how to upload cost object information using store and forward voucher entry upload.

Understanding Cost Object Information Uploads Using Store and Forward Voucher Entry Upload

When you upload vouchers with cost object information, the system:

• Creates records in the Voucher Transactions - Batch File (F0411Z1) and Journal Entry Transactions- Batch Files (F0911Z1) tables on the server (target environment).

• Updates the transaction control status of each voucher to 5 (uploaded) on the PC.

  After a voucher is updated to this status, you cannot modify it on the PC. You can make changes to it only on the server.

  If a voucher on the PC is a status of 1 (ready to process) or 2 (errors), you can make changes to it on the PC.

• Creates a transaction control record for each voucher on the server and assigns it a status of 1 (ready to process).

The system creates a transmission upload report for all of the vouchers that you upload. Use this report to verify that the vouchers have been uploaded correctly.

See Also

Understanding the Store-and-Forward Process for Vouchers

Uploading Cost Object Information Using Store and Forward Voucher Entry Upload

Select Store and Forward Vouchers (G04318), Voucher Upload.

Uploading Cost Object Information Using the Store and Forward Batch Voucher Process

This section provides an overview of cost object information uploads using the store and forward batch voucher process and discusses how to upload cost object information using the store and forward batch voucher process.

Understanding Cost Object Information Uploads Using the Store and Forward Batch Voucher Process

After you upload vouchers to the server, you must process them to create transactions in the Accounts Payable Ledger table (F0411). When you process vouchers in the store and forward environment, the system creates:

• Voucher information in the Accounts Payable Ledger table.

• Associated accounting distribution information and cost object information in the Account Ledger table (F0911).

• Payment information in the Accounts Payable Matching Document (F0413) and the Accounts Payable Matching Document Detail (F0414) tables.

After you upload your vouchers and process them, you must update the transaction control status of the vouchers on the PC to match the status of those on the server.

See Also

Understanding the Store-and-Forward Process for Vouchers

Uploading Cost Object Information Using the Store and Forward Batch Voucher Process

Select Store and Forward Vouchers (G04318), Store and Forward Batch Voucher Process.