15 Running the End of Day Processes

This chapter contains the following topics:

15.1 Understanding End of Day Processing

End of day processing is the last step in consigned or VMI orders processing and includes updating, verifying and posting daily shipment and sales information to ledgers. This is one of the most important steps in consigned or VMI shipment orders processing because the system updates the records in the other systems such as JD Edwards EnterpriseOne Accounts Receivable system, JD Edwards EnterpriseOne General Ledger system and JD Edwards EnterpriseOne Inventory Management systems.

You run the end of day process to maintain accurate consigned and VMI shipment and sales information, and update sales and quantity information in other JD Edwards systems. After you run the process, you can review and post shipment and sales information, and print reports.

15.2 Understanding Sales Update Report and Batches

Before you post journal entries created by the Sales Update program (R42800) to the general ledger, you can ensure the accuracy of the outbound inventory transactions by reviewing the journal entries.

The R42800 program groups transactions into different types of batches for posting to journals.

Invoice Batch (IB Batch)

The system creates the IB batch when it creates A/R entries. When you run the Sales Update report, the system automatically creates the default IB batch. When you run R42800 over orders that contain both internally owned shipment and other order detail lines, and no summarization option is turned on, the system saves other order detail line journal entries under the IB batch and internally owned shipment line journal entries under the Internally Owned Shipment G batch.

Internally Owned Shipment Batch (G Batch)

The system creates a new general ledger batch Internally Owned Shipment (type G) when you run the Sales Update report over orders consisting of internally owned shipment lines. Since the internally owned shipment lines are not part of the invoice, the system creates a new Internally Owned Shipment G batch.

To track movement of inventory from the inventory account to the consigned inventory account, you use the internally owned shipment G batch. You can also differentiate internally owned shipment order detail line journal entries using the Internally Owned Shipment G batch.

15.3 Updating Customer Sales

This section provides overviews of the Sales Update program and AAIs used by the Sales Update program, lists prerequisites, and discusses how to:

  • Set processing options for the Sales Update program (R42800)

  • Run the Sales Update program

15.3.1 Understanding the Sales Update Program (R42800)

To maintain the most accurate sales and shipment information, you can update the records daily in the JD Edwards EnterpriseOne Sales Order Management system. Run a version of the Sales Update program (R42800) each day to maintain the most accurate sales information. The system updates the records in the JD Edwards EnterpriseOne Sales Order Management system and the records in the other systems with which it interacts, such as the JD Edwards EnterpriseOne Accounts Receivable and JD Edwards EnterpriseOne Inventory Management systems. After you run the program, you can review and post sales transactions and review sales reports.

Note:

The Sales Update Program (R42800) processes internally owned billing orders and customer owned VMI orders in the same way as it processes other sales orders.

The following diagram illustrates the process flow when you run the Sales Update program over orders consisting of internally owned shipment lines and other order detail lines when no summarization options are turned on.

Figure 15-1 Sales Update Process Flow

Surrounding text describes Figure 15-1 .

15.3.1.1 Updating Tables

When you run the Sales Update program, the system generates:

  • Information about customer sales

  • Accounts receivables and general ledger entries

  • Any errors that the system generates when you run the report

Depending on how you set the processing options, the system creates or updates:

  • All status codes as per order activity rules

    After you run the Sales Update program over internally owned shipment orders lines, the system updates order status codes to 999

  • Updates the Item Ledger File table (F4111)

  • Updates the Sales Order Detail File table (F4211)

  • Updates the Outbound Inventory Agreement Acknowledge table (F42I02) if inventory is relieved when running the Sales Update program

    Note:

    For customer owned VMI orders, the system also creates invoices and assigns invoice numbers to outbound inventory orders that you do not process through the Print Invoices program (R42565).

    For internally owned shipment orders, the system creates the document number and assigns document numbers to the orders.

15.3.1.2 Relieving Inventory

You can relieve the on-hand quantity for an item during shipment confirmation or sales update. The method that you select affects the history records that the system writes to the F4111 table.

Internally Owned Shipment Orders

If you subtract the on-hand quantity from inventory during:

  • Shipment confirmation, the system creates a record in the F4111 table with the internally owned shipment order number as the document number and the order type as the document type.

    During sales update, the system overwrites the record with the document number and type, general ledger date, and batch number.

  • Sales update, the system updates the document number, type, and general ledger date to the F4111 table.

    Note:

    For internally owned shipment orders, the system relieves inventory from the supplying branch/plant.

Internally Owned Billing and Customer Owned VMI Orders

If you subtract the on-hand quantity from inventory during:

  • Shipment confirmation, the system creates a record in the F4111 table with the outbound inventory order as the document number and the order type as the document type.

    During sales update, the system overwrites the record with the invoice number and type, general ledger date, and batch number.

  • Sales update, the system updates the invoice number, type, and general ledger date to the F4111 table.

    Note:

    For internally owned billing orders, the system relieves inventory from the outbound branch/plant and for customer owned VMI orders, the system relieves inventory from the supplying branch/plant.

15.3.1.3 Understanding Interbranch and Intercompany Transactions

See "Understanding Interbranch and Intercompany Orders" in the JD Edwards EnterpriseOne Sales Order Management Implementation Guide.

15.3.2 Setting Processing Options for the Sales Update Program (R42800)

13-Outbound Inventory

Use this processing option to specify the document type the system uses to assign to internally owned shipment lines.

If you leave this processing option blank, the system uses JE as the document type.

See "Setting Processing Options for the Sales Update Program (R42800)" in the JD Edwards EnterpriseOne Sales Order Management Implementation Guide.

15.3.3 Running the Sales Update Program

Select Outbound Inventory Order Processing (G42I10), Update Customer Sales.

15.3.4 Reposting Outbound Inventory Orders

The system detaches outbound inventory agreements from future committed orders. When you re-commit future orders, and you set the Outbound Inventory Agreement Selection processing option in the Sales Order Entry program (P4210) to:

1 or 3: the system automatically attaches the outbound inventory agreement to the order if only one outbound inventory agreement exists for the entered agreement search criteria (Item Number, Sold To, Ship To, Branch/Plant, Order Date).

2: the system does not attach any outbound inventory agreement to the order.

See "Reposting Orders" in the JD Edwards EnterpriseOne Sales Order Management Implementation Guide.

15.3.4.1 Example of Reposting Outbound Inventory Orders

The following table illustrates agreement details for outbound inventory agreement NAB2016-17.

Field Name Value Header/Detail
Sold To 4242 Header
Branch/Plant 30 Header
Agreement Number/Supplement NAB2016-17 Header
Item Number DEFIBRILLATOR Detail
Agreement Quantity/UOM 10000 EA Detail
Ship To 4243 Detail
Remaining Quantity/UOM 9000 EA Detail
Outbound Branch/Plant 550011 Detail
Location NAB.01.1 Detail

Specific Commitment Days for Branch/plant 30 is 10 days. A future committed order is created with the following details:

Field Name Value
Sold To 4242
Branch/Plant (Header) 30
Agreement Number/Supplement BLANK
Ship To 4243
Item Number DEFIBRILLATOR
Order Quantity 1000EA
Order Date 4/18/ 2016
Promised Ship Date 4/29/2016

When you run the Repost Active Sales Orders (R42995) on 4/23/2016, with the Outbound Inventory Agreement Selection processing option in the Sales Order Entry program (P4210) set to 1 or 3, the system attaches the NAB2016-17 agreement to order, and updates the outbound inventory tables with the following information:

Field Name Value Header/Detail
Sold To 4242 Header
Branch/Plant 30 Header
Agreement Number/Supplement NAB2016-17 Header
Item Number DEFIBRILLATOR Detail
Agreement Quantity/UOM 10000 EA Detail
Ship To 4243 Detail
Remaining Quantity/UOM 8000 EA Detail
Outbound Branch/Plant 550011 Detail
Location NAB.01.1 Detail